Skip to Content
Author's profile photo Prabhith Prabhakaran

Solution for HANA Studio Tables Missing Issue in SLT Data Provisioning (Non-SAP Source System Scenarios)

Hi All,

These days am seeing lot of questions here in LT replication server Space about missing tables from Source even after a successful configuration.(For Non-SAP Source System Scenarios)

We had also faced a similar challenge at one of  the customer site and through this document I would like to demonstrate the solution(I would say it’s work around) that was implemented to overcome this challenge.


ISSUE:  Even after successful LT configuration(For Non-SAP Source System Scenarios), some tables at the source seems to be missing under the search table option at HANA studio –> Data Provisioning –>  Replicate –>  Find Source table.


/wp-content/uploads/2015/04/1_684856.png


Configurations in which the error happened :

a) HANA Studio

/wp-content/uploads/2015/04/2_684881.png

             

b) Source is a  Non Sap Source System

c) LT system(installed in a separate server)

/wp-content/uploads/2015/04/3_684882.png

        

Method /workaround suggested by SAP: We had raised an internal ticket to SAP and as per their suggestion, both these workarounds  were tried from our end.

Solution 1:

Theory: Basically, during LT replication configuration, we have to give a configuration name, which appears as a schema name in the HANA studio.

In my case, configuration name was MII_EC3  and under the schema MII_EC3, you will find a table name RS_ORDER. The communication between the HANA Studio and the LT Replication Server is handled via table RS_ORDER. The master job of the respective configuration permanently checks table RS_ORDER for new entries. In case of new entries, the requested action will be processed and the record will be deleted from RS_ORDER. Therefore RS_ORDER contains only those data provisioning requests, which are not yet handeld by the LT Replication Server.

/wp-content/uploads/2015/04/4_684883.png

Solution: since the missing tables is not having an entry in RS_ORDER, we will manually provide an entry using the INSERT SQL command like follows:

insert into “<TARGET_SCHEMA>”.”RS_ORDER” values(‘SID’,’hostname’,’tablename’,0,’R’,”,”,”)

Here Target_Schema: configuration name/HANA schema name

Source System ID (SID) can be derived from table “SYS_REPL”.”RS_REPLICATION_COMPONENTS” field SID.
Hostname of the Source System (CI_HOST) can be derived from table “SYS_REPL”.”RS_REPLICATION_COMPONENTS” field CI_HOST.

/wp-content/uploads/2015/04/5_684887.png

Table name is the missing table which we want to manually insert into the table RS_ORDER.

Once this sql is inserted, you will find the table in the RS_ODDER.

Now, We can start the replication using the following.(TCODE LTRC)

/wp-content/uploads/2015/04/6_684888.png

Solution 2:

Theory:

Below are the key points for non ABAP source systems related to LT Configuration.

1. The fundamental concept of the trigger-based replication is designed as for ABAP source systems. And the main differences here is that the connection is a database connection (no RFC connection) and the read modules reside on the SAP LT Replication Server.

2. In case of non ABAP source system, tables DD02L, DD02T which include the metadata of the tables , are just initially loaded and not automatically updated.

3. Newly created tables after successful configuration in SLT will not be automatically updated.

Now our job is to adjust the DD02L, DD02T mechanisms.

Thankfully SAP has come up with the following note to solve this issue:

1751323 – Hana LTR : Non Sap Replication-Update DD02L and DD02T tables

This Note basically contains a Program which needs to be copied and has to be recreated in SLT system using SE38.

Once the Program is executed, you will be prompted for a configuration ID, which in our case was 15.

/wp-content/uploads/2015/04/7_684889.png

Screenshot(Before implementing the solution)


/wp-content/uploads/2015/04/8_684890.jpg

Screenshot(After implementing the solution)

/wp-content/uploads/2015/04/9_684891.jpg

Once that step is done, you will now be able to see all the missing table from that Non-SAP source.

In my Personal Opinion, the 2nd Solution would be the best one as it avoids lot of intermediate steps and all the missing tables will appear as soon as the Program is executed.

Hope this will help you out when you face a similar issue next time.

BR

Prabhith

Assigned Tags

      11 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Thanks for creating the document. It is really helpful who is having issues with missing tables.

      Author's profile photo Former Member
      Former Member

      Nice Informative document on non SAP scenarios of SLT.

      Book marked...

      Author's profile photo Former Member
      Former Member

      thanks.

      I have a scenario where we have to automate stopping and starting the replication on a daily basis. We understand this will mean deletion of triggers, re-creation of triggers and full load on a daily basis. We want to know if there are any programs readily available that can take tables as input and can achieve this.

      Can you please advise.

      Author's profile photo Sergio Guerrero
      Sergio Guerrero

      was there ever an explanation why the tables didnt get populated initially? I have done all the steps.. before seeing this post and I am not able to see any tables.. I am now starting to follow this post and I am hoping i can see some tables next

      Author's profile photo Prabhith Prabhakaran
      Prabhith Prabhakaran
      Blog Post Author

      Hello Sergio Guerrero.

      Please try the steps and let us know the result.

      I would suggest solution 2

      BR

      Prabhith

      Author's profile photo Sergio Guerrero
      Sergio Guerrero

      Prabith,

      I am able to see the table to be scheduled to replicate and this seems that it will work however, my question for @sap would be why do we need to do a workaround? or what steps are missing from a straight forward proces

      thank you

      Author's profile photo Sergio Guerrero
      Sergio Guerrero

      The table structure came across after the work around, however, the data was not replicated... agin.. this an effort to replicate tables from MSSQL server 2008R2 into HANA ..  i still need some direction if anyone has been successful on this exercise... any documentation or urls would be apprecuiated.

      thank you

      Author's profile photo Former Member
      Former Member

      Good document.

      Author's profile photo Former Member
      Former Member

      Nice!

      Thanks for sharing


      🙂 .

      Author's profile photo Shankar Choudary
      Shankar Choudary

      Nice document, Thanks for Sharing...

      Author's profile photo Rajanikanth Reddy Madadi
      Rajanikanth Reddy Madadi

      Very Nice Doc.., Thanks for Sharing ..