cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

System Copy error

Former Member

on ‎11-30-2011 2:16 PM

0 Kudos

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

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
‎11-30-2011 8:01 PM
0 Kudos

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

Show replies
Show replies
Former Member
‎11-30-2011 9:14 PM
0 Kudos

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.)

Former Member
‎12-05-2011 10:31 AM
0 Kudos

Thanks

Issue solved with JDBC drivers

Ramesh Nair

Former Member
‎11-30-2011 3:32 PM
0 Kudos

Hello Ramesh,

Could you please paste jload.java.log and jload.log content?

Thanks,

Siva Kumar

Show replies
Show replies
Former Member
‎11-30-2011 5:29 PM
0 Kudos

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

Former Member
‎11-30-2011 2:19 PM
0 Kudos

As suggested by last line, please check the log files - jload.log and jload.java.log

Thanks

Show replies
Show replies
Ask a Question