RemoteRRCSnapshotService has failed. Aborting all the jobs
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.
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.