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

Fulltext problem when creating tables for RTC

Hey All,

If you run into the problem fulltext search below it is most likely because your SQL server has not been setup correct. The problem is caused by the COLLATE being set wrong. Your should review the guide for setting up SQL databse and run the following command:



ALTER DATABASE jazz COLLATE SQL_Latin1_General_CP437_CS_AS
GO

Rational Jazz Team Server - Enterprise
CRJAZ1363I Loading configuration from "file:conf/jazz/teamserver.properties".
CRJAZ1365I Attempting Initial Database Connection Using
Db Name/Location: //W86671:1433;databaseName=RTC_POC;user=xxxxxxxx;password=xx
xxxxxx;
CRJAZ1364I Initial database connection successful
Db Product Name: Microsoft SQL Server
Db Product Version: 9.00.3200
Db URL: jdbc:sqlserver://W86671:1433;xopenStates=false;trustServerCertificate=
false;sendStringParametersAsUnicode=true;selectMethod=direct;responseBuffering=a
daptive;packetSize=8000;loginTimeout=15;lockTimeout=-1;lastUpdateCount=true;encr
ypt=false;disableStatementPooling=true;databaseName=RTC_POC;applicationName=Micr
osoft SQL Server JDBC Driver;
Jdbc Driver Name: Microsoft SQL Server JDBC Driver 2.0
Jdbc Driver Version: 2.0.1803.100
CRJAZ8192I: Fulltext Index Location: D:\APP\IBM\JazzTeamServer\server\workitemin
dex\fulltext_index
CRJAZ8190E: The fulltext index location property (indexLocation) should point to
an absolute directory but is currently set to 'workitemindex'
Creating the tables for the database "//W86671:1433;databaseName=RTC_POC;user=xx
xxxxxx;password=xxxxxxxx;" with indices.
The database is not set to support case-sensitivity in string comparison operati
ons
The database tables were not created.

0 votes


Be the first one to answer this question!

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

Question asked: Nov 04 '09, 3:32 a.m.

Question was seen: 3,466 times

Last updated: Nov 04 '09, 3:32 a.m.

Confirmation Cancel Confirm