Next Number Locking Issue

INRAKBH

INRAKBH

Active Member
Hi All,
We have been facing an issues with Next Numbers failures in our E1 8.12. The 'Next Number Failed' errors occurs in P4210 - Sales Order Entry and other custom programs.The issue gets resolved when we clear some related system file.

Technical Observations :

1.Significant high number of record locks on F0002 table.
2.Due to the above the sub system jobs runnning into loop and significant hign nummber of corrupted records found in F986113 Table for that batch process.

Please help me out with suggestions or fixes or work arounds.

Thanks in Advance.

Ramesh
 
is your db still SQL2K? There are some threads here concerning the same problem with SQL2K5, which seem to be solved by installing SP2 and use the latest drivers. Maybe this is something similar
 
Back
Top