Modern BI & Analytics – Experience the power of data with modern visualization techniques.Strategy & Architecture – Drive successful outcomes with the right data strategy and architecture.Data Architecture & Engineering – Build a modern data foundation that supports your business.Hope this will help you out when you face a similar issue next time.
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. Once that step is done, you will now be able to see all the missing table from that Non-SAP source. Screenshot(After implementing the solution) Screenshot(Before implementing the solution) Once the Program is executed, you will be prompted for a configuration ID, which in our case was 15. This Note basically contains a Program which needs to be copied and has to be recreated in SLT system using SE38. Thankfully SAP has come up with the following note to solve this issue:ġ751323 – Hana LTR : Non Sap Replication-Update DD02L and DD02T tables Now our job is to adjust the DD02L, DD02T mechanisms. Newly created tables after successful configuration in SLT will not be automatically updated. 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.ģ. 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.Ģ. The fundamental concept of the trigger-based replication is designed as for ABAP source systems.
Now, We can start the replication using the following.(TCODE LTRC)īelow are the key points for non ABAP source systems related to LT Configuration.ġ. Once this sql is inserted, you will find the table in the RS_ODDER. Table name is the missing table which we want to manually insert into the table RS_ORDER. Hostname of the Source System (CI_HOST) can be derived from table “SYS_REPL”.”RS_REPLICATION_COMPONENTS” field CI_HOST. Source System ID (SID) can be derived from table “SYS_REPL”.”RS_REPLICATION_COMPONENTS” field SID. Here Target_Schema: configuration name/HANA schema name 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: Therefore RS_ORDER contains only those data provisioning requests, which are not yet handeld by the LT Replication Server. In case of new entries, the requested action will be processed and the record will be deleted from RS_ORDER. The master job of the respective configuration permanently checks table RS_ORDER for new entries. The communication between the HANA Studio and the LT Replication Server is handled via table RS_ORDER. In my case, configuration name was MII_EC3 and under the schema MII_EC3, you will find a table name RS_ORDER. Theory: Basically, during LT replication configuration, we have to give a configuration name, which appears as a schema name in the HANA studio. 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. 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.Ĭonfigurations in which the error happened :Ĭ) LT system(installed in a separate server) 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. 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)