Skip to main content

Software  >  Rational  >  

Using SQL Server with multibyte data collation might cause data divergence in ClearQuest databases

 Flash (Alert)
 
Abstract
This flash identifies an issue that can occur in IBM Rational ClearQuest when hosted on Microsoft SQL Server. When SQL Server is using a multibyte data collation, such as Japanese collation, data corruption might occur in the ClearQuest databases.
 
Content
When hosting ClearQuest databases on SQL Server with multibyte data collation, data divergence might occur when performing administration tasks. This corrupts ClearQuest elements, including scripts and multiline text fields. This problem applies to both SQL Server 2000 and SQL Server 2005.

The observed symptoms:

  • Data divergence in a multiline fields after moving a user database using ClearQuest Designer or using the installutil command.
  • Data corruption in scripts that might cause validation errors.

This issue was investigated as a defect under APAR PK51555. However, it was determined that this problem is caused by a Microsoft MDAC defect, described in Microsoft article KB945142.

If you utilize this database hosting configuration, it is strongly recommended that you install the hotfix provided by Microsoft. You should install this hotfix on any system where you have ClearQuest installed. This includes systems with ClearQuest Designer installed.

Refer to the KB945142 article for more information on acquiring this hotfix. It is currently available for Windows 2003. Contact Microsoft Support should you require additional information about this hotfix, or if you require a download for a version of Microsoft Windows not offered in the KB article.



 BACKING UP FILES:

Always make new database back-ups of your schema repository and user databases prior to making schema changes and performing database upgrades. Failure to create back-up copies can limit your ability to recover from a an upgrade failure, design change issues or other unforeseen failures.

Do you need more help?

For additional assistance, contact IBM Rational Customer Support:
Submit a Service Request (SR)
 
 
Cross Reference information
Segment Product Component Platform Version Edition
Software DevelopmentRational ClearQuestDesigner
 
 

Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.
Rate this page
Please take a moment to complete this form to help us better serve you.
This material provides me with the information I need.




This material is clear and easy to understand.




Did the information help you to achieve your goal?
What updates, improvements, or related information would you like to see in this document?
Your response will be used to improve our document content. Requests for assistance, if applicable, should be submitted through your normal support channel as we cannot respond from this site.
Input the verification number to submit feedback:
Document information
 Product categories:
 Software
 Software Development
 Change, Configuration, & Release Management
 Rational ClearQuest
 Database Configuration/Connectivity - SQL Server
 Operating system(s):
  Windows
 Software version:
  7.0, 7.0.0.1, 7.0.0.2, 7.0.0.3, 7.0.0.4, 7.0.0.5, 7.0.0.6, 7.0.0.7, 7.0.0.8, 7.0.1, 7.0.1.1, 7.0.1.2, 7.0.1.3, 7.0.1.4, 7.0.1.5, 7.0.1.6, 7.0.1.7, 7.1, 7.1.0.1, 7.1.0.2
 Reference #:
  1398742
 IBM Group:
 Software Group
 Modified date:
 2009-09-14

Translate My Page
 
 

Rate this page

Help us improve this page. Your response will be used to improve our document content. Requests for assistance, if applicable, should be submitted through your normal support channel as we cannot respond from this site.