AFTER REPAIR SUSPECT DATABASE ERROR OCCURS Requested objects cannot be loaded, because they are absent in the data store. These objects can already be deleted or purged.

Created by Cheng Kah Poh, Modified on Thu, 17 Dec, 2020 at 5:32 PM by Cheng Kah Poh

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

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article