Community email notifications are disrupted. While we are working to resolve, please check on your favorite boards regularly to keep up with your conversations and new topics.
After adding projectLink module to existing system getting below error and method server also not comming up -
Nested exception is: wt.pom.DatastoreException: A SQL error has occurred for the statement "SELECT 'com.ptc.projectmanagement.assignment.DetailAssignment' FROM (SELECT 'com.ptc.projectmanagement.assignment.DetailAssignment' classname FROM DUAL WHERE (NOT (EXISTS (SELECT B0.idA2A2 FROM SharedAssignmentDetails B0)))) A0; Bind Parameters=[]". Database system message follows: Nested exception is: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:776) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:897) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1034) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3820) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3867) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1502) at wt.pds.AbstractResultCursor.executeQuery(AbstractResultCursor.java:575) at wt.pds.AbstractResultCursor.executeQuery(AbstractResultCursor.java:539) at wt.pds.BasicResultCursor.getNextResultSet(BasicResultCursor.java:282) at wt.pds.BasicResultCursor.advance(BasicResultCursor.java:234) at wt.pds.BasicResultCursor.next(BasicResultCursor.java:82) at wt.pds.SQLDatabasePds.query(SQLDatabasePds.java:837) at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1076) at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:985) at wt.pom.EmptyTableManager.queryTables(EmptyTableManager.java:512) at wt.pom.EmptyTableManager.queryTables(EmptyTableManager.java:463) at wt.pom.EmptyTableManager.findEmptyTables(EmptyTableManager.java:564) at wt.pom.EmptyTableManager.populateCache(EmptyTableManager.java:120) at wt.pom.EmptyTableManager.access$100(EmptyTableManager.java:71) at wt.pom.EmptyTableManager$AllManagersStartedEventListener.notifyVetoableEvent(EmptyTableManager.java:665) at wt.events.StandardKeyedEventBranch.intDispatchEvent(StandardKeyedEventBranch.java:312) at wt.events.StandardKeyedEventBranch.dispatchVetoableEvent(StandardKeyedEventBranch.java:250) at wt.events.StandardKeyedEventDispatcher.intDispatchEvent(StandardKeyedEventDispatcher.java:304) at wt.events.StandardKeyedEventDispatcher.dispatchVetoableEvent(StandardKeyedEventDispatcher.java:228) at wt.services.StandardManagerService.intDispatchVetoableEvent(StandardManagerService.java:406) at wt.services.StandardManagerService.dispatchVetoableEvent(StandardManagerService.java:302) at wt.services.StandardManagerService.performStartupProcess(StandardManagerService.java:184) at wt.services.StandardManager.startup(StandardManager.java:459) at wt.services.StandardServicesHandler.start(StandardServicesHandler.java:44) at wt.method.MethodServerMain.run(MethodServerMain.java:603) at wt.method.MethodServerMain.main(MethodServerMain.java:373) 2023-08-28 15:48:27,226 FATAL [main] wt.method.server.shutdown - Stopping services... 2023-08-28 15:48:27,277 INFO [main] wt.method.server.shutdown.services - All managers shut down. 2023-08-28 15:48:27,277 FATAL [main] wt.method.server.shutdown - MethodServer stopped
Run update_tool -noui in the shell , clean caches and restart