Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Table RESOURCE_RESOURCE does not exist?

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!

0 votes



One answer

Permanent link
It turned out that we didn't upgrade the database when we applied the 2.0.0.1 patch.
Exporting, recreating and importing the scheme with repotools fixed this error.

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Mar 09 '10, 12:28 p.m.

Question was seen: 3,766 times

Last updated: Mar 09 '10, 12:28 p.m.

Confirmation Cancel Confirm