It's all about the answers!

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

×42,863
×82
×1
×1

question asked: Jun 30 '15, 8:16 a.m.
question was seen: 2,913 times
last updated: Jul 01 '15, 3:21 a.m.

Related questions

com.ibm.team.repository.common.StaleDataException: CRJAZ0322I 1 row was expected but 0 rows were found

0
SEC Servizi (971●2●38●60) | asked Jun 30 '15, 8:16 a.m.
edited Jun 30 '15, 8:17 a.m.
After a disk failure on the database server, now we get a stale data exception when the Jazz Team Server restarted: 
2015-06-30 14:05:11,640 [http-bio-443-exec-38 @@ 14:05 Buildengine_Usr1 /jazz/service/com.ibm.team.build.internal.common.ITeamBuildRequestService] ERROR com.ibm.team.build                                  - Unable to update last contact time for build engine "_RqdooLu0EeK9ian2-cTBbA":
com.ibm.team.repository.common.StaleDataException: UpdateItemCurrentRow failure:  Params=[_QbQHAB8gEeWAFbJkn363TQ,_ODKf4bu2EeKHvZ3VRjRq2A,_2rFc4hOgEeWKH5VNQykqTw]
	at com.ibm.team.repository.service.internal.dataaccess.UpdateItemCurrentRow.validateResult(UpdateItemCurrentRow.java:99)
	at com.ibm.team.repository.service.internal.dataaccess.BatchingRowReceiver.simulatedBatch(BatchingRowReceiver.java:400)
	at com.ibm.team.repository.service.internal.dataaccess.BatchingRowReceiver.executeBatch(BatchingRowReceiver.java:277)
	at com.ibm.team.repository.service.internal.dataaccess.BatchingRowReceiver.execute(BatchingRowReceiver.java:204)
	at com.ibm.team.repository.service.internal.dataaccess.IRowReceiver$IRowReceiverLocator.executePendingChanges(IRowReceiver.java:143)
	at com.ibm.team.repository.service.internal.dataaccess.FlushingMediatorService.flush(FlushingMediatorService.java:62)
	at com.ibm.team.repository.service.internal.dataaccess.FlushingMediatorService.update(FlushingMediatorService.java:87)
	at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.updateSimpleItem(RdbRepositoryDataMediator.java:2071)
	at com.ibm.team.repository.service.internal.RepositoryItemService.doUpdateSimpleItem(RepositoryItemService.java:1586)
	at com.ibm.team.repository.service.internal.RepositoryItemService.doSaveSimpleItem(RepositoryItemService.java:1531)
	at com.ibm.team.repository.service.internal.RepositoryItemService.doSaveItem(RepositoryItemService.java:1332)
	at com.ibm.team.repository.service.internal.RepositoryItemService.access$13(RepositoryItemService.java:1308)
	at com.ibm.team.repository.service.internal.RepositoryItemService$20.run(RepositoryItemService.java:1302)
	at com.ibm.team.repository.service.internal.RepositoryItemService$20.run(RepositoryItemService.java:1)
	at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:347)
	at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runInTransaction(RepositoryDatabase.java:271)
	at com.ibm.team.repository.service.internal.PrimitiveTransactionService.runInTransaction(PrimitiveTransactionService.java:96)
	at sun.reflect.GeneratedMethodAccessor146.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
	at java.lang.reflect.Method.invoke(Method.java:611)
	at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
	at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
	at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
	at com.sun.proxy.$Proxy160.runInTransaction(Unknown Source)
	at com.ibm.team.repository.service.internal.RepositoryItemService.saveItem(RepositoryItemService.java:1299)
	at sun.reflect.GeneratedMethodAccessor261.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
	at java.lang.reflect.Method.invoke(Method.java:611)
	at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
	at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
	at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
	at com.sun.proxy.$Proxy233.saveItem(Unknown Source)
	at com.ibm.team.repository.service.internal.ComponentRepositoryItemService.saveItem(ComponentRepositoryItemService.java:659)
	at com.ibm.team.build.internal.service.AbstractTeamBuildService$6.run(AbstractTeamBuildService.java:1749)
	at com.ibm.team.build.internal.service.AbstractTeamBuildService.runAsRetryable(AbstractTeamBuildService.java:417)
	at com.ibm.team.build.internal.service.AbstractTeamBuildService.runAsRetryable(AbstractTeamBuildService.java:331)
	at com.ibm.team.build.internal.service.AbstractTeamBuildService.saveWithoutProcess(AbstractTeamBuildService.java:1746)
	at com.ibm.team.build.internal.service.AbstractTeamBuildService$21$1.run(AbstractTeamBuildService.java:2555)
	at com.ibm.team.repository.service.internal.PrimitiveTransactionService$3.run(PrimitiveTransactionService.java:163)
	at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:496)
	at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$1.run(RepositoryDatabase.java:320)
	at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:448)
	at sun.reflect.GeneratedMethodAccessor55.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
	at java.lang.reflect.Method.invoke(Method.java:611)
	at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
	at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
	at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
	at com.sun.proxy.$Proxy120.withCurrentConnection(Unknown Source)
	at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:316)
	at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runInTransaction(RepositoryDatabase.java:271)
	at com.ibm.team.repository.service.internal.PrimitiveTransactionService.runInTransaction(PrimitiveTransactionService.java:96)
	at com.ibm.team.repository.service.internal.PrimitiveTransactionService.runInTransaction(PrimitiveTransactionService.java:91)
	at sun.reflect.GeneratedMethodAccessor262.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
	at java.lang.reflect.Method.invoke(Method.java:611)
	at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
	at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
	at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
	at com.sun.proxy.$Proxy159.runInTransaction(Unknown Source)
	at com.ibm.team.repository.service.AbstractService.runInTransaction(AbstractService.java:967)
	at com.ibm.team.build.internal.service.AbstractTeamBuildService$21.run(AbstractTeamBuildService.java:2530)
	at com.ibm.team.build.internal.service.AbstractTeamBuildService.runAsRetryable(AbstractTeamBuildService.java:417)
	at com.ibm.team.build.internal.service.AbstractTeamBuildService.runAsRetryableIncludingStaleData(AbstractTeamBuildService.java:376)
	at com.ibm.team.build.internal.service.AbstractTeamBuildService.runAsRetryableIncludingStaleData(AbstractTeamBuildService.java:353)
	at com.ibm.team.build.internal.service.AbstractTeamBuildService.setLastContactTimeWithoutProcess(AbstractTeamBuildService.java:2527)
	at com.ibm.team.build.internal.service.TeamBuildRequestService$20.run(TeamBuildRequestService.java:1870)
	at com.ibm.team.build.internal.service.AbstractTeamBuildService.runWithoutException(AbstractTeamBuildService.java:297)
	at com.ibm.team.build.internal.service.TeamBuildRequestService.setLastContactTime(TeamBuildRequestService.java:1867)
	at com.ibm.team.build.internal.service.TeamBuildRequestService.getNextRequest(TeamBuildRequestService.java:552)
	at com.ibm.team.build.internal.service.TeamBuildRequestService.getNextRequest(TeamBuildRequestService.java:408)
	at sun.reflect.GeneratedMethodAccessor279.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
	at java.lang.reflect.Method.invoke(Method.java:611)
	at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
	at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
	at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
	at com.sun.proxy.$Proxy1075.getNextRequest(Unknown Source)
	at sun.reflect.GeneratedMethodAccessor279.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
	at java.lang.reflect.Method.invoke(Method.java:611)
	at com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleMethod(AbstractTeamServerServlet.java:1421)
	at com.ibm.team.repository.servlet.AbstractTeamServerServlet.executeMethod(AbstractTeamServerServlet.java:956)
	at com.ibm.team.repository.servlet.AbstractTeamServerServlet.doPost(AbstractTeamServerServlet.java:729)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
	at com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest2(AbstractTeamServerServlet.java:2362)
	at com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest(AbstractTeamServerServlet.java:2153)
	at com.ibm.team.repository.servlet.AbstractTeamServerServlet.access$0(AbstractTeamServerServlet.java:2138)
	at com.ibm.team.repository.servlet.AbstractTeamServerServlet$1.service(AbstractTeamServerServlet.java:219)
	at com.ibm.team.repository.internal.service.auth.impl.JAuthHandler$1.run(JAuthHandler.java:109)
	at com.ibm.team.repository.servlet.AbstractTeamServerServlet.service(AbstractTeamServerServlet.java:1792)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
	at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180)
	at org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61)
	at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:126)
	at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:76)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
	at org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:120)
	at com.ibm.team.repository.server.servletbridge.JazzServlet.service(JazzServlet.java:74)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at com.ibm.team.repository.server.servletbridge.BridgeFilter.processDelegate(BridgeFilter.java:165)
	at com.ibm.team.repository.server.servletbridge.BridgeFilter.doFilter(BridgeFilter.java:198)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:610)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
	at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:339)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:315)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
	at java.lang.Thread.run(Thread.java:761)
Caused by: com.ibm.team.repository.common.StaleDataException: CRJAZ0322I 1 row was expected but 0 rows were found for handle "com.ibm.team.build.internal.common.model.impl.BuildEngineActivityImpl@6eaf6eaf (stateId: [UUID _QbQHAB8gEeWAFbJkn363TQ], itemId: [UUID _ODKf4bu2EeKHvZ3VRjRq2A], origin: <unset>, immutable: true) (contextId: [UUID _nTXHwKc8EeKrAa2uSvBFmQ], modified: 2015-06-30 14:05:10.64, workingCopy: <unset>) (predecessor: [UUID _2rFc4hOgEeWKH5VNQykqTw]) (lastContact: 2015-06-30 14:05:06.64)".
	at com.ibm.team.repository.service.internal.dataaccess.AbstractRow.oneOrStaleData(AbstractRow.java:324)
	at com.ibm.team.repository.service.internal.dataaccess.UpdateItemCurrentRow.validateResult(UpdateItemCurrentRow.java:96)
	... 119 more
It seems like we have missing rows on Jazz tables related to the Build Engine definitions... How could we solve it without a backup restore?
Thanks in advance.

2 answers

Most liked answers ↑|Newest answers|Oldest answers

1
permanent link
Ralph Schoon (63.4k●3●36●46) | answered Jun 30 '15, 8:18 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Get in contact with support.
0
permanent link
Martha (Ruby) Andrews (3.0k●4●43●51) | answered Jun 30 '15, 3:00 p.m.
JAZZ DEVELOPER

Yes, you and Ralph are both correct. IBM Rational Support can work with you to delete the build engine. It is not going to be recoverable. You will need to create a new build engine and have it support the same build definitions as the one.

Ruby
Martha (Ruby) Andrews
Jazz Foundation L3 Development Team Lead
Comments
SEC Servizi commented Jul 01 '15, 3:21 a.m. | edited Jul 01 '15, 3:21 a.m.
 It is not going to be recoverable. You will need to create a new build engine and have it support the same build definitions as the one. 
Thanks Ruby, we will do that.
Cheers.

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.