Skip to main content
Rocket_Max
17-Peridot
February 20, 2024

Ensure there are indexes on table wtgroup

Rocket_Max_0-1708392234957.png

 

6 replies

Rocket_Max
17-Peridot
February 20, 2024

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

Translate
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)

Translate
Rocket_Max
17-Peridot
February 20, 2024

Ensure there are indexes on table wtgroup

Rocket_Max_0-1708392234957.png

 

Translate