AnsweredAssumed Answered

HELP - v13 Upgrade - Index Errors

Question asked by DevK on May 8, 2012
Latest reply on May 17, 2012 by DevK
Hi All,

We are in the process of upgrading from 12.0.3 to v13. We have started the upgrade but we are stuck at a point when the v12 DB is upgraded to 12.1.1. The pre-upgrade process completes successfully. However, the DB upgrade fails with the following error:
Process - table: APMASTER.xml
java.sql.SQLException: [CA Clarity][SQLServer JDBC Driver][SQLServer]The index 'APMASTER_IND_1' is dependent on column 'ADDRESS_NAME'.
The scripts that error out are:
ALTER TABLE APMASTER ALTER COLUMN ADDRESS_NAME nvarchar ( 80 ) NOT NULL

ALTER TABLE APMASTER ALTER COLUMN ADDR1 nvarchar ( 80 ) NULL

ALTER TABLE APMASTER ALTER COLUMN ADDR2 nvarchar ( 80 ) NULL

ALTER TABLE APMASTER ALTER COLUMN ADDR3 nvarchar ( 80 ) NULL

ALTER TABLE APMASTER ALTER COLUMN ADDR4 nvarchar ( 80 ) NULL

ALTER TABLE APMASTER ALTER COLUMN ADDR5 nvarchar ( 80 ) NULL

ALTER TABLE APMASTER ALTER COLUMN ADDR6 nvarchar ( 80 ) NULL

ALTER TABLE APMASTER ALTER COLUMN ATTENTION_NAME nvarchar ( 40 ) NOT NULL

ALTER TABLE APMASTER ALTER COLUMN ATTENTION_PHONE nvarchar ( 30 ) NOT NULL

ALTER TABLE APMASTER ALTER COLUMN CONTACT_NAME nvarchar ( 40 ) NOT NULL

ALTER TABLE APMASTER ALTER COLUMN CONTACT_PHONE nvarchar ( 30 ) NOT NULL
The index is not a custom index so not sure how to solve this issue. Any help is greatly appreciated.

Thanks,
~Dev

EDIT:-
Current:- CA Clarity 12.0.3, SQL Server 2005, Windows 2003
Upgrade: - v13, SQL Server 2008 R2, Windows 2008 64 bit

Outcomes