CLM 5.0 Data Collection Component for registering

Eray İzgin

(116●1●17●24) Jun 26 '14, 4:07 a.m.

Hi,

I try to register "Data collection Component" application. During setup process(jts/setup), it needs to configure database(DCC DB) before DWH step. We're using MSSQL Server databases for CLM applications and but I can't find any details about database spec.(collation...) for DCC.

Is there any document related to it? I think there is no explanation on CLM 5.0 Documentation.

Thanks

0 votes

Comments

Lily Wang

Jun 26 '14, 8:13 a.m.

I don't think MSSQL is supported. You can refer to https://jazz.net/help-dev/clm/topic/com.ibm.rational.dcc.doc/topics/t_preinstall_database.html about database preparation, which only has DB2, Oracle and SQL server.

5 answers

7,750 views

0 votes

5 answers

Permanent link

Benjamin Silverman

FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER (4.1k●6●10) Jun 26 '14, 8:40 a.m.

Hi Eray,

SQL Server is supported and you can create the database the same way you do your other CLM databases. Then once you get to the setup portion for DCC, enter the connection string the same way you're used to with the other apps. We're working on the documentation updates. Hope it helps!

2 votes

Comments

Eray İzgin

Jun 26 '14, 9:31 a.m.

For RM collation is SQL_Latin1_General_CP437_CS_AS,

and DWH SQL_Latin1_General_CP1_CS_AS. For DCC Database, which collation should we use?

Eray İzgin

Jun 26 '14, 9:59 a.m.

And also I tried with CP1_CS_AS. After then, on creating tables it gives an error:

The database creation failed with an exception

com.ibm.team.repository.common.TeamRepositoryException: The database is not set to support case-sensitivity in string...

Larry McCarthy

Jun 29 '14, 2:30 p.m.

@bsilverm - Very, very glad to hear that you are working on documentation updates! The RRDI 5.0 installation documentation is ... inscrutable, to put it politely. Please, hurry!

Thanks,

Permanent link

Benjamin Silverman

FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER (4.1k●6●10) Jun 30 '14, 9:17 a.m.

Hi Eray,

That is expected. You need to contact support to obtain a patch that contains the mapping files.

1 vote

Comments

Dong Young Kim

JAZZ DEVELOPER Aug 22 '14, 8:33 p.m.

Which release will include the patch? Or where can I download the patch? I'm testing CLM 5.0.1 and encountered this problem.

Francesco Chiossi

Sep 02 '14, 6:02 a.m.

RRDI 5.0.1 GA should include the mapping files. Not sure about the current RC1.

Geoffrey Rosenthal

JAZZ DEVELOPER Sep 23 '14, 7:06 p.m.

This was NOT fixed in 5.0.1. There is still a hot fix that needs to be applied. Check the Release Notes and/or All Downloads page under the RRDI 5.0.1 release.

1 vote

Francesco Chiossi

Sep 24 '14, 4:14 a.m.

They are not in the RRDI package but can be downloaded directly from jazz.net: https://jazz.net/downloads/RRDI/releases/5.0.1?p=allDownloads see the Data Collection Component fixes section.

Permanent link

Rohit Balduwa

(945●5●11) Jun 30 '14, 12:01 a.m.

Hi Eray

I am not much sure as i have not tried, the Data Collection Component dB might use the content store collation as below:


	

	SQL_Latin1_General_CP1_CI_AS

Let me know if this helps.

Regards,
Rohit

0 votes

Comments

Eray İzgin

Jun 30 '14, 2:28 a.m.

Hi Rohit,

I tried again with SQL_Latin1_General_CP1_CS_AS and it doesn't give "case sensivity message". But it gives on dcc/web page following message:

Error 500: CRRCD4515E ETL storage does not contain any map groups.

Rohit Balduwa

Jun 30 '14, 2:50 a.m.

Hi Eray

Did you tried with SQL_Latin1_General_CP1_CIAS. Please confirm. You have mentioned SQL_Latin1_General_CP1CS_AS.

Permanent link

Eray İzgin

(116●1●17●24) Jun 30 '14, 5:23 a.m.

Hi Rohit,

Sorry for wrong and missing explanation.

Firstly, I tried with SQL_Latin1_General_CP1_CI_AS and it gave "case sensivity message" error.

Secondly, I tried with SQL_Latin1_General_CP1_CS_AS and it doesn't give the message.

--------------

But I still have problem dcc/web

Error 500: CRRCD4515E ETL storage does not contain any map groups.

Thanks

0 votes

Permanent link

Stefan Riedmüller

(47●1●3●6) Nov 11 '14, 3:17 a.m.

I have the same Problem like Eray izgin.

I also get the message: Error 500: CRRCD4515E ETL storage does not contain any map groups.

My configuration:

JTS/RTC/RM/QM on one VM with WAS and DB2

DCC on a second VM ContentDB is a derby DB and the DatawarehouseDB (DB2) is stored on first VM

What can I do to fix the Problem?

0 votes

Comments

Benjamin Silverman

FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Nov 11 '14, 9:25 a.m.

Hi Stefan,

Which version are you using? If 5.0, you need to contact support to obtain a hotfix. If you're on 5.0.1, apply the fix found on this page.

1 vote

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.

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

clm

× 7,592

administration

× 4,744

rrdi

× 403

datacollectionjobs

× 2

Question asked: Jun 26 '14, 4:07 a.m.

Question was seen: 7,750 times

Last updated: Nov 11 '14, 9:25 a.m.

CLM 5.0 Data Collection Component for registering

Comments

5 answers

7,750 views

0 votes

5 answers

Comments

Comments

Comments

Comments

Your answer

Follow this question

Question details

Related questions