JOB queue running in Background which fetches data from Dynamics 365 CRM on job table but I dont know sometime when I am working on puchase order table it is giving errror that "we cannot save your data due to a record is modified in another table by another transaction"
Error: We can't save your changes right now, because a record in table 'Job' is being updated in a transaction done by another session. You'll have to wait until the other transaction has completed, which may take a while. Please try again later.Business central
Its not happening everytime.It gives error sometimes and sometimes not.
Hi, as far as I know, there is no job table in the standard connector with CRM. Is this a custom one? If yes, please check your code, you can try to debug to see where this problem occurs.
Hope this can give you some hints.
Thanks.
ZHU
may be because Purchase is connected with the Job Table in certain cases so there might be Job table modifying in backend and that is why this lock table occurs when both the processes modify the job table at the same time.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156