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.

You can create selection patterns in the process variant Deleting Requests from the Change Log and thus delete requests flexibly.

Procedure

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

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

...

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

       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. Here you define the selection patterns to which requests should be deleted from the change log.

       4.      Enter a DataStore object and an InfoArea. You can use the placeholders Asterisk * and Plus + to select requests with a certain character string flexibly for multiple DataStore objects or InfoAreas.

The character string ABC* results in the selection of all DataStore objects that start with ABC and that end in any way whatsoever. The character string ABC+ results in the selection of all DataStore objects that start with ABC and that end with any other character.

       5.      If you set the indicator Exclude Selection Pattern, this pattern is not take account of in the selection. Settings regarding the age and status of a selection pattern (request selections) are not taken into consideration for excluded selection patterns.

You define a selection pattern for the DataStore objects ABC*. To exclude certain DataStore objects for this selection pattern, create a second selection pattern for the DataStore objects ABCD* and set the indicator Exclude Selection Pattern. This selects all DataStore objects that start with ABC, with the exception of those that start with ABCD.

       6.      Enter a date or a number of days in the field Older than, in order to define the time when the requests should be deleted.

       7.      If you only want to select requests with a certain status, set the corresponding indicator.

You can select the following status indicators:

 Delete Successfully Updated Requests Only

 Delete Incorrect Requests that were not Updated

 Delete Activation Requests Only, No Load Requests

With   Copy Request Selections you can copy the settings for the age and status of a selection pattern (request selections) to any number of selection patterns. Select the selection pattern to which you want to copy the settings, place the cursor on the selection pattern from which you want to copy, and choose  Copy Request Selections.

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

       9.      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 change log 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.