Share
Report
173I have a job queue which basically fetches data from third-party software and stores in business central. This table in businesss central has around 439 fields so this job queue takes a lot of time. Meanwhile, we are storing all fetched data from API call inside json buffer table. But for up to 5000 records, it is running fine but for more than that it is showing following error:
We can't save your changes right now, because a record in table 'JSON Buffer' 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.
We have also increased job timeout to 18 to 23 hours still it is failing within 11 hours. No user has been working on the table as well.
We can't save your changes right now, because a record in table 'JSON Buffer' 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.
We have also increased job timeout to 18 to 23 hours still it is failing within 11 hours. No user has been working on the table as well.
All responses (
Answers (
