on 05-22-2009 12:17 PM
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
file is open by other process
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
-- UTL_load_usages.log --
May 22, 2009 6:58:48 PM Info : Processing error caused by incorrect SQL statement. Return code: 52
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
-- 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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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: ???)).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
10 | |
10 | |
9 | |
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.