cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

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 getting an error

AP_10750193
6-Contributor

After adding projectLink module getting an error

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

2 REPLIES 2
Fadel
22-Sapphire I
(To:AP_10750193)

Run update_tool -noui in the shell , clean caches and  restart 

Fede
AP_10750193
6-Contributor
(To:Fadel)

Hi @Fadel ,

I have tried it but still the same issue.

 

Top Tags