IBM Support

IBM Rational DOORS Next Generation: Migration failed with error

Troubleshooting


Problem

Attempts to migrate DOORS Next Generation to 6.0.1 or 6.0.2 fail with the following error: " CRJAZ2971E The length of the string attribute "concept" in class "com. ibm.team.repository.service.internal.vvc.vvcmodel.Version" increased, but there is no corresponding model evolution descriptor. CRJAZ2971E The length of the string attribute "storage" in class "com. ibm.team.repository.service.internal.vvc.vvcmodel.Version" increased, but there is no corresponding model evolution descriptor. "

Symptom

The rm addTables log contains:


CRJAZ2971E The length of the string attribute "concept" in class "com. ibm.team.repository.service.internal.vvc.vvcmodel.Version" increased, but there is no corresponding model evolution descriptor.
CRJAZ2971E The length of the string attribute "storage" in class "com. ibm.team.repository.service.internal.vvc.vvcmodel.Version" increased, but there is no corresponding model evolution descriptor."

For upgrades to version 6.0.3, the addTables log contains the following:


CRJAZ2521E An error occurred while attempting to modify the column "VERSION.CONCEPT".
CRJAZ2521E An error occurred while attempting to modify the column "VERSION.CONCEPT".
com.ibm.team.repository.common.TeamRepositoryException: CRJAZ2521E An error occurred while attempting to modify the column "VERSION.CONCEPT".
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The index 'VERSION_CONCEPT_DX' is dependent on column 'CONCEPT'.
CRJAZ1791E The migration completed with errors. The imported database is unstable and should not be used without further analysis.

Cause

Performance tuning recommendations modify the schema in a way the upgrade is not expecting. The changes must be rolled back temporarily before performing the upgrade and re-applied after the upgrade has completed.

Environment

DOORS Next Generation running on Microsoft SQL Server

Diagnosing The Problem

Check the table design for VVCMODEL.VERSION on the DNG database.

The following commands may have been executed to improve performance:

DROP INDEX VERSION_CONCEPT_DX ON VVCMODEL.VERSION
DROP INDEX VERSION_STORAGE_DX ON VVCMODEL.VERSION



ALTER TABLE VVCMODEL.VERSION ALTER COLUMN CONCEPT NVARCHAR(450) NOT NULL
ALTER TABLE VVCMODEL.VERSION ALTER COLUMN STORAGE NVARCHAR(450) NULL
                                                                        
CREATE  INDEX VERSION_CONCEPT_DX ON VVCMODEL.VERSION (CONCEPT)          
CREATE  INDEX VERSION_STORAGE_DX ON VVCMODEL.VERSION (STORAGE)

Resolving The Problem

Revert to the default field sizes (1000) on the VVCMODEL.VERSION table that were changed, they should be:

CONCEPT (nvarchar(1000), not null)
STORAGE (nvarchar(1000), null)

Execute the following commands to return the database to the expected state:

DROP INDEX VERSION_CONCEPT_DX ON VVCMODEL.VERSION
DROP INDEX VERSION_STORAGE_DX ON VVCMODEL.VERSION


ALTER TABLE VVCMODEL.VERSION ALTER COLUMN CONCEPT NVARCHAR(1000) not null

ALTER TABLE VVCMODEL.VERSION ALTER COLUMN STORAGE NVARCHAR(1000) null


CREATE  INDEX VERSION_CONCEPT_DX ON VVCMODEL.VERSION (CONCEPT)          
CREATE  INDEX VERSION_STORAGE_DX ON VVCMODEL.VERSION (STORAGE)

Once the upgrade has completed, re-apply the optimizations by running the following commands.

Note: If you are upgrading to 6.0.3 or higher, this step is not needed as it is done as part of the upgrade.




DROP INDEX VERSION_CONCEPT_DX ON VVCMODEL.VERSION
DROP INDEX VERSION_STORAGE_DX ON VVCMODEL.VERSION

ALTER TABLE VVCMODEL.VERSION ALTER COLUMN CONCEPT NVARCHAR(450) NOT NULL
ALTER TABLE VVCMODEL.VERSION ALTER COLUMN STORAGE NVARCHAR(450) NULL

CREATE  INDEX VERSION_CONCEPT_DX ON VVCMODEL.VERSION (CONCEPT)          
CREATE  INDEX VERSION_STORAGE_DX ON VVCMODEL.VERSION (STORAGE)

Internal Use Only

This technote was generated by Technote Kickstart 1.1.0.97 based on Rational Customer Support PMR 84498,442,000.
View the associated PMR's text via Wellspring at: http://eclient.lenexa.ibm.com:9082/DocFetcher/source/PMR/84498.442.000%20O16/03/28

[{"Product":{"code":"SSJJ9R","label":"Rational DOORS Next Generation"},"Business Unit":{"code":"BU005","label":"IoT"},"Component":"Installation","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"6.0.1;6.0.2;6.0.3","Edition":""}]

Document Information

Modified date:
01 October 2019

UID

swg21980867