Windchill takes long time to startup

[YZ_10818805]

Windchill takes long time to startup

30 mins

how to fix

[Rocket_Max]

Ensure sufficient memory
Ensure proper communication between Windchill and database server
Ensure LDAP is functioning properly

[YZ_10818805]

The information you mentioned is all normal

We have rebuilt the wtgroup table before, is it related to this?

Moreover, there is this information in the log

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

 - locked <0x00000003c74090c8> (a oracle.jdbc.driver.T4CConnection)

 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)

[Rocket_Max · Accepted solution]

Ensure there are indexes on table wtgroup

[YZ_10818805]

Yes, we miss index

Thank you

[mmeadows-3]

Those are just a few possible causes.  Search PTC's knowledge base for "windchill slow startup" to get many more possible solutions.

[YZ_10818805]

thanks, I will check that.