Skip to Content
0

SDI replication error

Oct 15, 2017 at 06:59 PM

151

avatar image
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: )

error.jpg (217.2 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Oct 30, 2017 at 12:38 PM
0

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

:)

Share
10 |10000 characters needed characters left characters exceeded