4Site
Support Request System
View Patch #60.001.026
Description
Patch ID:
Date Implemented:
Patch Title:
Patch Type:
Request IDs:
Bug
Enhancement
Other
03268 -
Running StTotals process locks users out of PO Issue process
Symptoms:
While the sttotal process is running, users may experience database timeouts while using the other 4Site applications.
Solution:
The sttotal process processes a large amount of data. The SELECT statements that retrieve the data to process could take a long time to complete, during which time the tables involved would be locked to other processes by SQL server to ensure data integrity. To reduce the amount of time that tables would be locked, the SELECT statements have been changed to retrieve information for one stock item at a time instead of for all stock in a single statement. Now, each SELECT now only takes a couple of seconds at most instead of minutes, but many more SELECTs are required. The end result is a process that now takes several hours to complete with a constant burden places on the SQL server due to the thousands of operations it must now execute, but no extended table locking occurs which will prevent user of other 4Site applications from experiencing timeouts.
Browse Patches
Find a Patch
Return to Request System Menu
