Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Tim Cooke
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Knute Snortum
  • paul wheaton
  • Devaka Cooray
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Ron McLeod
  • Piet Souris
  • Ganesh Patekar
Bartenders:
  • Tim Holloway
  • Carey Brown
  • salvin francis

Failed to initialize WebSphere Application Server

 
Chethan Kumar Baliga
Greenhorn
Posts: 11
posted 16 years ago
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have installed WebSphere Application Server (WAS) Advanced Edition V4.0 on Windows NT (Version 4 with SP 6a). The Database server Oracle 8.1.7 is installed on Solaris(Version 8).
When Websphere Admin server is started for the first time, it creates certain tables for EJSADMIN user. But when I tried to start WS AdminServer for the first time, I encountered the following error in the tracefile:
-----------------------------------------
************ Start Display Current Environment ************
WebSphere AE 4.0.1 a0131.07 running with process name ess-rohit/__adminServer and process id 280
Host Operating System is Windows 2000, version 5.0
Java version = J2RE 1.3.0 IBM build cn130-20010609 (JIT enabled: jitc), Java Compiler = jitc
server.root = C:\WebSphere\AppServer
Java Home = C:\WebSphere\AppServer\java\jre
ws.ext.dirs = C:/WebSphere/AppServer/java/lib;C:/WebSphere/AppServer/classes;C:/WebSphere/AppServer/lib;C:/WebSphere/AppServer/lib/ext;C:/oracle/ora81/jdbc/lib/classes12.zip;C:/oracle/ora81/jdbc/lib/nls_charset12.zip
Classpath = C:/WebSphere/AppServer/properties;C:/WebSphere/AppServer/lib/bootstrap.jar
Java Library path = C:\WebSphere\AppServer\java\bin;.;C:\WINNT\System32;C:\WINNT;C:\\WebSphere\\AppServer\\bin;C:\\oracle\\ora81\\bin;C:\\WebSphere\\AppServer\\java\\bin;C:\Program Files\ibm\gsk5\lib;C:\IBMCON~1\CICS\BIN;C:\IBM Connectors\Encina\bin;C:\oracle\ora81\bin;C:\Program Files\Oracle\jre\1.1.7\bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;C:\WebSphere\WCS\bin;C:\IMNnq_NT;C:\MSSQL7\BINN;C:\jdk1.3.1_02\bin;C:\Program Files\TTERMPRO;C:\WebSphere\AppServer\bin
Current trace specification =
************* End Display Current Environment *************
[02.10.01 14:52:41:091 GMT+05:30] 1500b3d7 Server U Version : 4.0.1
[02.10.01 14:52:41:282 GMT+05:30] 1500b3d7 Server U Edition: Advanced Edition for Multiplatforms
[02.10.01 14:52:41:282 GMT+05:30] 1500b3d7 Server U Build date: Thu Aug 09 00:00:00 GMT+05:30 2001
[02.10.01 14:52:41:282 GMT+05:30] 1500b3d7 Server U Build number: a0131.07
[02.10.01 14:52:42:513 GMT+05:30] 1500b3d7 ORBRas W com.ibm.CORBA.iiop.Util Util P=161632 =0:CT JORB0012: Pass by reference has been set to: true (NoLocalCopies = true)
[02.10.01 14:52:48:852 GMT+05:30] 1500b3d7 DBMgr W SMTL0039W: An exception occurred during database query: select * from EJSADMIN.WLMBOOT_TABLE where GROUP_NAME = ? java.sql.SQLException: ORA-00942: table or view does not exist

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:822)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1446)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1371)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1900)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:363)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:407)
at com.ibm.ejs.cm.cache.CachedStatement.execute(CachedStatement.java:314)
at com.ibm.ejs.cm.proxy.PreparedStatementProxy.execute(PreparedStatementProxy.java:268)
at com.ibm.ejs.cm.lock.TableLockLock.getLock(TableLockLock.java:60)
at com.ibm.ejs.cm.lock.Lock.lock(Lock.java:66)
at com.ibm.ejs.sm.util.db.DBMgr.lockRepository(DBMgr.java:844)
at com.ibm.ejs.sm.util.db.DBMgr.executePreparedQuery(DBMgr.java:578)
at com.ibm.ws.wlm.bootstrap.WLMBootstrapImpl.updateBootTable(WLMBootstrapImpl.java:315)
at com.ibm.ws.wlm.bootstrap.WLMBootstrapImpl.initialize(WLMBootstrapImpl.java:151)
at com.ibm.ejs.sm.server.AdminServer.initializeWLM(AdminServer.java:1225)
at com.ibm.ws.runtime.Server.initializeRuntime0(Server.java:945)
at com.ibm.ejs.sm.server.ManagedServer.initializeRuntime0(ManagedServer.java:407)
at com.ibm.ejs.sm.server.AdminServer.initializeRuntime0(AdminServer.java:1104)
at com.ibm.ws.runtime.Server.initializeRuntime(Server.java:882)
at com.ibm.ejs.sm.server.AdminServer.main(AdminServer.java:391)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:158)

[02.10.01 14:52:49:083 GMT+05:30] 1500b3d7 WLMBootstrapI W WWLM0013: Method updateBootTable encountered an unexpected exception while updating table EJSADMIN.WLMBOOT_TABLE. java.sql.SQLException: ORA-00942: table or view does not exist

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:822)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1446)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1371)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1900)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:363)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:407)
at com.ibm.ejs.cm.cache.CachedStatement.execute(CachedStatement.java:314)
at com.ibm.ejs.cm.proxy.PreparedStatementProxy.execute(PreparedStatementProxy.java:268)
at com.ibm.ejs.cm.lock.TableLockLock.getLock(TableLockLock.java:60)
at com.ibm.ejs.cm.lock.Lock.lock(Lock.java:66)
at com.ibm.ejs.sm.util.db.DBMgr.lockRepository(DBMgr.java:844)
at com.ibm.ejs.sm.util.db.DBMgr.executePreparedQuery(DBMgr.java:578)
at com.ibm.ws.wlm.bootstrap.WLMBootstrapImpl.updateBootTable(WLMBootstrapImpl.java:315)
at com.ibm.ws.wlm.bootstrap.WLMBootstrapImpl.initialize(WLMBootstrapImpl.java:151)
at com.ibm.ejs.sm.server.AdminServer.initializeWLM(AdminServer.java:1225)
at com.ibm.ws.runtime.Server.initializeRuntime0(Server.java:945)
at com.ibm.ejs.sm.server.ManagedServer.initializeRuntime0(ManagedServer.java:407)
at com.ibm.ejs.sm.server.AdminServer.initializeRuntime0(AdminServer.java:1104)
at com.ibm.ws.runtime.Server.initializeRuntime(Server.java:882)
at com.ibm.ejs.sm.server.AdminServer.main(AdminServer.java:391)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:158)

[02.10.01 14:52:49:343 GMT+05:30] 1500b3d7 AdminServer X ADMS0001W: Unexpected WLMBootstrapException
Current exception:
Message:
WWLM0013: Method updateBootTable encountered an unexpected exception while updating table EJSADMIN.WLMBOOT_TABLE.
Stack trace:
com.ibm.ws.wlm.bootstrap.WLMBootstrapException
at com.ibm.ws.wlm.bootstrap.WLMBootstrapImpl.updateBootTable(WLMBootstrapImpl.java:364)
at com.ibm.ws.wlm.bootstrap.WLMBootstrapImpl.initialize(WLMBootstrapImpl.java:151)
at com.ibm.ejs.sm.server.AdminServer.initializeWLM(AdminServer.java:1225)
at com.ibm.ws.runtime.Server.initializeRuntime0(Server.java:945)
at com.ibm.ejs.sm.server.ManagedServer.initializeRuntime0(ManagedServer.java:407)
at com.ibm.ejs.sm.server.AdminServer.initializeRuntime0(AdminServer.java:1104)
at com.ibm.ws.runtime.Server.initializeRuntime(Server.java:882)
at com.ibm.ejs.sm.server.AdminServer.main(AdminServer.java:391)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:158)

Previous exception:
Message:
null
Stack trace:
java.sql.SQLException: ORA-00942: table or view does not exist

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:822)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1446)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1371)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1900)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:363)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:407)
at com.ibm.ejs.cm.cache.CachedStatement.execute(CachedStatement.java:314)
at com.ibm.ejs.cm.proxy.PreparedStatementProxy.execute(PreparedStatementProxy.java:268)
at com.ibm.ejs.cm.lock.TableLockLock.getLock(TableLockLock.java:60)
at com.ibm.ejs.cm.lock.Lock.lock(Lock.java:66)
at com.ibm.ejs.sm.util.db.DBMgr.lockRepository(DBMgr.java:844)
at com.ibm.ejs.sm.util.db.DBMgr.executePreparedQuery(DBMgr.java:578)
at com.ibm.ws.wlm.bootstrap.WLMBootstrapImpl.updateBootTable(WLMBootstrapImpl.java:315)
at com.ibm.ws.wlm.bootstrap.WLMBootstrapImpl.initialize(WLMBootstrapImpl.java:151)
at com.ibm.ejs.sm.server.AdminServer.initializeWLM(AdminServer.java:1225)
at com.ibm.ws.runtime.Server.initializeRuntime0(Server.java:945)
at com.ibm.ejs.sm.server.ManagedServer.initializeRuntime0(ManagedServer.java:407)
at com.ibm.ejs.sm.server.AdminServer.initializeRuntime0(AdminServer.java:1104)
at com.ibm.ws.runtime.Server.initializeRuntime(Server.java:882)
at com.ibm.ejs.sm.server.AdminServer.main(AdminServer.java:391)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:158)

End of exception traces

[02.10.01 14:52:49:453 GMT+05:30] 1500b3d7 AdminServer X WSVR0009E: Error occurred during startup
com.ibm.ejs.sm.exception.OpException: Unexpected WLMBootstrapException thrown while initializing WLM Bootstrap service
at com.ibm.ejs.sm.server.AdminServer.initializeWLM(AdminServer.java:1229)
at com.ibm.ws.runtime.Server.initializeRuntime0(Server.java:945)
at com.ibm.ejs.sm.server.ManagedServer.initializeRuntime0(ManagedServer.java:407)
at com.ibm.ejs.sm.server.AdminServer.initializeRuntime0(AdminServer.java:1104)
at com.ibm.ws.runtime.Server.initializeRuntime(Server.java:882)
at com.ibm.ejs.sm.server.AdminServer.main(AdminServer.java:391)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:158)

[02.10.01 14:52:49:553 GMT+05:30] 1500b3d7 AdminServer F WSVR0067E: Failed to initialize WebSphere Administration server
java.lang.Throwable
at com.ibm.ejs.ras.TraceLogger.fatalEvent(TraceLogger.java:219)
at com.ibm.ejs.ras.TraceEventGeneratorImpl.fireTraceEvent(Tr.java:1402)
at com.ibm.ejs.ras.TraceEventGeneratorImpl.fireTraceEvent(Tr.java:1346)
at com.ibm.ejs.ras.Tr.fatal(Tr.java:828)
at com.ibm.ejs.sm.server.AdminServer.main(AdminServer.java:405)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:158)
[02.10.01 14:52:49:734 GMT+05:30] 1500b3d7 SystemOut U WSVR0067E: Failed to initialize WebSphere Administration server
************ Start Display Current Environment ************
WebSphere AE 4.0.1 a0131.07 running with process name ess-rohit/__adminServer and process id 1844
Host Operating System is Windows 2000, version 5.0
Java version = J2RE 1.3.0 IBM build cn130-20010609 (JIT enabled: jitc), Java Compiler = jitc
server.root = C:\WebSphere\AppServer
Java Home = C:\WebSphere\AppServer\java\jre
ws.ext.dirs = C:/WebSphere/AppServer/java/lib;C:/WebSphere/AppServer/classes;C:/WebSphere/AppServer/lib;C:/WebSphere/AppServer/lib/ext;C:/oracle/ora81/jdbc/lib/classes12.zip;C:/oracle/ora81/jdbc/lib/nls_charset12.zip
Classpath = C:/WebSphere/AppServer/properties;C:/WebSphere/AppServer/lib/bootstrap.jar
Java Library path = C:\WebSphere\AppServer\java\bin;.;C:\WINNT\System32;C:\WINNT;C:\\WebSphere\\AppServer\\bin;C:\\oracle\\ora81\\bin;C:\\WebSphere\\AppServer\\java\\bin;C:\Program Files\ibm\gsk5\lib;C:\IBMCON~1\CICS\BIN;C:\IBM Connectors\Encina\bin;C:\oracle\ora81\bin;C:\Program Files\Oracle\jre\1.1.7\bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;C:\WebSphere\WCS\bin;C:\IMNnq_NT;C:\MSSQL7\BINN;C:\jdk1.3.1_02\bin;C:\Program Files\TTERMPRO;C:\WebSphere\AppServer\bin
Current trace specification =
************* End Display Current Environment *************
[02.10.01 14:53:02:782 GMT+05:30] 153eb3e1 Server U Version : 4.0.1
[02.10.01 14:53:02:883 GMT+05:30] 153eb3e1 Server U Edition: Advanced Edition for Multiplatforms
[02.10.01 14:53:02:883 GMT+05:30] 153eb3e1 Server U Build date: Thu Aug 09 00:00:00 GMT+05:30 2001
[02.10.01 14:53:02:883 GMT+05:30] 153eb3e1 Server U Build number: a0131.07
[02.10.01 14:53:03:614 GMT+05:30] 153eb3e1 ORBRas W com.ibm.CORBA.iiop.Util Util P=183033 =0:CT JORB0012: Pass by reference has been set to: true (NoLocalCopies = true)
[02.10.01 14:53:08:741 GMT+05:30] 153eb3e1 DBMgr W SMTL0039W: An exception occurred during database query: select * from EJSADMIN.WLMBOOT_TABLE where GROUP_NAME = ? java.sql.SQLException: ORA-00942: table or view does not exist

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:822)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1446)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1371)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1900)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:363)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:407)
at com.ibm.ejs.cm.cache.CachedStatement.execute(CachedStatement.java:314)
at com.ibm.ejs.cm.proxy.PreparedStatementProxy.execute(PreparedStatementProxy.java:268)
at com.ibm.ejs.cm.lock.TableLockLock.getLock(TableLockLock.java:60)
at com.ibm.ejs.cm.lock.Lock.lock(Lock.java:66)
at com.ibm.ejs.sm.util.db.DBMgr.lockRepository(DBMgr.java:844)
at com.ibm.ejs.sm.util.db.DBMgr.executePreparedQuery(DBMgr.java:578)
at com.ibm.ws.wlm.bootstrap.WLMBootstrapImpl.updateBootTable(WLMBootstrapImpl.java:315)
at com.ibm.ws.wlm.bootstrap.WLMBootstrapImpl.initialize(WLMBootstrapImpl.java:151)
at com.ibm.ejs.sm.server.AdminServer.initializeWLM(AdminServer.java:1225)
at com.ibm.ws.runtime.Server.initializeRuntime0(Server.java:945)
at com.ibm.ejs.sm.server.ManagedServer.initializeRuntime0(ManagedServer.java:407)
at com.ibm.ejs.sm.server.AdminServer.initializeRuntime0(AdminServer.java:1104)
at com.ibm.ws.runtime.Server.initializeRuntime(Server.java:882)
at com.ibm.ejs.sm.server.AdminServer.main(AdminServer.java:391)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:158)

[02.10.01 14:53:08:941 GMT+05:30] 153eb3e1 WLMBootstrapI W WWLM0013: Method updateBootTable encountered an unexpected exception while updating table EJSADMIN.WLMBOOT_TABLE. java.sql.SQLException: ORA-00942: table or view does not exist

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:822)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1446)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1371)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1900)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:363)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:407)
at com.ibm.ejs.cm.cache.CachedStatement.execute(CachedStatement.java:314)
at com.ibm.ejs.cm.proxy.PreparedStatementProxy.execute(PreparedStatementProxy.java:268)
at com.ibm.ejs.cm.lock.TableLockLock.getLock(TableLockLock.java:60)
at com.ibm.ejs.cm.lock.Lock.lock(Lock.java:66)
at com.ibm.ejs.sm.util.db.DBMgr.lockRepository(DBMgr.java:844)
at com.ibm.ejs.sm.util.db.DBMgr.executePreparedQuery(DBMgr.java:578)
at com.ibm.ws.wlm.bootstrap.WLMBootstrapImpl.updateBootTable(WLMBootstrapImpl.java:315)
at com.ibm.ws.wlm.bootstrap.WLMBootstrapImpl.initialize(WLMBootstrapImpl.java:151)
at com.ibm.ejs.sm.server.AdminServer.initializeWLM(AdminServer.java:1225)
at com.ibm.ws.runtime.Server.initializeRuntime0(Server.java:945)
at com.ibm.ejs.sm.server.ManagedServer.initializeRuntime0(ManagedServer.java:407)
at com.ibm.ejs.sm.server.AdminServer.initializeRuntime0(AdminServer.java:1104)
at com.ibm.ws.runtime.Server.initializeRuntime(Server.java:882)
at com.ibm.ejs.sm.server.AdminServer.main(AdminServer.java:391)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:158)

[02.10.01 14:53:09:202 GMT+05:30] 153eb3e1 AdminServer X ADMS0001W: Unexpected WLMBootstrapException
Current exception:
Message:
WWLM0013: Method updateBootTable encountered an unexpected exception while updating table EJSADMIN.WLMBOOT_TABLE.
Stack trace:
com.ibm.ws.wlm.bootstrap.WLMBootstrapException
at com.ibm.ws.wlm.bootstrap.WLMBootstrapImpl.updateBootTable(WLMBootstrapImpl.java:364)
at com.ibm.ws.wlm.bootstrap.WLMBootstrapImpl.initialize(WLMBootstrapImpl.java:151)
at com.ibm.ejs.sm.server.AdminServer.initializeWLM(AdminServer.java:1225)
at com.ibm.ws.runtime.Server.initializeRuntime0(Server.java:945)
at com.ibm.ejs.sm.server.ManagedServer.initializeRuntime0(ManagedServer.java:407)
at com.ibm.ejs.sm.server.AdminServer.initializeRuntime0(AdminServer.java:1104)
at com.ibm.ws.runtime.Server.initializeRuntime(Server.java:882)
at com.ibm.ejs.sm.server.AdminServer.main(AdminServer.java:391)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:158)

Previous exception:
Message:
null
Stack trace:
java.sql.SQLException: ORA-00942: table or view does not exist

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:822)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1446)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1371)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1900)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:363)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:407)
at com.ibm.ejs.cm.cache.CachedStatement.execute(CachedStatement.java:314)
at com.ibm.ejs.cm.proxy.PreparedStatementProxy.execute(PreparedStatementProxy.java:268)
at com.ibm.ejs.cm.lock.TableLockLock.getLock(TableLockLock.java:60)
at com.ibm.ejs.cm.lock.Lock.lock(Lock.java:66)
at com.ibm.ejs.sm.util.db.DBMgr.lockRepository(DBMgr.java:844)
at com.ibm.ejs.sm.util.db.DBMgr.executePreparedQuery(DBMgr.java:578)
at com.ibm.ws.wlm.bootstrap.WLMBootstrapImpl.updateBootTable(WLMBootstrapImpl.java:315)
at com.ibm.ws.wlm.bootstrap.WLMBootstrapImpl.initialize(WLMBootstrapImpl.java:151)
at com.ibm.ejs.sm.server.AdminServer.initializeWLM(AdminServer.java:1225)
at com.ibm.ws.runtime.Server.initializeRuntime0(Server.java:945)
at com.ibm.ejs.sm.server.ManagedServer.initializeRuntime0(ManagedServer.java:407)
at com.ibm.ejs.sm.server.AdminServer.initializeRuntime0(AdminServer.java:1104)
at com.ibm.ws.runtime.Server.initializeRuntime(Server.java:882)
at com.ibm.ejs.sm.server.AdminServer.main(AdminServer.java:391)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:158)

End of exception traces

[02.10.01 14:53:09:322 GMT+05:30] 153eb3e1 AdminServer X WSVR0009E: Error occurred during startup
com.ibm.ejs.sm.exception.OpException: Unexpected WLMBootstrapException thrown while initializing WLM Bootstrap service
at com.ibm.ejs.sm.server.AdminServer.initializeWLM(AdminServer.java:1229)
at com.ibm.ws.runtime.Server.initializeRuntime0(Server.java:945)
at com.ibm.ejs.sm.server.ManagedServer.initializeRuntime0(ManagedServer.java:407)
at com.ibm.ejs.sm.server.AdminServer.initializeRuntime0(AdminServer.java:1104)
at com.ibm.ws.runtime.Server.initializeRuntime(Server.java:882)
at com.ibm.ejs.sm.server.AdminServer.main(AdminServer.java:391)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:158)

[02.10.01 14:53:09:422 GMT+05:30] 153eb3e1 AdminServer F WSVR0067E: Failed to initialize WebSphere Administration server
java.lang.Throwable
at com.ibm.ejs.ras.TraceLogger.fatalEvent(TraceLogger.java:219)
at com.ibm.ejs.ras.TraceEventGeneratorImpl.fireTraceEvent(Tr.java:1402)
at com.ibm.ejs.ras.TraceEventGeneratorImpl.fireTraceEvent(Tr.java:1346)
at com.ibm.ejs.ras.Tr.fatal(Tr.java:828)
at com.ibm.ejs.sm.server.AdminServer.main(AdminServer.java:405)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:158)
[02.10.01 14:53:09:602 GMT+05:30] 153eb3e1 SystemOut U WSVR0067E: Failed to initialize WebSphere Administration server
************ Start Display Current Environment ************
WebSphere AE 4.0.1 a0131.07 running with process name ess-rohit/__adminServer and process id 1316
Host Operating System is Windows 2000, version 5.0
Java version = J2RE 1.3.0 IBM build cn130-20010609 (JIT enabled: jitc), Java Compiler = jitc
server.root = C:\WebSphere\AppServer
Java Home = C:\WebSphere\AppServer\java\jre
ws.ext.dirs = C:/WebSphere/AppServer/java/lib;C:/WebSphere/AppServer/classes;C:/WebSphere/AppServer/lib;C:/WebSphere/AppServer/lib/ext;C:/oracle/ora81/jdbc/lib/classes12.zip;C:/oracle/ora81/jdbc/lib/nls_charset12.zip
Classpath = C:/WebSphere/AppServer/properties;C:/WebSphere/AppServer/lib/bootstrap.jar
Java Library path = C:\WebSphere\AppServer\java\bin;.;C:\WINNT\System32;C:\WINNT;C:\\WebSphere\\AppServer\\bin;C:\\oracle\\ora81\\bin;C:\\WebSphere\\AppServer\\java\\bin;C:\Program Files\ibm\gsk5\lib;C:\IBMCON~1\CICS\BIN;C:\IBM Connectors\Encina\bin;C:\oracle\ora81\bin;C:\Program Files\Oracle\jre\1.1.7\bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;C:\WebSphere\WCS\bin;C:\IMNnq_NT;C:\MSSQL7\BINN;C:\jdk1.3.1_02\bin;C:\Program Files\TTERMPRO;C:\WebSphere\AppServer\bin
Current trace specification =
************* End Display Current Environment *************
[02.10.01 14:53:22:651 GMT+05:30] 153b33ef Server U Version : 4.0.1
[02.10.01 14:53:22:741 GMT+05:30] 153b33ef Server U Edition: Advanced Edition for Multiplatforms
[02.10.01 14:53:22:751 GMT+05:30] 153b33ef Server U Build date: Thu Aug 09 00:00:00 GMT+05:30 2001
[02.10.01 14:53:22:751 GMT+05:30] 153b33ef Server U Build number: a0131.07
[02.10.01 14:53:23:472 GMT+05:30] 153b33ef ORBRas W com.ibm.CORBA.iiop.Util Util P=202891 =0:CT JORB0012: Pass by reference has been set to: true (NoLocalCopies = true)
[02.10.01 14:53:28:610 GMT+05:30] 153b33ef DBMgr W SMTL0039W: An exception occurred during database query: select * from EJSADMIN.WLMBOOT_TABLE where GROUP_NAME = ? java.sql.SQLException: ORA-00942: table or view does not exist

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:822)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1446)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1371)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1900)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:363)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:407)
at com.ibm.ejs.cm.cache.CachedStatement.execute(CachedStatement.java:314)
at com.ibm.ejs.cm.proxy.PreparedStatementProxy.execute(PreparedStatementProxy.java:268)
at com.ibm.ejs.cm.lock.TableLockLock.getLock(TableLockLock.java:60)
at com.ibm.ejs.cm.lock.Lock.lock(Lock.java:66)
at com.ibm.ejs.sm.util.db.DBMgr.lockRepository(DBMgr.java:844)
at com.ibm.ejs.sm.util.db.DBMgr.executePreparedQuery(DBMgr.java:578)
at com.ibm.ws.wlm.bootstrap.WLMBootstrapImpl.updateBootTable(WLMBootstrapImpl.java:315)
at com.ibm.ws.wlm.bootstrap.WLMBootstrapImpl.initialize(WLMBootstrapImpl.java:151)
at com.ibm.ejs.sm.server.AdminServer.initializeWLM(AdminServer.java:1225)
at com.ibm.ws.runtime.Server.initializeRuntime0(Server.java:945)
at com.ibm.ejs.sm.server.ManagedServer.initializeRuntime0(ManagedServer.java:407)
at com.ibm.ejs.sm.server.AdminServer.initializeRuntime0(AdminServer.java:1104)
at com.ibm.ws.runtime.Server.initializeRuntime(Server.java:882)
at com.ibm.ejs.sm.server.AdminServer.main(AdminServer.java:391)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:158)

[02.10.01 14:53:28:830 GMT+05:30] 153b33ef WLMBootstrapI W WWLM0013: Method updateBootTable encountered an unexpected exception while updating table EJSADMIN.WLMBOOT_TABLE. java.sql.SQLException: ORA-00942: table or view does not exist

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:822)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1446)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1371)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1900)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:363)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:407)
at com.ibm.ejs.cm.cache.CachedStatement.execute(CachedStatement.java:314)
at com.ibm.ejs.cm.proxy.PreparedStatementProxy.execute(PreparedStatementProxy.java:268)
at com.ibm.ejs.cm.lock.TableLockLock.getLock(TableLockLock.java:60)
at com.ibm.ejs.cm.lock.Lock.lock(Lock.java:66)
at com.ibm.ejs.sm.util.db.DBMgr.lockRepository(DBMgr.java:844)
at com.ibm.ejs.sm.util.db.DBMgr.executePreparedQuery(DBMgr.java:578)
at com.ibm.ws.wlm.bootstrap.WLMBootstrapImpl.updateBootTable(WLMBootstrapImpl.java:315)
at com.ibm.ws.wlm.bootstrap.WLMBootstrapImpl.initialize(WLMBootstrapImpl.java:151)
at com.ibm.ejs.sm.server.AdminServer.initializeWLM(AdminServer.java:1225)
at com.ibm.ws.runtime.Server.initializeRuntime0(Server.java:945)
at com.ibm.ejs.sm.server.ManagedServer.initializeRuntime0(ManagedServer.java:407)
at com.ibm.ejs.sm.server.AdminServer.initializeRuntime0(AdminServer.java:1104)
at com.ibm.ws.runtime.Server.initializeRuntime(Server.java:882)
at com.ibm.ejs.sm.server.AdminServer.main(AdminServer.java:391)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:158)

[02.10.01 14:53:29:080 GMT+05:30] 153b33ef AdminServer X ADMS0001W: Unexpected WLMBootstrapException
Current exception:
Message:
WWLM0013: Method updateBootTable encountered an unexpected exception while updating table EJSADMIN.WLMBOOT_TABLE.
Stack trace:
com.ibm.ws.wlm.bootstrap.WLMBootstrapException
at com.ibm.ws.wlm.bootstrap.WLMBootstrapImpl.updateBootTable(WLMBootstrapImpl.java:364)
at com.ibm.ws.wlm.bootstrap.WLMBootstrapImpl.initialize(WLMBootstrapImpl.java:151)
at com.ibm.ejs.sm.server.AdminServer.initializeWLM(AdminServer.java:1225)
at com.ibm.ws.runtime.Server.initializeRuntime0(Server.java:945)
at com.ibm.ejs.sm.server.ManagedServer.initializeRuntime0(ManagedServer.java:407)
at com.ibm.ejs.sm.server.AdminServer.initializeRuntime0(AdminServer.java:1104)
at com.ibm.ws.runtime.Server.initializeRuntime(Server.java:882)
at com.ibm.ejs.sm.server.AdminServer.main(AdminServer.java:391)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:158)

Previous exception:
Message:
null
Stack trace:
java.sql.SQLException: ORA-00942: table or view does not exist

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:822)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1446)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1371)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1900)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:363)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:407)
at com.ibm.ejs.cm.cache.CachedStatement.execute(CachedStatement.java:314)
at com.ibm.ejs.cm.proxy.PreparedStatementProxy.execute(PreparedStatementProxy.java:268)
at com.ibm.ejs.cm.lock.TableLockLock.getLock(TableLockLock.java:60)
at com.ibm.ejs.cm.lock.Lock.lock(Lock.java:66)
at com.ibm.ejs.sm.util.db.DBMgr.lockRepository(DBMgr.java:844)
at com.ibm.ejs.sm.util.db.DBMgr.executePreparedQuery(DBMgr.java:578)
at com.ibm.ws.wlm.bootstrap.WLMBootstrapImpl.updateBootTable(WLMBootstrapImpl.java:315)
at com.ibm.ws.wlm.bootstrap.WLMBootstrapImpl.initialize(WLMBootstrapImpl.java:151)
at com.ibm.ejs.sm.server.AdminServer.initializeWLM(AdminServer.java:1225)
at com.ibm.ws.runtime.Server.initializeRuntime0(Server.java:945)
at com.ibm.ejs.sm.server.ManagedServer.initializeRuntime0(ManagedServer.java:407)
at com.ibm.ejs.sm.server.AdminServer.initializeRuntime0(AdminServer.java:1104)
at com.ibm.ws.runtime.Server.initializeRuntime(Server.java:882)
at com.ibm.ejs.sm.server.AdminServer.main(AdminServer.java:391)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:158)

End of exception traces

[02.10.01 14:53:29:200 GMT+05:30] 153b33ef AdminServer X WSVR0009E: Error occurred during startup
com.ibm.ejs.sm.exception.OpException: Unexpected WLMBootstrapException thrown while initializing WLM Bootstrap service
at com.ibm.ejs.sm.server.AdminServer.initializeWLM(AdminServer.java:1229)
at com.ibm.ws.runtime.Server.initializeRuntime0(Server.java:945)
at com.ibm.ejs.sm.server.ManagedServer.initializeRuntime0(ManagedServer.java:407)
at com.ibm.ejs.sm.server.AdminServer.initializeRuntime0(AdminServer.java:1104)
at com.ibm.ws.runtime.Server.initializeRuntime(Server.java:882)
at com.ibm.ejs.sm.server.AdminServer.main(AdminServer.java:391)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:158)

[02.10.01 14:53:29:291 GMT+05:30] 153b33ef AdminServer F WSVR0067E: Failed to initialize WebSphere Administration server
java.lang.Throwable
at com.ibm.ejs.ras.TraceLogger.fatalEvent(TraceLogger.java:219)
at com.ibm.ejs.ras.TraceEventGeneratorImpl.fireTraceEvent(Tr.java:1402)
at com.ibm.ejs.ras.TraceEventGeneratorImpl.fireTraceEvent(Tr.java:1346)
at com.ibm.ejs.ras.Tr.fatal(Tr.java:828)
at com.ibm.ejs.sm.server.AdminServer.main(AdminServer.java:405)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:158)
[02.10.01 14:53:29:471 GMT+05:30] 153b33ef SystemOut U WSVR0067E: Failed to initialize WebSphere Administration server
---------------------------------------------

However a table with name "DOMAIN_TMPTBL" is created in the database for EJSADMIN user.
Please help.
Thanks in Advance!!!
 
Patrick Finnegan
Ranch Hand
Posts: 179
posted 16 years ago
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The WAS DB2 respository is corrupt. Either WebSphere did not install properly or someone manually dropped the missing tables. Either re-install or manually drop and recreate the WebSphere Database then edit the admin.config file so that WebSphere re-initializes the database(i.e creates it's tables) when it starts.
This will wipe out any existing configuration.
Do you need instructions for this?
 
Chethan Kumar Baliga
Greenhorn
Posts: 11
posted 16 years ago
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for the suggestions. But no such mistakes have happened. I would like to point out one interesting thing. When I have Oracle and WAS on the same machine it works fine (i.e. when started for the first time it creates all the required tables and so on). But when I have Oracle and WAS on different machines, it fails except for the creation of one table DOMAIN_TMPTBL. Does that give any clues?
 
Always! Wait. Never. Shut up. Look at this tiny ad.
professionally read, modify and write PDF files from Java
https://products.aspose.com/pdf/java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!

Similar Threads

More...