Show TOC

Procedure documentationDeleting from the Change Log Locate this document in the navigation structure

 

Deleting data from the change log of a DataStore object is recommended 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 for updates to connected InfoProviders is available, requests have to be posted first 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

Including the deletion of requests from the change log in 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 BW Processes by double-clicking.

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

  3. In 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 flexibly select requests with a certain character string for multiple DataStore objects or InfoAreas.

    Example Example

    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 one character.

    End of the example.

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

    Example Example

    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.

    End of the example.

  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 Successfully Updated Requests Only)

    Delete Incorrect Requests that were not Updated (Delete Incorrect Requests that were not Updated)

    Delete Activation Requests Only, No Load Requests (Delete Activation Requests Only, No Load Requests)

    With Copy Request Selections (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 (Copy Request Selections).

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

  9. On the following screen, confirm the addition of the process variants in the process chain.

    You arrive in the plan view for the process chain. The process variant for deleting requests from the change log is included in your process chain.

Deletion of 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 that need 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 is only valid for 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. You can also mark requests and then delete them directly.