Skip to Content
avatar image
Former Member

SDI replication error

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

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

    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

    :)

    Add comment
    10|10000 characters needed characters exceeded