Synchronizing entity ResourceActivity is taking a long time to complete (210 seconds)

Look to see how much data is being synchronized in this entity - there is a Mobile lobby that will show you this

If the volume of data is too large and not needed by the mobile users then you can add a Permission Set Filter to restrict the amount of data being synchronized. This will increase the sync time for this entity

Cheers

James

Hi @lopespetro  We use ResourceActivity Lu in different functionalities eg. new work

Can you please run below sql and check whether how many records appear for entity ResourceActivity

SELECT msd.user_id, msd.device_id, msd.entity, count(1) as "Record Count"
FROM ifsapp.mobile_sync_data msd, ifsapp.mobile_device_app_user mdau
WHERE msd.app_name='MaintEngApp'
AND mdau.app_name=msd.app_name
AND  mdau.device_id = msd.device_id
AND mdau.user_id = msd.user_id
AND msd.user_id = upper('XXXXXXX')    --- Replace your user id
AND mdau.state_db = 'ACTIVE'
GROUP BY msd.user_id, msd.device_id, msd.entity
ORDER BY msd.user_id, msd.device_id, msd.entity

Ok timing seems not due to returning large rec count.  Can you share the record count in below tables:

• Mobile_Work_Order_Tab
• Jt_Task_Tab
• Resource_Activity_Alloc_Tab

Sorry I forgot to add table resource_activity_tab. Please share that count too.

It is appeared this very large record count in resource_activity_tab and Resource_Activity_Alloc_Tab causing the delay when syncing Ly ResouceActivity

Our default where is 

"origin_key1 IN(select task_seq from Mobile_Work_Order_Uiv) and activity_origin_db = 'WORK_TASK' and resource_activity_seq NOT IN (select resource_activity_seq from resource_activity_alloc)";

It is unlikely we can do any thing in the core solution. May be you can try to add below indexes and check for any improvement. 

• origin_key1 on table  Resource_Activity_Tab
• resource_activity_seq on table Resource_Activity_Alloc_Tab

Cheers,

B

Hi @lopespetro , As you see you already get a small data count to mobile in Lu (5 records) So PS filters won’t helps. So as I see try out the indexes would be a better option here