Archive problem after WIP DB Restore

[Former Member]

Hi,

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,

Johan

[Former Member · Accepted solution]

Johan

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.

Stuart

[Former Member · Accepted solution]

Hi Stuart,

Yes, I have gone through the tables.

I have created a join query between the ODS AR_SFC table and the WIP ID_USED table where ID_USED.ARCHIVED=false to find all the SFC's that are in archive tables but not archived according to WIP DB. Does this sound like the right approach?

After I have taken care of SFC's I will have to find Inventories and Shop Orders as well.

/Johan

[Former Member · Accepted solution]

Yes, that should work fine.

[sergiy_katerinich · Accepted solution]

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.

Regards,

Sergiy