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: 

Export Java Database

Former Member

on ‎04-04-2008 1:56 AM

0 Kudos

Dear All

I system copy with distribution instance (MS SQL 2005 with ECC 2005),but export from Java Database

log file

03.04.08 17:45:11 com.sap.inst.jload.Jload dbExport

SEVERE: Error during export of J2EE_CONFIGENTRY

03.04.08 17:45:11 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)

03.04.08 17:45:11 com.sap.inst.jload.db.DBConnection disconnect

INFO: disconnected

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
‎04-10-2008 10:51 AM
0 Kudos

Dear All

I add longDataCacheSize=20480 (Note 819130 - SQLServer JDBC Driver errors on reading huge LOBs) but still problem and posted log,I worked System Copy Solution Manager and ECC 2005 still the same problem,

Thanks

Please help me.

Show replies
Show replies
Former Member
‎04-07-2008 5:40 AM
0 Kudos

Dear All

This is my sapinst.log,I edit longDataCacheSize=2048 but still problem

Thanks

INFO 2008-04-07 11:23:14.6

Copied file 'C:/Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/DISTRIBUTED/AS/EXPDB/inifile.xml' to 'C:/Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/DISTRIBUTED/AS/EXPDB/inifile.10.xml'.

INFO 2008-04-07 11:23:14.146

Copied file 'C:/Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/DISTRIBUTED/AS/EXPDB/inifile.xml' to 'C:/Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/DISTRIBUTED/AS/EXPDB/inifile.11.xml'.

INFO 2008-04-07 11:23:14.600

Execute step

Component W2K_ServicePack_Check|ind|ind|ind|ind

Preprocess of component |NW_Export|ind|ind|ind|ind|0|0|NW_First_Steps|ind|ind|ind|ind|0|0|W2K_ServicePack_Check|ind|ind|ind|ind|2|0.

INFO 2008-04-07 11:23:18.178

Copied file 'C:/Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/DISTRIBUTED/AS/EXPDB/keydb.xml' to 'C:/Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/DISTRIBUTED/AS/EXPDB/keydb.6.xml'.

INFO 2008-04-07 11:23:18.209

Execute step exportJ2EEDatabase of component |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.

INFO[E] 2008-04-07 11:23:18.537

FSL-02077 File system export (share) saploc does not exist.

INFO 2008-04-07 11:23:20.115

Creating file C:\Program Files\sapinst_instdir\SOLMAN\LM\COPY\MSS\EXP\DISTRIBUTED\AS\EXPDB\jload.java.log.

INFO 2008-04-07 11:23:20.115

Output of C:\j2sdk1.4.2_15-x64\jre\bin\java.exe -classpath
sap0810\sapmnt\SOL\SYS\global\sltools\sharedlib\launcher.jar -showversion -Xmx512m com.sap.engine.offline.OfflineToolStart com.sap.inst.jload.Jload
sap0810/sapmnt/SOL/SYS/global/security/lib/tools/iaik_jce.jar;
sap0810/sapmnt/SOL/SYS/global/security/lib/tools/iaik_jsse.jar;
sap0810/sapmnt/SOL/SYS/global/security/lib/tools/iaik_smime.jar;
sap0810/sapmnt/SOL/SYS/global/security/lib/tools/iaik_ssl.jar;
sap0810/sapmnt/SOL/SYS/global/security/lib/tools/w3c_http.jar;
sap0810/sapmnt/SOL/SYS/global/sltools/sharedlib/jload.jar;
sap0810/sapmnt/SOL/SYS/global/sltools/sharedlib/antlr.jar;
sap0810/sapmnt/SOL/SYS/global/sltools/sharedlib/exception.jar;
sap0810/sapmnt/SOL/SYS/global/sltools/sharedlib/jddi.jar;
sap0810/sapmnt/SOL/SYS/global/sltools/sharedlib/logging.jar;
sap0810/sapmnt/SOL/SYS/global/sltools/sharedlib/offlineconfiguration.jar;
sap0810/sapmnt/SOL/SYS/global/sltools/sharedlib/opensqlsta.jar;
sap0810/sapmnt/SOL/SYS/global/sltools/sharedlib/tc_sec_secstorefs.jar;
sap0810/sapmnt/SOL/SYS/exe/uc/NTAMD64/mssjdbc/sqljdbc.jar -sec SOL,jdbc/pool/SOL,
sap0810/sapmnt/SOL/SYS/global/security/data/SecStore.properties,
sap0810/sapmnt/SOL/SYS/global/security/data/SecStore.key -dataDir H:/systemcopy/Database/JAVA/JDMP -remove_trailing_blanks "C:\Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/DISTRIBUTED/AS/EXPDB/removeTrailingBlanks.txt" -convert_empty_LOBs "C:\Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/DISTRIBUTED/AS/EXPDB/convertEmptyLobs.txt" -convert_empty_strings "C:\Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/DISTRIBUTED/AS/EXPDB/convertEmptyStrings.txt" -convert_empty_binary "C:\Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/DISTRIBUTED/AS/EXPDB/convertEmptyBinary.txt" is written to the logfile C:/Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/DISTRIBUTED/AS/EXPDB/jload.java.log.

WARNING 2008-04-07 11:23:36.787

Execution of the command "C:\j2sdk1.4.2_15-x64\jre\bin\java.exe -classpath
sap0810\sapmnt\SOL\SYS\global\sltools\sharedlib\launcher.jar -showversion -Xmx512m com.sap.engine.offline.OfflineToolStart com.sap.inst.jload.Jload
sap0810/sapmnt/SOL/SYS/global/security/lib/tools/iaik_jce.jar;
sap0810/sapmnt/SOL/SYS/global/security/lib/tools/iaik_jsse.jar;
sap0810/sapmnt/SOL/SYS/global/security/lib/tools/iaik_smime.jar;
sap0810/sapmnt/SOL/SYS/global/security/lib/tools/iaik_ssl.jar;
sap0810/sapmnt/SOL/SYS/global/security/lib/tools/w3c_http.jar;
sap0810/sapmnt/SOL/SYS/global/sltools/sharedlib/jload.jar;
sap0810/sapmnt/SOL/SYS/global/sltools/sharedlib/antlr.jar;
sap0810/sapmnt/SOL/SYS/global/sltools/sharedlib/exception.jar;
sap0810/sapmnt/SOL/SYS/global/sltools/sharedlib/jddi.jar;
sap0810/sapmnt/SOL/SYS/global/sltools/sharedlib/logging.jar;
sap0810/sapmnt/SOL/SYS/global/sltools/sharedlib/offlineconfiguration.jar;
sap0810/sapmnt/SOL/SYS/global/sltools/sharedlib/opensqlsta.jar;
sap0810/sapmnt/SOL/SYS/global/sltools/sharedlib/tc_sec_secstorefs.jar;
sap0810/sapmnt/SOL/SYS/exe/uc/NTAMD64/mssjdbc/sqljdbc.jar -sec SOL,jdbc/pool/SOL,
sap0810/sapmnt/SOL/SYS/global/security/data/SecStore.properties,
sap0810/sapmnt/SOL/SYS/global/security/data/SecStore.key -dataDir H:/systemcopy/Database/JAVA/JDMP -remove_trailing_blanks "C:\Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/DISTRIBUTED/AS/EXPDB/removeTrailingBlanks.txt" -convert_empty_LOBs "C:\Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/DISTRIBUTED/AS/EXPDB/convertEmptyLobs.txt" -convert_empty_strings "C:\Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/DISTRIBUTED/AS/EXPDB/convertEmptyStrings.txt" -convert_empty_binary "C:\Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/DISTRIBUTED/AS/EXPDB/convertEmptyBinary.txt"" finished with return code 1. Output:

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 7, 2008 11:23:21 AM com.sap.inst.jload.Jload main

INFO: Jload -sec SOL,jdbc/pool/SOL,
sap0810/sapmnt/SOL/SYS/global/security/data/SecStore.properties,
sap0810/sapmnt/SOL/SYS/global/security/data/SecStore.key -dataDir H:/systemcopy/Database/JAVA/JDMP -remove_trailing_blanks C:\Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/DISTRIBUTED/AS/EXPDB/removeTrailingBlanks.txt -convert_empty_LOBs C:\Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/DISTRIBUTED/AS/EXPDB/convertEmptyLobs.txt -convert_empty_strings C:\Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/DISTRIBUTED/AS/EXPDB/convertEmptyStrings.txt -convert_empty_binary C:\Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/DISTRIBUTED/AS/EXPDB/convertEmptyBinary.txt

Apr 7, 2008 11:23:23 AM com.sap.inst.jload.db.DBConnection connectViaSecureStore

INFO: connected to SOL on jdbc/pool/SOL

Apr 7, 2008 11:23:23 AM com.sap.inst.jload.db.ExcludedObjects addObjects

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

Apr 7, 2008 11:23:23 AM com.sap.inst.jload.db.ExcludedObjects addObjects

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

Apr 7, 2008 11:23:23 AM com.sap.inst.jload.db.ExcludedObjects addObjects

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

Apr 7, 2008 11:23:23 AM com.sap.inst.jload.db.ExcludedObjects addObjects

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

Apr 7, 2008 11:23:23 AM com.sap.inst.jload.JobStatus readStatus

INFO: trying to read status file C:\Program Files\sapinst_instdir\SOLMAN\LM\COPY\MSS\EXP\DISTRIBUTED\AS\EXPDB\EXPORT.sta

Apr 7, 2008 11:23:23 AM com.sap.inst.jload.JobStatus readStatus

INFO: commencing restart

Apr 7, 2008 11:23:36 AM com.sap.inst.jload.Jload dbExport

SEVERE: Error during export of J2EE_CONFIGENTRY

Apr 7, 2008 11:23:36 AM 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 7, 2008 11:23:36 AM com.sap.inst.jload.db.DBConnection disconnect

INFO: disconnected

ERROR 2008-04-07 11:23:36.787

CJS-30049 <html> <head> </head> <body> Execution of <font face="Monospaced">JLoad</font> tool 'C:\j2sdk1.4.2_15-x64\jre\bin\java.exe -classpath
sap0810\sapmnt\SOL\SYS\global\sltools\sharedlib\launcher.jar -showversion -Xmx512m com.sap.engine.offline.OfflineToolStart com.sap.inst.jload.Jload
sap0810/sapmnt/SOL/SYS/global/security/lib/tools/iaik_jce.jar;
sap0810/sapmnt/SOL/SYS/global/security/lib/tools/iaik_jsse.jar;
sap0810/sapmnt/SOL/SYS/global/security/lib/tools/iaik_smime.jar;
sap0810/sapmnt/SOL/SYS/global/security/lib/tools/iaik_ssl.jar;
sap0810/sapmnt/SOL/SYS/global/security/lib/tools/w3c_http.jar;
sap0810/sapmnt/SOL/SYS/global/sltools/sharedlib/jload.jar;
sap0810/sapmnt/SOL/SYS/global/sltools/sharedlib/antlr.jar;
sap0810/sapmnt/SOL/SYS/global/sltools/sharedlib/exception.jar;
sap0810/sapmnt/SOL/SYS/global/sltools/sharedlib/jddi.jar;
sap0810/sapmnt/SOL/SYS/global/sltools/sharedlib/logging.jar;
sap0810/sapmnt/SOL/SYS/global/sltools/sharedlib/offlineconfiguration.jar;
sap0810/sapmnt/SOL/SYS/global/sltools/sharedlib/opensqlsta.jar;
sap0810/sapmnt/SOL/SYS/global/sltools/sharedlib/tc_sec_secstorefs.jar;
sap0810/sapmnt/SOL/SYS/exe/uc/NTAMD64/mssjdbc/sqljdbc.jar -sec SOL,jdbc/pool/SOL,
sap0810/sapmnt/SOL/SYS/global/security/data/SecStore.properties,
sap0810/sapmnt/SOL/SYS/global/security/data/SecStore.key -dataDir H:/systemcopy/Database/JAVA/JDMP -remove_trailing_blanks "C:\Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/DISTRIBUTED/AS/EXPDB/removeTrailingBlanks.txt" -convert_empty_LOBs "C:\Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/DISTRIBUTED/AS/EXPDB/convertEmptyLobs.txt" -convert_empty_strings "C:\Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/DISTRIBUTED/AS/EXPDB/convertEmptyStrings.txt" -convert_empty_binary "C:\Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/DISTRIBUTED/AS/EXPDB/convertEmptyBinary.txt"' aborts with return code 1.<br>SOLUTION: Check 'jload.log' and 'C:/Program Files/sapinst_instdir/SOLMAN/LM/COPY/MSS/EXP/DISTRIBUTED/AS/EXPDB/jload.java.log' for more information. </body></html>

ERROR 2008-04-07 11:23:36.896

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 2008-04-07 11:25:32.912

An error occured and the user decide to stop.\n 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".

Show replies
Show replies
Former Member
‎04-04-2008 7:27 AM
0 Kudos

Dear Santosh Karadkar

Thank reply,I new comer of SAP,please You determine How to config JDBC

Thanks

Show replies
Show replies
Former Member
‎04-04-2008 7:33 AM
0 Kudos

Please post the logs from Installation directory ( may in your case C:\Program Files\sapinst_instdir\ OR search "sapinst.log"; ( Latest updated file ) and post here so that we can able to track log .

Former Member
‎04-04-2008 6:30 AM
0 Kudos

Dear

I have new problem with R3szchkExport.log and I update kernel but still problem

ERROR: process_file: unable to open "H:\system copy\Export prepatation\ABAP\DATA\SAP0000.STR"

Thank for your help.

Show replies
Show replies
Former Member
‎04-04-2008 7:09 AM
0 Kudos

Hello Phuc ,

Check the error : ERROR: process_file: unable to open why system is not allowing to access the file "H:\system copy\Export prepatation\ABAP\DATA\SAP0000.STR" in log .

Or try changing the Target location .

Regards ,

Santosh Karadkar

Former Member
‎04-04-2008 4:58 AM
0 Kudos

Hello Phuc ,

Please refer the attached note for the solution .

Note 819130 - SQLServer JDBC Driver errors on reading huge LOBs Resource bottleneck on .

Regards ,

Santosh Karadkar

Show replies
Show replies
Ask a Question