AnsweredAssumed Answered

Clarity upgrade 12.1.3 with patch 3 to 13.1

Question asked by ravindra07 on Mar 19, 2014
Latest reply on Mar 31, 2014 by jadhavvinod123

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 with patch 3

3-12.1.3 patch3-->13.1.0

4-13.1.0-->13.2.0

5-13.2.0-->13.3

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

Any suggestions on the below error message much appreciated.

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

........................................................................................................................................................................................................

3/19/14 4:04 PM (ExecTask)        at com.niku.dbtools.DriverApp.apply(DriverApp.java:1486)

3/19/14 4:04 PM (ExecTask)        at com.niku.dbtools.DriverApp.installSchemaDriver(DriverApp.java:706)

3/19/14 4:04 PM (ExecTask)        at com.niku.dbtools.Utilities.run(Utilities.java:1600)

3/19/14 4:04 PM (ExecTask)        at com.niku.dbtools.Utilities.main(Utilities.java:738)

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

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

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

3/19/14 4:04 PM (ExecTask) DROP INDEX SRM_RESOURCES_N6A

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

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

3/19/14 4:04 PM (ExecTask) DROP INDEX SRM_RESOURCES_N2';

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

3/19/14 4:04 PM (ExecTask) ALTER TABLE SRM_RESOURCES MODIFY LAST_NAME VARCHAR ( 96 )';

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

3/19/14 4:04 PM (ExecTask) CREATE INDEX SRM_RESOURCES_N2 ON SRM_RESOURCES ( NLS_UPPER("LAST_NAME") ) TABLESPACE CLAX';

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

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

3/19/14 4:04 PM (ExecTask) ALTER TABLE SRM_RESOURCES MODIFY FIRST_NAME VARCHAR ( 96 )

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

3/19/14 4:04 PM (ExecTask) ALTER TABLE SRM_RESOURCES MODIFY MIDDLE_NAME VARCHAR ( 96 )

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

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

3/19/14 4:04 PM (ExecTask) DROP INDEX SRM_RESOURCES_U1A';

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

3/19/14 4:04 PM (ExecTask) ALTER TABLE SRM_RESOURCES MODIFY UNIQUE_NAME VARCHAR ( 96 )';

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

3/19/14 4:04 PM (ExecTask) CREATE INDEX SRM_RESOURCES_U1A ON SRM_RESOURCES ( NLS_UPPER("UNIQUE_NAME") ) TABLESPACE CLAX';

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

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

3/19/14 4:04 PM (ExecTask) ALTER TABLE SRM_RESOURCES MODIFY EMAIL VARCHAR ( 765 )

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

3/19/14 4:04 PM (ExecTask) ALTER TABLE SRM_RESOURCES MODIFY SMS_EMAIL VARCHAR ( 765 )

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

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

3/19/14 4:04 PM (ExecTask) DROP INDEX SRM_RESOURCES_N6A';

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

3/19/14 4:04 PM (ExecTask) ALTER TABLE SRM_RESOURCES MODIFY FULL_NAME VARCHAR ( 300 )';

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

3/19/14 4:04 PM (ExecTask) CREATE INDEX SRM_RESOURCES_N6A ON SRM_RESOURCES ( NLS_UPPER("FULL_NAME") ) TABLESPACE CLAX';

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

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

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

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

3/19/14 4:04 PM (ExecTask) ALTER TABLE SRM_RESOURCES MODIFY ENTITY_CODE VARCHAR ( 60 )

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

3/19/14 4:04 PM (ExecTask) CREATE INDEX SRM_RESOURCES_N6A ON SRM_RESOURCES ( NLS_UPPER( FULL_NAME ), USER_ID, ID ) TABLESPACE CLAX

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

3/19/14 4:04 PM (ExecTask) Note: Foreign Keys and Triggers have been enabled

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

3/19/14 4:04 PM (ExecTask) DBDriver failed to install!

Thanks in advance for your help.

Regards

Ravi

Outcomes