Tuesday 21 February 2023

SAP LT Replication Server Cockpit - Expert Functions details - Reset Status for Triggers and Logging Tables

Hi Guys,

we frequently use all these functions but must know the details. in this blog, we are going to see about expert functions of SLT Configuration ( SAP)

Note: All this information available in SAP Application 

 A: Reset Indicator/Status 

   1: Reset Status for Triggers and Logging Tables

Features

You can use this step to reset flags for the tables listed on the Table Overview tab page.

You can reset the following flags:

•Failed

•In Process

•Logging Table Created

•Trigger State

Selection

You must specify a mass transfer ID. If you want to restrict the selection to certain tables, you can specify in the Table Name fields. Otherwise, the system resets the relevant status for all tables of the mass transfer ID.


You can reset the following flags:

•In Process: 

You can reset this flag if a table remains in the status In Process, but does not make any progress. Do not reset this flag if a table is still being processed by a job as some actions could be executed twice for the same table and this could result in errors.

•Failed: 

You can reset this flag if a table has the status Failed, and you want to manually reset the flag. This flag can be reset at any time; tables are not processed if they have the status Failed.

•Logging Table Created: 

You can reset this flag if you deleted the logging table manually in the source system, and you want to recreate the logging table. For 1:N replication scenarios, you should also ensure that the consumer registration was reset correctly in the source system (you can use the 1:N health check to verify this). If the initial load or the replication is already running for a table, do not recreate missing logging tables as delta tables might already be missing. Instead, you can stop and restart the table in the data provisioning UI (accessible from the Table Overview tab page).

•Trigger State: 

You can reset this flag if you deleted the trigger manually in the source system, and you want to recreate the database trigger. If the initial load or the replication is already running for a table, do not recreate the missing triggers as delta tables might already be missing. Instead, you can stop and restart the table in the Data Provisioning dialog box (accessible from the Table Overview tab page).


Thanks 

Rupesh Chavan