RRC etl warn of RRCCustomAttributeETL - Attr def id not found for item id _bxLPtN7vEeKkDZZa-eUwXw, anyone can help?
Hi, in another question I asked if RRC can extract customized attribute, the anwser is String and Enum customized attribute can be extracted.
But in my RRC project area, my customized string can not be shown in RRDI ODS of requirement string extend table.
I find the following warn msg in etl.log. Can anyone help to analyse if this is the root cause and how to resolve it? Thanks very much!
2013-06-27 14:11:27,140 [http-bio-9443-exec-187 @@ 14:11 lijiajia /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSomeSnapshotData] WARN ervice.rrc.internal.etlbuild.RRCCustomAttributeETL - Attr def id not found for item id _bxLPtN7vEeKkDZZa-eUwXw
2013-06-27 14:11:27,143 [http-bio-9443-exec-187 @@ 14:11 lijiajia /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSomeSnapshotData] WARN ervice.rrc.internal.etlbuild.RRCCustomAttributeETL - Attr def id not found for item id _s2r_Id7vEeKkDZZa-eUwXw
2013-06-27 14:11:27,143 [http-bio-9443-exec-187 @@ 14:11 lijiajia /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSomeSnapshotData] WARN ervice.rrc.internal.etlbuild.RRCCustomAttributeETL - Attr def id not found for item id _s2r_Id7vEeKkDZZa-eUwXw
4 answers
Hi, it seems the Insight driver is not providing enough information about the attribute, so the ETL does not know where to store the value it receives. This might be related to a few defects we are currently investigating. Depending on the version of RM that you are using, if confirmed, a hotfix might be required.
Comments
Dear Petru,
I am using CLM 403, and when install CLM and RRDI203, I choose Chinese and English language. I have tried purify English language in English OS, there was no such warn and custimized attributes are indeed shown in ODS. So I doubt it is a g18n problem. Does your mentioned investigating defects include my problem? Thanks very much!
Thanks Petru, I am using CLM 403, and when install CLM and RRDI203, I choose Chinese and English language. I have tried purify English language in English OS, there was no such warn and custimized attributes are indeed shown in ODS. So I doubt it is a g18n problem. Does your mentioned investigating defects include my problem? Thanks very much!
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.
This is what the log says:
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
