Trouble with check links in sales work - This file cannot be processed while other users are accessing it

(0) Share

Report

Posted on by Community Member

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?

When I look in the work table (SOP10100) I see two records, but they are both voided out.

There are no records for this company in dynamics..activity

There are no records for this query either, SELECT * FROM TEMPDB..DEX_LOCK

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

MG-16101311-0 26,225 on at

Like (0)

Report

Have you tried clearing the SY00800 and SY00801 tables?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

There are no records in the SY00800 for this company and there are no records for any company in SY00801.
Any other tables I should look at?

Was this reply helpful? Yes No
MG-16101311-0 26,225 on at

Like (0)

Report

My apologies... let's start over. I know you said you have run a number of checks, but here is what I want you to do:

Run these against your DYNAMICS database. Make sure all GP sessions are closed, including the one you are working on:

USE DYNAMICS;
GO
DELETE ACTIVITY;
DELETE SY00800;
DELETE SY00801;

USE tempdb;
GO
DELETE DEX_LOCK;
DELETE DEX_SESSION;

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

The very last one is the only one that affected any records, check links ran perfect. Thank you so very very much!

Was this reply helpful? Yes No
MG-16101311-0 26,225 on at

Like (0)

Report

Glad I could help.

Was this reply helpful? Yes No
Dan Liebl 7,320 on at

Like (0)

Report

I am updating this thread as I have the same problem. For this customer, I have cleared all the above tables, stopped a Scribe CRM>GP integration (stopped all Scribe services), and also checked the SQL Activity Monitor and it showed only 1 record to the database/company I was logged in at. I ended all other processes out there. The 1 process was for the sa user to run the checklinks. Any suggestions on what else to look for? I am stumped...

Dan Liebl, CMA CPIM | Senior Consultant | OTT,Inc | DLiebl@OTT-inc.com

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

Have you tried running SQL Profiler while no one is in GP to see what service is running on the SOP tables?

Was this reply helpful? Yes No
Dan Liebl 7,320 on at

Like (0)

Report

Thanks Richard! I will give that a try. Have you ever run across this before?

Dan Liebl, CMA CPIM | Senior Consultant | OTT,Inc | DLiebl@OTT-inc.com

Was this reply helpful? Yes No