About udate record failure

[Former Member]

Hi all,

I have seen update record failures in sm13 with error, what should i do first?

kind regards,

praveen

[Former Member]

Hi,

The update work process reads the data from the VB* tables and executes the updates in the corresponding tables of the r/3 database.

Once the update is sucessfully completed , the entries in the VB* tables and in the lock table are deleted.

If an error occurs, the lock table entry is deleted, but hte entries in the VB* tables

are not deleted.

The user is notified immediately by the mail.

Depending on the business data object, the entry may be reposted.

[Former Member]

Thanks for ur reply

[Former Member]

Hi Praveen,

Follow the below steps to avoid data inconsistency in production environment,

1. In SM13, check whether the `Update is in active` status , if yes, then the problem is with certain user action. If not, check the table space status. whether any table space has reached 100%. If the table space has reached full , extend the table space and change the update to active. SAP will automatically change the status to inactive if any of the table space reaches 100%, this is to avoid inconsistency.

2. If it is not related to table space problem, check the failed update error. if you double click on that error, you will get the detailed error report..where it got failed and in which transaction it happened etc.

Normally, update errors are to be handled with coordination from Func and end user. Find out which user action has triggered this update error etc. Ask your func team to check if there is any business impact due to this error ( due to missing document etc). if there is any, ask your func team to analyze the situation and repost the failed document.

Once the business impact is fixed, ask your func team to search for any notes available in OSS for that particular transaction which caused the update error. in general, there will be some corrections or SAP will recommend to apply note.

This will solve the problem.

Hope this will help you a bit to analyze the update error situation.

regards,

Vinodh.