AnsweredAssumed Answered

Upgrade from 8.1 to 12.1 AddMissingTaskODFCAConstraint?

Question asked by mrmikev on Apr 12, 2011
Latest reply on Apr 15, 2011 by mrmikev
Hello all,
working on upgrading our dev env to 12.1 and am not getting very far. Just wondering if any has any ideas... install log excerpt below.

4/12/11 9:13 AM (CallList) preupgrade::projmgr --> start
4/12/11 9:13 AM (Target) Target "AddMissingTaskODFCAConstraint" started.
4/12/11 9:13 AM (Java) Exception in thread "main" com.niku.union.persistence.PersistenceException:
4/12/11 9:13 AM (Java) SQL error code: 1
4/12/11 9:13 AM (Java) Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00001: unique constraint (NIKU.ODF_CA_CONSTRAINT_PK) violated
4/12/11 9:13 AM (Java)
4/12/11 9:13 AM (Java) Executed:
4/12/11 9:13 AM (Java) insert into odf_ca_constraint (id, created_by, created_date, last_updated_by, last_updated_date, partition_code)
4/12/11 9:13 AM (Java) select prc.prid, ?, ?, ?, ?, c.partition_code from prconstraint prc, prtask t, inv_projects p, odf_ca_project c where
4/12/11 9:13 AM (Java) p.prid = c.id and p.prid = t.prprojectid and t.prid = prc.prtaskid
4/12/11 9:13 AM (Java) Derived from statement:
4/12/11 9:13 AM (Java) <?xml version="1.0" encoding="UTF-8"?>
4/12/11 9:13 AM (Java) <statement location="tasksPMD.xml" id="projmgr.insertOdfCAConstraintsForTask_stmt" sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" inputSource="none" xmlns="http://schemas.niku.com/2002/pmd">
4/12/11 9:13 AM (Java) <sql dbVendor="all">
4/12/11 9:13 AM (Java) <text>
4/12/11 9:13 AM (Java) insert into odf_ca_constraint (id, created_by, created_date, last_updated_by, last_updated_date, partition_code)
4/12/11 9:13 AM (Java) select prc.prid, ?, ?, ?, ?, c.partition_code from prconstraint prc, prtask t, inv_projects p, odf_ca_project c where
4/12/11 9:13 AM (Java) p.prid = c.id and p.prid = t.prprojectid and t.prid = prc.prtaskid
4/12/11 9:13 AM (Java) </text>
4/12/11 9:13 AM (Java) <param replace="userId" direction="IN" expressionListDelimiter=","/>
4/12/11 9:13 AM (Java) <param replace="timestamp" direction="IN" expressionListDelimiter=","/>
4/12/11 9:13 AM (Java) <param replace="userId" direction="IN" expressionListDelimiter=","/>
4/12/11 9:13 AM (Java) <param replace="timestamp" direction="IN" expressionListDelimiter=","/>
4/12/11 9:13 AM (Java) </sql>
4/12/11 9:13 AM (Java) </statement>
4/12/11 9:13 AM (Java)
4/12/11 9:13 AM (Java) Referenced by:
4/12/11 9:13 AM (Java) <?xml version="1.0" encoding="UTF-8"?>
4/12/11 9:13 AM (Java) <statementRef id="projmgr.insertOdfCAConstraintsForTask_stmt" inputSource="none" sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" xmlns="http://schemas.niku.com/2002/pmd"/>
4/12/11 9:13 AM (Java)
4/12/11 9:13 AM (Java) Using input:
4/12/11 9:13 AM (Java) None
4/12/11 9:13 AM (Java)
4/12/11 9:13 AM (Java)
at com.niku.union.persistence.PersistenceController.createException(PersistenceController.java:1800)
4/12/11 9:13 AM (Java)
at com.niku.union.persistence.PersistenceController.handleSQLException(PersistenceController.java:1858)
4/12/11 9:13 AM (Java)
at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:2334)
4/12/11 9:13 AM (Java)
at com.niku.union.persistence.PersistenceController.processStatement(PersistenceController.java:701)
4/12/11 9:13 AM (Java)
at com.niku.union.persistence.PersistenceController.processStatements(PersistenceController.java:610)
4/12/11 9:13 AM (Java)
at com.niku.union.persistence.PersistenceController.doProcessRequest(PersistenceController.java:450)
4/12/11 9:13 AM (Java)
at com.niku.union.persistence.PersistenceController.processRequest(PersistenceController.java:221)
4/12/11 9:13 AM (Java)
at com.niku.union.persistence.PersistenceConversation.process(PersistenceConversation.java:296)
4/12/11 9:13 AM (Java)
at com.niku.projmgr.upgrade.AddMissingTaskODFCAConstraint.doUpgrade(AddMissingTaskODFCAConstraint.java:59)
4/12/11 9:13 AM (Java)
at com.niku.xql2.upgrade.BaseUpgrade.run(BaseUpgrade.java:189)
4/12/11 9:13 AM (Java)
at com.niku.projmgr.upgrade.AddMissingTaskODFCAConstraint.main(AddMissingTaskODFCAConstraint.java:69)
4/12/11 9:13 AM (Java) Caused by: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00001: unique constraint (NIKU.ODF_CA_CONSTRAINT_PK) violated
4/12/11 9:13 AM (Java)
4/12/11 9:13 AM (Java)
at com.ca.clarity.jdbc.base.BaseExceptions.createException(Unknown Source)
4/12/11 9:13 AM (Java)
at com.ca.clarity.jdbc.base.BaseExceptions.getException(Unknown Source)
4/12/11 9:13 AM (Java)
at com.ca.clarity.jdbc.oracle.OracleImplStatement.execute(Unknown Source)
4/12/11 9:13 AM (Java)
at com.ca.clarity.jdbc.base.BaseStatement.commonExecute(Unknown Source)
4/12/11 9:13 AM (Java)
at com.ca.clarity.jdbc.base.BaseStatement.executeInternal(Unknown Source)
4/12/11 9:13 AM (Java)
at com.ca.clarity.jdbc.base.BasePreparedStatement.execute(Unknown Source)
4/12/11 9:13 AM (Java)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
4/12/11 9:13 AM (Java)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
4/12/11 9:13 AM (Java)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
4/12/11 9:13 AM (Java)
at java.lang.reflect.Method.invoke(Method.java:597)
4/12/11 9:13 AM (Java)
at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:68)
4/12/11 9:13 AM (Java)
at org.logicalcobwebs.cglib.proxy.Proxy$ProxyImpl$$EnhancerByCGLIB$$90772cf0.execute(<generated>)
4/12/11 9:13 AM (Java)
at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:2313)
4/12/11 9:13 AM (Java)
... 8 more
4/12/11 9:13 AM (UnknownElement) Task "upgrade.java" finished with error.
C:\niku\Clarity12Install\upgrade\12.1.0\preupgrade\projmgr.xml:28: 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.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.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 org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:107)

at com.niku.tools.taskdefs.IfTask.execute(IfTask.java:209)

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.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 org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:107)

at com.niku.tools.taskdefs.IfTask.execute(IfTask.java:209)

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.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 org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:107)

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.Task.perform(Task.java:364)

at com.niku.tools.taskdefs.ChooseTask.execute(ChooseTask.java:146)

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.Task.perform(Task.java:364)

at com.niku.tools.taskdefs.ChooseTask.execute(ChooseTask.java:146)

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 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 org.apache.tools.ant.Main.runBuild(Main.java:675)

at org.apache.tools.ant.Main.startAnt(Main.java:190)

at org.apache.tools.ant.launch.Launcher.run(Launcher.java:246)

at org.apache.tools.ant.launch.Launcher.main(Launcher.java:67)
4/12/11 9:13 AM (Log4jOut) Use these settings? [(y)es, (n)o] ERROR 2011-04-12 09:13:14,992 [main] ant.UnknownElement Task "upgrade.java" finished with error.

Outcomes