Any changes are not getting saved in to table, after saving it is getting deleted

[former_member200650]

Hi all,

In my client Sandbox environment since yesterday any changes am doing (e.g creating sales order, creating customer master or updating the customer name to the existing customer  etc are not getting updated) not getting saved into table.

The below are some of my observations:

• lock entries are getting updated every time and i need to go to SM12 every time and delete the entries, again when am trying to create a sales order system is saving the order and when i go to change mode of the sales order. system is showing either it is deleted or archived.
• Lock entries are getting accumulated every time
• Tried to create a new customer or material system is saving the customer or material and when i tried to check in change mode, it says no data exist.
• Similarly MM people also tried their transaction data, same issue no data is getting saved.
• Checked in ST22 and SM50 but found no clue.

VA02:

sm12

SM50

[Former Member · Accepted solution]

From your SM50 screenshot we can see that your only one update work process is hanging, and I suppose that's the root cause.

Find out why it is hanging.

For are start check SM13. Is update active?

Then check database logs for problems. Something like tablespace full in case of Oracle, for example.

If needed ask your Basis team for help again.

Then you might consider to increase the number of update work processes.

hope this helps