Hi! I'm sorry for intruding your post, but I think I may be going to something similar. I'm using RTC 4.0.3 and when I start the collection jobs, the requirement job fails.
INFO ouse.service.rrc.internal.RemoteRRCSnapshotService - Load all RRC link types
INFO house.service.rrc.internal.etlbuild.RRCLinkTypeETL - ***********Start to execute the Java ETL of com.ibm.team.datawarehouse.service.rrc.internal.etlbuild.RRCLinkTypeETL********************
WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL - No project found for id a73d40fe67b19f7b1ef5f7f6e9123c97
ERROR house.service.rrc.internal.etlbuild.RRCLinkTypeETL - Could not transform link type Embeds
ERROR house.service.rrc.internal.etlbuild.RRCLinkTypeETL - Name:Embeds @@ UUID:c2edd236b93a623c49f5f2e080e52f57 @@ URL:https://servidor-rtc:9443/rm/types/_TCdrG81HEeKkseNwsBCG5A @@ ProjectUUID:a73d40fe67b19f7b1ef5f7f6e9123c97 @@ SubjToObj:Embeds @@ ObjToSubj:Embedded In @@ Type:
WARN house.service.rrc.internal.etlbuild.RRCLinkTypeETL - Failure threshold 0 exceeded
ERROR house.service.rrc.internal.etlbuild.RRCLinkTypeETL - java.sql.SQLException
WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer - Preceding event: 'Extracting external key 2 [row]' from 'RRCLinkTypeETL::execute(?,...)'
WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer - Event subject: Name:Derives @@ UUID:12e10e38c40d854a8c1be1fdd9518e83 @@ URL:https://servidor-rtc:9443/rm/types/_FQMY1dz8EeK1bK7lSlayqw @@ ProjectUUID:3a077bb298da75e6c63fbc934388cc75 @@ SubjToObj:Derives @@ ObjToSubj:Derives From @@ Type:
WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer - Preceding event: 'Processing [row]' from 'RRCLinkTypeETL::execute(?,...)'
WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer - Event subject: Name:Derives @@ UUID:12e10e38c40d854a8c1be1fdd9518e83 @@ URL:https://servidor-rtc:9443/rm/types/_FQMY1dz8EeK1bK7lSlayqw @@ ProjectUUID:3a077bb298da75e6c63fbc934388cc75 @@ SubjToObj:Derives @@ ObjToSubj:Derives From @@ Type:
WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer - Preceding event: 'Transforming [row]' from 'RRCLinkTypeETL::execute(?,...)'
WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer - Event subject: Name:Derives @@ UUID:12e10e38c40d854a8c1be1fdd9518e83 @@ URL:https://servidor-rtc:9443/rm/types/_FQMY1dz8EeK1bK7lSlayqw @@ ProjectUUID:3a077bb298da75e6c63fbc934388cc75 @@ SubjToObj:Derives @@ ObjToSubj:Derives From @@ Type:
WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer - Preceding event: 'CALL' from 'RRCLinkTypeETL::transformRecord(?, record)'
WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer - Event subject: name=Embeds; UUID=c2edd236b93a623c49f5f2e080e52f57; datasrcId=_Uthwp8efEeKcX-Pw3TFwRARRC; extKey2=_TCdrG81HEeKkseNwsBCG5A; subjToObj=Embeds; objToSubj=Embedded In; projectUUID=a73d40fe67b19f7b1ef5f7f6e9123c97; URL=https://servidor-rtc:9443/rm/types/_TCdrG81HEeKkseNwsBCG5A; lookupPrjId=5; lookupLnkTypeId=15
WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer - Preceding event: 'CALL' from 'RRCLinkTypeETL::loadRecordIntoDW(?, record)'
WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer - Event subject: name=Embeds; UUID=c2edd236b93a623c49f5f2e080e52f57; datasrcId=_Uthwp8efEeKcX-Pw3TFwRARRC; extKey2=_TCdrG81HEeKkseNwsBCG5A; subjToObj=Embeds; objToSubj=Embedded In; projectUUID=a73d40fe67b19f7b1ef5f7f6e9123c97; URL=https://servidor-rtc:9443/rm/types/_TCdrG81HEeKkseNwsBCG5A; lookupPrjId=5; lookupLnkTypeId=15
WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer - Preceding event: 'Extracting external key 2 [row]' from 'RRCLinkTypeETL::execute(?,...)'
WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer - Event subject: Name:Embeds @@ UUID:c2edd236b93a623c49f5f2e080e52f57 @@ URL:https://servidor-rtc:9443/rm/types/_TCdrG81HEeKkseNwsBCG5A @@ ProjectUUID:a73d40fe67b19f7b1ef5f7f6e9123c97 @@ SubjToObj:Embeds @@ ObjToSubj:Embedded In @@ Type:
WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer - Preceding event: 'Processing [row]' from 'RRCLinkTypeETL::execute(?,...)'
WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer - Event subject: Name:Embeds @@ UUID:c2edd236b93a623c49f5f2e080e52f57 @@ URL:https://servidor-rtc:9443/rm/types/_TCdrG81HEeKkseNwsBCG5A @@ ProjectUUID:a73d40fe67b19f7b1ef5f7f6e9123c97 @@ SubjToObj:Embeds @@ ObjToSubj:Embedded In @@ Type:
WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer - Preceding event: 'Updating project type [row]' from 'RRCLinkTypeETL::execute(?,...)'
WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer - Event subject: Name:Embeds @@ UUID:c2edd236b93a623c49f5f2e080e52f57 @@ URL:https://servidor-rtc:9443/rm/types/_TCdrG81HEeKkseNwsBCG5A @@ ProjectUUID:a73d40fe67b19f7b1ef5f7f6e9123c97 @@ SubjToObj:Embeds @@ ObjToSubj:Embedded In @@ Type:
WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer - Preceding event: 'Transforming [row]' from 'RRCLinkTypeETL::execute(?,...)'
WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer - Event subject: Name:Embeds @@ UUID:c2edd236b93a623c49f5f2e080e52f57 @@ URL:https://servidor-rtc:9443/rm/types/_TCdrG81HEeKkseNwsBCG5A @@ ProjectUUID:a73d40fe67b19f7b1ef5f7f6e9123c97 @@ SubjToObj:Embeds @@ ObjToSubj:Embedded In @@ Type:
WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer - Suspect event: 'CALL' from 'RRCLinkTypeETL::transformRecord(?, record)'
WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer - Event subject: name=Embeds; UUID=c2edd236b93a623c49f5f2e080e52f57; datasrcId=_Uthwp8efEeKcX-Pw3TFwRARRC; extKey2=_TCdrG81HEeKkseNwsBCG5A; subjToObj=Embeds; objToSubj=Embedded In; projectUUID=a73d40fe67b19f7b1ef5f7f6e9123c97; URL=https://servidor-rtc:9443/rm/types/_TCdrG81HEeKkseNwsBCG5A; lookupPrjId=5; lookupLnkTypeId=15
WARN ouse.service.rrc.internal.RemoteRRCSnapshotService - com.ibm.team.datawarehouse.service.rrc.internal.etlbuild.RRCLinkTypeETL failed to complete
ERROR ouse.service.rrc.internal.RemoteRRCSnapshotService - !!!com.ibm.team.datawarehouse.service.rrc.internal.RemoteRRCSnapshotService has failed. Aborting all the jobs !!!
INFO ouse.service.rrc.internal.RemoteRRCSnapshotService - -=REQUIREMENTS=-
INFO ouse.service.rrc.internal.RemoteRRCSnapshotService - End of loading requirements
Thank you