ravindra07

Clarity 12.1.3 to 13.2 upgrade

Discussion created by ravindra07 on Mar 25, 2014
Latest reply on Mar 26, 2014 by Chris_Hackett

We are in process to upgrade clarity from 12.1.0 to 13.3 and following the below paths.

1-12.1.0-->12.1.1

2-12.1.1-->12.1.3

3-12.1.3 patch6-->13.2.0

4-13.2.0-->13.3

At present we are performing the third step 12.1.3 patch6-->13.2 and getting below error message during database upgrade step.

Any suggestions on the below error message much appreciated.

 

3/25/14 6:23 PM (ExecTask) Process - table: INV_APPLICATIONS.xml

3/25/14 6:23 PM (ExecTask) Process - table: IMM_INCIDENTS.xml
3/25/14 6:23 PM (ExecTask) 
3/25/14 6:23 PM (ExecTask) SQL Text:
3/25/14 6:23 PM (ExecTask) 
3/25/14 6:23 PM (ExecTask) DROP INDEX IMM_INCIDENTS_U1
3/25/14 6:23 PM (ExecTask) 
3/25/14 6:23 PM (ExecTask) DROP INDEX IMM_INCIDENTS_N4
3/25/14 6:23 PM (ExecTask) BEGIN
3/25/14 6:23 PM (ExecTask) EXECUTE IMMEDIATE '
3/25/14 6:23 PM (ExecTask) DROP INDEX IMM_INCIDENTS_U1';
3/25/14 6:23 PM (ExecTask) EXECUTE IMMEDIATE '
3/25/14 6:23 PM (ExecTask) ALTER TABLE IMM_INCIDENTS MODIFY INCIDENT_CODE VARCHAR ( 60 )';
3/25/14 6:23 PM (ExecTask) EXECUTE IMMEDIATE '
3/25/14 6:23 PM (ExecTask) CREATE UNIQUE INDEX IMM_INCIDENTS_U1 ON IMM_INCIDENTS ( NLS_UPPER("INCIDENT_CODE") ) TABLESPACE CLAX';
3/25/14 6:23 PM (ExecTask) END;
3/25/14 6:23 PM (ExecTask) BEGIN
3/25/14 6:23 PM (ExecTask) EXECUTE IMMEDIATE '
3/25/14 6:23 PM (ExecTask) DROP INDEX IMM_INCIDENTS_N4';
3/25/14 6:23 PM (ExecTask) EXECUTE IMMEDIATE '
3/25/14 6:23 PM (ExecTask) ALTER TABLE IMM_INCIDENTS MODIFY SUBJECT VARCHAR ( 150 )';
3/25/14 6:23 PM (ExecTask) EXECUTE IMMEDIATE '
3/25/14 6:23 PM (ExecTask) CREATE INDEX IMM_INCIDENTS_N4 ON IMM_INCIDENTS ( NLS_UPPER("SUBJECT") ) TABLESPACE CLAX';
3/25/14 6:23 PM (ExecTask) END;
3/25/14 6:23 PM (ExecTask) 
3/25/14 6:23 PM (ExecTask) ALTER TABLE IMM_INCIDENTS MODIFY DESCRIPTION VARCHAR ( 3000 )
3/25/14 6:23 PM (ExecTask) 
3/25/14 6:23 PM (ExecTask) ALTER TABLE IMM_INCIDENTS MODIFY STATUS_CODE VARCHAR ( 30 )
3/25/14 6:23 PM (ExecTask) 
3/25/14 6:23 PM (ExecTask) ALTER TABLE IMM_INCIDENTS MODIFY TYPE_CODE VARCHAR ( 30 )
3/25/14 6:23 PM (ExecTask) 
3/25/14 6:23 PM (ExecTask) ALTER TABLE IMM_INCIDENTS MODIFY EXTERNAL_ID VARCHAR ( 500 )
3/25/14 6:23 PM (ExecTask) 
3/25/14 6:23 PM (ExecTask) CREATE INDEX IMM_INCIDENTS_N4 ON IMM_INCIDENTS ( NLS_UPPER(SUBJECT) ) TABLESPACE CLAX
3/25/14 6:23 PM (ExecTask) 
3/25/14 6:23 PM (ExecTask) CREATE UNIQUE INDEX IMM_INCIDENTS_U1 ON IMM_INCIDENTS ( NLS_UPPER(INCIDENT_CODE) ) TABLESPACE CLAX
3/25/14 6:23 PM (ExecTask) 
3/25/14 6:23 PM (ExecTask) com.ca.clarity.jdbc.oraclebase.ddc: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01418: specified index does not exist
3/25/14 6:23 PM (ExecTask) ORA-06512: at line 2
3/25/14 6:23 PM (ExecTask) 
3/25/14 6:23 PM (ExecTask) at com.ca.clarity.jdbc.oraclebase.ddej.j(Unknown Source)
3/25/14 6:23 PM (ExecTask) at com.ca.clarity.jdbc.oraclebase.ddej.a(Unknown Source)
3/25/14 6:23 PM (ExecTask) at com.ca.clarity.jdbc.oraclebase.ddej.executeBatch(Unknown Source)
3/25/14 6:23 PM (ExecTask) at sun.reflect.GeneratedMethodAccessor25.invoke(Unknown Source)
3/25/14 6:23 PM (ExecTask) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
3/25/14 6:23 PM (ExecTask) at java.lang.reflect.Method.invoke(Method.java:601)
3/25/14 6:23 PM (ExecTask) at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:68)
3/25/14 6:23 PM (ExecTask) at org.logicalcobwebs.cglib.proxy.Proxy$ProxyImpl$$EnhancerByCGLIB$$5b7424f8.executeBatch(<generated>)
3/25/14 6:23 PM (ExecTask) at com.niku.dbtools.Utilities.executeAndCommitSql(Utilities.java:2376)
3/25/14 6:23 PM (ExecTask) at com.niku.dbtools.DriverApp.apply(DriverApp.java:1455)
3/25/14 6:23 PM (ExecTask) at com.niku.dbtools.DriverApp.installSchemaDriver(DriverApp.java:702)
3/25/14 6:23 PM (ExecTask) at com.niku.dbtools.Utilities.run(Utilities.java:1561)
3/25/14 6:23 PM (ExecTask) at com.niku.dbtools.Utilities.main(Utilities.java:716)
3/25/14 6:23 PM (ExecTask) Note: Foreign Keys and Triggers have been enabled
3/25/14 6:23 PM (ExecTask) 
3/25/14 6:23 PM (ExecTask) DBDriver failed to install!
3/25/14 6:23 PM (ExecTask) 
3/25/14 6:23 PM (ExecTask) Total time: 0H:5M:38S
3/25/14 6:23 PM (ExecTask) Exception in thread "main" java.lang.Exception: DBDriver failed to install
3/25/14 6:23 PM (ExecTask) at com.niku.dbtools.DriverApp.installSchemaDriver(DriverApp.java:880)
3/25/14 6:23 PM (ExecTask) at com.niku.dbtools.Utilities.run(Utilities.java:1561)
3/25/14 6:23 PM (ExecTask) at com.niku.dbtools.Utilities.main(Utilities.java:716)
3/25/14 6:23 PM (ExecTask) Caused by: com.ca.clarity.jdbc.oraclebase.ddc: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01418: specified index does not exist
3/25/14 6:23 PM (ExecTask) ORA-06512: at line 2
3/25/14 6:23 PM (ExecTask) 
3/25/14 6:23 PM (ExecTask) at com.ca.clarity.jdbc.oraclebase.ddej.j(Unknown Source)
3/25/14 6:23 PM (ExecTask) at com.ca.clarity.jdbc.oraclebase.ddej.a(Unknown Source)
3/25/14 6:23 PM (ExecTask) at com.ca.clarity.jdbc.oraclebase.ddej.executeBatch(Unknown Source)
3/25/14 6:23 PM (ExecTask) at sun.reflect.GeneratedMethodAccessor25.invoke(Unknown Source)
3/25/14 6:23 PM (ExecTask) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
3/25/14 6:23 PM (ExecTask) at java.lang.reflect.Method.invoke(Method.java:601)
3/25/14 6:23 PM (ExecTask) at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:68)
3/25/14 6:23 PM (ExecTask) at org.logicalcobwebs.cglib.proxy.Proxy$ProxyImpl$$EnhancerByCGLIB$$5b7424f8.executeBatch(<generated>)
3/25/14 6:23 PM (ExecTask) at com.niku.dbtools.Utilities.executeAndCommitSql(Utilities.java:2376)
3/25/14 6:23 PM (ExecTask) at com.niku.dbtools.DriverApp.apply(DriverApp.java:1455)
3/25/14 6:23 PM (ExecTask) at com.niku.dbtools.DriverApp.installSchemaDriver(DriverApp.java:702)
 
Regards
Ravi

Outcomes