on 04-02-2009 1:20 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
We checked the SQL Server logs and certainly there were out of memory errors. Apparently a Microsoft Hotfix has to be applied.
Thank you guys!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Samuel
We have a similar similar scenario of sending huge volume of data into oracle 10g database and are sending in chunks of 10,000 each.Its taking almost 7 mins for inserting into the oracle database.How are you using the batch mode.
Could you please provide the target message structure used for inserion of data into table.
Hi
It's puperly MSSQL server issue and handling too. No other parameter can be set in XI to take away that error.
Try to run the statement from SQL plus and see , contact u r DBA Admin
rgd
srin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
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.