philippoommen1
Member
Hi,
One of our clients is using Progress Schema Holder and maps to an MS SQL Server. Application is hanged for a long time. When we checked the asbroker log and found the below error.
Can anyone help me sort out this issue? Is this raised due to the locking by SQL DB? Or shall we look into the Progress code base? I am asking this because no other Progress DB customers are reporting this issue. Any more log files I can refer in the SQL side? Can we give a utility to this customer when it hangs which user is locking these records (a kind of debug utility).
Kindly suggest which are the area I need to focus on so that customers should not report this issue.
[20/05/29@23:06:57.669-0400] P-020192 T-014932 1 AS -- (Procedure: 'STOCK-1 APPSERVER\STOCK\STCK0001-A.P' Line:3821) Lock wait timeout of 1800 seconds expired (8812)
[20/05/29@23:06:57.669-0400] P-020192 T-014932 1 AS -- (Procedure: 'STOCK1 APPSERVER\STOCK\STCK0001-A.P' Line:3821) Lock wait timeout of 1800 seconds expired (8812)
[20/05/29@23:06:57.773-0400] P-000532 T-011312 1 AS -- (Procedure: 'DEL1 appserver\stOck\stck002-a.p' Line:893) Lock wait timeout of 1800 seconds expired (8812)
Thanks
-Philip-
One of our clients is using Progress Schema Holder and maps to an MS SQL Server. Application is hanged for a long time. When we checked the asbroker log and found the below error.
Can anyone help me sort out this issue? Is this raised due to the locking by SQL DB? Or shall we look into the Progress code base? I am asking this because no other Progress DB customers are reporting this issue. Any more log files I can refer in the SQL side? Can we give a utility to this customer when it hangs which user is locking these records (a kind of debug utility).
Kindly suggest which are the area I need to focus on so that customers should not report this issue.
[20/05/29@23:06:57.669-0400] P-020192 T-014932 1 AS -- (Procedure: 'STOCK-1 APPSERVER\STOCK\STCK0001-A.P' Line:3821) Lock wait timeout of 1800 seconds expired (8812)
[20/05/29@23:06:57.669-0400] P-020192 T-014932 1 AS -- (Procedure: 'STOCK1 APPSERVER\STOCK\STCK0001-A.P' Line:3821) Lock wait timeout of 1800 seconds expired (8812)
[20/05/29@23:06:57.773-0400] P-000532 T-011312 1 AS -- (Procedure: 'DEL1 appserver\stOck\stck002-a.p' Line:893) Lock wait timeout of 1800 seconds expired (8812)
Thanks
-Philip-