Scenario
After Repair suspect Database, while click transaction screen or report error occurs:
This type of issue mostly database suspect, after repair by script.
Some of the missing data will purged/deleted after repair.
To solve this issue please refer solution.
Solution
Step 1 – From the message we get the important info
f5d4b56c-57e6-41a4-913b-e7e92b49a423
b656776d-5730-4a31-9067-c504b5c39073
Step 2 – Please get the script from google drive:
https://drive.google.com/file/d/1F-ZZ0Ovjuoelq5enG-mSPdc98_YK5_Fi/view?usp=sharing
Step 3 – Copy and Paste the script in SQL Management Studio.
Step 4 – Click Execute.
Result:
Note: From the result we know that in Stock Table, Stock code is 90915-YZZD2 , this stock item column name Model33 contain the id (f5d4b56c-57e6-41a4-913b-e7e92b49a423), we looking for.
This id is purged or deleted item, so then we can run script to remove it.
Done.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article