Skip to Content
0

HANA SDI Error on loading from big file

Mar 27, 2017 at 03:26 PM

23

avatar image

Hi,

i have a file with 4 GB which contains 28 million rows with 16 columns. Using SDI I am successfully able to create a virtual table and then load the data into physical table using INSERT INTO SELECT command.

But the same thing is failing when i use another server for DP Agent. So basically its working when DP Agent is installed on server A , but failing with below error when DP Agent is installed on server B.

can someone help me on which settings should i change.?

Could not execute 'insert into "PROJECT010"."FACT_DATA_SDI" select FISCAL_PERIOD_ID , TICKET_ID , SEQUENCE_NUMBER , ...' in 8:23.320 minutes .

SAP DBTech JDBC: [403]: internal error: Remote execution error File Reader was not able to put rows into the processing queue for a longer period of time for query "SELECT ...

it looks to me that some settings needs to be modified on server B. currently the settings are same on both the servers.

Regards,

Sai

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers