It's all about the answers!

Ask a question

[Solved]:Insight1.1.1: RTC_WorkitemDimensions ETL job fails


Timur Markunin (6495160144) | asked Sep 12 '12, 8:37 a.m.
edited Sep 13 '12, 4:34 a.m.
Hello,
I'm trying to integrate Insight1.1.1 and CLM4. (Windows Server 8 R2 64-bit)
During execution of OOTBE2E job in DataManager I've received following error:
Exception in thread "main" java.sql.SQLException: com.ibm.rational.etl.common.exception.ETLException: com.ibm.rational.etl.common.exception.ETLException: com.ibm.rational.dataservices.client.auth.AuthenticationException: CRRRE1417E: The HTTP status '401' and the message is 'Unauthorized'.

Any ideas?

Job_RTC_Workitem log:
run context:
JobStream 'OOTBE2E'
    JobStream 'CLM4.0_All'
        JobStream 'RTC_ODS4.0_DeltaLoad'
            JobStream 'RTC_ODS4.0'
                JobStream 'RTC_Workitem4.0'

[PROGRESS   - 13:50:49] JobStream 'RTC_Workitem4.0'; starting
[PROGRESS   - 13:50:49] Procedure Node 8 'Init'; executing (inline)
[PROGRESS   - 13:50:51] Procedure Node 8 'Init'; succeeded
[PROGRESS   - 13:50:51] Condition Node 9 'More'; executing (inline)
[PROGRESS   - 13:50:51] Condition Node 9 'More'; succeeded (TRUE)
[PROGRESS   - 13:50:51] Procedure Node 11 'Prepare'; executing (inline)
[PROGRESS   - 13:50:51] Procedure Node 11 'Prepare'; succeeded
[PROGRESS   - 13:50:51] Condition Node 29 'MigrationRequired'; executing (inline)
[PROGRESS   - 13:50:52] Condition Node 29 'MigrationRequired'; succeeded (FALSE)
[PROGRESS   - 13:50:52] JobStream Node 18 'RTC_WorkitemDimensions'; executing (pid 5548)
[PROGRESS   - 13:51:24] JobStream Node 18 'RTC_WorkitemDimensions'; succeeded
[PROGRESS   - 13:51:24] Build Node 26 'RTC_Workitem3.0.1.2'; executing (pid 2460)
[PROGRESS   - 13:51:29] Build Node 26 'RTC_Workitem3.0.1.2'; succeeded
[PROGRESS   - 13:51:30] Build Node 17 'RTC_WorkitemHierarchy3.0.1.2'; executing (pid 5640)
[PROGRESS   - 13:51:34] Build Node 17 'RTC_WorkitemHierarchy3.0.1.2'; succeeded
[PROGRESS   - 13:51:35] Build Node 25 'RTC_WorkitemReverseHierarchy3'; executing (pid 4612)
[PROGRESS   - 13:51:39] Build Node 25 'RTC_WorkitemReverseHierarchy3'; succeeded
[PROGRESS   - 13:51:40] JobStream Node 28 'RTC_WorkitemHistory3.0.1.2'; executing (pid 6100)
[PROGRESS   - 13:51:53] JobStream Node 28 'RTC_WorkitemHistory3.0.1.2'; succeeded
[PROGRESS   - 13:51:54] JobStream Node 19 'RTC_WorkitemCustomAttribute'; executing (pid 3892)
[PROGRESS   - 13:52:05] JobStream Node 19 'RTC_WorkitemCustomAttribute'; succeeded
[PROGRESS   - 13:52:06] Build Node 24 'RTC_WorkitemLink3'; executing (pid 5412)
[PROGRESS   - 13:52:10] Build Node 24 'RTC_WorkitemLink3'; succeeded
[PROGRESS   - 13:52:11] Build Node 21 'RTC_DeletedWorkitem3'; executing (pid 6128)
[PROGRESS   - 13:52:14] Build Node 21 'RTC_DeletedWorkitem3'; succeeded
[PROGRESS   - 13:52:14] Build Node 22 'RTC_DeletedWorkitemHistory3'; executing (pid 6004)
[PROGRESS   - 13:52:18] Build Node 22 'RTC_DeletedWorkitemHistory3'; succeeded
[PROGRESS   - 13:52:18] Build Node 23 'RTC_DeletedLink3'; executing (pid 1944)
[PROGRESS   - 13:52:22] Build Node 23 'RTC_DeletedLink3'; succeeded
[PROGRESS   - 13:52:22] Procedure Node 12 'Finish'; executing (inline)
[PROGRESS   - 13:52:22] Procedure Node 12 'Finish'; succeeded
[PROGRESS   - 13:52:22] Condition Node 9 'More'; executing (inline)
[PROGRESS   - 13:52:22] Condition Node 9 'More'; succeeded (TRUE)
[PROGRESS   - 13:52:22] Procedure Node 11 'Prepare'; executing (inline)
[PROGRESS   - 13:52:22] Procedure Node 11 'Prepare'; succeeded
[PROGRESS   - 13:52:22] Condition Node 29 'MigrationRequired'; executing (inline)
[PROGRESS   - 13:52:22] Condition Node 29 'MigrationRequired'; succeeded (FALSE)
[PROGRESS   - 13:52:23] JobStream Node 18 'RTC_WorkitemDimensions'; executing (pid 3632)
[PROGRESS   - 13:53:09] pid 3632 JobStream Node 18 'RTC_WorkitemDimensions'; reported the following:

(for details, see ..\datamanager\log\Job_RTC_WorkitemDimensions_0004.log)

[PROGRESS   - 13:53:09] JobStream Node 18 'RTC_WorkitemDimensions'; failed

Comments
Timur Markunin commented Sep 13 '12, 3:19 a.m.

It looks like the root cause of the error is incorrect xdc file (workitem3012.xdc). I have downloaded this file from CLM4 server https://server:9443/ccm/admin#action=com.ibm.team.reportsManagement.reportDownloads

Test for resource group WORKITEM_CCM passed but for WORKITEM_QM returns "Unauthorized" error.

Accepted answer


permanent link
Rafik Jaouani (5.0k16) | answered Sep 13 '12, 4:17 p.m.
JAZZ DEVELOPER
The OAuth JTS authentication type is there for use by the built-in Java ETL. Please use one of the other authentication types that use a real user and password. You can also make the OAuth JTS authentication type work but make sure you set the values for consumer key and consumer secret to those that are defined in QM. Currently they get set to the values stored in the APP from which you downloaded the XDC file.

You can try downloading the XDC file from QM and copy the values of consumer key and consumer secret to the XDC file you got from RTC.
Timur Markunin selected this answer as the correct answer

One other answer



permanent link
Timur Markunin (6495160144) | answered Sep 13 '12, 4:34 a.m.
It looks like the root cause of the error is incorrect xdc file (workitem3012.xdc). I have downloaded this file from CLM4 server https://server:9443/ccm/admin#action=com.ibm.team.reportsManagement.reportDownloads Test for resource group WORKITEM_CCM passed but for WORKITEM_QM returns "Unauthorized" error.

Your answer


Register or to post your answer.