IBM Support

Unable to apply RequisitePro 1.10 package to a schema when code page of the database set is UTF-8

Troubleshooting


Problem

This technote identifies an issue that can occur in IBM Rational ClearQuest Designer with database sets using code page UTF-8. When attempting to add the RequisitePro 1.10 package to a schema, an error occurs.

Symptom

Attempting to apply the RequisitePro 1.10 package to a schema results in this error:

!%$Enabling of record type failed...
Unhandled Exception
!!! Discarding all changes to the latest revision of schema...
..This operation cannot proceed until the metadata has been loaded.

Cause

This issue is identified as a product defect under APAR PM06922.

Resolving The Problem

This defect is fixed starting in versions 7.1.1.4 and 7.1.2.1. These versions introduce RequisitePro package 1.11. Upgrade to the latest version to resolve this problem.

WORKAROUND

There is a workaround for this defect. However, it would require starting fresh with a new schema repository. These are the steps to workaround this issue:


  1. Create a new database set with an ASCII code page. You should still configure your vendor character set of UTF-8.
  2. Apply all the required packages (including RequisitePro 1.10) for the desired schemas.
  3. Upgrade the user database(s) with the schemas or create new user database(s) as needed.
  4. Using the Maintenance Tool, change the ClearQuest data code page for the database set to UTF-8.
  5. You can now continue your work with UTF-8 code page.


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.

[{"Product":{"code":"SSSH5A","label":"Rational ClearQuest"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Designer - Packages","Platform":[{"code":"PF033","label":"Windows"}],"Version":"7.1.1;7.1.1.1;7.1.1.2;7.1.1.3","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}},{"Product":{"code":"SSSTXH","label":"Rational Integrations"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"ClearQuest and RequisitePro","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"","label":""}},{"Product":{"code":"SSSHCT","label":"Rational RequisitePro"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Integration: ClearQuest","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
16 June 2018

UID

swg21421674