Hi All.
I’m facing this situation where it takes a long time to sync a single task to mobile user, about 30 40 minutes.
The user need to initialize the app to receive the task.
Using Apps10 UPD17, MWO Maintenance app Aurena.
Sync Task T10565723] of User UFRSA] Device v27559] - Still executing... Database Process is waiting for MWS.
Any ideia what might it be?
Hi,
MWS is taking more time to process the PUSH sync task. This delay could be caused by one or multiple entities experiencing slow execution.
To identify currently executing slow SQL, you'll need to check the active sessions in Oracle, which requires DBA support.
If you can consistently replicate this issue for a user, then gather the Sync traces (ensure it's enabled before testing) to pinpoint the slow SQL queries. This problem is likely associated with a large dataset or poor SQL execution within the application entity.
Sometimes, a single Sync Task may receive a large number of records simultaneously for synchronization. Check the Push Queue and observe the data change pattern. Do you notice a significant increase in the number of push queue records within a short interval?
Hi,
MWS is taking more time to process the PUSH sync task. This delay could be caused by one or multiple entities experiencing slow execution.
To identify currently executing slow SQL, you'll need to check the active sessions in Oracle, which requires DBA support.
If you can consistently replicate this issue for a user, then gather the Sync traces (ensure it's enabled before testing) to pinpoint the slow SQL queries. This problem is likely associated with a large dataset or poor SQL execution within the application entity.
Sometimes, a single Sync Task may receive a large number of records simultaneously for synchronization. Check the Push Queue and observe the data change pattern. Do you notice a significant increase in the number of push queue records within a short interval?
Hi
They will apply this setting to our environment and let’s see if we have a solution.
Br.
Lopes
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.