HOW TO SAP - jload export fails with java.lang.OutOfMemoryError

Note 1276704 - jload export fails with java.lang.OutOfMemoryError



Symptom
A jload export of a MSSQL datasource fails with java.lang.OutOfMemory error.
Other terms
system copy, export, jload
Reason and Prerequisites
The used JDBC driver is Microsoft SQL Server 2005 Driver for JDBC (com.microsoft.sqlserver.jdbc.SQLServerDriver).
The table the jload fails to export contains LOB fields.

Solution
For the duration of the export we recommend to extend the URL of the export datasource by the property
responseBuffering=adaptive
Use configtool to do so.
This should avoid the memory problems.
After the export is done switch back to the original URL again.

Example:
original URL:
jdbc:sqlserver://PWDF6636:1433;databasename=BIG
changed URL: jdbc:sqlserver://PWDF6636:1433;databasename=BIG;responseBuffering=adaptive

Usage of configtool:
The configtool is normally located on $(DIR_INSTANCE)\j2ee\configtool
(for example: c:\usr\sap\\J\j2ee\configtool).
To start it, execute configtool.bat.
In the emerging popup, after the connect, click on "secure store".
The URL to change can be either directly modified in the "Secure Store Data" tab or the "Connection Pools" tab.
Edit this entry by double-clicking the URL-line and changing the value in the "Value:" line. Save by hitting "Add".
Save the setting by File->Apply Changes or hitting the floppy icon.


Header Data
Release Status:Released for Customer
Released on:03.03.2010 08:30:40
Master Language:English
Priority:Recommendations/additional info
Category:Workaround for missing functionality
Primary Component:BC-DB-MSS Microsoft SQL Server

Popular posts from this blog

HOW TO SAP - Create RFC TCPIP connection and Register Server Program with RFCEXEC

Step by step to create new job using SM36

HOW TO SAP - SAP Web dispatcher Installation