Hi,
This is going to be the most generic GL post problem ever ... but the problem itself is obscure. When any user logs into Accpac and attempts to go into GL Transactions - Batch List and then immediately attempt to change the status of a batch from ready to post No to Yes then the screen immediately freezes. Accpac 5.6A / SQL Server 2005.
The odd thing is I can replicate the issue on my PC, but if I open the window and then immediately click one of the up or down arrows on the scroll bar for the list/grid first and then attempt to change the ready to post status it works. This doesn't work on our Citrix environment however.
To be honest I have no idea what I should be looking for in RVSPY, but here's the last line when the window freezes:
[1a54] GL0008: GLBCTL [16:27:57.10].Update(view=0x05BE8EFC)
From SQL Profiler I see the following statements/calls:
select top 1 "BATCHID","AUDTDATE","AUDTTIME","AUDTUSER","AUDTORG","ACTIVESW","BTCHDESC","SRCELEDGR","DATECREAT","DATEEDIT","BATCHTYPE","BATCHSTAT","POSTNGSEQ","DEBITTOT","CREDITTOT","QTYTOTAL","ENTRYCNT","NEXTENTRY","ERRORCNT","ORIGSTATUS","SWPRINTED","SWICT","SWRVRECOG" from "GLBCTL" with (index(GLBCTL_KEY_0) /*,updlock*/) where "BATCHID"='274769' option(keep plan)
(@P1 decimal(9, 0),@P2 char(8),@P3 char(1))update "GLBCTL" set "AUDTTIME"=@P1,"AUDTUSER"=@P2,"BATCHSTAT"=@P3 where "BATCHID"='274769' and "AUDTDATE"=20130326 and "AUDTTIME"=15560922 and "AUDTUSER"='XXXXX ' and "AUDTORG"='XXXX'
Not that it matters, but I made the username and org XXXX.
What happens is the BEGIN TRAN of the update statement is called, but the update statement appears to hang and creates a row lock on whatever record you tried to update (this happens for all records). I can post in subledgers, but nothing in the GL. To my knowledge nothing has changed from the server or application side ...
Input?
Thanks,
Ian
This is going to be the most generic GL post problem ever ... but the problem itself is obscure. When any user logs into Accpac and attempts to go into GL Transactions - Batch List and then immediately attempt to change the status of a batch from ready to post No to Yes then the screen immediately freezes. Accpac 5.6A / SQL Server 2005.
The odd thing is I can replicate the issue on my PC, but if I open the window and then immediately click one of the up or down arrows on the scroll bar for the list/grid first and then attempt to change the ready to post status it works. This doesn't work on our Citrix environment however.
To be honest I have no idea what I should be looking for in RVSPY, but here's the last line when the window freezes:
[1a54] GL0008: GLBCTL [16:27:57.10].Update(view=0x05BE8EFC)
From SQL Profiler I see the following statements/calls:
select top 1 "BATCHID","AUDTDATE","AUDTTIME","AUDTUSER","AUDTORG","ACTIVESW","BTCHDESC","SRCELEDGR","DATECREAT","DATEEDIT","BATCHTYPE","BATCHSTAT","POSTNGSEQ","DEBITTOT","CREDITTOT","QTYTOTAL","ENTRYCNT","NEXTENTRY","ERRORCNT","ORIGSTATUS","SWPRINTED","SWICT","SWRVRECOG" from "GLBCTL" with (index(GLBCTL_KEY_0) /*,updlock*/) where "BATCHID"='274769' option(keep plan)
(@P1 decimal(9, 0),@P2 char(8),@P3 char(1))update "GLBCTL" set "AUDTTIME"=@P1,"AUDTUSER"=@P2,"BATCHSTAT"=@P3 where "BATCHID"='274769' and "AUDTDATE"=20130326 and "AUDTTIME"=15560922 and "AUDTUSER"='XXXXX ' and "AUDTORG"='XXXX'
Not that it matters, but I made the username and org XXXX.
What happens is the BEGIN TRAN of the update statement is called, but the update statement appears to hang and creates a row lock on whatever record you tried to update (this happens for all records). I can post in subledgers, but nothing in the GL. To my knowledge nothing has changed from the server or application side ...
Input?
Thanks,
Ian