AnsweredAssumed Answered

CA Clarity upgrade 12.06 to 13.2 failed after 12.1.1

Question asked by shiva.s43 on Jul 11, 2013
Latest reply on Jul 26, 2013 by another_martink
Hi,

I'm trying to upgrade CA Clarity V12.06 to 13.2 but it failed after 12.1.1. I also tried to analyze the issue through
install.log file but couldn't understand much.

We are using
OS:
Windows Server 2008 R2 Standard (64-bit)
Database: Microsoft SQL Server 2008 - EE (64-bit)
Java: JDK 1.7
WebServer: Tomcat 5(old) --> Tomcat 7(Target)

I followed all the instruction mentioned in installation guide. Below is the few lines from install.log file.

7/09/13 8:28 AM (ExecTask) To URL: jdbc:clarity:sqlserver://eadevsql2k801:40002;DatabaseName=clarityent;InsensitiveResultSetBufferSize=0;ProgramName=Clarity
7/09/13 8:28 AM (ExecTask) As user: niku
7/09/13 8:28 AM (ExecTask) For vendor: mssql
7/09/13 8:28 AM (ExecTask)
7/09/13 8:28 AM (ExecTask) Process: C:\V13.2\v13.2_temp\install-packages\12.1.1\upgrade-repack.12.1.1.1208tpexcludes\upgrade\12.1.1\postupgrade\POSTUPGRADE_INV_FLAT_HIER_RECONSTRUCT.xml
7/09/13 8:28 AM (ExecTask)
7/09/13 8:29 AM (ExecTask)
7/09/13 8:29 AM (ExecTask) postupgrade:
7/09/13 8:29 AM (ExecTask) postupgrade::evm --> 2.0 seconds
7/09/13 8:29 AM (ExecTask) ==========================================
7/09/13 8:29 AM (ExecTask) DBTools Log - Tue Jul 09 08:29:12 EDT 2013
7/09/13 8:29 AM (ExecTask) ==========================================
7/09/13 8:29 AM (ExecTask) Total time: 0H:0M:1S
7/09/13 8:29 AM (ExecTask)
7/09/13 8:29 AM (ExecTask) init:
7/09/13 8:29 AM (ExecTask)
7/09/13 8:29 AM (ExecTask) uploadprops:
7/09/13 8:29 AM (ExecTask) Uploaded properties.xml
7/09/13 8:29 AM (ExecTask) Installation Successful - 09-July-2013 08:29:16
7/09/13 8:29 AM (ExecTask)
7/09/13 8:29 AM (ExecTask) BUILD SUCCESSFUL
7/09/13 8:29 AM (ExecTask) Total time: 94 minutes 33 seconds
7/09/13 8:29 AM (Echo) release.exec.result = Result: 255
7/09/13 8:29 AM (Echo) Result: 255
7/09/13 8:29 AM (Echo) Result: 255
7/09/13 8:29 AM (Echo) Result: 255
7/09/13 8:29 AM (UnknownElement) Task "fail" finished with error.
c:\V13.2\v13.2_temp\install.xml:845: The upgrade step for 12.1.1 failed. Please consult the
c:\V13.2\v13.2_temp\install-packages\12.1.1\upgrade-repack.12.1.1.1208tpexcludes/install.log for that release package."

at org.apache.tools.ant.taskdefs.Exit.execute(Exit.java:164)

at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)

at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)

at org.apache.tools.ant.Main.runBuild(Main.java:811)

.

.

.

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

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

at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109)
7/09/13 8:29 AM (UnknownElement) Task "if" finished with error.
c:\V13.2\v13.2_temp\install.xml:845: The upgrade step for 12.1.1 failed. Please consult the
c:\V13.2\v13.2_temp\install-packages\12.1.1\upgrade-repack.12.1.1.1208tpexcludes/install.log for that release package."

at org.apache.tools.ant.taskdefs.Exit.execute(Exit.java:164)

at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)

at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at ct.Method.invoke(Method.java:601)

.

.

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

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

at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109)




I also see errors related to NULL value insert in the log file...



7/09/13 7:56 AM (ExecTask) SQL error code: 515
7/09/13 7:56 AM (ExecTask) Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Cannot insert the value NULL into column 'ODF_PK', table 'ClarityEnt.niku.ODF_LOCKED_ATTRIBUTES'; column does not allow nulls. INSERT fails.
7/09/13 7:56 AM (ExecTask) SQL error code: 3621
7/09/13 7:56 AM (ExecTask) Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]The statement has been terminated.
7/09/13 7:56 AM (ExecTask) Executed:
7/09/13 7:56 AM (ExecTask) insert into ODF_CA_IDEA (id, created_date, created_by,last_updated_date, last_updated_by) select inv_ideas.id odf_pk ,created_date, created_by, last_updated_date, last_updated_by from inv_ideas where not exists (select 'row exists' from odf_ca_idea where id = inv_ideas.id)
7/09/13 7:56 AM (ExecTask) Derived from statement:
7/09/13 7:56 AM (ExecTask) <?xml version="1.0" encoding="UTF-8"?>
7/09/13 7:56 AM (ExecTask) <statement location="unionPMD.xml" id="union.dynamicSQL" 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">
7/09/13 7:56 AM (ExecTask) <sql dbVendor="all">
7/09/13 7:56 AM (ExecTask) <text>@dynamic@</text>
7/09/13 7:56 AM (ExecTask) <param direction="IN" dynamicReplacement="@dynamic@" expressionListDelimiter=","/>
7/09/13 7:56 AM (ExecTask) </sql>
7/09/13 7:56 AM (ExecTask) </statement>
7/09/13 7:56 AM (ExecTask)
7/09/13 7:56 AM (ExecTask) Referenced by:
7/09/13 7:56 AM (ExecTask) <?xml version="1.0" encoding="UTF-8"?>
7/09/13 7:56 AM (ExecTask) <statementRef id="union.dynamicSQL" inputSource="map" 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"/>
7/09/13 7:56 AM (ExecTask)
7/09/13 7:56 AM (ExecTask) Using input:
7/09/13 7:56 AM (ExecTask) {dynamic=insert into ODF_CA_IDEA (id, created_date, created_by,last_updated_date, last_updated_by) select inv_ideas.id odf_pk ,created_date, created_by, last_updated_date, last_updated_by from inv_ideas where not exists (select 'row exists' from odf_ca_idea where id = inv_ideas.id)}
7/09/13 7:56 AM (ExecTask)
7/09/13 7:56 AM (ExecTask)
at com.niku.union.persistence.PersistenceController.createException(PersistenceController.java:1805)
7/09/13 7:56 AM (ExecTask)
at com.niku.union.persistence.PersistenceController.handleSQLException(PersistenceController.java:1863)
7/09/13 7:56 AM (ExecTask)
at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:2349)
7/09/13 7:56 AM (ExecTask)
at com.niku.union.persistence.PersistenceController.processStatement(PersistenceController.java:702)
7/09/13 7:56 AM (ExecTask)
at com.niku.union.persistence.PersistenceController.processStatements(PersistenceController.java:611)
7/09/13 7:56 AM (ExecTask)
at com.niku.union.persistence.PersistenceController.doProcessRequest(PersistenceController.java:451)
7/09/13 7:56 AM (ExecTask)
at com.niku.union.persistence.PersistenceController.processRequest(PersistenceController.java:222)
7/09/13 7:56 AM (ExecTask)
at com.niku.odf.object.Utils.executeDynamicPMDQuery(Utils.java:2185)
7/09/13 7:56 AM (ExecTask)
at com.niku.odf.object.Utils.populateODF_CA_Table(Utils.java:1744)
7/09/13 7:56 AM (ExecTask)
at com.niku.odf.object.Bootstrap.createCustomAttributeTables(Bootstrap.java:579)
7/09/13 7:56 AM (ExecTask)
at com.niku.odf.object.Bootstrap.main(Bootstrap.java:1015)
7/09/13 7:56 AM (ExecTask) Caused by: java.sql.SQLException: [CA Clarity][SQLServer JDBC Driver][SQLServer]Cannot insert the value NULL into column 'ODF_PK', table 'ClarityEnt.niku.ODF_LOCKED_ATTRIBUTES'; column does not allow nulls. INSERT fails.


I have a support ticket open for this.. Any help from here will be really helpful. I have attached the install.log and cmn_install_history list. Please let me know if any other information is required.


Thanks
Shiva

Outcomes