Hi there!
After we installed RQM 2.0.0.1 and created the Oracle 10g database scheme with the repotools we occasionally observe an error related to a non-existing table 'RESOURCE_RESOURCE' on the Tomcat console:
16:12:14,171 [jfs.triple.indexing] ERROR com.ibm.team.jfs - !AbstractIndexAgent.ErrorPerformingIndexConsistencyCheck!
com.ibm.team.repository.common.InternalRepositoryException: CRJAZ1037I Fehlerhafte Abfrage ->
ResourceQueryModel r = ResourceQueryModel.ROOT;
AstQuery q = (AstQuery) IItemQuery.FACTORY.newInstance(r);
q.filter(r.modified()._gtOrEq(q.newDateTimeArg())._and(r.modified()._lt(q.newDateTimeArg()))._and(r.uri()._like("storage/%")._or(r.uri()._like("baselines/%"))._or(r.uri()._like("reindex/%"))));
q.orderByAsc(r.modified());
at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.doQueryData(RdbRepositoryDataMediator.java:931)
at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.queryData(RdbRepositoryDataMediator.java:892)
...
...
Caused by:
com.ibm.team.repository.common.InternalRepositoryException: CRJAZ0368I Fehler bei Ausfhrung der Abfrage
stmt = select t1.ITEM_ID, t1.STATE_ID, t1.JZ_DISCRIMINATOR from RESOURCE_RESOURCE t1 where ((t1.MODIFIED >= ?) and (t1.MODIFIED < ?) and (t1.URI like 'storage/%' or t1.URI like 'baselines/%' or t1.URI like 'reindex/%')) order by t1.MODIFIED asc
at com.ibm.team.repository.service.internal.dataaccess.FetchRows.execute(FetchRows.java:233)
at com.ibm.team.repository.service.internal.dataaccess.MediatorUtils.fetchData(MediatorUtils.java:61)
at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.doQueryData(RdbRepositoryDataMediator.java:925)
... 41 more
Caused by:
java.sql.SQLException: ORA-00942: Tabelle oder View nicht vorhanden
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:813)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1049)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:854)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1154)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3415)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.PreparedStatementStatWrapper.executeQuery(PreparedStatementStatWrapper.java:57)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.PreparedStatementErrLogWrapper.executeQuery(PreparedStatementErrLogWrapper.java:75)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.PreparedStatementLeakWrapper.executeQuery(PreparedStatementLeakWrapper.java:54)
at com.ibm.team.repository.service.internal.dataaccess.FetchRows.execute(FetchRows.java:230)
... 43 more
As mentioned before, the table RESOURCE_RESOURCE does not exist in the database scheme that we created with repotools.
But there's a table RESOURCE_WORK_RESOURCE_DETAILS, could this be the table in question?
Also it's not obvious to us if this error thrown by the Jazz server or RQM itself, and what task should be executed here.
Any help is appreciated!