HANA SDI Error on loading from big file

[Former Member]

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