It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×10,952

question asked: Mar 09 '10, 12:28 p.m.
question was seen: 3,709 times
last updated: Mar 09 '10, 12:28 p.m.

Related questions

Table RESOURCE_RESOURCE does not exist?

0
Jens Lippmann (11●1●1●1) | asked Mar 09 '10, 12:28 p.m.
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!

One answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Jens Lippmann (11●1●1●1) | answered Mar 11 '10, 6:22 a.m.
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.

Your answer

Register or 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.