cancel
Showing results for 
Search instead for 
Did you mean: 

Netweaver 7.0 SR3 system copy error

former_member211576
Contributor
0 Kudos

Hi experts,

Please help.

-- sapinst.log --

ERROR 2009-05-22 18:58:49.290

FJS-00003 uncaught exception: nw.usageTypes.utlSQLError:

Execution of UTL tool 'C:\j2sdk1.4.2_11-x64\bin\java.exe -classpath C:\usr\sap\PI1\SYS\global\sltools\sharedlib\launcher.jar -showversion -Xmx256m com.sap.engine.offline.OfflineToolStart com.sap.sl.ut.manager.UtlMain
TCCQAS1/sapmnt/PI1/SYS/global/security/lib/tools/iaik_jce.jar;
TCCQAS1/sapmnt/PI1/SYS/global/security/lib/tools/iaik_jsse.jar;
TCCQAS1/sapmnt/PI1/SYS/global/security/lib/tools/iaik_smime.jar;
TCCQAS1/sapmnt/PI1/SYS/global/security/lib/tools/iaik_ssl.jar;
TCCQAS1/sapmnt/PI1/SYS/global/security/lib/tools/w3c_http.jar;C:/usr/sap/PI1/SYS/global/sltools/sharedlib/sap.com~sl.ut.infoprovider_lib.jar;C:/usr/sap/PI1/SYS/global/sltools/sharedlib/sap.com~sl.ut.manager.offline.jar;C:/usr/sap/PI1/SYS/global/sltools/sharedlib/antlr.jar;C:/usr/sap/PI1/SYS/global/sltools/sharedlib/exception.jar;C:/usr/sap/PI1/SYS/global/sltools/sharedlib/jddi.jar;C:/usr/sap/PI1/SYS/global/sltools/sharedlib/logging.jar;C:/usr/sap/PI1/SYS/global/sltools/sharedlib/offlineconfiguration.jar;C:/usr/sap/PI1/SYS/global/sltools/sharedlib/opensqlsta.jar;C:/usr/sap/PI1/SYS/global/sltools/sharedlib/tc_sec_secstorefs.jar;C:/usr/sap/PI1/SYS/global/sltools/sharedlib/sap.com~tc~sdt~cvl~impl.jar;C:/usr/sap/PI1/SYS/global/sltools/sharedlib/SDMutil.jar;C:/usr/sap/PI1/SYS/global/sltools/sharedlib/SLUtil.jar;C:\usr\sap\PI1\DVEBMGS00\exe\mssjdbc\sqljdbc.jar -export -type=keydb "-expfile=C:/Program Files/sapinst_instdir/NW04S/LM/COPY/MSS/EXP/CENTRAL/AS/EXP/usages_data.xml" -log=UTL_load_usages.log -sid=PI1 -dsn=jdbc/pool/PI1 -ssprops=C:/usr/sap/PI1/SYS/global/security/data/SecStore.properties -ssk=C:/usr/sap/PI1/SYS/global/security/data/SecStore.key' aborts due to an error in the execution of an SQL statement. DIAGNOSIS: Return code is 52. SOLUTION: Check 'UTL_load_usages.log' and 'C:/Program Files/sapinst_instdir/NW04S/LM/COPY/MSS/EXP/CENTRAL/AS/EXP/UTL.java.log' for more information. (in script unknown, line 0: ???)

-- UTL.java.log --

java version "1.4.2_11"

Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_11-b06)

Java HotSpot(TM) 64-Bit Server VM (build 1.4.2_11-b06, mixed mode)

-- UTL_load_usages.log --

<!LOGHEADER[START]/>

<!HELP[Manual modification of the header may cause parsing problem!]/>

<!LOGGINGVERSION[1.5.3.7185 - 630]/>

<!NAME[UTL_load_usages.log]/>

<!PATTERN[UTL_load_usages.log]/>

<!FORMATTER[com.sap.tc.logging.TraceFormatter(%24d %7s: %m)]/>

<!ENCODING[UTF8]/>

<!LOGHEADER[END]/>

May 22, 2009 6:58:16 PM Info : Successfully parsed!

May 22, 2009 6:58:16 PM Info : Executing command Export...

May 22, 2009 6:58:16 PM Info : Establishing DB connection...

May 22, 2009 6:58:19 PM Info : Connecting succeeded!

May 22, 2009 6:58:19 PM Info : Constructing System Info from the database ...

May 22, 2009 6:58:19 PM Path : Exception : The SQL Statement is wrong : SELECT * FROM BC_SL_PRODUCTS

java.lang.Exception

at com.sap.exception.BaseExceptionInfo.traceAutomatically(BaseExceptionInfo.java:1141)

at com.sap.exception.BaseExceptionInfo.<init>(BaseExceptionInfo.java:413)

at com.sap.exception.BaseException.<init>(BaseException.java:302)

at com.sap.sl.ut.infoprovider.exceptions.UTInfoException.<init>(UTInfoException.java:99)

at com.sap.sl.ut.manager.persistence.db.DataBaseInfoFactory.fillProducts(DataBaseInfoFactory.java:1264)

at com.sap.sl.ut.manager.persistence.db.DataBaseInfoFactory.constructSystemInfo(DataBaseInfoFactory.java:894)

at com.sap.sl.ut.manager.command.Export.executeExportKDB(Export.java:56)

at com.sap.sl.ut.manager.command.Export.execute(Export.java:80)

at com.sap.sl.ut.manager.command.Command.exec(Command.java:88)

at com.sap.sl.ut.manager.UtlMain.exec(UtlMain.java:74)

at com.sap.sl.ut.manager.UtlMain.main(UtlMain.java:70)

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)

Caused by: java.sql.SQLException: Invalid object name 'BC_DDDBTABLERT'.

at com.sap.dictionary.database.catalog.XmlCatalogReader.getTable(XmlCatalogReader.java:98)

at com.sap.sql.catalog.impl.BufferedCatalogReader.getTable(BufferedCatalogReader.java:124)

at com.sap.sql.catalog.impl.BufferedCatalogReader.getTable(BufferedCatalogReader.java:87)

at com.sap.sql.sqlparser.CheckColAndTabVisitor.checkTables(CheckColAndTabVisitor.java:299)

at com.sap.sql.sqlparser.CheckColAndTabVisitor.performCatalogChecks(CheckColAndTabVisitor.java:176)

at com.sap.sql.sqlparser.CommonSQLStatement.checkSemantics(CommonSQLStatement.java:169)

at com.sap.sql.jdbc.common.StatementAnalyzerImpl.check(StatementAnalyzerImpl.java:35)

at com.sap.sql.jdbc.common.StatementAnalyzerImpl.preprepareStatement(StatementAnalyzerImpl.java:101)

at com.sap.sql.jdbc.common.StatementAnalyzerImpl.preprepareStatement(StatementAnalyzerImpl.java:87)

at com.sap.sql.jdbc.common.CommonStatementImpl.executeQuery(CommonStatementImpl.java:114)

at com.sap.sl.ut.manager.persistence.db.DataBaseInfoFactory.fillProducts(DataBaseInfoFactory.java:1248)

at com.sap.sl.ut.manager.persistence.db.DataBaseInfoFactory.constructSystemInfo(DataBaseInfoFactory.java:894)

at com.sap.sl.ut.manager.command.Export.executeExportKDB(Export.java:56)

at com.sap.sl.ut.manager.command.Export.execute(Export.java:80)

at com.sap.sl.ut.manager.command.Command.exec(Command.java:88)

at com.sap.sl.ut.manager.UtlMain.exec(UtlMain.java:74)

at com.sap.sl.ut.manager.UtlMain.main(UtlMain.java:70)

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)

May 22, 2009 6:58:19 PM Info : Processing error caused by incorrect SQL statement. Return code: 52

May 22, 2009 6:58:45 PM Info : Successfully parsed!

May 22, 2009 6:58:45 PM Info : Executing command Export...

May 22, 2009 6:58:45 PM Info : Establishing DB connection...

May 22, 2009 6:58:48 PM Info : Connecting succeeded!

May 22, 2009 6:58:48 PM Info : Constructing System Info from the database ...

May 22, 2009 6:58:48 PM Path : Exception : The SQL Statement is wrong : SELECT * FROM BC_SL_PRODUCTS

java.lang.Exception

at com.sap.exception.BaseExceptionInfo.traceAutomatically(BaseExceptionInfo.java:1141)

at com.sap.exception.BaseExceptionInfo.<init>(BaseExceptionInfo.java:413)

at com.sap.exception.BaseException.<init>(BaseException.java:302)

at com.sap.sl.ut.infoprovider.exceptions.UTInfoException.<init>(UTInfoException.java:99)

at com.sap.sl.ut.manager.persistence.db.DataBaseInfoFactory.fillProducts(DataBaseInfoFactory.java:1264)

at com.sap.sl.ut.manager.persistence.db.DataBaseInfoFactory.constructSystemInfo(DataBaseInfoFactory.java:894)

at com.sap.sl.ut.manager.command.Export.executeExportKDB(Export.java:56)

at com.sap.sl.ut.manager.command.Export.execute(Export.java:80)

at com.sap.sl.ut.manager.command.Command.exec(Command.java:88)

at com.sap.sl.ut.manager.UtlMain.exec(UtlMain.java:74)

at com.sap.sl.ut.manager.UtlMain.main(UtlMain.java:70)

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)

Caused by: java.sql.SQLException: Invalid object name 'BC_DDDBTABLERT'.

at com.sap.dictionary.database.catalog.XmlCatalogReader.getTable(XmlCatalogReader.java:98)

at com.sap.sql.catalog.impl.BufferedCatalogReader.getTable(BufferedCatalogReader.java:124)

at com.sap.sql.catalog.impl.BufferedCatalogReader.getTable(BufferedCatalogReader.java:87)

at com.sap.sql.sqlparser.CheckColAndTabVisitor.checkTables(CheckColAndTabVisitor.java:299)

at com.sap.sql.sqlparser.CheckColAndTabVisitor.performCatalogChecks(CheckColAndTabVisitor.java:176)

at com.sap.sql.sqlparser.CommonSQLStatement.checkSemantics(CommonSQLStatement.java:169)

at com.sap.sql.jdbc.common.StatementAnalyzerImpl.check(StatementAnalyzerImpl.java:35)

at com.sap.sql.jdbc.common.StatementAnalyzerImpl.preprepareStatement(StatementAnalyzerImpl.java:101)

at com.sap.sql.jdbc.common.StatementAnalyzerImpl.preprepareStatement(StatementAnalyzerImpl.java:87)

at com.sap.sql.jdbc.common.CommonStatementImpl.executeQuery(CommonStatementImpl.java:114)

at com.sap.sl.ut.manager.persistence.db.DataBaseInfoFactory.fillProducts(DataBaseInfoFactory.java:1248)

at com.sap.sl.ut.manager.persistence.db.DataBaseInfoFactory.constructSystemInfo(DataBaseInfoFactory.java:894)

at com.sap.sl.ut.manager.command.Export.executeExportKDB(Export.java:56)

at com.sap.sl.ut.manager.command.Export.execute(Export.java:80)

at com.sap.sl.ut.manager.command.Command.exec(Command.java:88)

at com.sap.sl.ut.manager.UtlMain.exec(UtlMain.java:74)

at com.sap.sl.ut.manager.UtlMain.main(UtlMain.java:70)

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)

May 22, 2009 6:58:48 PM Info : Processing error caused by incorrect SQL statement. Return code: 52

Accepted Solutions (0)

Answers (4)

Answers (4)

former_member211576
Contributor
0 Kudos

file is open by other process

Former Member
0 Kudos

Long time ago.. But Did you solve this problem?

former_member211576
Contributor
0 Kudos

Hi Anderson,

  In fact, I forget this problem but sometimes Windows server open/lock file longer than I expected(even I have closed the application/files for 10 seconds). You can use process explorer from sysinternal to find out the file which is being locked or reboot and try it again. Good luck.

former_member211576
Contributor
0 Kudos

-- UTL_load_usages.log --

May 22, 2009 6:58:48 PM Info : Processing error caused by incorrect SQL statement. Return code: 52

former_member211576
Contributor
0 Kudos

-- UTL.java.log --

java version "1.4.2_11"

Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_11-b06)

Java HotSpot(TM) 64-Bit Server VM (build 1.4.2_11-b06, mixed mode)

former_member211576
Contributor
0 Kudos

ERROR 2009-05-22 18:58:49.290

FJS-00003 uncaught exception: nw.usageTypes.utlSQLError:

--

DIAGNOSIS: Return code is 52. SOLUTION: Check 'UTL_load_usages.log' and 'C:/Program Files/sapinst_instdir/NW04S/LM/COPY/MSS/EXP/CENTRAL/AS/EXP/UTL.java.log' for more information. (in script unknown, line 0: ???)).