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

Facing an error in job queue

(0) Share

Report

Posted on by Pragya752

236

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

All responses (4)

Answers (0)

Sort by

Judy Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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
SP-27040910-0 6 on at

Like (0)

Report
Copy link

Link copied!

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.
Suggested answer

KasparsSemjonovs 4,851 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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.
Pragya752 236 on at

Like (0)

Report
Copy link

Link copied!

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;

Join the conversation

Community site session details

Facing an error in job queue

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the September 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

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the September Top 10 Community Leaders

Subscribe to this forum!

Select categories

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

Featured topics

Product updates