AnsweredAssumed Answered

Upgrade Help for old 12.1 Environment --> 12.1.3

Question asked by Keri Taylor on Feb 13, 2014
Latest reply on Mar 4, 2014 by Nika_Hadzhikidi

Hello, I am trying to understand the whole upgrade process, of course i have read al lthe documentation, and now am faced with some errors. Since i have never done an upgrade alone myself on an oracle box, nor ever used command line, figured i would start with something small, so I decided to play on a old environment that had 4 environments, wiped them all away to just have one unvironment. On Redhat, Tomcat 6.0.26, Oracle 11.1, Java 1.6_20, This is an old 12.1 app box, decided to give it a try, to upgrade to 12.1.3. I deactivated all custom triggers. PreUpgrade, success, however, when moving to DB install I face some errors. So either using CSA db install or nikuadmin db install i get the following errors in the admin.log file. 

2/12/14 3:47 PM (admin) As user: clarity
2/12/14 3:47 PM (admin) For vendor: oracle
2/12/14 3:47 PM (admin) Loading DBDriver file: /opt/niku/clarity/database/schema/driver.xml
2/12/14 3:47 PM (admin) Loading DBDriver file: /opt/niku/clarity/database/schema/driver.xml
2/12/14 3:47 PM (admin) Current database version is database_12.1.3_20111214
2/12/14 3:47 PM (admin) DBDriver for database_12.1.3_20111214
2/12/14 3:47 PM (admin) Resume installation of DBDriver ...
2/12/14 3:47 PM (admin) Note: Foreign Keys have been disabled
2/12/14 3:49 PM (admin) Note: Triggers have been disabled
2/12/14 3:49 PM (admin) java.lang.RuntimeException: Internal Error: String index out of range: -1
2/12/14 3:49 PM (admin) Process - table: CAL_TEMP_VIRTUAL_EVENTS.xml
2/12/14 3:49 PM (admin) at com.niku.dbtools.OracleGenerator.getFunctionIndexOnColumn(OracleGenerator.java:512)
2/12/14 3:49 PM (admin) at com.niku.dbtools.OracleGenerator.getModifyColumnDDL(OracleGenerator.java:452)
2/12/14 3:49 PM (admin) at com.niku.dbtools.AbstractGenerator.getDDL(AbstractGenerator.java:168)
2/12/14 3:49 PM (admin) at com.niku.dbtools.Utilities.generateDDL(Utilities.java:1834)
2/12/14 3:49 PM (admin) at com.niku.dbtools.DriverApp$EntryIterator.next(DriverApp.java:1714)
2/12/14 3:49 PM (admin) at com.niku.dbtools.DriverApp.installSchemaDriver(DriverApp.java:425)
2/12/14 3:49 PM (admin) at com.niku.dbtools.Utilities.run(Utilities.java:1301)
2/12/14 3:49 PM (admin) at com.niku.dbtools.Utilities.main(Utilities.java:633)
2/12/14 3:49 PM (admin) Note: Foreign Keys and Triggers have been enabled
2/12/14 3:49 PM (admin) DBDriver failed to install!
2/12/14 3:49 PM (admin) Total time: 0H:1M:31S
2/12/14 3:49 PM (admin) Exception in thread "main" java.lang.Exception: DBDriver failed to install
2/12/14 3:49 PM (admin) at com.niku.dbtools.DriverApp.installSchemaDriver(DriverApp.java:697)
2/12/14 3:49 PM (admin) at com.niku.dbtools.Utilities.run(Utilities.java:1301)
2/12/14 3:49 PM (admin) at com.niku.dbtools.Utilities.main(Utilities.java:633)
2/12/14 3:49 PM (admin) Caused by: java.lang.RuntimeException: Internal Error: String index out of range: -1
2/12/14 3:49 PM (admin) at com.niku.dbtools.OracleGenerator.getFunctionIndexOnColumn(OracleGenerator.java:512)
2/12/14 3:49 PM (admin) at com.niku.dbtools.OracleGenerator.getModifyColumnDDL(OracleGenerator.java:452)
2/12/14 3:49 PM (admin) at com.niku.dbtools.AbstractGenerator.getDDL(AbstractGenerator.java:168)
2/12/14 3:49 PM (admin) at com.niku.dbtools.Utilities.generateDDL(Utilities.java:1834)
2/12/14 3:49 PM (admin) at com.niku.dbtools.DriverApp$EntryIterator.next(DriverApp.java:1714)
2/12/14 3:49 PM (admin) at com.niku.dbtools.DriverApp.installSchemaDriver(DriverApp.java:425)
2/12/14 3:49 PM (admin) ... 2 more
Feb 12, 2014 3:49:28 PM Error executing command: db install
/opt/niku/clarity/.setup/scripts/db.xml:218: The following error occurred while executing this line:
/opt/niku/clarity/.setup/scripts/db.xml:105: Java returned: 1
at org.apache.tools.ant.ProjectHelper.addLocationToBuildException(ProjectHelper.java:539)
at org.apache.tools.ant.taskdefs.MacroInstance.execute(MacroInstance.java:380)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
at org.apache.tools.ant.Task.perform(Task.java:364)
at com.niku.tools.taskdefs.IfTask.execute(IfTask.java:204)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
at org.apache.tools.ant.Task.perform(Task.java:364)
at org.apache.tools.ant.Target.execute(Target.java:342)
at org.apache.tools.ant.Target.performTasks(Target.java:370)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
at com.niku.nsa.service.AntUtil.executeTargets(AntUtil.java:90)
at com.niku.nsa.service.AntUtil.executeAntScript(AntUtil.java:58)
at com.niku.nsa.service.AdminManager.invokeAction(AdminManager.java:171)
at com.niku.nsa.service.AdminManager.execute(AdminManager.java:89)
at com.niku.nsa.service.Admin.main(Admin.java:76)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.werken.forehead.Forehead.run(Forehead.java:551)
at com.werken.forehead.Forehead.main(Forehead.java:581)
Caused by: /opt/niku/clarity/.setup/scripts/db.xml:105: Java returned: 1
at org.apache.tools.ant.taskdefs.Java.execute(Java.java:87)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
at org.apache.tools.ant.Task.perform(Task.java:364)
at org.apache.tools.ant.taskdefs.Sequential.execute(Sequential.java:64)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
at org.apache.tools.ant.Task.perform(Task.java:364)
at org.apache.tools.ant.taskdefs.MacroInstance.execute(MacroInstance.java:378)
... 22 more
--- Nested Exception ---
/opt/niku/clarity/.setup/scripts/db.xml:105: Java returned: 1
at org.apache.tools.ant.taskdefs.Java.execute(Java.java:87)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
at org.apache.tools.ant.Task.perform(Task.java:364)
at org.apache.tools.ant.taskdefs.Sequential.execute(Sequential.java:64)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
at org.apache.tools.ant.Task.perform(Task.java:364)
at org.apache.tools.ant.taskdefs.MacroInstance.execute(MacroInstance.java:378)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
at org.apache.tools.ant.Task.perform(Task.java:364)
at com.niku.tools.taskdefs.IfTask.execute(IfTask.java:204)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
at org.apache.tools.ant.Task.perform(Task.java:364)
at org.apache.tools.ant.Target.execute(Target.java:342)
at org.apache.tools.ant.Target.performTasks(Target.java:370)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
at com.niku.nsa.service.AntUtil.executeTargets(AntUtil.java:90)
at com.niku.nsa.service.AntUtil.executeAntScript(AntUtil.java:58)
at com.niku.nsa.service.AdminManager.invokeAction(AdminManager.java:171)
at com.niku.nsa.service.AdminManager.execute(AdminManager.java:89)
at com.niku.nsa.service.Admin.main(Admin.java:76)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.werken.forehead.Forehead.run(Forehead.java:551)
at com.werken.forehead.Forehead.main(Forehead.java:581)
 
If someone can point me to some things to check, it will be most appreciated. 
 
Keri

 

Outcomes