RRC_ODS3.0 ETL job doesn't transfer any data to DW

You can ignore log4j warnings. If the DW tables are empty: did you run
the JFS jobs first? You need to run the jobs in CLMJobs even if you only
use RRC. RRC still depends on the foundation jobs. Check the DM logs for
hints for what went wrong.

The official instructions to follow are:
http://publib.boulder.ibm.com/infocenter/rentrpt/v1r0m1/topic/com.ibm.rational.raer.integration.doc/topics/t_integrate_clm.html

Hope this helps,
Peter Haumer.


On 9/21/2011 9:23 AM, timur.markunin wrote:

Hi,

I'm trying to integrate CLM3 and Insight.
I've imported CLM package into DataManager as described in wiki
https://jazz.net/wiki/bin/view/Main/CALMReportingSetupSteps and
started RRC_ODS3.0 job. There were a lot of warnings:
log4j:WARN No appenders could be found for logger
(org.apache.http.impl.conn.tsccm.ThreadSafeClientConnManager).
log4j:WARN Please initialize the log4j system properly.

Datawarehouse tables are empty. How could I found the root problem?

-thanks in advance

Thanks Peter!

I use this official instructions and wiki.

I've following error during JFS_ODS3.0_DeltaLoad execution:

Exception in thread "main" java.sql.SQLException: com.ibm.rational.etl.common.ex
ception.ETLException: com.ibm.rational.etl.common.exception.ETLException: com.ibm.rational.dataservices.client.auth.AuthenticationException: CRRRE1405E: The '404' HTTP status code is not expected.

I've tested JFS (ODBC) connection in Data Manager. It works.
I've added "/" to jfs resource group URLs in jfs301.xdc using XML Data Configuration so they look like:

https://server name:9443/jts/
https://server name:9443/ccm/
https://server name:9443/qm/

Any ideas?

-thanks in advance

Timur

This looks like an authentication problem. Before you downloaded the xdc
files, was a data collection user filled into each apps Reports admin
page? Is that user jazzadmin and has the Data Collector license? Did you
modify the xdc file in any way after download? The authentication type
in the xdc file needs to stay as generated by the server (Form for all
apps, except RRC uses OAuth).

Peter.

CLM setup has created dw_user in each CLM app. It has JazzAdmins rights and Data Collector license assigned.

I've added "/" to jfs resource group URLs in jfs301.xdc using XML Data Configuration so they look like:

https://server name:9443/jts/
https://server name:9443/ccm/
https://server name:9443/qm/

-Timur