Repotools.sh is failing with message about case sensitivity
We are trying to create the database tables in a SQL Server 2005 database for RQM using Repotools.sh on a Linux box. It is failing with the following error message:
The database is not set to support case-sensitivity in string comparison operations The database tables were not created. Do we need to create th database with a case-sensitive collating sequence? If so, which of the collation sequences do we use? |
2 answers
We are trying to create the database tables in a SQL Server 2005 database for RQM using Repotools.sh on a Linux box. It is failing with the following error message: Hi Ken, I'm not a SQL guru (someone else with more expertise in this area may be able to jump in), but if you are following the RQM Documentation on "Setting up a SQL Server database" you should have run this command: ALTER DATABASE jazz COLLATE SQL_Latin1_General_CP437_ If I am not mistaken the CS (bolded above) would configure the database to support case-sensitivity. Reference: http://publib.boulder.ibm.com/infocenter/rqmhelp/v2r0/topic/com.ibm.rational.test.qm.install.doc/topics/t_s_server_installation_setup_sql.html -Patrick |
|
Thank you, Patrick. That worked like a charm. For some reason, the printed copy of the installation instructions that I had omitted this step / command.
|
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.