Question

MWO Init Waiting for GP / ORA-01873: the leading precision of the interval is too small

  • 23 September 2022
  • 3 replies
  • 250 views

Userlevel 2
Badge +2

Hi together,

 

we have a problem that the MWO Service App is not connecting to the server. Every User we used, is stuck on the same loading screen during initlization.

Furthermore, we used already several new environments and the issue always exists. After around 24 hours, sometimes we can connect, however changes in object, workflow configuration etc. need again around 24 hours to show up in the mobile devices.

 

We have set up everything according to the technical documentation correctly:

 

1, IAM Clients → set up the URL´s

2, User IFSSERVICEENGAPP & IFSMAINENGAPP added to the relevant company as well site

3, Database Processes are “Scheduled” and active

 

Every Native User has the status in installed Apps “Init Waiting for GP” 

 

 

 

Furthermore, we found out that we get an error in Grouped Push Transaction Traces:

Error when processing transactions in procedure Mobile_Transaction_Batch_SYS.Execute_Task_. Error: Error during execution of GroupedPush background task (ORA-01873: the leading precision of the interval is too small
ORA-06512: at "IFSAPP.MOBILE_TRANSACTION_UTIL_SYS", line 161
ORA-06512: at "IFSAPP.MOBILE_TRANSACTION_BATCH_SYS", line 1773
)

 

 

 

Has anyone a suggestion or solution? We need a quick solution.

Thanks in advance


3 replies

Userlevel 6
Badge +16

This is a known issue and we are working on a correction. As a workaround you can run the following SQL:

UPDATE mobile_transaction_task_tab

SET (STARTED_AT,FINISHED_AT) =

(SELECT STARTED_AT,FINISHED_AT

FROM mobile_transaction_task_tab

WHERE app_name = 'ServiceEngApp'

AND TASK='INIT')

WHERE app_name = 'ServiceEngApp'

AND TASK='REFRESH'

Userlevel 2
Badge +2

Thanks James,

 

the issue is, that we use a managed IFS Cloud 22R1, so it looks like we can only initalize via SQL through an IFS Support Case.

 

I will give an update if the workaorund helped, after IFS executed it.

Userlevel 5
Badge +8

Hi @DanielH

Have you resolved this error? 
How did you execute this Update block in the IFS Cloud environment?

Thanks in advance! 

Kalana.  

Reply