Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Out of memory error in JDBC receiver adapter

Hi

I am inserting a large data set using a receiver JDBC adapter into a single table in an MSSQL server.

Theoretically I could use statement batch mode to increase throughput. However if I set the batch flag I get an "insufficient system memory to execute this SQL Statement" exception which is apparently being thrown by the jdbc driver.

Question is: Is there a way to allow it to use more memory? Which parameter should be modified and where is it?

Thanx

-Sam.

Former Member
replied

Same answer.. XI is doing what it has to do.. pushing data to SQL server. When the SQL server is not able to take it.. you should try to solve it at the SQL end..!!

VJ

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question