Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1085
  • Last Modified:

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?
0
bradlee27514
Asked:
bradlee27514
  • 3
  • 2
1 Solution
 
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
 
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

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now