Background task diagnostic error after upgrade from 2 to 3

Hi

I recently upgraded an old RTC v2 repository to RTC 3 and have seen that the app admin diagnostics for background task is reporting the following error:

CRJAZ1992E The task "com.ibm.team.repository.Defect140238RepairTask" has failed with an unexpected error which has caused it to be unscheduled. The error message is "CRJAZ0350I Error fetching item values. statement = Select VAL_ENCODING, ITEM_VALUE From REPOSITORY.ITEM_STATES Where KEY_UUID = ? parameter = _2sjCgkELEd-7vK05HH6O6A". Please check your server logs for details. Once you have addressed the issues, you should restart the server to reschedule this background task.

Looking in the log file I find the following:

2012-01-04 08:13:31,672 ERROR com.ibm.team.repository - CRJAZ0852I An exception occurred while executing the task "Defect140238RepairTask", contributed by component "com.ibm.team.repository". The task will be removed from the schedule.
com.ibm.team.repository.common.InternalRepositoryException: CRJAZ0350I Error fetching item values.
statement = Select VAL_ENCODING, ITEM_VALUE From REPOSITORY.ITEM_STATES Where KEY_UUID = ?
parameter = _2sjCgkELEd-7vK05HH6O6A
at com.ibm.team.repository.service.internal.dataaccess.DocumentMediatorService.doReadItemValues(DocumentMediatorService.java:792)
at com.ibm.team.repository.service.internal.dataaccess.DocumentMediatorService.doReadItemValues(DocumentMediatorService.java:758)
at com.ibm.team.repository.service.internal.dataaccess.DocumentMediatorService.fetchByKeyId(DocumentMediatorService.java:592)
at com.ibm.team.repository.service.internal.dataaccess.DocumentMediatorService.fetchCurrent(DocumentMediatorService.java:432)
at com.ibm.team.repository.service.internal.dataaccess.MediatorServiceDelegator.fetchCurrent(MediatorServiceDelegator.java:107)
at com.ibm.team.repository.service.internal.dataaccess.MediatorServiceDelegator.fetchCurrent(MediatorServiceDelegator.java:107)
at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.doFetchItem(RdbRepositoryDataMediator.java:1940)
at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.fetchStateBypassCache(RdbRepositoryDataMediator.java:2146)
at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.fetchStateBypassCache(RdbRepositoryDataMediator.java:2134)
at com.ibm.team.repository.service.internal.repair.Defect140238Repairer$1.run(Defect140238Repairer.java:300)
at com.ibm.team.repository.service.internal.repair.Defect140238Repairer$1.run(Defect140238Repairer.java:1)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:458)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$1.run(RepositoryDatabase.java:285)
at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:379)
at sun.reflect.GeneratedMethodAccessor139.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy61.withCurrentConnection(Unknown Source)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:281)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runInTransaction(RepositoryDatabase.java:236)
at com.ibm.team.repository.service.internal.TransactionService.runInTransaction(TransactionService.java:119)
at sun.reflect.GeneratedMethodAccessor388.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy97.runInTransaction(Unknown Source)
at com.ibm.team.repository.service.internal.repair.Defect140238Repairer.queryForAndRepairBrokenAttributes(Defect140238Repairer.java:276)
at com.ibm.team.repository.service.internal.repair.Defect140238Repairer.queryForAndRepairBrokenAttributes(Defect140238Repairer.java:179)
at com.ibm.team.repository.service.internal.repair.Defect140238Repairer.repairItems(Defect140238Repairer.java:140)
at com.ibm.team.repository.service.internal.repair.Defect140238RepairTask.runTask(Defect140238RepairTask.java:52)
at com.ibm.team.repository.service.async.AbstractAutoScheduledTask.executeTask(AbstractAutoScheduledTask.java:86)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy618.executeTask(Unknown Source)
at com.ibm.team.repository.service.internal.scheduler.AsynchronousTaskRunner.runTask(AsynchronousTaskRunner.java:136)
at com.ibm.team.repository.service.internal.scheduler.AsynchronousTaskRunner.run(AsynchronousTaskRunner.java:99)
at java.lang.Thread.run(Thread.java:811)
Caused by:
java.lang.RuntimeException: CRJAZ0179I The package "epmwork" is not present in the package registry.
at com.ibm.team.repository.common.internal.marshal.util.WebServicesSAXXMLHandler.createObjectFromTypeName(WebServicesSAXXMLHandler.java:111)
at org.eclipse.emf.ecore.xmi.impl.XMLHandler.createObject(XMLHandler.java:2030)
at org.eclipse.emf.ecore.xmi.impl.XMLHandler.handleFeature(XMLHandler.java:1839)
at com.ibm.team.repository.common.internal.marshal.util.WebServicesSAXXMLHandler.handleFeature(WebServicesSAXXMLHandler.java:61)
at org.eclipse.emf.ecore.xmi.impl.XMLHandler.processElement(XMLHandler.java:1023)
at org.eclipse.emf.ecore.xmi.impl.XMLHandler.startElement(XMLHandler.java:1001)
at org.eclipse.emf.ecore.xmi.impl.XMLHandler.startElement(XMLHandler.java:712)
at org.apache.xerces.parsers.AbstractSAXParser.startElement(Unknown Source)
at org.apache.xerces.parsers.AbstractXMLDocumentParser.emptyElement(Unknown Source)
at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanStartElement(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
at org.apache.xerces.jaxp.SAXParserImpl.parse(Unknown Source)
at org.eclipse.emf.ecore.xmi.impl.XMLLoadImpl.load(XMLLoadImpl.java:181)
at com.ibm.team.repository.common.internal.marshal.util.WebServicesXMLLoadImpl.load(WebServicesXMLLoadImpl.java:76)
at org.eclipse.emf.ecore.xmi.impl.XMLResourceImpl.doLoad(XMLResourceImpl.java:180)
at com.ibm.team.repository.common.internal.marshal.impl.EObjectMarshaller.demarshalInputStreamToObject(EObjectMarshaller.java:573)
at com.ibm.team.repository.service.internal.dataaccess.DocumentMediatorService$5.processRow(DocumentMediatorService.java:941)
at com.ibm.team.repository.service.internal.dataaccess.FetchRows.processResultSet(FetchRows.java:301)
at com.ibm.team.repository.service.internal.dataaccess.FetchRows.execute(FetchRows.java:332)
at com.ibm.team.repository.service.internal.dataaccess.FetchRows.execute(FetchRows.java:147)
at com.ibm.team.repository.service.internal.dataaccess.DocumentMediatorService.doFetchItemValues(DocumentMediatorService.java:991)
at com.ibm.team.repository.service.internal.dataaccess.DocumentMediatorService.doReadItemValues(DocumentMediatorService.java:778)
... 46 more

This repository used to have Rational Project Conductor installed at one point and I'm not sure that was properly uninstalled.

Could that be causing the issue? And if so, how do I fix it?

Thanks in advance for any advice on this.

Sounds like some state belonging to a certain project area is not found. Could you recheck that your migration went well ? perhaps the export ended before you were finished or perhaps the migration has reported some things missing.

Just to close the loop on this. At some point this diagnostics error disappeared.

Wish I could give more info on what fixed it, but its gone now.