cancel
Showing results for 
Search instead for 
Did you mean: 

System Copy based on Solution Manager Problem

Former Member
0 Kudos

Dear All

Please debug this problem,When System Copy Java Database error.Log sapinst.log of Solution Manager

Thanks

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)

Apr 11, 2008 4:46:22 PM com.sap.inst.jload.db.DBConnection disconnect

INFO: disconnected

ERROR 2008-04-11 16:46:23.31

CJS-30049 <html> <head> </head> <body> Execution of <font face="Monospaced">JLoad</font> tool 'C:\j2sdk1.4.2_15-x64\bin\java.exe -classpath F:\usr\sap\SOL\SYS\global\sltools\sharedlib\launcher.jar -showversion -Xmx512m com.sap.engine.offline.OfflineToolStart com.sap.inst.jload.Jload
sap0806/sapmnt/SOL/SYS/global/security/lib/tools/iaik_jce.jar;
sap0806/sapmnt/SOL/SYS/global/security/lib/tools/iaik_jsse.jar;
sap0806/sapmnt/SOL/SYS/global/security/lib/tools/iaik_smime.jar;
sap0806/sapmnt/SOL/SYS/global/security/lib/tools/iaik_ssl.jar;
sap0806/sapmnt/SOL/SYS/global/security/lib/tools/w3c_http.jar;F:/usr/sap/SOL/SYS/global/sltools/sharedlib/jload.jar;F:/usr/sap/SOL/SYS/global/sltools/sharedlib/antlr.jar;F:/usr/sap/SOL/SYS/global/sltools/sharedlib/exception.jar;F:/usr/sap/SOL/SYS/global/sltools/sharedlib/jddi.jar;F:/usr/sap/SOL/SYS/global/sltools/sharedlib/logging.jar;F:/usr/sap/SOL/SYS/global/sltools/sharedlib/offlineconfiguration.jar;F:/usr/sap/SOL/SYS/global/sltools/sharedlib/opensqlsta.jar;F:/usr/sap/SOL/SYS/global/sltools/sharedlib/tc_sec_secstorefs.jar;F:\usr\sap\SOL\DVEBMGS00\exe\mssjdbc\sqljdbc.jar -sec SOL,jdbc/pool/SOL,
sap0806/sapmnt/SOL/SYS/global/security/data/SecStore.properties,
sap0806/sapmnt/SOL/SYS/global/security/data/SecStore.key -dataDir F:/syssol/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. </body></html>

ERROR 2008-04-11 16:46:23.218

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 .

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Dear Sergo Beradze

This's my mistaked.I installed Solution Manager and ECC with MS SQL 2005 (64 bit) + MS Windows (64 bit).Both are installed same version J2EE,

I thanks reply for me.Because my problem is Export from Java Database with SAP Tool while your solution is Import Java .Please help for me,

I thinks this problem of JAVA because Export Abap database ok but Java database failed

and my bug

java version "1.4.2_15"

Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_15-b02)

Java HotSpot(TM) 64-Bit Server VM (build 1.4.2_15-b02, mixed mode)

Apr 11, 2008 5:02:01 PM com.sap.inst.jload.Jload main

INFO: Jload -sec SOL,jdbc/pool/SOL,

sap0806/sapmnt/SOL/SYS/global/security/data/SecStore.properties,

sap0806/sapmnt/SOL/SYS/global/security/data/SecStore.key -dataDir F:/syssol/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

Apr 11, 2008 5:02:02 PM com.sap.inst.jload.db.DBConnection connectViaSecureStore

INFO: connected to SOL on jdbc/pool/SOL

Apr 11, 2008 5:02:02 PM com.sap.inst.jload.db.ExcludedObjects addObjects

INFO: excluded objects (type TB): J2EE_CONFIGENTRY

Please for suggest me about Java Version when installed on SAP Solution and SAP ECC

Thanks

Former Member
0 Kudos

Hi. I'm think the best way to create the "Customer message" on service.sap.com , in our place the JAVA on SOLMAN server is --> 1.4.2_13 (64 bit). Regards.

Former Member
0 Kudos

Dear Sergo Beradze

Thanks for your reply, I readed SAP Notes but DBMS is MS SQL 2005,Only Solution Manager is problem but ECC don't see,Please help debug based on Solution Manger with MS SQL 2005 + MS Windows 2003

Have I upgrade JDBC on Solution Manager with SAP Note?

Thanks

Former Member
0 Kudos

hi Phuc Nguy. "Only Solution Manager is problem but ECC don't see" Your ECC are to on MS SQL 2005 + MS Windows 2003 64 ? Chek the JAVA versions are same on both

servers ? Read this -- Regards.

Former Member
0 Kudos

Dear Joe Bo

This's jload.log

INFO: excluded objects (type EB): [J2EE_CONFIGENTRY]

11.04.08 17:02:02 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

11.04.08 17:02:02 com.sap.inst.jload.JobStatus readStatus

INFO: commencing restart

11.04.08 17:02:31 com.sap.inst.jload.Jload dbExport

SEVERE: Error during export of J2EE_CONFIGENTRY

11.04.08 17:02:31 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)

11.04.08 17:02:31 com.sap.inst.jload.db.DBConnection disconnect

INFO: disconnected

And Jload.java.log

java version "1.4.2_15"

Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_15-b02)

Java HotSpot(TM) 64-Bit Server VM (build 1.4.2_15-b02, mixed mode)

Apr 11, 2008 5:02:01 PM com.sap.inst.jload.Jload main

INFO: Jload -sec SOL,jdbc/pool/SOL,
sap0806/sapmnt/SOL/SYS/global/security/data/SecStore.properties,
sap0806/sapmnt/SOL/SYS/global/security/data/SecStore.key -dataDir F:/syssol/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

Apr 11, 2008 5:02:02 PM com.sap.inst.jload.db.DBConnection connectViaSecureStore

INFO: connected to SOL on jdbc/pool/SOL

Apr 11, 2008 5:02:02 PM com.sap.inst.jload.db.ExcludedObjects addObjects

INFO: excluded objects (type TB): [J2EE_CONFIGENTRY]

Apr 11, 2008 5:02:02 PM com.sap.inst.jload.db.ExcludedObjects addObjects

INFO: excluded objects (type EL): [J2EE_CONFIGENTRY]

Apr 11, 2008 5:02:02 PM com.sap.inst.jload.db.ExcludedObjects addObjects

INFO: excluded objects (type ES): [BC_SCVERSION, J2EE_CONFIGENTRY]

Apr 11, 2008 5:02:02 PM com.sap.inst.jload.db.ExcludedObjects addObjects

INFO: excluded objects (type EB): [J2EE_CONFIGENTRY]

Apr 11, 2008 5:02:02 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

Apr 11, 2008 5:02:02 PM com.sap.inst.jload.JobStatus readStatus

INFO: commencing restart

Apr 11, 2008 5:02:31 PM com.sap.inst.jload.Jload dbExport

SEVERE: Error during export of J2EE_CONFIGENTRY

Apr 11, 2008 5:02:31 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)

Apr 11, 2008 5:02:31 PM com.sap.inst.jload.db.DBConnection disconnect

INFO: disconnected

Thanks

Former Member
0 Kudos

Are you use the DB6 ? If yes read the Note Note 864937 - DB6: Export of database with JAVA stops with an error.

Reason and Prerequisites

Caused by an error in the JDBC driver "IBM DB2 JDBC Universal Driver Architecture 1.9.23" which is released with DB2 V8.2 with Fixpak 5.

Solution

The problem is solved with the driver included in Fixpak 9.

Regards. Award if helpful.

Former Member
0 Kudos

SOLUTION: Check 'jload.log' and 'C:/Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/CENTRAL/AS/EXP/jload.java.log' for more information.