Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Data Collection Component CLM 6.0

 Hi

Is there any guide on how to enable the Data Collection component in CLM 6.0? If you want to view Data collection jobs, then JAZZ takes you to /dcc, and the setup of Resource Group Configuration needs to be done. Is there any guide for this for e.g. what DB details/username/password do you use for the setup of "A Relational Database DataSource". 

Thanks

Leesen

0 votes



5 answers

Permanent link
 Hi Leesen,

Please find the link below and let me know does it helps.

http://www-01.ibm.com/support/knowledgecenter/SSYMRC_6.0.0/com.ibm.rational.dcc.doc/topics/t_roadmap_dcc.html?lang=en

http://www-01.ibm.com/support/knowledgecenter/SSYMRC_6.0.0/com.ibm.team.jp.jrs.doc/topics/t_jrs_mng_ds.html?lang=en

Regards,
Arun.

0 votes


Permanent link
 Hi Arun

Thanks for the links. Just a quick question:

When setting up the Rational Reporting Data Warehouse Database: it says this is a special resource group which is the data warehouse. So I assume that I will need to use the "dw" database details that were created by the DBA's before the setup? I have done this as seen below: 

  • Relational Database Type: SQL Server 
  • URL //03RNB-MerganTestSrv01.za.ds.naspers.com:59129; databaseName=dw;integratedSecurity=true
  • For the User name and Password, I used the data warehouse DB credentials that were created by DBA
  • For the Version, Version 6
But I get this error:


Failed to connect to the resource group
hide details
Error 500: CRRCD4506E A JDBC connection could not be created for the database at jdbc:sqlserver://03RNB-MerganTestSrv01.za.ds.naspers.com:59129;databaseName=dw;integratedSecurity=true. The error occurs at A Relational Database DataSource
This driver is not configured for integrated authentication. ClientConnectionId:60386432-75a9-41bf-b180-b7d843d4f590.

Thanks

Leesen

0 votes


Permanent link
  Hi Lessen,

I think it could be one of the below reason.

1) I wonder if the problem its connected to the right database and connection string.

2) Could you please check the authentication details.

3) Can you check the configuration in dcc/web -> Data Warehouse Connection, as well as in Resource Group Configuration -> "Rational Reporting Data Warehouse Database"?  This invalid connection must be defined somewhere there.

Regards,
Arun.

0 votes


Permanent link
 Hi Arun

When I test the connection in dcc/web -> Data Warehouse Connection, it passes. But when I use the same dw details for Resource Group Configuration -> "Rational Reporting Data Warehouse Database" thats when I get the error.

Is this the right format for an SQL Server URL for the "Rational Reporting Data Warehouse Database"  :

//03RNB-MerganTestSrv01.za.ds.naspers.com:59129; databaseName=dw;integratedSecurity=true


0 votes

Comments

 Hi Leesen,


Could you please verify the below details.


  • Use  netstat -a  to check whether sql server is listening on the desired port
  • Try to do the  telnet  on the host and port
  • Verify the SQL Server Configuration Manager, and then  SQL Server 2012 Network Configuration.

  • Regards,
    Arun.


    Permanent link

    I am encountering the same error (Error 500: CRRCD4506E A JDBC connection could not be created for the database...The error occurs at A Relational Database DataSource). Need help!!!

     
    - It was a working setup.
    - Server never restarted.
    - Nothing changed to my knowledge.
    - Verified that the DB connection string is valid, DB is reachable for other apps and everything looks good in the Jazz Team Server properties page. However; the JDBC Vendor and JDBC Location field values have gone missing in DCC due to unknown reasons. I am not able to add the values back after clicking on edit since the fields doesn't let me key in the values.

    Thanks in advance.
    Aljo George

    0 votes

    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.

    Search context
    Follow this question

    By Email: 

    Once you sign in you will be able to subscribe for any updates here.

    By RSS:

    Answers
    Answers and Comments
    Question details
    × 7,495
    × 1,700

    Question asked: Jul 28 '15, 8:33 a.m.

    Question was seen: 5,034 times

    Last updated: Jun 26 '20, 2:58 a.m.

    Confirmation Cancel Confirm