Wednesday, 12 July 2023

1908498 - How to set SLT jobs in SLT configuration

Symptom :

Following phenomena may occur during SLT replication.

You started a replication in Data provisioning of HANA Studio, but the replication remained in the status "Scheduled".

Some tables were updated on the source system, but the new data were not synchronized to the HANA system.

You saw a long latency time in the tag page Statistics of Configuration in the Configuration & Monitoring Dashboard.

Environment

DMIS 2010 all SPs

DMIS 2011 all SPs

Cause

When you create an SLT configuration, you can specify the No. of Data Transfer Jobs and No. of Calculation Jobs.

If you set these parameters as below, you need to configure at least 16 background work processes on the SLT system.

KBA1.PNG

One BGD is for the master job, 12 BGDs are for Data Transfer Jobs, 2 BGDs are for Calculation Jobs and another one is for other temporary jobs such as the generation job.

If you configure less than 16 background processes (for example only 12 BGDs as below), some jobs will not be started because there is no free background process.

KBA2.PNG

Resolution:

There are two ways to resolve this issue:

Reduce the Data Transfer Jobs and/or Calculation Jobs.

Increase Background processes.

If there are several SLT configurations (for example N configurations) on the SLT system, you need to configure background processes >= sum of all No. of Data Transfer Jobs and No. of Calculation Jobs + 2 x N.