on 11-30-2011 2:16 PM
Hi Experts,
While I am performing a system copy (export) in Solution Manager, I am getting an error with java stack
Please suggest me how to fix this error
ERROR 2011-11-30 17:27:43.515
CJS-30049 Execution of <font face="Monospaced">JLoad</font> tool 'C:\j2sdk1.4.2_12\bin\java.exe -classpath C:\usr\sap\SMP\SYS\global\sltools\sharedlib\launcher.jar -showversion -Xmx512m com.sap.engine.offline.OfflineToolStart com.sap.inst.jload.Jload
ramesh/sapmnt/SMP/SYS/global/security/lib/tools/iaik_jce.jar;
ramesh/sapmnt/SMP/SYS/global/security/lib/tools/iaik_jsse.jar;
ramesh/sapmnt/SMP/SYS/global/security/lib/tools/iaik_smime.jar;
ramesh/sapmnt/SMP/SYS/global/security/lib/tools/iaik_ssl.jar;
ramesh/sapmnt/SMP/SYS/global/security/lib/tools/w3c_http.jar;C:/usr/sap/SMP/SYS/global/sltools/sharedlib/jload.jar;C:/usr/sap/SMP/SYS/global/sltools/sharedlib/antlr.jar;C:/usr/sap/SMP/SYS/global/sltools/sharedlib/exception.jar;C:/usr/sap/SMP/SYS/global/sltools/sharedlib/jddi.jar;C:/usr/sap/SMP/SYS/global/sltools/sharedlib/logging.jar;C:/usr/sap/SMP/SYS/global/sltools/sharedlib/offlineconfiguration.jar;C:/usr/sap/SMP/SYS/global/sltools/sharedlib/opensqlsta.jar;C:/usr/sap/SMP/SYS/global/sltools/sharedlib/tc_sec_secstorefs.jar;C:\usr\sap\SMP\DVEBMGS00\exe\mssjdbc\sqljdbc.jar -sec SMP,jdbc/pool/SMP,
ramesh/sapmnt/SMP/SYS/global/security/data/SecStore.properties,
ramesh/sapmnt/SMP/SYS/global/security/data/SecStore.key -dataDir G:/Export/JAVA/JDMP -remove_trailing_blanks "C:\Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/CENTRAL/AS/EXP/removeTrailingBlanks.txt" -convert_empty_LOBs "C:\Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/CENTRAL/AS/EXP/convertEmptyLobs.txt" -convert_empty_strings "C:\Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/CENTRAL/AS/EXP/convertEmptyStrings.txt" -convert_empty_binary "C:\Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/CENTRAL/AS/EXP/convertEmptyBinary.txt"' aborts with return code 1.<br>SOLUTION: Check 'jload.log' and 'C:/Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/CENTRAL/AS/EXP/jload.java.log' for more information.
ERROR 2011-11-30 17:27:43.546
FCO-00011 The step exportJ2EEDatabase with step key |NW_Export|ind|ind|ind|ind|0|0|NW_Java_Export_Dialog|ind|ind|ind|ind|5|0|NW_JAVA_Export_DB|ind|ind|ind|ind|2|0|exportJ2EEDatabase was executed with status ERROR .
INFO 2011-11-30 18:12:04.125
An error occured and the user decided to retry the current step: "|NW_Export|ind|ind|ind|ind|0|0|NW_Java_Export_Dialog|ind|ind|ind|ind|5|0|NW_JAVA_Export_DB|ind|ind|ind|ind|2|0|exportJ2EEDatabase".
INFO 2011-11-30 18:12:29.906
Creating file C:\Program Files\sapinst_instdir\SOLMAN\LM\COPY\MSS\EXP\CENTRAL\AS\EXP\jload.java.log.
INFO 2011-11-30 18:12:29.906
Output of C:\j2sdk1.4.2_12\bin\java.exe -classpath C:\usr\sap\SMP\SYS\global\sltools\sharedlib\launcher.jar -showversion -Xmx512m com.sap.engine.offline.OfflineToolStart com.sap.inst.jload.Jload
ramesh/sapmnt/SMP/SYS/global/security/lib/tools/iaik_jce.jar;
ramesh/sapmnt/SMP/SYS/global/security/lib/tools/iaik_jsse.jar;
ramesh/sapmnt/SMP/SYS/global/security/lib/tools/iaik_smime.jar;
ramesh/sapmnt/SMP/SYS/global/security/lib/tools/iaik_ssl.jar;
ramesh/sapmnt/SMP/SYS/global/security/lib/tools/w3c_http.jar;C:/usr/sap/SMP/SYS/global/sltools/sharedlib/jload.jar;C:/usr/sap/SMP/SYS/global/sltools/sharedlib/antlr.jar;C:/usr/sap/SMP/SYS/global/sltools/sharedlib/exception.jar;C:/usr/sap/SMP/SYS/global/sltools/sharedlib/jddi.jar;C:/usr/sap/SMP/SYS/global/sltools/sharedlib/logging.jar;C:/usr/sap/SMP/SYS/global/sltools/sharedlib/offlineconfiguration.jar;C:/usr/sap/SMP/SYS/global/sltools/sharedlib/opensqlsta.jar;C:/usr/sap/SMP/SYS/global/sltools/sharedlib/tc_sec_secstorefs.jar;C:\usr\sap\SMP\DVEBMGS00\exe\mssjdbc\sqljdbc.jar -sec SMP,jdbc/pool/SMP,
ramesh/sapmnt/SMP/SYS/global/security/data/SecStore.properties,
ramesh/sapmnt/SMP/SYS/global/security/data/SecStore.key -dataDir G:/Export/JAVA/JDMP -remove_trailing_blanks "C:\Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/CENTRAL/AS/EXP/removeTrailingBlanks.txt" -convert_empty_LOBs "C:\Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/CENTRAL/AS/EXP/convertEmptyLobs.txt" -convert_empty_strings "C:\Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/CENTRAL/AS/EXP/convertEmptyStrings.txt" -convert_empty_binary "C:\Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/CENTRAL/AS/EXP/convertEmptyBinary.txt" is written to the logfile C:/Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/CENTRAL/AS/EXP/jload.java.log.
WARNING 2011-11-30 18:13:26.156
Execution of the command "C:\j2sdk1.4.2_12\bin\java.exe -classpath C:\usr\sap\SMP\SYS\global\sltools\sharedlib\launcher.jar -showversion -Xmx512m com.sap.engine.offline.OfflineToolStart com.sap.inst.jload.Jload
ramesh/sapmnt/SMP/SYS/global/security/lib/tools/iaik_jce.jar;
ramesh/sapmnt/SMP/SYS/global/security/lib/tools/iaik_jsse.jar;
ramesh/sapmnt/SMP/SYS/global/security/lib/tools/iaik_smime.jar;
ramesh/sapmnt/SMP/SYS/global/security/lib/tools/iaik_ssl.jar;
ramesh/sapmnt/SMP/SYS/global/security/lib/tools/w3c_http.jar;C:/usr/sap/SMP/SYS/global/sltools/sharedlib/jload.jar;C:/usr/sap/SMP/SYS/global/sltools/sharedlib/antlr.jar;C:/usr/sap/SMP/SYS/global/sltools/sharedlib/exception.jar;C:/usr/sap/SMP/SYS/global/sltools/sharedlib/jddi.jar;C:/usr/sap/SMP/SYS/global/sltools/sharedlib/logging.jar;C:/usr/sap/SMP/SYS/global/sltools/sharedlib/offlineconfiguration.jar;C:/usr/sap/SMP/SYS/global/sltools/sharedlib/opensqlsta.jar;C:/usr/sap/SMP/SYS/global/sltools/sharedlib/tc_sec_secstorefs.jar;C:\usr\sap\SMP\DVEBMGS00\exe\mssjdbc\sqljdbc.jar -sec SMP,jdbc/pool/SMP,
ramesh/sapmnt/SMP/SYS/global/security/data/SecStore.properties,
ramesh/sapmnt/SMP/SYS/global/security/data/SecStore.key -dataDir G:/Export/JAVA/JDMP -remove_trailing_blanks "C:\Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/CENTRAL/AS/EXP/removeTrailingBlanks.txt" -convert_empty_LOBs "C:\Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/CENTRAL/AS/EXP/convertEmptyLobs.txt" -convert_empty_strings "C:\Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/CENTRAL/AS/EXP/convertEmptyStrings.txt" -convert_empty_binary "C:\Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/CENTRAL/AS/EXP/convertEmptyBinary.txt"" finished with return code 1. Output:
java version "1.4.2_12"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_12-b03)
Java HotSpot(TM) Client VM (build 1.4.2_12-b03, mixed mode)
Nov 30, 2011 6:12:30 PM com.sap.inst.jload.Jload main
INFO: Jload -sec SMP,jdbc/pool/SMP,
ramesh/sapmnt/SMP/SYS/global/security/data/SecStore.properties,
ramesh/sapmnt/SMP/SYS/global/security/data/SecStore.key -dataDir G:/Export/JAVA/JDMP -remove_trailing_blanks C:\Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/CENTRAL/AS/EXP/removeTrailingBlanks.txt -convert_empty_LOBs C:\Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/CENTRAL/AS/EXP/convertEmptyLobs.txt -convert_empty_strings C:\Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/CENTRAL/AS/EXP/convertEmptyStrings.txt -convert_empty_binary C:\Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/CENTRAL/AS/EXP/convertEmptyBinary.txt
Nov 30, 2011 6:12:31 PM com.sap.inst.jload.db.DBConnection connectViaSecureStore
INFO: connected to SMP on jdbc/pool/SMP
Nov 30, 2011 6:12:31 PM com.sap.inst.jload.db.ExcludedObjects addObjects
INFO: excluded objects (type TB): [J2EE_CONFIGENTRY]
Nov 30, 2011 6:12:31 PM com.sap.inst.jload.db.ExcludedObjects addObjects
INFO: excluded objects (type EL): [J2EE_CONFIGENTRY]
Nov 30, 2011 6:12:31 PM com.sap.inst.jload.db.ExcludedObjects addObjects
INFO: excluded objects (type ES): [BC_SCVERSION, J2EE_CONFIGENTRY]
Nov 30, 2011 6:12:31 PM com.sap.inst.jload.db.ExcludedObjects addObjects
INFO: excluded objects (type EB): [J2EE_CONFIGENTRY]
Nov 30, 2011 6:12:31 PM com.sap.inst.jload.JobStatus readStatus
INFO: trying to read status file C:\Program Files\sapinst_instdir\SOLMAN\LM\COPY\MSS\EXP\CENTRAL\AS\EXP\EXPORT.sta
Nov 30, 2011 6:12:31 PM com.sap.inst.jload.JobStatus readStatus
INFO: commencing restart
Nov 30, 2011 6:13:26 PM com.sap.inst.jload.Jload dbExport
SEVERE: Error during export of J2EE_CONFIGENTRY
Nov 30, 2011 6:13:26 PM com.sap.inst.jload.Jload logStackTrace
SEVERE: java.lang.NullPointerException
at com.sap.sql.jdbc.mss.MssSQLExceptionAnalyzer.getCategory(MssSQLExceptionAnalyzer.java:112)
at com.sap.sql.services.core.CoreServices.isDuplicateKeyException(CoreServices.java:133)
at com.sap.sql.jdbc.direct.DirectPreparedStatement.processSQLException(DirectPreparedStatement.java:1189)
at com.sap.sql.jdbc.direct.DirectPreparedStatement.executeQuery(DirectPreparedStatement.java:285)
at com.sap.sql.jdbc.common.CommonPreparedStatement.executeQuery(CommonPreparedStatement.java:185)
at com.sap.inst.jload.db.DBTable.unload(DBTable.java:192)
at com.sap.inst.jload.Jload.dbExport(Jload.java:179)
at com.sap.inst.jload.Jload.executeJob(Jload.java:395)
at com.sap.inst.jload.Jload.main(Jload.java:621)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:81)
Nov 30, 2011 6:13:26 PM com.sap.inst.jload.db.DBConnection disconnect
INFO: disconnected
ERROR 2011-11-30 18:13:26.156
CJS-30049 > Execution of <font face="Monospaced">JLoad</font> tool 'C:\j2sdk1.4.2_12\bin\java.exe -classpath C:\usr\sap\SMP\SYS\global\sltools\sharedlib\launcher.jar -showversion -Xmx512m com.sap.engine.offline.OfflineToolStart com.sap.inst.jload.Jload
ramesh/sapmnt/SMP/SYS/global/security/lib/tools/iaik_jce.jar;
ramesh/sapmnt/SMP/SYS/global/security/lib/tools/iaik_jsse.jar;
ramesh/sapmnt/SMP/SYS/global/security/lib/tools/iaik_smime.jar;
ramesh/sapmnt/SMP/SYS/global/security/lib/tools/iaik_ssl.jar;
ramesh/sapmnt/SMP/SYS/global/security/lib/tools/w3c_http.jar;C:/usr/sap/SMP/SYS/global/sltools/sharedlib/jload.jar;C:/usr/sap/SMP/SYS/global/sltools/sharedlib/antlr.jar;C:/usr/sap/SMP/SYS/global/sltools/sharedlib/exception.jar;C:/usr/sap/SMP/SYS/global/sltools/sharedlib/jddi.jar;C:/usr/sap/SMP/SYS/global/sltools/sharedlib/logging.jar;C:/usr/sap/SMP/SYS/global/sltools/sharedlib/offlineconfiguration.jar;C:/usr/sap/SMP/SYS/global/sltools/sharedlib/opensqlsta.jar;C:/usr/sap/SMP/SYS/global/sltools/sharedlib/tc_sec_secstorefs.jar;C:\usr\sap\SMP\DVEBMGS00\exe\mssjdbc\sqljdbc.jar -sec SMP,jdbc/pool/SMP,
ramesh/sapmnt/SMP/SYS/global/security/data/SecStore.properties,
ramesh/sapmnt/SMP/SYS/global/security/data/SecStore.key -dataDir G:/Export/JAVA/JDMP -remove_trailing_blanks "C:\Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/CENTRAL/AS/EXP/removeTrailingBlanks.txt" -convert_empty_LOBs "C:\Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/CENTRAL/AS/EXP/convertEmptyLobs.txt" -convert_empty_strings "C:\Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/CENTRAL/AS/EXP/convertEmptyStrings.txt" -convert_empty_binary "C:\Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/CENTRAL/AS/EXP/convertEmptyBinary.txt"' aborts with return code 1.<br>SOLUTION: Check 'jload.log' and 'C:/Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/CENTRAL/AS/EXP/jload.java.log' for more information.
ERROR 2011-11-30 18:13:26.156
FCO-00011 The step exportJ2EEDatabase with step key |NW_Export|ind|ind|ind|ind|0|0|NW_Java_Export_Dialog|ind|ind|ind|ind|5|0|NW_JAVA_Export_DB|ind|ind|ind|ind|2|0|exportJ2EEDatabase was executed with status ERROR .
Thanks
Ramesh Nair
Edited by: Ramesh.Nair on Nov 30, 2011 3:17 PM
Hi Ramesh,
This seems to be a problem with LOBs that can not be copied over by Jload.
Please increase the memory that is being used by Jload.
Stop sapinst and take a backup of control.xml file and replace "-Xmx512m" by "-Xmx1024m.
in the section mentioned in Note 1120872.
Hope this helps.
Thanks,
Umesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI,
Restart the jload with more heap memory, use 1.5 G or 2 G:
java.exe ... -Xmx1540m com.sap.engine.offline.OfflineToolStart com.sap.inst.jload.Jload ...
...
or
java.exe ... -Xmx2048m com.sap.engine.offline.OfflineToolStart com.sap.inst.jload.Jload ...
If the problem occurs during a sapinst run (systemcopy for example), stop the sapinst, and edit control.xml.
Search for the line
var jloadHeap = "-Xmx1024m";
and replace it by
var jloadHeap = "-Xmx1540m";
Save control.xml.
Restart sapinst.
(It's not sufficient to just retry the phase, you have to restart the sapinst, otherwise control.xml isn't reread.)
Hello Ramesh,
Could you please paste jload.java.log and jload.log content?
Thanks,
Siva Kumar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
java version "1.4.2_12"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_12-b03)
Java HotSpot(TM) Client VM (build 1.4.2_12-b03, mixed mode)
Nov 30, 2011 6:12:30 PM com.sap.inst.jload.Jload main
INFO: Jload -sec SMP,jdbc/pool/SMP,
solman_ser/sapmnt/SMP/SYS/global/security/data/SecStore.properties,
solman_ser/sapmnt/SMP/SYS/global/security/data/SecStore.key -dataDir G:/Export/JAVA/JDMP -remove_trailing_blanks C:\Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/CENTRAL/AS/EXP/removeTrailingBlanks.txt -convert_empty_LOBs C:\Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/CENTRAL/AS/EXP/convertEmptyLobs.txt -convert_empty_strings C:\Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/CENTRAL/AS/EXP/convertEmptyStrings.txt -convert_empty_binary C:\Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/CENTRAL/AS/EXP/convertEmptyBinary.txt
Nov 30, 2011 6:12:31 PM com.sap.inst.jload.db.DBConnection connectViaSecureStore
INFO: connected to SMP on jdbc/pool/SMP
Nov 30, 2011 6:12:31 PM com.sap.inst.jload.db.ExcludedObjects addObjects
INFO: excluded objects (type TB): [J2EE_CONFIGENTRY]
Nov 30, 2011 6:12:31 PM com.sap.inst.jload.db.ExcludedObjects addObjects
INFO: excluded objects (type EL): [J2EE_CONFIGENTRY]
Nov 30, 2011 6:12:31 PM com.sap.inst.jload.db.ExcludedObjects addObjects
INFO: excluded objects (type ES): [BC_SCVERSION, J2EE_CONFIGENTRY]
Nov 30, 2011 6:12:31 PM com.sap.inst.jload.db.ExcludedObjects addObjects
INFO: excluded objects (type EB): [J2EE_CONFIGENTRY]
Nov 30, 2011 6:12:31 PM com.sap.inst.jload.JobStatus readStatus
INFO: trying to read status file C:\Program Files\sapinst_instdir\SOLMAN\LM\COPY\MSS\EXP\CENTRAL\AS\EXP\EXPORT.sta
Nov 30, 2011 6:12:31 PM com.sap.inst.jload.JobStatus readStatus
INFO: commencing restart
Nov 30, 2011 6:13:26 PM com.sap.inst.jload.Jload dbExport
SEVERE: Error during export of J2EE_CONFIGENTRY
Nov 30, 2011 6:13:26 PM com.sap.inst.jload.Jload logStackTrace
SEVERE: java.lang.NullPointerException
at com.sap.sql.jdbc.mss.MssSQLExceptionAnalyzer.getCategory(MssSQLExceptionAnalyzer.java:112)
at com.sap.sql.services.core.CoreServices.isDuplicateKeyException(CoreServices.java:133)
at com.sap.sql.jdbc.direct.DirectPreparedStatement.processSQLException(DirectPreparedStatement.java:1189)
at com.sap.sql.jdbc.direct.DirectPreparedStatement.executeQuery(DirectPreparedStatement.java:285)
at com.sap.sql.jdbc.common.CommonPreparedStatement.executeQuery(CommonPreparedStatement.java:185)
at com.sap.inst.jload.db.DBTable.unload(DBTable.java:192)
at com.sap.inst.jload.Jload.dbExport(Jload.java:179)
at com.sap.inst.jload.Jload.executeJob(Jload.java:395)
at com.sap.inst.jload.Jload.main(Jload.java:621)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:81)
Nov 30, 2011 6:13:26 PM com.sap.inst.jload.db.DBConnection disconnect
INFO: disconnected
Edited by: Ramesh.Nair on Nov 30, 2011 6:32 PM
As suggested by last line, please check the log files - jload.log and jload.java.log
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
79 | |
9 | |
9 | |
7 | |
7 | |
6 | |
6 | |
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.