Error DBIF_RSQL_TABLE_UNKNOWN while replicating the tables affected using SLT into HANA database.
We have installed HANA application accelerator (add-on SWT2DB) and replicated the tables affected using SLT into HANA database. After activation of the particular scenario in report RDA_MAINTAIN, execution of a SELECT statement against the tables fails with runtime error DBIF_RSQL_TABLE_UNKNOWN.
The corresponding workprocess trace in transaction ST11 (number can be found via system log SM21 or in the 'system environment' section of the short dump) show the database error message:
*** ERROR => prepare() of C_0002, rc=1, rcSQL=259 (invalid table name: Could not find table/view SFLIGHT in schema SYSTEM: line [dbsdbsql.cpp 1378]
*** ERROR => SQL PREPARE on connection 1, rc=259 (invalid table name: Could not find table/view SFLIGHT in schema SYSTEM: line 1 [dbslsdb.cpp 9934]
There is a scenario definition using report RDA_MAINTAIN, a DBCON database connection (see table RDA_CONFIG and transaction DBCO for reference) with username SYSTEM (or different) was chosen. Thus the default schema used to find the table is SYSTEM and not the one of the schema owner where the table has been replicated into.
To Resolve this issue please do as following:
Define a new DBCON connection in SM30 using the schema owner and modify the scenario accordingly. Note that the password for the schema owner is generated automatically (and unkown), thus it needs to be changed according to the procedure in the Application Operations Guide for trigger-based data replication using SAP LT Replication Server for SAP HANA.
The SELECT statements will then be executed in the correct database schema. If the SAP system where the HANA application accelerator and SLT replication server is installed are equivalent, you can use the already existing DBCON connection <MT_ID>:R:R used for replication.