2,010
For a custom SL, no results return because the following three errors appear:
GPS Error 58
SQL Error: 601 [Microsoft][ODBC SQL Server Driver][SQL Server] could not
continue scan with NOLOCK due to data movement.
ODBC Error 37000
*This post is locked for comments
Update: There are no reminders and the errors still appear when logged in as SA in the live company. It doesn't happen with the sa user id in a sample company.
Hi Leslie,
I think this is due to data corruption in the dba, based on the second SQL error message. The version/SP is SP2 of 2010. After some digging, we've found that only specific fields set off this series of errors, so if any of these fields are used in the SL, the SL will error out with those three messages. It is a SL under Inventory Trx's so we attempted a Check Links for IV Trxs, Item Master, BOMs and Receipts but no errors were found. We don't know when this SL stopped working, but it did work at some point.
Hi,
I thought of some more questions. Is this happening for every user? Is the SmartList Favorite available to the System? Are any reminders set up that reference this SmartList. Has it ever worked?
When does the error present? If you delete all SmartList reminders, is the error still present? Do any users have Reminders based on Favorites that no longer exist?
If you log in as 'sa' for the sample company, do you still get the error? You'll need to import the SL into the sample company first.
Random ideas, maybe one of them will help.
Kind regards,
Leslie
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,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (