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

Problem to create the database on SQL Server 2008 R2

Questions
Tags
Users
Badges
Demi Goldberg
(11●5●6) May 10 '13, 2:49 a.m.

Hi

I got an error when trying to create tables:

The database creation failed with an exception
com.ibm.team.repository.common.TeamRepositoryException: The database is not set to support case-sensitivity in string comparison operations at com.ibm.team.repository.service.db.provider.CaseSensitivityValidator.checkResultSetSize
....
Which collation do I need to use in order to create tables ?

0 votes

2 answers
7,538 views
0 votes

2 answers

Permanent link
Karl Weinert
JAZZ DEVELOPER (2.0k●5●27●36) May 10 '13, 5:53 a.m.
Here's the Setting up an SQL Server database section of the 4.0.2 information center
One of the steps is to  run:
ALTER DATABASE jts COLLATE SQL_Latin1_General_CP437_CS_AS
The CS near the end is what indicates the DB should be case sensitive. (CI would indicate Case Insensitive)
I'm pretty sure that value is available from a drop down list if you are creating the database from the GUI interface.

3 votes

Comments
Josh Crawford
May 10 '13, 11:35 a.m.
I think Karl's answer is the most plausible.  But I've also seen this exception when the JDBC connection string in the teamserver.properties file is incorrect.   For example: using: //<host>:<port>;JTS=jts;<user>=name;password={password} instead of: //<host>:<port>;databaseName=jts;user=<name>;password={password}

Permanent link
Krzysztof Kaźmierczyk
(7.5k●4●80●103) May 10 '13, 3:07 a.m.
Helo Demi,
Are you using Oracle? It seems that you can find your answer here: http://www-01.ibm.com/support/docview.wss?uid=swg21414012
Let me know if it helps for you.

Best regards,
Krzysztof Kazmierczyk

0 votes

Comments
Krzysztof Kaźmierczyk
May 10 '13, 6:29 a.m.
It seems that I have answered on wrong question. Anyway I will stay this post in case someone else has this issue :)

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.

Ask a question
Guidelines
FAQ
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

Question asked: May 10 '13, 2:49 a.m.

Question was seen: 7,538 times

Last updated: May 10 '13, 11:35 a.m.

Confirmation Cancel Confirm