You’re offline. This is a read only version of the page.
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
Have you tried running SQL Profiler while no one is in GP to see what service is running on the SOP tables?
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
Glad I could help.
The very last one is the only one that affected any records, check links ran perfect. Thank you so very very much!
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;
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?
Have you tried clearing the SY00800 and SY00801 tables?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,134
Super User 2024 Season 2
#2
Martin Dráb
229,928
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (