It's all about the answers!

Ask a question

Background task diagnostic error after upgrade from 2 to 3


Greg Hodgkinson (2092119) | asked Jan 04 '12, 10:15 a.m.
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.

2 answers



permanent link
Kim Soederhamn (1.5k24146) | answered Jan 06 '12, 8:31 p.m.
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.

Comments
Greg Hodgkinson commented Aug 03 '12, 6:01 a.m.

@kim - thanks for the response - I'm afraid those logs are no longer available so can't check the migration status. I had thought it had completed without errors.


permanent link
Greg Hodgkinson (2092119) | answered Feb 01 '12, 6:36 a.m.
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.

Comments
Greg Hodgkinson commented Aug 03 '12, 6:01 a.m.

In case anyone refers to this old posting - I had thought the issue had gone away, but it hasn't.

I was about to upgrade the server to v4 and noticed the error is still being reported in diagnostics.

The server seems to be working OK, but I am a bit concerned that there is some issue lurking.

Your answer


Register or to post your answer.