20
Hello!
When the team or myself tries to check this debit line, we get the error in the screenshot. I have found a lot of other forums with answers but none have seemed to work yet.
There is nothing sitting in the Batch Recovery also.
Thanks!
The batch recovery window is located in the menu options: Microsoft Dynamics > Tools > Routines > Batch Recover. TellHappyStar
First, get everyone out of GP. Then run this script.
SELECT * FROM [DYNAMICS].[dbo].[ACTIVITY] ORDER BY USERID
SELECT * FROM [DYNAMICS].[dbo].[SY00800]
SELECT * FROM [DYNAMICS].[dbo].[SY00801]
SELECT * FROM [TEMPDB].[dbo].[DEX_LOCK]
SELECT * FROM [TEMPDB].[dbo].[DEX_SESSION]
If any records are returned run this.
DELETE [DYNAMICS].[dbo].[ACTIVITY]
DELETE [DYNAMICS].[dbo].[SY00800]
DELETE [DYNAMICS].[dbo].[SY00801]
DELETE [TEMPDB].[dbo].[DEX_LOCK]
DELETE [TEMPDB].[dbo].[DEX_SESSION]
If this does not fix it run this script after backing up your company database
DELETE RM00401
Then run Maintenance->Check Links on the entire sales series. I usually send the output the screen and to a text file.
Did you have a fix on this issue? Challenging a relative issue yet no response from anyone and couldn't see this point taking a gander at in google.
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (