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!

It's all about the answers!

Related questions

RM Datawarehouse Collection Job failed - No project found for id

2 answers

Your answer