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?
bradlee27514Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

bradlee27514Author Commented:
When I look in the work table (SOP10100) I see two records, but they are both voided out.
0
Steve EndowMicrosoft MVP - Dynamics GPCommented:
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


0
bradlee27514Author Commented:
That query returns no results for the company or system database, any other ideas?
0
Steve EndowMicrosoft MVP - Dynamics GPCommented:
Hi,

Well, I should have checked the Knowledge Base first!

https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?WTNTZSMNWUKNTMMYMXTYYKSWTLKQNNOXTSMLXKWYRXQSRQMWZTVNXLWYLVVVVOMQ

Here are the tables to check:

DYNAMICS..ACTIVITY
DYNAMICS..SY00800
DYNAMICS..SY00801

tempdb..DEX_LOCK
tempdb..DEX_SESSION

You can have everyone log out of and close GP and then run delete on all of the tables, or you can query them and selectively delete only the records you need to remove.

Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified Professional

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
bradlee27514Author Commented:
Weird I didn't see a KB on it, I got a response in a different forum with that very response.  Thanks!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Tax / Financial Software

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.