Skip to main content
1-Visitor
November 18, 2014
Question

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

  • November 18, 2014
  • 6 replies
  • 3452 views

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

13-Aquamarine
November 18, 2014

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?

1-Visitor
June 16, 2016

Hi chris,

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

13-Aquamarine
June 16, 2016

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

1-Visitor
February 12, 2015

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

vuchekar1-VisitorAuthor
1-Visitor
February 12, 2015

Hi, Senthil Kumar,

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

Regards,

Vivek