Solved

MWO ServiceEng not working after upgrade to 22r2

  • 5 April 2023
  • 8 replies
  • 230 views
paul harland
Rank
Userlevel 7
Badge +24

Just upgraded to 22r2 and we are not able to log into MWO Service.

The Application is not Active - on trying to activate it i get this error

 

 

 

 

here’s the error detail:

 

IFS Web Version: 22.2.6.20230310132734.0
Date: 2023-04-05T18:00:20.902Z

--------------------------------------------------------------------------------------------------------

Database error occurred. Contact administrator.
Error details: [{"code":6502,"message":"ORA-06502: PL/SQL: numeric or value error: character string buffer too small"}]

Request Id: 874e17ba-69e1-4885-8c2c-13f1fed2d388

Url: https://saskpower-cfg.ifs.cloud/main/ifsapplications/projection/v1/MobileApplications.svc/MobileApplications(AppName='ServiceEngApp')/Versions(AppName='ServiceEngApp',AppVersion='22.2')/IfsApp.MobileApplications.MobileApplicationVersion_Activate

--------------------------------------------------------------------------------------------------------

{"version":"odata-server-core Version 4.5.0.3-ifs","environment":{"authType":"BASIC","localAddr":"10.224.220.63","localName":"ifsapp-odata-7d6b6865d6-ncwlc","localPort":"8080","pathInfo":"/MobileApplications.svc/MobileApplications(AppName='ServiceEngApp')/Versions(AppName='ServiceEngApp',AppVersion='22.2')/IfsApp.MobileApplications.MobileApplicationVersion_Activate","pathTranslated":"/opt/ifs/wlp/usr/servers/defaultServer/apps/expanded/ifs-odata-provider.war/MobileApplications.svc/MobileApplications(AppName='ServiceEngApp')/Versions(AppName='ServiceEngApp',AppVersion='22.2')/IfsApp.MobileApplications.MobileApplicationVersion_Activate","remoteAddr":"10.224.220.63","remoteHost":"ifsapp-odata-7d6b6865d6-ncwlc","remotePort":"33022","remoteUser":"pcopharl","scheme":"https","serverName":"ifsapp-odata","serverPort":"8080","servletPath":"/main/ifsapplications/projection/v1"},"uri":{"kind":"resource","uriResourceParts":[{"uriResourceKind":"entitySet","segment":"MobileApplications","type":"IfsApp.MobileApplications.MobileApplication","isCollection":false,"keys":{"AppName":"'ServiceEngApp'"}},{"uriResourceKind":"navigationProperty","segment":"Versions","type":"IfsApp.MobileApplications.MobileApplicationVersion","isCollection":false,"keys":{"AppName":"'ServiceEngApp'","AppVersion":"'22.2'"}},{"uriResourceKind":"action","segment":"MobileApplicationVersion_Activate","isCollection":false}],"customQueryOptions":{"odata-debug":"json"}},"runtime":[{"class":"ODataHandlerWrapper","method":"process","duration":856320,"unit":"µs","children":[{"class":"ODataHandlerWrapper","method":"fillODataRequest","duration":106,"unit":"µs","children":[{"class":"ODataHandlerWrapper","method":"copyHeaders","duration":67,"unit":"µs"},{"class":"ODataHandlerWrapper","method":"fillUriInformation","duration":22,"unit":"µs"}]},{"class":"ODataHandler","method":"process","duration":856173,"unit":"µs","children":[{"class":"ODataHandler","method":"processInternal","duration":853678,"unit":"µs","children":[{"class":"Parser","method":"parseUri","duration":237,"unit":"µs"},{"class":"UriValidator","method":"validate","duration":12,"unit":"µs"},{"class":"ODataDispatcher","method":"dispatch","duration":853412,"unit":"µs"}]},{"class":"ODataHandler","method":"handleException","duration":2466,"unit":"µs","children":[{"class":"ErrorProcessor","method":"processError","duration":2390,"unit":"µs"}]}]}]}],"stacktrace":{"exceptions":[{"class":"com.ifsworld.fnd.common.exceptions.DatabaseException","message":"Failed to execute the generated database statement","invocation":{"class":"com.ifsworld.fnd.storage.StorageProviderUtils","method":"createODataProviderExceptionFrom","line":1173}},{"class":"java.sql.SQLException","message":"ORA-06502: PL/SQL: numeric or value error: character string buffer too small\nORA-06512: at \"IFSAPP.MOBILE_TRIGGER_SYS\", line 521\nORA-06512: at \"IFSAPP.MOBILE_TRIGGER_SYS\", line 559\nORA-06512: at \"IFSAPP.MOBILE_TRIGGER_SYS\", line 77\nORA-06512: at \"IFSAPP.MOBILE_APP_UTILITIES_API\", line 157\nORA-06512: at \"IFSAPP.MOBILE_APPLICATION_VERSION_API\", line 2587\nORA-06512: at \"IFSAPP.MOBILE_APPLICATION_VERSION_API\", line 2345\nORA-06512: at \"IFSAPP.MOBILE_APPLICATIONS_SVC\", line 1478\nORA-06512: at \"IFSAPP.MOBILE_APPLICATIONS_SVC\", line 437\nORA-06512: at line 2\n","invocation":{"class":"oracle.jdbc.driver.T4CTTIoer11","method":"processError","line":509}},{"class":"oracle.jdbc.OracleDatabaseException","message":"ORA-06502: PL/SQL: numeric or value error: character string buffer too small\nORA-06512: at \"IFSAPP.MOBILE_TRIGGER_SYS\", line 521\nORA-06512: at \"IFSAPP.MOBILE_TRIGGER_SYS\", line 559\nORA-06512: at \"IFSAPP.MOBILE_TRIGGER_SYS\", line 77\nORA-06512: at \"IFSAPP.MOBILE_APP_UTILITIES_API\", line 157\nORA-06512: at \"IFSAPP.MOBILE_APPLICATION_VERSION_API\", line 2587\nORA-06512: at \"IFSAPP.MOBILE_APPLICATION_VERSION_API\", line 2345\nORA-06512: at \"IFSAPP.MOBILE_APPLICATIONS_SVC\", line 1478\nORA-06512: at \"IFSAPP.MOBILE_APPLICATIONS_SVC\", line 437\nORA-06512: at line 2\n","invocation":{"class":"oracle.jdbc.driver.T4CTTIoer11","method":"processError","line":513}}],"stacktrace":[{"class":"com.ifsworld.fnd.storage.StorageProviderUtils","method":"createODataProviderExceptionFrom","line":1173},{"class":"com.ifsworld.fnd.storage.PlsqlStatementExecutor","method":"executeStatement","line":143},{"class":"com.ifsworld.fnd.storage.PlsqlStatementExecutor","method":"execute","line":112},{"class":"com.ifsworld.fnd.storage.PlsqlStatementExecutor","method":"execute","line":86},{"class":"com.ifsworld.fnd.storage.PlsqlStatementExecutor","method":"execute","line":63},{"class":"com.ifsworld.fnd.storage.invoker.PlsqlOperationInvoker","method":"invoke","line":56},{"class":"com.ifsworld.fnd.storage.invoker.BpaInvokerWrapper","method":"invoke","line":170},{"class":"com.ifsworld.fnd.provider.processor.FndActionProcessor","method":"processActionVoid","line":821},{"class":"org.apache.olingo.server.core.ODataDispatcher","method":"handleActionDispatching","line":225},{"class":"org.apache.olingo.server.core.ODataDispatcher","method":"handleResourceDispatching","line":141},{"class":"org.apache.olingo.server.core.ODataDispatcher","method":"dispatch","line":117},{"class":"org.apache.olingo.server.core.ODataHandlerImpl","method":"processInternal","line":164},{"class":"org.apache.olingo.server.core.ODataHandlerImpl","method":"process","line":85},{"class":"com.ifsworld.fnd.provider.ODataHandlerWrapper","method":"process","line":64},{"class":"com.ifsworld.fnd.provider.ODataHandlerWrapper","method":"process","line":77},{"class":"com.ifsworld.fnd.web.api.FndODataServletBase","method":"serviceODataRequest","line":329},{"class":"com.ifsworld.fnd.web.api.FndODataServletBase","method":"serviceProjectionRequest","line":162},{"class":"com.ifsworld.fnd.web.api.FndODataServletBase","method":"service","line":112},{"class":"javax.servlet.http.HttpServlet","method":"service","line":791},{"class":"com.ibm.ws.webcontainer.servlet.ServletWrapper","method":"service","line":1258},{"class":"com.ibm.ws.webcontainer.servlet.ServletWrapper","method":"handleRequest","line":746},{"class":"com.ibm.ws.webcontainer.servlet.ServletWrapper","method":"handleRequest","line":443},{"class":"com.ibm.ws.webcontainer.filter.WebAppFilterChain","method":"invokeTarget","line":193},{"class":"com.ibm.ws.webcontainer.filter.WebAppFilterChain","method":"doFilter","line":98},{"class":"com.ifsworld.fnd.web.api.ResponseFilterBase","method":"doFilter","line":60},{"class":"com.ibm.ws.webcontainer.filter.FilterInstanceWrapper","method":"doFilter","line":201},{"class":"com.ibm.ws.webcontainer.filter.WebAppFilterChain","method":"doFilter","line":91},{"class":"com.ifsworld.fnd.web.api.InitConfigurationFilterBase","method":"doFilter","line":201},{"class":"com.ibm.ws.webcontainer.filter.FilterInstanceWrapper","method":"doFilter","line":201},{"class":"com.ibm.ws.webcontainer.filter.WebAppFilterChain","method":"doFilter","line":91},{"class":"com.ibm.ws.security.jaspi.JaspiServletFilter","method":"doFilter","line":56},{"class":"com.ibm.ws.webcontainer.filter.FilterInstanceWrapper","method":"doFilter","line":201},{"class":"com.ibm.ws.webcontainer.filter.WebAppFilterChain","method":"doFilter","line":91},{"class":"com.ibm.ws.webcontainer.filter.WebAppFilterManager","method":"doFilter","line":1002},{"class":"com.ibm.ws.webcontainer.filter.WebAppFilterManager","method":"invokeFilters","line":1140},{"class":"com.ibm.ws.webcontainer.filter.WebAppFilterManager","method":"invokeFilters","line":1011},{"class":"com.ibm.ws.webcontainer.servlet.CacheServletWrapper","method":"handleRequest","line":75},{"class":"com.ibm.ws.webcontainer40.servlet.CacheServletWrapper40","method":"handleRequest","line":85},{"class":"com.ibm.ws.webcontainer.WebContainer","method":"handleRequest","line":938},{"class":"com.ibm.ws.webcontainer.osgi.DynamicVirtualHost$2","method":"run","line":281},{"class":"com.ibm.ws.http.dispatcher.internal.channel.HttpDispatcherLink$TaskWrapper","method":"run","line":1184},{"class":"com.ibm.ws.http.dispatcher.internal.channel.HttpDispatcherLink","method":"wrapHandlerAndExecute","line":453},{"class":"com.ibm.ws.http.dispatcher.internal.channel.HttpDispatcherLink","method":"ready","line":412},{"class":"com.ibm.ws.http.channel.internal.inbound.HttpInboundLink","method":"handleDiscrimination","line":566},{"class":"com.ibm.ws.http.channel.internal.inbound.HttpInboundLink","method":"handleNewRequest","line":500},{"class":"com.ibm.ws.http.channel.internal.inbound.HttpInboundLink","method":"processRequest","line":360},{"class":"com.ibm.ws.http.channel.internal.inbound.HttpICLReadCallback","method":"complete","line":70},{"class":"com.ibm.ws.tcpchannel.internal.WorkQueueManager","method":"requestComplete","line":504},{"class":"com.ibm.ws.tcpchannel.internal.WorkQueueManager","method":"attemptIO","line":574},{"class":"com.ibm.ws.tcpchannel.internal.WorkQueueManager","method":"workerRun","line":958},{"class":"com.ibm.ws.tcpchannel.internal.WorkQueueManager$Worker","method":"run","line":1047},{"class":"com.ibm.ws.threading.internal.ExecutorServiceImpl$RunnableWrapper","method":"run","line":238},{"class":"java.util.concurrent.ThreadPoolExecutor","method":"runWorker","line":-1},{"class":"java.util.concurrent.ThreadPoolExecutor$Worker","method":"run","line":-1},{"class":"java.lang.Thread","method":"run","line":-1}]}}

--------------------------------------------------------------------------------------------------------

icon

Best answer by kathlk 6 April 2023, 08:19

View original

8 replies

paul harland
Rank
Userlevel 7
Badge +24
A load of table not exist errors show in the log window when trying to activate this.

 

kathlk
Rank
Userlevel 6
Badge +14

Looks like this is caused by set of sync rule which were changed to ‘On Change’ delivery method. This could be a defect. But as a workaround can you pls do below to see you can get the app back working.

  1. Go to the sync rules and find any custom rules which were changed to ‘On Change’ type and reset them back to default delivery method.
  2. from Applications screen Enable the app.

Hope this will get the app back to active. 

But next step is to discuss why those entities were changed to ‘On Change’. This could effect the sync performance unless this has been clearly verified as entities are suitable for that delivery method. 

Regards KATHUK
T
Rank
Userlevel 7
Badge +19

From the code I can see that there might be a bug here in “On Changes” trigger generation for table names longer names than 30 characters.

I’m not so familiar with MWO and the sync rules etc. but I guess you can go to “Synchronization Rules” and check all lines where “Schedule” or “Default Schedule” is set to “On Changes” and see if any Entity is in the list in the 2nd. picture below (That picture shows entities with long table names in ServiceEngApp that I can see in another database.).

 

kathlk
Rank
Userlevel 6
Badge +14

Hi,

Once you do the workaround you can take the app activated back. And then we need to fix the issue for longer table name and this looks like a broken functionality after 22.2 where we refactored how Push triggers are working. 

However please consider below when you change entity sync delivery method to ‘On Change’:

On Change should only be used for slow moving tables otherwise they will impact the system performance and batch synchronization because the entity act as PUSH enabled entity and try to run batch sync more frequently.

 

Thanks

Kapila

  

Regards KATHUK
paul harland
Rank
Userlevel 7
Badge +24

Great, thanks for the help @kathlk and @Tomas Ruderfelt 

That resolved it - i was able to activate the application after setting them all back to a daily schedule.  Looks like a defect though.

Thanks for the insight regarding On Change, I did this as an experiment into sync rules - the intent was not to do this in a live environment.

kathlk
Rank
Userlevel 6
Badge +14

No Problem Paul. Will you report an issue for Mobile EXP team? 

Regards KATHUK
paul harland
Rank
Userlevel 7
Badge +24

Hi Kapila,  we have a ticket CS0132526

 https://ifsworld.service-now.com/csm?id=csm_ticket&table=sn_customerservice_case&sys_id=6d879495978e6150d0c0b901f053afc1

Let me know if that’s ok

A
Rank
Userlevel 3
Badge +11

hi Paul,

what’s the process of upgrading MWO? Recently the SU7 on IFS ver22 is out, so want to upgrade the MWO with that.

Reply


Terms & ConditionsCookie settings