Deleting from the Change Log 

Use

We recommend that you delete data from the change log of a DataStore object if several requests that are no longer needed for the delta update and are no longer used for an initialization from the change log have already been loaded into the DataStore object. If a delta initialization is available for updates to connected InfoProviders, requests have to be updated before the corresponding data can be deleted from the change log.

A temporary, limited history is retained. In some cases the change log becomes so large that is advisable to reduce the volume of data and delete data from a specific time period.

If you have deleted requests form the change log, and the requests can still be seen in the DataStore object administration screen on the Requests tab, this means that these requests cannot be deleted again on the DataStore object administration screen

This is because the requests have already been deleted from the change log, which means that it is no longer possible to perform a rollback.

Procedure

Inserting the deletion of requests from the change log into the process chain

You are in the plan view of the process chain where you want to insert the process variant.

...

       1.      To insert a process variant for deleting requests from the change log into the process chain, double-click process type Deletion of Requests from the Change Log from process category Further BI Processes.

       2.      In the next dialog box, enter a name for the process variant and choose Create.

       3.      On the next screen, enter a description for the process variant and choose Continue.

The maintenance screen for the process variant appears.

       4.      Under Type of Object, select Change Log Table.

       5.      Under Name of Object select one or more DataStore objects for which requests are to be deleted from the relevant change log tables.

       6.      Specify the requests to be deleted by determining the days or dates (local time zone). You also have the option to specify whether you only want to delete successfully updated requests, and/or only incorrect requests that are no longer updated in an InfoProvider (this only applies to transaction data).

       7.      Save your entries and return to the previous screen.

       8.      On the next screen, confirm the insertion of the process variant into the process chain.

The plan view of the process chain appears. The process variant for deleting requests from the PSA is included in your process chain.

Deleting requests from the change log in the administration of the DataStore object

...

       1.      In the main menu in DataStore object administration, choose Environment ® Delete Change Log Data.

       2.      Specify the requests to be deleted by determining the days or dates (local time zone). You also have the option to specify whether you only want to delete successfully updated requests, and/or only incorrect requests that are no longer updated in an InfoProvider (this only applies to transaction data).

       3.      Define the start date values under Start Conditions.

       4.      Select Start (Schedule Deletion).

The deletion is scheduled in the background according to the selection conditions.

You can also display a request list for the change log. In this list, you can mark requests and then delete them directly.