Hi All,
I am getting below error when trying to load the data from HANA - HANA… surprisingly,when i kept an Oracle Staging table in between these table ( HANA (Source)—> Staging Table(Oracle)—> HANA(Target))…and the job completed successfully and loaded…
2nd Approach: I have kept a DATA_TRANSFER transform between HANA (Source)—> HANA(Target) and the job completed successfully…
I am not able to understand …why can’t i load them directly…
Error:
SQL submitted to ODBC data source <HANA_DEV> resulted in error <[SAP AG][LIBODBCHDB SO][HDBODBC] General error;258 insufficient
privilege: Not authorized>. The SQL submitted is <CREATE PROCEDURE “schema”.“DS_PROC_1A5F1_CV_LDR” (OUT VAR_DS_TT_1A5F1
“schema.table”, OUT VAR_NUM_ROWS INTEGER ) LANGUAGE SQLSCRIPT READS SQL DATA AS
2 Views (edit) Tags: bods4.0, bods4, bods42, bods41
sam1984 (BOB member since 2014-06-17)