Table locking is serious in D365 BC

(0) Share

Report

Posted on by nikki_sixx91

hi all,

I didn't expect as long as if I'm writing/updating lot number of data to any table in BC. Pretty much it will create locked tables. For instance, I have a custom program to massively generate the warehouse shipment documents (500 to 1500 documents, we use warehouse shipment as our delivery document). During the program run, even another report is trying to read the data records from the table which stores the warehouse shipment document, will face table lock due to my custom program is still updating the table. Now my question is there any other way (in terms of coding in the report) that I can read and retrieve data from this table even the custom program is still updating it?

Thanks!

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

JAngle 133 on at

Like (0)

Report

Get the custom program to use temporary tables for reading and main table for writing. Add the routine to the job queue to run more frequently to minimise the amount of entries it handles per run or do the processing outside of office hours

Was this reply helpful? Yes No