RM Datawarehouse Collection Job failed - No project found for id

Yue Wu (2●2●3) | asked Nov 21 '13, 11:12 a.m.

Hello there,

I am encountering an issue about the data warehouse collection job for RM.

In the jts-etl.log, it is reflecting the project id is not found so the job is unable to run.

Does anyone have the similar issue or any direction i can investigate to?

What we have done is migrated the process templates and creating those RM project area using them.

Any ideas? Thanks!

2013-11-17 14:25:17,919 [WebContainer : 8 @@ 14:25 jazzadmin /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] INFO ouse.service.rrc.internal.RemoteRRCSnapshotService - Requirements Composer ETL jobs

2013-11-17 14:25:17,920 [WebContainer : 8 @@ 14:25 jazzadmin /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] INFO ouse.service.rrc.internal.RemoteRRCSnapshotService - Will generate names if empty: false

2013-11-17 14:25:18,022 [WebContainer : 8 @@ 14:25 jazzadmin /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] INFO ouse.service.rrc.internal.RemoteRRCSnapshotService - App: RRC Major: 40 Minor: 40

2013-11-17 14:25:18,024 [WebContainer : 8 @@ 14:25 jazzadmin /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] INFO ouse.service.rrc.internal.RemoteRRCSnapshotService - -=LINKS=-

2013-11-17 14:25:18,501 [WebContainer : 8 @@ 14:25 jazzadmin /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] INFO house.service.rrc.internal.etlbuild.RRCLinkTypeETL - ***********Start to execute the Java ETL of com.ibm.team.datawarehouse.service.rrc.internal.etlbuild.RRCLinkTypeETL********************

2013-11-17 14:25:18,503 [WebContainer : 8 @@ 14:25 jazzadmin /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] ERROR house.service.rrc.internal.etlbuild.RRCLinkTypeETL - Name:Embeds @@ UUID:674463f286bdda362be362767d3a4312 @@ URL:https://<FQDN>/rm/types/_FzdYwkrrEeOR2YvX3vZe4Q @@ ProjectUUID:cab5293e8c6881fd4e73883ce52dd319 @@ SubjToObj:Embeds @@ ObjToSubj:Embedded In @@ Type:

2013-11-17 14:25:18,503 [WebContainer : 8 @@ 14:25 jazzadmin /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer - Preceding event: 'Getting the XDC rows' from 'RemoteRRCSnapshotService::getNextLinkTypesPage(?,?)'

2013-11-17 14:25:18,503 [WebContainer : 8 @@ 14:25 jazzadmin /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer - Preceding event: 'Link types page retrieved' from 'RemoteRRCSnapshotService::updateSnapshot(?)'

2013-11-17 14:25:18,503 [WebContainer : 8 @@ 14:25 jazzadmin /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer - Preceding event: 'Soft deleting link types' from 'RRCLinkTypeETL::execute(?,...)'

2013-11-17 14:25:18,503 [WebContainer : 8 @@ 14:25 jazzadmin /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer - Preceding event: 'Processing page results' from 'RRCLinkTypeETL::execute(?,...)'

2013-11-17 14:25:18,503 [WebContainer : 8 @@ 14:25 jazzadmin /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer - Preceding event: 'Extracting external key 2 [row]' from 'RRCLinkTypeETL::execute(?,...)'

2013-11-17 14:25:18,503 [WebContainer : 8 @@ 14:25 jazzadmin /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer - Event subject: Name:Embeds @@ UUID:674463f286bdda362be362767d3a4312 @@ URL:https://<FQDN>/rm/types/_FzdYwkrrEeOR2YvX3vZe4Q @@ ProjectUUID:cab5293e8c6881fd4e73883ce52dd319 @@ SubjToObj:Embeds @@ ObjToSubj:Embedded In @@ Type:

2013-11-17 14:25:18,503 [WebContainer : 8 @@ 14:25 jazzadmin /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer - Preceding event: 'Processing [row]' from 'RRCLinkTypeETL::execute(?,...)'

2013-11-17 14:25:18,503 [WebContainer : 8 @@ 14:25 jazzadmin /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer - Event subject: Name:Embeds @@ UUID:674463f286bdda362be362767d3a4312 @@ URL:https://<FQDN>/rm/types/_FzdYwkrrEeOR2YvX3vZe4Q @@ ProjectUUID:cab5293e8c6881fd4e73883ce52dd319 @@ SubjToObj:Embeds @@ ObjToSubj:Embedded In @@ Type:

2013-11-17 14:25:18,503 [WebContainer : 8 @@ 14:25 jazzadmin /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer - Preceding event: 'Updating project type [row]' from 'RRCLinkTypeETL::execute(?,...)'

2013-11-17 14:25:18,503 [WebContainer : 8 @@ 14:25 jazzadmin /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer - Event subject: Name:Embeds @@ UUID:674463f286bdda362be362767d3a4312 @@ URL:https://<FQDN>/rm/types/_FzdYwkrrEeOR2YvX3vZe4Q @@ ProjectUUID:cab5293e8c6881fd4e73883ce52dd319 @@ SubjToObj:Embeds @@ ObjToSubj:Embedded In @@ Type:

2013-11-17 14:25:18,503 [WebContainer : 8 @@ 14:25 jazzadmin /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer - Preceding event: 'Transforming [row]' from 'RRCLinkTypeETL::execute(?,...)'

2013-11-17 14:25:18,503 [WebContainer : 8 @@ 14:25 jazzadmin /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer - Event subject: Name:Embeds @@ UUID:674463f286bdda362be362767d3a4312 @@ URL:https://<FQDN>/rm/types/_FzdYwkrrEeOR2YvX3vZe4Q @@ ProjectUUID:cab5293e8c6881fd4e73883ce52dd319 @@ SubjToObj:Embeds @@ ObjToSubj:Embedded In @@ Type:

2013-11-17 14:25:18,503 [WebContainer : 8 @@ 14:25 jazzadmin /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer - Suspect event: 'CALL' from 'RRCLinkTypeETL::transformRecord(?, record)'

2013-11-17 14:25:18,503 [WebContainer : 8 @@ 14:25 jazzadmin /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] WARN .ibm.team.datawarehouse.service.rrc.util.ETLTracer - Event subject: name=Embeds; UUID=674463f286bdda362be362767d3a4312; datasrcId=_3KpmwUjxEeOet5jW7vkaSwRRC; extKey2=_FzdYwkrrEeOR2YvX3vZe4Q; subjToObj=Embeds; objToSubj=Embedded In; projectUUID=cab5293e8c6881fd4e73883ce52dd319; URL=https://<FQDN>/rm/types/_FzdYwkrrEeOR2YvX3vZe4Q; lookupPrjId=-1; lookupLnkTypeId=-1

2013-11-17 14:25:18,503 [WebContainer : 8 @@ 14:25 jazzadmin /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] WARN ouse.service.rrc.internal.RemoteRRCSnapshotService - com.ibm.team.datawarehouse.service.rrc.internal.etlbuild.RRCLinkTypeETL failed to complete

2013-11-17 14:25:18,503 [WebContainer : 8 @@ 14:25 jazzadmin /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] ERROR ouse.service.rrc.internal.RemoteRRCSnapshotService - !!!com.ibm.team.datawarehouse.service.rrc.internal.RemoteRRCSnapshotService has failed. Aborting all the jobs !!!

2013-11-17 14:25:18,503 [WebContainer : 8 @@ 14:25 jazzadmin /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] INFO ouse.service.rrc.internal.RemoteRRCSnapshotService - -=REQUIREMENTS=-

2013-11-17 14:25:18,505 [WebContainer : 8 @@ 14:25 jazzadmin /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] INFO ouse.service.rrc.internal.RemoteRRCSnapshotService - -=END=-

2013-11-17 14:25:18,505 [WebContainer : 8 @@ 14:25 jazzadmin /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] INFO m.ibm.team.datawarehouse.service.rrc.RRCETLMetrics - -= RRC ETL Metrics =-

2013-11-17 14:25:18,505 [WebContainer : 8 @@ 14:25 jazzadmin /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] INFO m.ibm.team.datawarehouse.service.rrc.RRCETLMetrics - Duration values are represented in seconds. The suboperations are indented according to their level.

2013-11-17 14:25:18,505 [WebContainer : 8 @@ 14:25 jazzadmin /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] INFO m.ibm.team.datawarehouse.service.rrc.RRCETLMetrics - 'Requirements Composer ETL jobs' Runs: 1 Total (s): 0.59

2013-11-17 14:25:18,505 [WebContainer : 8 @@ 14:25 jazzadmin /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] INFO m.ibm.team.datawarehouse.service.rrc.RRCETLMetrics - 'Load all RRC link types' Runs: 1 Total (s): 0.48

2013-11-17 14:25:18,505 [WebContainer : 8 @@ 14:25 jazzadmin /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] INFO m.ibm.team.datawarehouse.service.rrc.RRCETLMetrics - 'Get page - RRC link types' Runs: 1 Total (s): 0.48

2013-11-17 14:25:18,505 [WebContainer : 8 @@ 14:25 jazzadmin /jts/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] INFO m.ibm.team.datawarehouse.service.rrc.RRCETLMetrics - 'Load page - RRC link types' Runs: 1 Total (s): 0.00

2 answers

Most liked answers ↑|Newest answers|Oldest answers

0	permanent link Rafik Jaouani (5.0k●1●6) \| answered Nov 21 '13, 11:17 a.m. JAZZ DEVELOPER If you had manually run the RM job without running the Common job, that could be a cause. Also ensure the ETL User has the Jazz Admin permission.

permanent link

Yue Wu (2●2●3) | answered Nov 25 '13, 10:16 p.m.

Hi Rafik,

Thank you for your prompt reply!

I tried running the data collection job one by one by clicking the button,

it still show fail for requirement DW collection job.

I confirmed i have Jazz Admin permission for etl_user.

Any ideas will be appreciate! Thanks!

Your answer

Register or log in 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.

It's all about the answers!

Related questions

RM Datawarehouse Collection Job failed - No project found for id

2 answers

Your answer