bradlee27514
asked on
Microsoft Dynamics GP cannot check links on Sales Work because it says users are accessing it
Running Check links on one of my company databases. Get no errors on all series except sales. Everything in sales is fine except for 'Sales Work'. It says
'This file cannot be processed while other users are accessing it'
Well no one is, the only user logged into the company is the sa, I even check the dynamics..activity table. What could be the issue here?
'This file cannot be processed while other users are accessing it'
Well no one is, the only user logged into the company is the sa, I even check the dynamics..activity table. What could be the issue here?
Hi,
Try querying TEMPDB.dbo.DEX_LOCK.
SELECT * FROM TEMPDB..DEX_LOCK
If you see a table_path_name value with SOP10100 (or another SOP table), those may be your candidates. The row_id value refers to the DEX_ROW_ID value for that table, which you can compare to the two voided records in SOP10100.
Once you are comfortable that the lock records are invalid, you can delete those specific records.
Thanks,
Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified Professional
Try querying TEMPDB.dbo.DEX_LOCK.
SELECT * FROM TEMPDB..DEX_LOCK
If you see a table_path_name value with SOP10100 (or another SOP table), those may be your candidates. The row_id value refers to the DEX_ROW_ID value for that table, which you can compare to the two voided records in SOP10100.
Once you are comfortable that the lock records are invalid, you can delete those specific records.
Thanks,
Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified Professional
ASKER
That query returns no results for the company or system database, any other ideas?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Weird I didn't see a KB on it, I got a response in a different forum with that very response. Thanks!
ASKER