4Site
Support Request System
View Patch #50.506.034
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:
Numerous locks on the transaction tables were affecting other applications causing slowdowns and even timeouts. The code causing this looked like: Insert into r_stkbyown Select … union … select … union…
Solution:
Each select is now done independently and returned in separate recordsets causing minimal select-read locking. Records are then inserted into r_stkbyown one at a time without involving transaction brackets. Note: This “de-optimization” causes the application to roughly take twice as long to run but causes next to no record locking. Additional: Two updates to the r_stkbyown table are now allowed to run with very high querytimeout setting.
Browse Patches
Find a Patch
Return to Request System Menu
