Update failed Error: - Error in database access: Table /LIME/NSERIAL

[Pankaj-Kumar]

Problem:

Problem:

Stock was un-sync where S4/ECC Stock was serialized and EWM stock was non-serialized due to faulty upload.
Additionally "C" was marked in /SCWM/MON whereas stock was non-serialized.
While performing the sync activity with: After change of serial profile in /SCWM/SERH, while performing ADGI system fetch error as stock is not properly serialized.

After ADGI stock upload with T-Code /SCWM/ISU getting Update failed Error: - Error in database access: Table /LIME/NSERIAL, operation I /LIME/CORE(012)

[Pankaj-Kumar · Accepted solution]

There may me other factors for this error.. But for my case

solution which I applied with Functional colleague and after approval of COE and system owner:

1. Delete "C" indicator from table /SCWM/QUAN in de-bug mode then delete stock with /SCWM/ADGI.

2. Get Parent_GUID and GUID_STOCK from /SCWM/AQUA with reference to Material Number only. If batch stock available for material then will be visible insided the table once get in to table.

3. Take GUID_STOCK from above table and put it in /LIME/NSERIAL and delete all related entries. 4. Delete entries from /SCWM/SERI for all related serial number in de-bug.

4. Change the serial Profile of Material /SCWM/SERH and Upload the stock.

Thanks!

Pankaj Kumar