Purpose

This purpose for this page is help with resolving SLT related queries.

How To Create A Configuration

• Link on how to create a configuration. 

DMIS Version

• Which version of DMIS is being used on the Source & SLT system?
• Here is a list of correction that has been released by SLT Development team. 
• It is recommended to install all correction on the Source & SLT system prior to raising incidents. 

How To Improve LOAD 

Improve Initial Load by Row ID

How to Load INDX tables into HANA using SLT (STXL & PCL2)

How to replicate VIEWS with SAP LT Replication Server

Performance Optimization Guide (2011 SP9)

How to load data from archives into HANA DB

How to replicate data from an INDX-like table to a target system using SLT (DMIS 2011 SP11)

How to reduce latency of table

Real Time Data Replication to BW Using SLT From SAP Source System (ODP Scenario)

Realtime Replication with SLT into Data Store Objects in SAP BW 7.4

Source tables have little activity or changes on them but their are frequent calls to the source system:

 If SLT is using real-time replication then it is continuously checking the logging tables for new records.  There are 2 ways the customer can reduce number of calls to the source:

Change from real-time replication to Interval.  This setting can be found in the LTR settings, where customer can specify in minutes, hours, day, the frequency to check the logging tables.  Perhaps once per minute is enough.  Only issue with this is latency will increase, having up to a minute of latency in the time the record appears in Hana target.

Change the logging table check behavior.  In LTRC-> Utilities-> Specify Option for Logging Tables, there are 2 options.  The alternate option of “Only Process Logging Tables with Records” will avoid querying the logging tables when they are empty.  This could be a good option as the customer’s configuration have very little activity as there is no need to continuously poll  the empty logging tables

Error Logs

1. Log into SLT system
2. Go into transaction LTRC
3. Enter in your MT_ID click Execute
4. Click on the Application Log Tab
5. Filter on MT_ID & Table Name for error’s

Check both of these location on the Source & SLT system

1. Check SM21 logs
2. Check  ST22 logs
3. Check WP logs in SM50

Validate Record Counts 

Source R/3 System

1. Log into R/3 system
2. Go to Transaction SE16
3. Put in table name and click execute
4. Click on Number of Entries

HANA System

1. Log into HANA Studio
2. Navigate to the Table in HANA
3. Right click on table and click Open Definition
4. Click on the Runtime Information
5. In the General section | Number of Entries

If you see any differences between the two systems just make sure there are no records in the logging table for the table in question. 

Cross Database Comparison

There are also alternative ways to check and compare data sources on the:

1. SAP Help portal: Cross-Database Comparison

2. SCN wiki: Cross Database Comparison

Structure Changes

Please review section 5 of the SLT Operation Guide. 

Related Documents:

SLT Landing Page
What's New in SAP HANA Real-Time Replication (Release Notes)
SAP HANA Installation Guide – Trigger-Based Replication (SLT)
SAP HANA Security Guide - Trigger-Based Replication (SLT)
Application Operations Guide – Trigger-Based Data Replication Using SAP LT Replication Server for SAP HANA
SLT Sizing Guide

Related Videos:

Related SAP Notes/KBAs

SAP Note 2705353 - Release Information SLT - DMIS 2011 SP16 and DMIS 2018 SP01

SAP Note 2648409 - Release Information SLT - DMIS 2011 SP15 and DMIS 2018 SP00

SAP Note 2570052 - Installation/Upgrade SLT - DMIS 2011 SP14

SAP Note 2446237 - Installation/Upgrade SLT - DMIS 2011 SP13

SAP Note 2415064 - Installation/Upgrade SLT - DMIS 2011 SP12

SAP Note 2325520 - Installation/Upgrade SLT - DMIS 2011 SP11

SAP Note 2191214 - Installation/Upgrade SLT - DMIS 2011 SP9 & SP10

SAP Note 2114257 - Installation/Upgrade SLT - DMIS 2011 SP8

SAP Note 2016511 - Installation/Upgrade SLT - DMIS 2011 SP7

SAP Note 1958809  - Installation/Upgrade SLT - DMIS 2011 SP6 / DMIS 2010 SP10

SAP Note 1882433 - Installation/Upgrade SLT - DMIS 2011 SP5

SAP Note 1824710 - Installation/Upgrade SLT - DMIS 2011 SP4 / 2010 SP9

SAP Note 1759156 - Installation/Upgrade SLT - DMIS 2011 SP3 / 2010 SP8

SAP Note 1709225 - Installation/Upgrade SLT - DMIS 2010 SP7 / 2011 SP2