Skip to main content
Rocket_Max
17-Peridot
Feb 20, 2024 1:24 AM UTC

Ensure there are indexes on table wtgroup

Rocket_Max_0-1708392234957.png

 

6 replies

Rocket_Max
17-Peridot
Feb 20, 2024 1:11 AM UTC

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

Translate
10-Marble
Feb 20, 2024 1:16 AM UTC

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
Feb 20, 2024 1:24 AM UTC

Ensure there are indexes on table wtgroup

Rocket_Max_0-1708392234957.png

 

Translate