Small and medium business | Business Central, N...

Facing an error in job queue

(0) Share

Report

Posted on by Pragya752

234

I 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.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (0)

Judy Microsoft Employee on at

Like (0)

Report

Hi,

Have you tried to restart the environment? Please restart the Job related and restart the API rest and run it again to see if the error occurred.

The following Document help you troubleshoot issues with Business Central so that you can gather information about a given problem, identify the cause of the problem, and eventually implement a sustainable solution.

Troubleshooting overview - Business Central | Microsoft Learn

Best Regards,

Judy

Was this reply helpful? Yes No
Community member 6 on at

Like (0)

Report

Hi,

Ìs it possible to do pageing in your API and read <5K records at a time to process and store it and use commit before u call for next pageing.

Was this reply helpful? Yes No
Suggested answer

KasparsSemjonovs 4,774 Super User 2025 Season 2 on at

Like (0)

Report

Sankar P is correct. Paging should solve the issue.
It is know that Business Central limits queries or records to 5000. Similar as You cannot export to excel more than 5000 lines. In NAV it was possible to change this limit in ClientUserSettings file, but for BC not sure if it can be done via CMDLETs. You can explore in this direction.

Was this reply helpful? Yes No
Pragya752 234 on at

Like (0)

Report

I have set one record per page only.

Pagingobject.Add('PageIndex', PageIndex);

Pagingobject.Add('PageSize', LSQSetp.PageSize);

JObject.Add('Paging', Pagingobject);

JObject.Add('Columns', IncludeCSVObject);

SortingObject.Add('ColumnName', 'CreatedOn');

SortingObject.Add('Direction', 1);

JObject.Add('Sorting', SortingObject);

if Response.IsSuccessStatusCode then begin

Response.Content().ReadAs(ResponseText);

//Message(ResponseText);

JsonBuffer.Reset();

if JsonBuffer.FindSet() then

JsonBuffer.DeleteAll();

jsonBufferTemp.ReadFromText(ResponseText);

if jsonBufferTemp.FindSet() then

repeat

JsonBuffer := jsonBufferTemp;

JsonBuffer.Insert();

until jsonBufferTemp.Next() = 0;

Was this reply helpful? Yes No

Join the conversation

Community site session details

Facing an error in job queue

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

Facing an error in job queue

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates