restarting an integration synchronisation job which crashed!

(1) Share

Report

Posted on by jaybeegee

135

Hello! We have an integration job which synchronises the BC customer price groups with CRM pricelists but has clearly crashed! Is there a way to kill the process as it is now effecting our ability to run the job again to refresh pricing and clashing with our jobs?

Categories:

Business Central

All responses (5)

Answers (1)

Verified answer

Andy Wingate 320 on at

Like (0)

Report

restarting an integration synchronisation job which crashed!

Hi some belt a braces suggestion if you didn't already try.

Based on your screen shot you must be on an older version of BC and on-prem? Did you restart the NAV service.

After that didn't fix anything, next I'd suggest to remove the Integration Table Mappings entry and re-create it, this will re-create the job queue entry for you.

I just created a test integration, and then manually deleted the job queue - which made this button non-functional.

Or you could just create the job queue manually for this integration task; here are the settings from the automatically created one extracted via rapid start, the key field that links the job back to the Table Mapping appears to be the "Record ID to Process" that seems you can only set via conf. packs.

https://github.com/andywingate/files/blob/main/Example%20of%20Integratino%20Job%20Queue%20Setup.xlsx

Hope that helps!

A
jaybeegee 135 on at

Like (0)

Report

restarting an integration synchronisation job which crashed!

Sorry Valentin and need some more spoonfeeding!

The particular job is definitely missing from the list of Job Queue Entries and so we trigger it from the 'Integration Table Mapping' - yes it is not set to schedule as we only run it after a price has been updated every 6months and will change to monthly. But it is not a problem as we can trigger manually after updating the customer price groups.

You mention "integration sync jobs" and yes I can see the job here but there is option to restart/stop the job from the log:

So the problem we have is that we have a job stuck but cannot stop/restart-any thoughts?

Is the solution to find the codeunt somehow and add it to the job queue so we have the restart/stop option?
Suggested answer

Valentin Castravet 24,824 Super User 2024 Season 2 on at

Like (2)

Report

restarting an integration synchronisation job which crashed!

The integration sync jobs is a log of the job queues being run that are related to your synch that are setup in the job queue entries page. It should definitely be in the job queue entries page, please look at the description column in the job queue entries page to recognize it. If its not there then its not setup to synch on a set schedule.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/
jaybeegee 135 on at

Like (1)

Report

restarting an integration synchronisation job which crashed!

thank you @valentin for taking the time to respond and whilst not the exact answer I was looking for i think we are close!

For some reason we have the particular job missing from the queue and it is being run from the integration sync jobs as per screenshot!

Is there a quick fix?
Valentin Castravet 24,824 Super User 2024 Season 2 on at

Like (0)

Report

restarting an integration synchronisation job which crashed!

You can stop or restart the job queue. In the Job Queue Entries Page select the integration job queue and select Restart or Set On Hold:

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/