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

Community Tip - Did you know you can set a signature that will be added to all your posts? Set it here! X

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