AnsweredAssumed Answered

Clarity Upgrade issues - From 8.1.3 to 12.1.0

Question asked by slsujith on Oct 21, 2011
Latest reply on Oct 26, 2011 by another_martink
Hi,

We are currently on Clarity 8.1.3.4545 FP00.02 001 running on Windows 2003 EE SP2 and SQL Server 2005 (9.0.5000.0) with Tomcat 5.5.17.

I am trying to upgrade our test instance to Clarity 12.1.0. I have upgraded Java and Tomcat and ran the install script. There were couple of errors that I encountered:

1. First one was during preupgrade where it failed due to Primary Key violation on ODF_CA_CONSTRAINT table. I found out with some help that this was a bug in the install script and that I could delete contents from the table and proceed with the install. So, did that and preupgrade went fine.

2. Second one was during DB install and this was the error I am getting:

10/20/11 3:36 AM (admin) Content Pack clarityContent version 7.5.3.3546 has been deployed
10/20/11 3:36 AM (admin) Installing content... clarityContent
10/20/11 3:36 AM (admin) Installing content items that do not already exist or have the force option set to true
10/20/11 3:36 AM (admin) - Initializing: pma.init...
10/20/11 3:36 AM (admin) SYS 2011-10-20 03:36:47,588 [main] niku.union Initializing: pma.init...
Oct 20, 2011 3:37:39 AM Error executing command: db install
D:\clarity\.setup\scripts\db.xml:204: exec returned: 2

at org.apache.tools.ant.taskdefs.ExecTask.runExecute(ExecTask.java:591)

at org.apache.tools.ant.taskdefs.ExecTask.runExec(ExecTask.java:617)

at org.apache.tools.ant.taskdefs.ExecTask.execute(ExecTask.java:452)

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)

I edited the db.xml file under upgrade folder in the clarity\.setup directory and removed the content section to proceed with install, then ran the command "nikuadmin content clarityContent -console -Dreports.apply=false" to apply the content upgrade. I believe this error has something to do with the add-in upgrade. We currently have the following add-in installed in our system: PMO (csk_8.1_v2), Administrator Content Pack, Service Connect:Remedy and System:Clarity content (7.5.3.3546).

How can I resolve this issue without having to modify any install file

3. Third one was during postupgrade and this also has something to do with add-in, I guess:

10/20/11 3:39 PM (admin) Upgrading content... clarityContent
10/20/11 3:39 PM (admin) Installing content items that do not already exist or have the force option set to true
10/20/11 3:39 PM (admin) - Initializing: pma.init...
10/20/11 3:39 PM (admin) SYS 2011-10-20 15:39:24,221 [main] niku.union Initializing: pma.init...
10/20/11 3:40 PM (admin) Thu Oct 20 15:40:27 EDT 2011 (postupgrade) content: failed.
Oct 20, 2011 3:40:27 PM Error executing command: postupgrade
D:\clarity\.setup\scripts\postupgrade.xml:17: The following error occurred while executing this line:
D:\clarity\.setup\upgrade\12.1.0\postupgrade\content.xml:50: Java returned: 2

at org.apache.tools.ant.ProjectHelper.addLocationToBuildException(ProjectHelper.java:539)

at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:384)

at com.niku.tools.taskdefs.CallList.executeTarget(CallList.java:649)

at com.niku.tools.taskdefs.CallList.execute(CallList.java:514)

at com.niku.tools.taskdefs.CallList.execute(CallList.java:460)

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 com.niku.nsa.service.AntUtil.executeTargets(AntUtil.java:94)

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: D:\clarity\.setup\upgrade\12.1.0\postupgrade\content.xml:50: Java returned: 2

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.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.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:37)

at org.apache.tools.ant.Project.executeTargets(Project.java:1068)

at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:382)

... 20 more
--- Nested Exception ---
D:\clarity\.setup\upgrade\12.1.0\postupgrade\content.xml:50: Java returned: 2

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.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.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:37)

at org.apache.tools.ant.Project.executeTargets(Project.java:1068)

at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:382)

at com.niku.tools.taskdefs.CallList.executeTarget(CallList.java:649)

at com.niku.tools.taskdefs.CallList.execute(CallList.java:514)

at com.niku.tools.taskdefs.CallList.execute(CallList.java:460)

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 com.niku.nsa.service.AntUtil.executeTargets(AntUtil.java:94)

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)

Please do let me know how I could proceed with the upgrade without having to edit any of the install files.

Outcomes