SDI replication error

[Former Member]

I am trying to replicate table SKA1 from S4 HANA to Enterprise HANA environment.

While running the hdbreptask, I am getting error. But still, I can see Virtual Table and table being created in HANA box with NO data. Below is the error screenshot:

error.jpg

SAP DBTech JDBC: [403]: internal error: "FINX_DL"."FINX_DL::ZSKA1.START_REPLICATION": line 27 col 7 (at pos 1031): [403] (range 3) internal error exception: internal error: "FINX_DL"."FINX_DL::ZSKA1.START_REPLICATION": line 27 col 7 (at pos 1031): internal error: internal error: Error opening the cursor for the remote database Failed to execute query [SELECT "FINX_DL::ZSKA1.VT_SAPABAP1_SKA1"."MANDT", "FINX_DL::ZSKA1.VT_SAPABAP1_SKA1"."KTOPL", "FINX_DL::ZSKA1.VT_SAPABAP1_SKA1"."SAKNR", "FINX_DL::ZSKA1.VT_SAPABAP1_SKA1"."XBILK", "FINX_DL::ZSKA1.VT_SAPABAP1_SKA1"."SAKAN", "FINX_DL::ZSKA1.VT_SAPABAP1_SKA1"."BILKT", "FINX_DL::ZSKA1.VT_SAPABAP1_SKA1"."ERDAT", "FINX_DL::ZSKA1.VT_SAPABAP1_SKA1"."ERNAM", "FINX_DL::ZSKA1.VT_SAPABAP1_SKA1"."GVTYP", "FINX_DL::ZSKA1.VT_SAPABAP1_SKA1"."KTOKS", "FINX_DL::ZSKA1.VT_SAPABAP1_SKA1"."MUSTR", "FINX_ for query "SELECT "FINX_DL::ZSKA1.VT_SAPABAP1_SKA1"."MANDT", "FINX_DL::ZSKA1.VT_SAPABAP1_SKA1"."KTOPL", "FINX_DL::ZSKA1.VT_SAPABAP1_SKA1"."SAKNR", "FINX_DL::ZSKA1.VT_SAPABAP1_SKA1"."XBILK", "FINX_DL::ZSKA1.VT_SAPABAP1_SKA1"."SAKAN", "FINX_DL::ZSKA1.VT_SAPABAP1_SKA1"."BILKT", "FINX_DL::ZSKA1.VT_SAPABAP1_SKA1"."ERDAT", "FINX_DL::ZSKA1.VT_SAPABAP1_SKA1"."ERNAM", "FINX_DL::ZSKA1.VT_SAPABAP1_SKA1"."GVTYP", "FINX_DL::ZSKA1.VT_SAPABAP1_SKA1"."KTOKS", "FINX_DL::ZSKA1.VT_SAPABAP1_SKA1"."MUSTR", "FINX_DL::ZSKA1.VT_SAPABAP1_SKA1"."VBUND", "FINX_DL::ZSKA1.VT_SAPABAP1_SKA1"."XLOEV", "FINX_DL::ZSKA1.VT_SAPABAP1_SKA1"."XSPEA", "FINX_DL::ZSKA1.VT_SAPABAP1_SKA1"."XSPEB", "FINX_DL::ZSKA1.VT_SAPABAP1_SKA1"."XSPEP", "FINX_DL::ZSKA1.VT_SAPABAP1_SKA1"."MCOD1", "FINX_DL::ZSKA1.VT_SAPABAP1_SKA1"."FUNC_AREA", "FINX_DL::ZSKA1.VT_SAPABAP1_SKA1"."GLACCOUNT_TYPE", "FINX_DL::ZSKA1.VT_SAPABAP1_SKA1"."LAST_CHANGED_TS" FROM """SAPABAP1"".""SKA1""" "FINX_DL::ZSKA1.VT_SAPABAP1_SKA1" " (please check lines: )

[Former Member]

You need to give select authorize to the DP Agent's id at target server.

You may try

grant select, execute, insert, update, delete, trigger onschema[any schema]to [dpagentID]

Tips

You should go to DP Agent's log and read the error on Framework.trc

Error message on console usually incomprehensible.

If the solution I provided not help, then you need to grab me the log at framework.trc

🙂