Introducing Monitoring in SLT

The SAP Landscape Transformation Replication Server cockpit (transaction LTRC) provides an overview of individual configurations and their status. It also specifies whether the master job (one job for all configurations per SLT server) is running.

In individual configuration, you can see the status of all tables. This allows you to identify whether there are any errors because they show the Failed status. For example, in the Table Overview tab, there is an issue with the trigger for table ZSFLIGHT_00. In the Data Transfer Monitor tab, there is a table with the Failed status. You can select the respective entry in the list and choose View Errors (or Display Errors for Object) to display the last error for this table.

The following information has already been provided earlier in this course and is repeated for convenience.

Starting from DMIS2018 SP04 / DMIS2020 / S/4HANA 2020, the LTRC UI has been reworked (for all scenarios except BW PSA) as follows:

• The Administration Data tab has been redesigned.
• The Processing Steps tab has been removed. Respective functions were moved to the Expert Functions tab.
• The Table Overview and Data Transfer Monitor tabs have been merged into the Participating Objects tab.
• The Application Log tab has been redesigned.
• The Statistics tab has been redesigned. It now provides the initial load statistics (including history) and the replication statistics, as well as the unprocessed logging table entries overview

The Table Overview tab and Data Transfer Monitor tab are now merged into the Participating Objects tab to connect related information and provide improved monitoring capabilities.

On the Application Logs tab, you can view the logs of the executed definition and replication tasks. To view the logs, you must define a filter.

If you want to find errors in a single replication, you can also select the table on the Table Overview tab and choose View Errors (or Display Errors for Object).

On the Statistics tab, you can view statistics for the initial load and statistics for the replication process. You can also view whether any unprocessed records exist in the logging tables.

There are the following options:

• View Unprocessed Logging Table Records

  You can use this option to check the logging tables in the source system for any remaining unprocessed logging records. The system displays the oldest timestamp for an unprocessed record in the logging table, and also the number of unprocessed records. You can restrict the check to certain objects by specifying them in the Object Name field. Note that this option is only relevant for objects for which a logging table has already been created.

• View Replication Statistics

  You can use this option to view statistical information for the replication process. This statistical information includes, for example, the number of inserted, updated, and deleted records for each object, as well as latency information. To view the statistical information, you must specify a time interval. The system will display statistical data for tables based on this interval.

  For example with a Time interval = Hour, for a table, the system displays the number of inserted, updated, and deleted records (and latency information) in intervals of one hour, for example, from 09:00 to 10:00, from 10:00 to 11:00, and so on. In this example, the first entry for a table in the Interval Start Time field will read 09:00, the second 10:00, the third 11:00, and so on.

  Note

  If you are replicating data to function modules in the target system (for example if you are replicating data to Central Finance), it is only possible to view the number of inserted records for each table. It is not possible to view the number of updated and deleted records. You can also view latency information.
• View Statistics for Initial Load

  You can use this option to view statistical information for the initial load. This statistical information includes, for example, the number of inserted, updated, and deleted records for each object. You can restrict the check to certain objects by specifying them in the Object Name field. In addition, you can filter the results by using the Status field.

  The following status values are possible:

• • Finished: The initial load is complete for the object.
  • In Process: The initial load is still in process for the object.
  • Error: An error occurred for the object during the initial load.

In addition, the following features are available on the toolbar for every tab:

• Configuration Notes
• Activate/Deactivate Configuration

You can use the SAP Landscape Transformation Replication Server cockpit (transaction LTRC) to view the status of a single configuration. However, system administrators managing multiple configurations have to switch from configuration to configuration to see the relevant status. The benefit of using the monitoring transaction (LTRO) is that it shows all the relevant information on one screen.

For example, you can use the monitoring transaction to get information about the following:

• The number of running, free batch, and dialog processes currently running on all application servers of the SAP Landscape Transformation Replication Server system
• The availability status of all connected SAP HANA target systems (for all selected configurations), and the corresponding log entries (warnings and errors)
• The status of multiple configurations (mass transfer IDs) within a single screen
• The results of SAP Landscape Transformation Replication Server health checks

The Overview tab is divided into the following sections:

• The left screen area contains SAP Landscape Transformation Replication Server system-specific information.
• The right screen area contains information about all connected SAP HANA systems, which are connected by the secondary database connection type ADBC.

In the left screen area, under Details, you can view the available application servers for the SAP Landscape Transformation Replication Server system. For each application server, you can view the number of free and available processes, and the maximum runtime (longest running process in seconds) for the processes. The number of free processes is an indicator for the load on the SAP Landscape Transformation Replication Server system. If a high maximum runtime value occurs, this could indicate an issue with a long running process.

The top of the tab page shows the aggregated values for the application servers. This is the total number of free and available processes, and the highest maximum runtime value (the longest running process across all application servers).

In the right screen area, you can view all SAP HANA target systems that are connected to the SAP Landscape Transformation Replication Server system for all selected configurations. For each target system, you can view the target system status (a connection status), as well as the configurations that are assigned to the target system. Under Target Alerts, the system displays up to 20 database log entries for the last 12 hours.

The Configuration View tab displays the status of the master job if present in your SLT release. It also provides an overview of all configurations selected when the transaction was executed.

For each configuration, you can display information such as the name, status, technical ID, and so on.

Note

Some information is only visible if the configuration is active, for example, the latency information and the status of the target system.

The benefit from this view is that administrators can see multiple configurations on a single screen, without needing to switch from one configuration to another.

You can navigate to the details of an individual configuration by choosing an entry in the Mass Transfer ID field or by choosing Open Tables View. To view additional information for the configuration, navigate to the SAP Landscape Transformation Replication Server cockpit (transaction LTRC) and use the following tabs:

• Participating Objects(or Table Overview and Data Transfer Monitor)
• Application Logs

On the Health Check Results tab, you can view the results of all SAP Landscape Transformation Replication Server health checks that the system runs in order to alarm about unusual behavior of SAP LT Replication Server and potential issues or inconsistencies. Health Checks are either system checks or table checks.

Note

In former SLT service packs, health checks were executed manually per configuration (transaction LTRC, Expert Functions tab). Since DMIS 2021, they are automatically executed every 10 minutes.

This can help system administrators to identify the root cause of problems. It also helps them to identify when the replication of a table encountered problems for the first time.

By default, the system only displays the health check results that have the Error status. If you would like to view health check results that have a different status, choose Filter. Then, change the time range for which the results are displayed. You can also filter the results based on a specific table or check.

Find out more about the Health Check Framework in the Application Operations Guide.