It's all about the answers!

Ask a question

RemoteRRCSnapshotService has failed. Aborting all the jobs


Michael Thai (1124) | asked Dec 06 '12, 12:55 a.m.
edited Dec 06 '12, 12:56 a.m.
The requirement ETL job is failing.  Receiving warnings and errors in the jts-etl.log.  Examples below

 WARN se.service.rrc.internal.etlbuild.RRCRequirementETL  - Failed to insert requirement: name=; uuid=aa200f4daa97cd8d25550ec510a79043; identifier=; format=; creatorUUID=5aed904b0dc4e6dc48b14cc7f6acc159; creationtime=2012-11-06 15:15:32.609; modifTime=2012-11-06 15:15:32.609; projectUUID=dba660238271c47164cceab6c04ab293; url=https://<host>:9443/rm/resources/_t4TMtihOEeKI66WajNOezA; datasrcId=_ny8e8RyQEeK-hYEL8BjByQRRC; extKey2=_t4TMtihOEeKI66WajNOezA; reqType=; isDeleted=false; lookupOwnerId=15; lookupPrjId=2; lookupReqClassId=23; lookupReqId=695; lookupCollId=-1
2012-12-05 23:37:41,994 [              WebContainer : 3]  WARN se.service.rrc.internal.etlbuild.RRCRequirementETL  - Could not transform requirement
2012-12-05 23:37:41,998 [              WebContainer : 3]  WARN se.service.rrc.internal.etlbuild.RRCRequirementETL  - java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("RIODS"."REQUIREMENT"."NAME")

2012-12-05 23:37:41,998 [              WebContainer : 3]  WARN se.service.rrc.internal.etlbuild.RRCRequirementETL  - Failed to insert requirement: name=; uuid=4cd8d163907a64fc36e4a5456d67df82; identifier=; format=; creatorUUID=5aed904b0dc4e6dc48b14cc7f6acc159; creationtime=2012-11-06 15:15:10.635; modifTime=2012-11-06 15:15:10.635; projectUUID=dba660238271c47164cceab6c04ab293; url=https://<host>:9443/rm/resources/_qmuuQChOEeKI66WajNOezA; datasrcId=_ny8e8RyQEeK-hYEL8BjByQRRC; extKey2=_qmuuQChOEeKI66WajNOezA; reqType=; isDeleted=false; lookupOwnerId=15; lookupPrjId=2; lookupReqClassId=23; lookupReqId=695; lookupCollId=-1
2012-12-05 23:37:41,998 [              WebContainer : 3]  WARN se.service.rrc.internal.etlbuild.RRCRequirementETL  - Could not transform requirement
2012-12-05 23:37:41,998 [              WebContainer : 3]  WARN se.service.rrc.internal.etlbuild.RRCRequirementETL  - Failure threshold 20 exceeded
2012-12-05 23:37:41,998 [              WebContainer : 3] ERROR se.service.rrc.internal.etlbuild.RRCRequirementETL  - java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("RIODS"."REQUIREMENT"."NAME")

2012-12-05 23:37:41,998 [              WebContainer : 3]  WARN se.service.rrc.internal.etlbuild.RRCRequirementETL  - Last known operation: Transforming [row]
2012-12-05 23:37:41,998 [              WebContainer : 3]  WARN se.service.rrc.internal.etlbuild.RRCRequirementETL  - Operation target: Name: @@ UUID:4cd8d163907a64fc36e4a5456d67df82 @@ Identifier: @@ Format: @@ TypeName: @@ CreatorUUID:5aed904b0dc4e6dc48b14cc7f6acc159 @@ CreationTime:2012-11-06 15:15:10.635 @@ ModificationTime:2012-11-06 15:15:10.635 @@ ProjectUUID:dba660238271c47164cceab6c04ab293 @@ URL:https://<host>:9443/rm/resources/_qmuuQChOEeKI66WajNOezA @@ DATASOURCE_ID:_ny8e8RyQEeK-hYEL8BjByQRRC @@ ImplementedBy: @@ ValidatedBy: @@ AffectedBy: @@ TrackedBy: @@ GenericLinkTitle: @@ GenericLinkTypeName: @@ GenericLinkTypeUUID: @@ GenericLink: @@ TypeItemId: @@ ProjectAreaUUID:dba660238271c47164cceab6c04ab293 @@ ItemId: @@ Datatype: @@ IsEnumeration: @@ IsDeleted:false @@ LiteralId: @@ LiteralName: @@ AttrName: @@ ExternalURL: @@ ExternalLabel: @@ ExternalLinkType: @@ Value:
2012-12-05 23:37:41,998 [              WebContainer : 3]  WARN ouse.service.rrc.internal.RemoteRRCSnapshotService  - com.ibm.team.datawarehouse.service.rrc.internal.etlbuild.RRCRequirementETL failed to complete
2012-12-05 23:37:41,998 [              WebContainer : 3] ERROR ouse.service.rrc.internal.RemoteRRCSnapshotService  - !!!com.ibm.team.datawarehouse.service.rrc.internal.RemoteRRCSnapshotService has failed. Aborting all the jobs !!!

Looking for suggestions.  Please help.  Thanks.

Be the first one to answer this question!


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.