Skip to Content

Archive problem after WIP DB Restore


After a failure in WIP Server we had to restore the WIP DB.
The restore was successful, but now the archiving job is failing because some
of the SFC's has been archived and exists in ODS Archive tables.

Is there any best practice on how to handle such a situation.

Naturally I can manually try to find the SFC's and delete them in the archive tables,
but I was thinking there might be a better way.

Best regards,


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    May 28, 2015 at 08:09 AM


    Whenever I've encountered such a problem, I've just used SQL to identify the duplicates and then prepared deletion scripts. It can be tricky as there are a lot of tables associated with each SFC.


    Add comment
    10|10000 characters needed characters exceeded

    • Hi Johan,

      There was an issue about ID_USED.ARCHIVED not set for Inventory IDs - see SAP Note 1997928.

      Thus I used to create SQL script to find same SFC IDs in WIP.SFC and ODS.AR_SFC tables. And then check for related content in SFC child tables. Similar approach - for Shop Orders and Inv IDs.