70
We just installed GP 2015 and are trying to void a wire.
When we go Purchasing>Void Historical Transactions and enter a Vendor ID the application spins. When I go to SQL Server, the task is sleeping with no CPU or I/O. The Accounting group reports that it does not do the same for Vendors with Checks. We are using GP 2015. The Accounting area did say this was slow in the 2010 version. Any reason why the SQL SPID would stay sleeping without CPU or I/O? The Client continues to wait.
I was able to get back to this. There are not alot of options when querying from the Void Historical screen. When you enter the VendorID it spins and spins.
When looking at the SQL Trace
exec TLI.dbo.zDP_CM20200N_3 25,'WIRES-TCFL ','CASH ',4,265055,'WIRES-TCFL','CASH',3,'WIRES-TCFL','CASH',4
Continues to get called again and again and again. I ran the check links against the Payables which did not resolve this issue. Are there any obvious indexes missed? is there a trick to query or filter to reduce the run time? the size of the DB is 145 Gig
By the way, it also wouldn't hurt to stop and start SQL. When was the last time the server was restarted?
With everyone out of GP run this script in GP:
SELECT * FROM DYNAMICS..ACTIVITY
SELECT * FROM DYNAMICS..SY00800
SELECT * FROM DYNAMICS..SY00801
SELECT * FROM TEMPDB..DEX_SESSION
SELECT * FROM TEMPDB..DEX_LOCK
If any records are returned run these
DELETE DYNAMICS..ACTIVITY
DELETE DYNAMICS..SY00800
DELETE DYNAMICS..SY00801
DELETE TEMPDB..DEX_SESSION
DELETE TEMPDB..DEX_LOCK
Then perform a backup and run check links in GP against the purchasing series. It sounds like some corruption has followed you since GP 2010. Let me know if this helps and if it does not let me know the size of your company database.
Richard are you familiar with the screen? It appears to be locked and awaiting a long running query. I am waiting for the screen to unlock so I can change the calendar dates and void the payment. Is this always a case of corrupt data or are there other tweaks?
Well it looks like another SPID session was running and getting info back. As we continue to investigate, is there any reason why the data to return on this screen would take minutes to an hour? is there maintenance or an index tweak that would help? We are attempting to void a wire and are in a wait on the Void Historical Payables Transaction screen.
I would perform a backup and while no one is in GP run check links on the purchasing series. I suspect corrupt data.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (