Share
ReportA get/change operation on table 'ivExceptionDays' failed accessing SQL data
Categories:
You’re offline. This is a read only version of the page.
A get/change operation on table 'ivExceptionDays' failed accessing SQL data
Inventory discrepancies can be caused by a multitude of factors, such as warehouse receiving errors, misplaced or lost inventory, inaccurate records of returns, using outdate warehouse technology, and poorly trained employees. www.myinsuranceinfo.org/
Hi,
Normally an error with 'Failed access SQL data' indicated that you have lost some type of connection to the server and it cannot get the table.
When this occurs logging out of GP and back in will usually resolve the issue.
Also, you might have orphaned/stuck activity records. You can get all users out of GP and check the activity tables for stuck records.
SELECT * FROM DYNAMICS..ACTIVITY
SELECT * FROM DYNAMICS..SY00800
SELECT * FROM DYNAMICS..SY00801
SELECT * FROM TEMPDB..DEX_LOCK
SELECT * FROM TEMPDB..DEX_SESSION
DELETE DYNAMICS..ACTIVITY
DELETE DYNAMICS..SY00800
DELETE DYNAMICS..SY00801
DELETE TEMPDB..DEX_LOCK
DELETE TEMPDB..DEX_SESSION
If you then still have this issue, there could be an issue with the table itself or the data in it and may require a support ticket for further investigation.
I hope this information helps.
Thank you,
Janelle
Dynamics GP Support
At least here or if I try an article I can get away with a few more paragraphs! It's good information though. www.mycoverageinfo.biz/
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,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
