This forum is closed to new posts and
responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:
~Jennifer Opasonoden 30.Mar.16 02:33 PM a Web browser Administration 9.0 All Platforms
When installing Sametime System Console 9.0 HotFix SPIR-9VM7XJ I'm seeing the following error in the SystemOut.log for STConsoleServer:
#############################################
[3/29/16 13:51:52:213 ART] 00000063 SchedulerImpl E SCHD0124E: Unable to initialize TaskStore due to error: SCHD0046E: The table SSCSCHEDTREG in datasource jdbc/sscScheduler used by scheduler resource SSC Update Scheduler (sched/sscUpdateScheduler) is missing or is not accessible.
[3/29/16 13:51:52:229 ART] 0000006e persist E CLPAA0048E: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: SSC.PREREQMASTER retrieving column information for table [SSC].[PREREQMASTER].
[3/29/16 13:51:52:229 ART] 0000006e persist E CLPAA####E: Table does not exists.
com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: SSC.PREREQMASTER
at com.ibm.db2.jcc.b.hh.c(hh.java:1662)
at com.ibm.db2.jcc.b.hh.d(hh.java:1650)
at com.ibm.db2.jcc.b.hh.a(hh.java:1219)
at com.ibm.db2.jcc.c.db.g(db.java:139)
at com.ibm.db2.jcc.c.db.a(db.java:39)
at com.ibm.db2.jcc.c.t.a(t.java:34)
at com.ibm.db2.jcc.c.sb.f(sb.java:142)
at com.ibm.db2.jcc.b.hh.n(hh.java:1190)
at com.ibm.db2.jcc.b.hh.a(hh.java:1902)
at com.ibm.db2.jcc.b.hh.a(hh.java:491)
at com.ibm.db2.jcc.b.hh.executeQuery(hh.java:475)
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.pmiExecuteQuery(WSJdbcStatement.java:1728)
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeQuery(WSJdbcStatement.java:1019)
at com.ibm.workplace.db.persist.TableInfo.<init>(TableInfo.java:248)
at com.ibm.workplace.db.persist.Database.init(Database.java:575)
at com.ibm.workplace.db.persist.Database.<init>(Database.java:253)
at com.ibm.workplace.db.persist.PersistenceManager.processDatabaseTag(PersistenceManager.java:1255)
at com.ibm.workplace.db.persist.PersistenceManager.init(PersistenceManager.java:1615)
at com.ibm.workplace.db.persist.PersistenceManager.<init>(PersistenceManager.java:281)
at com.ibm.workplace.db.persist.PersistMgrFactory.getPersistenceModule(PersistMgrFactory.java:93)
at com.ibm.sametime.console.dbservice.util.ConsoleDB.locate(ConsoleDB.java:262)
at com.ibm.sametime.console.dbservice.impl.PrereqMasterImpl.insertValues(PrereqMasterImpl.java:98)
at com.ibm.sametime.console.deployment.app.PreReqMasterInit.initPreReq(PreReqMasterInit.java:233)
at com.ibm.sametime.console.deployment.ejb.DeploymentStartupBean$AsyncStartupBean.run(DeploymentStartupBean.java:252)
at com.ibm.ws.asynchbeans.J2EEContext$RunProxy.run(J2EEContext.java:270)
at java.security.AccessController.doPrivileged(AccessController.java:284)
at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:796)
at com.ibm.ws.asynchbeans.WorkWithExecutionContextImpl.go(WorkWithExecutionContextImpl.java:222)
at com.ibm.ws.asynchbeans.ABWorkItemImpl.run(ABWorkItemImpl.java:206)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1881)
---- Begin backtrace for Nested Throwables
com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -727, SQLSTATE: 56098, SQLERRMC: 2;-204;42704;SSC.PREREQMASTER
at com.ibm.db2.jcc.b.hh.c(hh.java:1662)
at com.ibm.db2.jcc.b.hh.a(hh.java:1238)
at com.ibm.db2.jcc.c.db.n(db.java:737)
at com.ibm.db2.jcc.c.db.i(db.java:257)
at com.ibm.db2.jcc.c.db.c(db.java:53)
at com.ibm.db2.jcc.c.t.c(t.java:46)
at com.ibm.db2.jcc.c.sb.g(sb.java:154)
at com.ibm.db2.jcc.b.hh.p(hh.java:1233)
at com.ibm.db2.jcc.b.hh.a(hh.java:1904)
at com.ibm.db2.jcc.b.hh.a(hh.java:491)
at com.ibm.db2.jcc.b.hh.executeQuery(hh.java:475)
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.pmiExecuteQuery(WSJdbcStatement.java:1728)
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeQuery(WSJdbcStatement.java:1019)
at com.ibm.workplace.db.persist.TableInfo.<init>(TableInfo.java:248)
at com.ibm.workplace.db.persist.Database.init(Database.java:575)
at com.ibm.workplace.db.persist.Database.<init>(Database.java:253)
at com.ibm.workplace.db.persist.PersistenceManager.processDatabaseTag(PersistenceManager.java:1255)
at com.ibm.workplace.db.persist.PersistenceManager.init(PersistenceManager.java:1615)
at com.ibm.workplace.db.persist.PersistenceManager.<init>(PersistenceManager.java:281)
at com.ibm.workplace.db.persist.PersistMgrFactory.getPersistenceModule(PersistMgrFactory.java:93)
at com.ibm.sametime.console.dbservice.util.ConsoleDB.locate(ConsoleDB.java:262)
at com.ibm.sametime.console.dbservice.impl.PrereqMasterImpl.insertValues(PrereqMasterImpl.java:98)
at com.ibm.sametime.console.deployment.app.PreReqMasterInit.initPreReq(PreReqMasterInit.java:233)
at com.ibm.sametime.console.deployment.ejb.DeploymentStartupBean$AsyncStartupBean.run(DeploymentStartupBean.java:252)
at com.ibm.ws.asynchbeans.J2EEContext$RunProxy.run(J2EEContext.java:270)
at java.security.AccessController.doPrivileged(AccessController.java:284)
at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:796)
at com.ibm.ws.asynchbeans.WorkWithExecutionContextImpl.go(WorkWithExecutionContextImpl.java:222)
at com.ibm.ws.asynchbeans.ABWorkItemImpl.run(ABWorkItemImpl.java:206)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1881)
[3/29/16 13:51:52:229 ART] 0000006e persist E CLPAA0023E: Fatal error in processDatabaseTag.
[3/29/16 13:51:52:229 ART] 0000006e persist E CLPAA####E: Table does not exists.
com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: SSC.PREREQMASTER
at com.ibm.db2.jcc.b.hh.c(hh.java:1662)
at com.ibm.db2.jcc.b.hh.d(hh.java:1650)
at com.ibm.db2.jcc.b.hh.a(hh.java:1219)
at com.ibm.db2.jcc.c.db.g(db.java:139)
at com.ibm.db2.jcc.c.db.a(db.java:39)
at com.ibm.db2.jcc.c.t.a(t.java:34)
at com.ibm.db2.jcc.c.sb.f(sb.java:142)
at com.ibm.db2.jcc.b.hh.n(hh.java:1190)
at com.ibm.db2.jcc.b.hh.a(hh.java:1902)
at com.ibm.db2.jcc.b.hh.a(hh.java:491)
at com.ibm.db2.jcc.b.hh.executeQuery(hh.java:475)
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.pmiExecuteQuery(WSJdbcStatement.java:1728)
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeQuery(WSJdbcStatement.java:1019)
at com.ibm.workplace.db.persist.TableInfo.<init>(TableInfo.java:248)
at com.ibm.workplace.db.persist.Database.init(Database.java:575)
at com.ibm.workplace.db.persist.Database.<init>(Database.java:253)
at com.ibm.workplace.db.persist.PersistenceManager.processDatabaseTag(PersistenceManager.java:1255)
at com.ibm.workplace.db.persist.PersistenceManager.init(PersistenceManager.java:1615)
at com.ibm.workplace.db.persist.PersistenceManager.<init>(PersistenceManager.java:281)
at com.ibm.workplace.db.persist.PersistMgrFactory.getPersistenceModule(PersistMgrFactory.java:93)
at com.ibm.sametime.console.dbservice.util.ConsoleDB.locate(ConsoleDB.java:262)
at com.ibm.sametime.console.dbservice.impl.PrereqMasterImpl.insertValues(PrereqMasterImpl.java:98)
at com.ibm.sametime.console.deployment.app.PreReqMasterInit.initPreReq(PreReqMasterInit.java:233)
at com.ibm.sametime.console.deployment.ejb.DeploymentStartupBean$AsyncStartupBean.run(DeploymentStartupBean.java:252)
at com.ibm.ws.asynchbeans.J2EEContext$RunProxy.run(J2EEContext.java:270)
at java.security.AccessController.doPrivileged(AccessController.java:284)
at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:796)
at com.ibm.ws.asynchbeans.WorkWithExecutionContextImpl.go(WorkWithExecutionContextImpl.java:222)
at com.ibm.ws.asynchbeans.ABWorkItemImpl.run(ABWorkItemImpl.java:206)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1881)
---- Begin backtrace for Nested Throwables
com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -727, SQLSTATE: 56098, SQLERRMC: 2;-204;42704;SSC.PREREQMASTER
at com.ibm.db2.jcc.b.hh.c(hh.java:1662)
at com.ibm.db2.jcc.b.hh.a(hh.java:1238)
at com.ibm.db2.jcc.c.db.n(db.java:737)
at com.ibm.db2.jcc.c.db.i(db.java:257)
at com.ibm.db2.jcc.c.db.c(db.java:53)
at com.ibm.db2.jcc.c.t.c(t.java:46)
at com.ibm.db2.jcc.c.sb.g(sb.java:154)
at com.ibm.db2.jcc.b.hh.p(hh.java:1233)
at com.ibm.db2.jcc.b.hh.a(hh.java:1904)
at com.ibm.db2.jcc.b.hh.a(hh.java:491)
at com.ibm.db2.jcc.b.hh.executeQuery(hh.java:475)
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.pmiExecuteQuery(WSJdbcStatement.java:1728)
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeQuery(WSJdbcStatement.java:1019)
at com.ibm.workplace.db.persist.TableInfo.<init>(TableInfo.java:248)
at com.ibm.workplace.db.persist.Database.init(Database.java:575)
at com.ibm.workplace.db.persist.Database.<init>(Database.java:253)
at com.ibm.workplace.db.persist.PersistenceManager.processDatabaseTag(PersistenceManager.java:1255)
at com.ibm.workplace.db.persist.PersistenceManager.init(PersistenceManager.java:1615)
at com.ibm.workplace.db.persist.PersistenceManager.<init>(PersistenceManager.java:281)
at com.ibm.workplace.db.persist.PersistMgrFactory.getPersistenceModule(PersistMgrFactory.java:93)
at com.ibm.sametime.console.dbservice.util.ConsoleDB.locate(ConsoleDB.java:262)
at com.ibm.sametime.console.dbservice.impl.PrereqMasterImpl.insertValues(PrereqMasterImpl.java:98)
at com.ibm.sametime.console.deployment.app.PreReqMasterInit.initPreReq(PreReqMasterInit.java:233)
at com.ibm.sametime.console.deployment.ejb.DeploymentStartupBean$AsyncStartupBean.run(DeploymentStartupBean.java:252)
at com.ibm.ws.asynchbeans.J2EEContext$RunProxy.run(J2EEContext.java:270)
at java.security.AccessController.doPrivileged(AccessController.java:284)
at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:796)
at com.ibm.ws.asynchbeans.WorkWithExecutionContextImpl.go(WorkWithExecutionContextImpl.java:222)
at com.ibm.ws.asynchbeans.ABWorkItemImpl.run(ABWorkItemImpl.java:206)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1881)
[3/29/16 13:51:52:229 ART] 0000006e persist E CLPAA0024E: Fatal error encountered in initialization.
#############################################
I checked the following files for SSCSCHEDTREG but did not find any references for it: