Skip to main content
10-Marble
February 20, 2024
Solved

Windchill takes long time to startup

  • February 20, 2024
  • 1 reply
  • 1918 views

Windchill takes long time to startup

30 mins

how to fix

Best answer by Rocket_Max

Ensure there are indexes on table wtgroup

Rocket_Max_0-1708392234957.png

 

1 reply

17-Peridot
February 20, 2024

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

10-Marble
February 20, 2024

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)

17-Peridot
February 20, 2024

Ensure there are indexes on table wtgroup

Rocket_Max_0-1708392234957.png