Hi All,
According to Upgrade Docs, one of the steps needed for our upgrade (from Clarity 13.3 -> 15.3), it's needed patch 14:
Supported Patch Level for Upgrade
| Upgrade Patch Level Exceptions | How to Download and Install the Patch |
---|
Patch 13.3.0.14 on the base version 13.3.0 | None | See the CA Support Download Center. |
After downloaded and tried to install, we got errors (attached is full log). There are a lot of "java" errors don't know how they can be fixed, furthermore I've just 2 errors regarding DB:
- one with DB Driver:
9/27/17 9:05 AM (ExecTask) Loading DBDriver file: /home/clarity/niku/clarity/maintenance/database/schema/driver.xml
9/27/17 9:05 AM (ExecTask) Current database version is database_20131128_0809
9/27/17 9:05 AM (ExecTask) DBDriver for database_20151008_0600
9/27/17 9:05 AM (ExecTask) Start installation of DBDriver ...
9/27/17 9:05 AM (ExecTask) Note: Foreign Keys have been disabled
9/27/17 9:05 AM (ExecTask) DBDriver failed to install!
Q: How was this file created? Why there are tables, views and procedures and this date? (file is attached).
I suppose that file including other files under /maintenance folder were created during Patch 14 installation...
- second with our custom DB trigger which is currently Disabled:
9/27/17 9:05 AM (ExecTask) Exception in thread "main" java.lang.Exception: DBDriver failed to install
9/27/17 9:05 AM (ExecTask) at com.niku.dbtools.DriverApp.installSchemaDriver(DriverApp.java:908)
9/27/17 9:05 AM (ExecTask) at com.niku.dbtools.Utilities.run(Utilities.java:1836)
9/27/17 9:05 AM (ExecTask) at com.niku.dbtools.Utilities.main(Utilities.java:954)
9/27/17 9:05 AM (ExecTask) Caused by: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-20000: Error: ORA-04080: trigger 'Z_HEN_ARCFIT_BPM_FLAG_OLD' does not exist
9/27/17 9:05 AM (ExecTask) ORA-06512: at "NIKU.CMN_ENABLE_DISABLE_SP", line 67
9/27/17 9:05 AM (ExecTask) ORA-06512: at line 1
Q: How can it be caused by trigger 'Z_HEN_ARCFIT_BPM_FLAG_OLD' when it's Disabled?
Example of other java errors:
9/27/17 9:05 AM (ExecTask) /home/clarity/niku/clarity/.setup/scripts/db.xml:1652: The following error occurred while executing this line:
9/27/17 9:05 AM (ExecTask) /home/clarity/niku/clarity/.setup/scripts/db.xml:1789: The following error occurred while executing this line:
9/27/17 9:05 AM (ExecTask) /home/clarity/niku/clarity/.setup/scripts/db.xml:527: The following error occurred while executing this line:
9/27/17 9:05 AM (ExecTask) /home/clarity/niku/clarity/.setup/scripts/db.macros.xml:44: Java returned: 1
9/27/17 9:05 AM (ExecTask) at org.apache.tools.ant.ProjectHelper.addLocationToBuildException(ProjectHelper.java:551)
9/27/17 9:05 AM (ExecTask) at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:444)
9/27/17 9:05 AM (ExecTask) at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)
9/27/17 9:05 AM (ExecTask) at com.niku.tools.taskdefs.xpath.Iter.executeTarget(Iter.java:294)
9/27/17 9:05 AM (ExecTask) at com.niku.tools.taskdefs.xpath.Iter.execute(Iter.java:189)
9/27/17 9:05 AM (ExecTask) at com.niku.tools.taskdefs.xpath.Iter.execute(Iter.java:145)
9/27/17 9:05 AM (ExecTask) at com.niku.tools.taskdefs.XPath.execute(XPath.java:419)
9/27/17 9:05 AM (ExecTask) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
9/27/17 9:05 AM (ExecTask) at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
9/27/17 9:05 AM (ExecTask) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
9/27/17 9:05 AM (ExecTask) at java.lang.reflect.Method.invoke(Method.java:606)
9/27/17 9:05 AM (ExecTask) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
9/27/17 9:05 AM (ExecTask) at org.apache.tools.ant.Task.perform(Task.java:348)
9/27/17 9:05 AM (ExecTask) at com.niku.tools.taskdefs.IfTask.execute(IfTask.java:219)
9/27/17 9:05 AM (ExecTask) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
9/27/17 9:05 AM (ExecTask) at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
9/27/17 9:05 AM (ExecTask) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja
Any help from the experts would be very appreciated.
Thanks
Matej