AnsweredAssumed Answered

Upgrade Error

Question asked by Matt114 on Mar 28, 2014
Latest reply on Apr 2, 2014 by VasanthGeddam

 Hi All,

We are trying to Upgrade our CA Clarity PPM Applicaiton from version 12.1.0 to 13.3

When we tried to upgrade from 12.1.0 to 12.1.1, we are getting the below error.

================================================================

Process - table: IMM_INCIDENTS.xml

3/27/14 4:04 PM (ExecTask)

3/27/14 4:04 PM (ExecTask) SQL Text:

3/27/14 4:04 PM (ExecTask)

3/27/14 4:04 PM (ExecTask) DROP INDEX IMM_INCIDENTS_U1

3/27/14 4:04 PM (ExecTask)

3/27/14 4:04 PM (ExecTask) DROP INDEX IMM_INCIDENTS_N4

3/27/14 4:04 PM (ExecTask) BEGIN

3/27/14 4:04 PM (ExecTask) EXECUTE IMMEDIATE '

3/27/14 4:04 PM (ExecTask) DROP INDEX IMM_INCIDENTS_U1';

3/27/14 4:04 PM (ExecTask) EXECUTE IMMEDIATE '

3/27/14 4:04 PM (ExecTask) ALTER TABLE IMM_INCIDENTS MODIFY INCIDENT_CODE VARCHAR ( 60 )';

3/27/14 4:04 PM (ExecTask) EXECUTE IMMEDIATE '

3/27/14 4:04 PM (ExecTask) CREATE UNIQUE INDEX IMM_INCIDENTS_U1 ON IMM_INCIDENTS ( NLS_UPPER("INCIDENT_CODE") ) TABLESPACE CLAX';

3/27/14 4:04 PM (ExecTask) END;

3/27/14 4:04 PM (ExecTask) BEGIN

3/27/14 4:04 PM (ExecTask) EXECUTE IMMEDIATE '

3/27/14 4:04 PM (ExecTask) DROP INDEX IMM_INCIDENTS_N4';

3/27/14 4:04 PM (ExecTask) EXECUTE IMMEDIATE '

3/27/14 4:04 PM (ExecTask) ALTER TABLE IMM_INCIDENTS MODIFY SUBJECT VARCHAR ( 150 )';

3/27/14 4:04 PM (ExecTask) EXECUTE IMMEDIATE '

3/27/14 4:04 PM (ExecTask) CREATE INDEX IMM_INCIDENTS_N4 ON IMM_INCIDENTS ( NLS_UPPER("SUBJECT") ) TABLESPACE CLAX';

3/27/14 4:04 PM (ExecTask) END;

3/27/14 4:04 PM (ExecTask)

3/27/14 4:04 PM (ExecTask) ALTER TABLE IMM_INCIDENTS MODIFY DESCRIPTION VARCHAR ( 3000 )

3/27/14 4:04 PM (ExecTask)

3/27/14 4:04 PM (ExecTask) ALTER TABLE IMM_INCIDENTS MODIFY STATUS_CODE VARCHAR ( 30 )

3/27/14 4:04 PM (ExecTask)

3/27/14 4:04 PM (ExecTask) ALTER TABLE IMM_INCIDENTS MODIFY TYPE_CODE VARCHAR ( 30 )

3/27/14 4:04 PM (ExecTask)

3/27/14 4:04 PM (ExecTask) ALTER TABLE IMM_INCIDENTS MODIFY EXTERNAL_ID VARCHAR ( 500 )

3/27/14 4:04 PM (ExecTask)

3/27/14 4:04 PM (ExecTask) CREATE INDEX IMM_INCIDENTS_N4 ON IMM_INCIDENTS ( NLS_UPPER(SUBJECT) ) TABLESPACE CLAX

3/27/14 4:04 PM (ExecTask)

3/27/14 4:04 PM (ExecTask) CREATE UNIQUE INDEX IMM_INCIDENTS_U1 ON IMM_INCIDENTS ( NLS_UPPER(INCIDENT_CODE) ) TABLESPACE CLAX

3/27/14 4:04 PM (ExecTask)

3/27/14 4:04 PM (ExecTask) com.ca.clarity.jdbc.oraclebase.ddc: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01418: specified index does not exist

3/27/14 4:04 PM (ExecTask) ORA-06512: at line 2

3/27/14 4:04 PM (ExecTask)

3/27/14 4:04 PM (ExecTask)        at com.ca.clarity.jdbc.oraclebase.ddej.j(Unknown Source)

3/27/14 4:04 PM (ExecTask)        at com.ca.clarity.jdbc.oraclebase.ddej.a(Unknown Source)

3/27/14 4:04 PM (ExecTask)        at com.ca.clarity.jdbc.oraclebase.ddej.executeBatch(Unknown Source)

===========================================================================

 

We tried several possible upgrade paths given below.

  1. 12.1.0 -> 12.1.1 -> 12.1.3 -> patch 3 -> 13.1
  2. 12.1.0 -> 12.1.1 -> 12.1.3 -> patch 6 -> 13.2

We are unable to get past this issue. (In each iteration and upgrade we are face with the above issue)

We have verified that the indexes exist before upgrade process.

Is the upgrade process trying to delete/drop the index and then attempt to access it ?

Any idea on how to resolve this issue, I am also attaching the XML file for the reference.

Regards,

Mathan

Outcomes