?
Solved

Microsoft Dynamics GP cannot check links on Sales Work because it says users are accessing it

Posted on 2010-01-11
5
Medium Priority
?
1,067 Views
Last Modified: 2013-12-11
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
Comment
Question by:bradlee27514
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 

Author Comment

by:bradlee27514
ID: 26288053
When I look in the work table (SOP10100) I see two records, but they are both voided out.
0
 
LVL 18

Expert Comment

by:Steve Endow
ID: 26288383
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
 

Author Comment

by:bradlee27514
ID: 26296667
That query returns no results for the company or system database, any other ideas?
0
 
LVL 18

Accepted Solution

by:
Steve Endow earned 2000 total points
ID: 26300704
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
 

Author Comment

by:bradlee27514
ID: 26307659
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A frequent question here in the MAS90 Zone is, How do you get data out of MAS90 for analysis, reporting or using the data on your web pages?   This is an introductory level tutorial to getting data out of MAS90 using ODBC. Data can be accessed by…
Hi, I've just fixed a problem with Sage 50 Accounts 2010 crashing when creating a new Company.  I've spent nearly 4 hours on it including three calls to the Sage helpdesk (they didn't work it out in the end - I did!) ... so I thought I'd share th…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question