Retrive deleted entries in CATSDB table

[Former Member]

Hi,

We are facing an issue where CATSDB table entries have got deleted accidentally while running the program RCATSDEL. This has resulted in all time entries being deleted in time entry related tables. Is there any way we can reload/retrieve the deleted data in the system at DB level? We are using SQL server for storing the data.

Appreciate your help,

~Athreya

[Reagan]

Restore the backup of the system to another server and try retrieving the data for the affected tables.

This needs to be consulted with the developers to ensure that there wont be any other damages done to the system.

Like suggested above switching to the DR site and using the standby database there is not a solution as the changes will be already replicated to the standby node.

Regards

RB

[former_member188883]

Thanks RB for correcting me.

[Former Member]

First, I should warn you that it isn't just about the CATSDB table. See the Technical Background Information chapter of the application help in order to understand the complexity of CATS. Depending on your system configuration (which modules are in use), the restore process can vary from semi difficult to very difficult. First talk to your ABAP developer to analyze report RCATSDEL in order to figure out what tables are involved and then include the respective system analysts (HR, FI/CO, PS, MM). Once you know the list of involved tables, you can talk to your DBA about restoring the tables (assumed you have backups) to a temporary DB which you can then use to rebuild the CATS entries. Depending on the system configuration post-processing and/or manual activities might be required and that is where you will need the help of your ABAP developer and system analysts.

[former_member188883]

Hi Athreya,

1) Do you have a full and consitent backup before the deletion activity happened ?

If yes, you may restore the same .

2) Is this your Production system and you have DR system configured ?

    If yes, make DR as Productive and re-create production with backup from DR.

Hope this helps.

Regards,

Deepak Kori