Lots of errorlogs about RESOURCE0.RESOURCE not available
Hi.
I see a lot of these in our jazz.log: <pre> 2009-xx-xx xx:xx:xx,xxx ERROR ository.service.internal.RdbRepositoryDataMediator - Failing ast query ----------- ResourceQueryModel r = ResourceQueryModel.ROOT; AstQuery q = (AstQuery) IItemQuery.FACTORY.newInstance(r); q.filter(r.uri()._eq(q.newStringArg())); ----------- IDynamicQueryModel d = ItemUtil.itemTypeFor("Resource", "com.ibm.team.jfs.resource").getQueryModel(); IItemQuery q = IItemQuery.FACTORY.newInstance((IDynamicItemQueryModel) d); q.filter(((IStringField) d.getReference("uri"))._eq(q.newStringArg())); ----------- parm 1: storage/net.jazz.ajax.theming select t1.ITEM_ID, t1.STATE_ID, t1.JZ_DISCRIMINATOR from RESOURCE0.RESOURCE t1 where (t1.URI = ?) 2009-xx-xx xx:xx:xx,xxx ERROR ository.service.internal.RdbRepositoryDataMediator - InternalRepositoryException processing query com.ibm.team.repository.common.InternalRepositoryException: CRJAZ0368I Error executing query stmt = select t1.ITEM_ID, t1.STATE_ID, t1.JZ_DISCRIMINATOR from RESOURCE0.RESOURCE t1 where (t1.URI = ?) at com.ibm.team.repository.service.internal.dataaccess.FetchRows.execute(FetchRows.java:233) Caused by: com.ibm.db2.jcc.b.co: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=RESOURCE0.RESOURCE, DRIVER=3.53.70 </pre> The error code means that the table of view requested does not exist. However, everything seems to work just fine.. I didn't install the server myself, but I know it is a new installation, i.e. not an old database that's been 're-used', so I am confident that the database has not been touched by human hand. Does anyone know what the messages mean - and how I can get rid of them? Thanks, /Morten |
5 answers
This normally happens when you migrate a repository from RTC 2.0. to RTC 2.0.0.1 and forget to add the new tables. You probably need to stop the server and run:
repotools.sh -clean -addTables |
repotools.sh -clean -addTables Thanks. I was actually under the impression that it was a 2.0 installation, but the status summary page shows 2.0.0.1, so I think you may have hit the spot. Just curious, what does the -clean option do? I don't find it mentioned on https://jazz.net/library/content/docs/repo-migration/index.html (and I wouldn't want to wipe anything too clean) /Morten |
Not sure if this step about adding tables is mentioned anywhere. We migrated from 2.0 to 2.0.0.2 and see the same error.
Any information on what tables are being added with this command as well as a pointer to some documentation that talks about steps involved in upgrading from 2.0 to later versions will be much appreciated. Thanks Sunil |
This is mentioned in the 2.0.0.2 release notes except the part about the -clean option:
Must run "repotools -addTables" after deployment |
We ran into a similar issue when we upgraded from RTC Client for Visual Studio v2.0.0.1 (and v2.0) last week. The "repotools -addTables" command did not help us. We ended up working with IBM Rational RTC Support and found out that some Visual Studio web configuration files had been updated (maybe because of some .NET Framework and/or Windows Updates). You will want to look at defect 107836 for how we resolved the issue we had.
|
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.