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

Community Tip - Help us improve the PTC Community by taking this short Community Survey! X

Method Server Fails to Start after Update from Windchill 10.1 M040 to Windchill 10.1 M050

vuchekar
9-Granite

Method Server Fails to Start after Update from Windchill 10.1 M040 to Windchill 10.1 M050

Hi All,

Today, i have sucessfully update Windchill 10.1, from 10.1M040 to Windchill 10.1M050.

When, i start the Windchill, method server was not up.

MS Log file is in attachment.

Please help us to solve this.

In MS logs, below is error :

ested exception is: A persistence error occurred.

Nested exception is: (wt.pom.pomResource/0) wt.pom.PersistenceException: A persistence error occurred. System message follows:

Nested exception is: A persistence error occurred.

Nested exception is: wt.util.WTException: (wt.pom.pomResource/0) wt.pom.PersistenceException: A persistence error occurred. System message follows:

Nested exception is: A persistence error occurred.

Nested exception is: (wt.pom.pomResource/0) wt.pom.PersistenceException: A persistence error occurred. System message follows:

Nested exception is: (wt.pom.pomResource/0) wt.pom.PersistenceException: A persistence error occurred. System message follows:

Nested exception is: wt.pom.DatastoreException: A SQL error has occurred for the statement "SELECT 'com.ptc.swlink.scm.ContainerAttributeLink' FROM (SELECT 'com.ptc.swlink.scm.ContainerAttributeLink' classname FROM DUAL WHERE (NOT (EXISTS (SELECT B0.idA2A2 FROM ContainerAttributeLink 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:447)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)

at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)

at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)

at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)

at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)

at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)

at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:886)

at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296)

at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613)

at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3657)

at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495)

at wt.pds.AbstractResultCursor.executeQuery(AbstractResultCursor.java:518)

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:687)

at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1108)

at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1017)

at wt.pom.EmptyTableManager.queryTables(EmptyTableManager.java:540)

at wt.pom.EmptyTableManager.queryTables(EmptyTableManager.java:491)

at wt.pom.EmptyTableManager.findEmptyTables(EmptyTableManager.java:588)

at wt.pom.EmptyTableManager.populateCache(EmptyTableManager.java:133)

at wt.pom.EmptyTableManager.access$100(EmptyTableManager.java:83)

at wt.pom.EmptyTableManager$AllManagersStartedEventListener.notifyVetoableEvent(EmptyTableManager.java:689)

at wt.events.StandardKeyedEventBranch.intDispatchEvent(StandardKeyedEventBranch.java:320)

at wt.events.StandardKeyedEventBranch.dispatchVetoableEvent(StandardKeyedEventBranch.java:229)

at wt.events.StandardKeyedEventDispatcher.intDispatchEvent(StandardKeyedEventDispatcher.java:286)

at wt.events.StandardKeyedEventDispatcher.dispatchVetoableEvent(StandardKeyedEventDispatcher.java:215)

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:506)

at wt.method.MethodServerMain.main(MethodServerMain.java:311)

Thanks,

Vivek

6 REPLIES 6

It looks like Windchill is expecting a table to exist in the DB that's not there. After running the PSI to apply the M050 update, did you run the update tool to update the DB schema?

Hi chris,

     I came across same error, but after checking in DB, table exists in DB. Still it throws error.

What is the query that is causing the ORA-00942 error?

Running update tool, should fix the issue

Did you get the answer from TS. Even I got stuck with the same issue.

Hi, Senthil Kumar,

Please run the update tool, it will fix this issue.

Regards,

Vivek

Top Tags