on 10-15-2017 7:59 PM
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:
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: )
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
🙂
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.