Clarity 12.1.1 to Clarity 13.0 Upgrade Issue

[kanbh02]

Hi Everyone,

 

Upgrade fails when it reaches the Post Upgrade step. Below are some details on the issue encountered.

 

DB :- MS SQL Server 2005.

 

Executing Ant script: E:\Apps\Clarity\upgrade\13.0.0\postupgrade\npt.xml

Provide favorites menu portlet for each existing user

com.niku.tools.ant.ExecutableException: E:\Apps\Clarity\upgrade\13.0.0\postupgrade\npt.xml:28: com.niku.union.service.ServiceException: UpgradeUserFavoritesMenu: doUpgrade(). PersistenceApplicationException. Error message is: java.sql.SQLException: [CA Clarity][SQLServer JDBC Driver][SQLServer]-20005_USER_NAME DOES NOT EXIST

  at com.niku.tools.ant.AntUtil.executeAntScript(AntUtil.java:112)

  at com.niku.tools.ant.AntUtil.executeAntScript(AntUtil.java:87)

  at com.niku.dbtools.Utilities.executeAntScript(Utilities.java:1954)

  at com.niku.dbtools.Utilities.run(Utilities.java:1587)

  at com.niku.dbtools.Utilities.main(Utilities.java:716)

Caused by: E:\Apps\Clarity\upgrade\13.0.0\postupgrade\npt.xml:28: com.niku.union.service.ServiceException: UpgradeUserFavoritesMenu: doUpgrade(). PersistenceApplicationException. Error message is: java.sql.SQLException: [CA Clarity][SQLServer JDBC Driver][SQLServer]-20005_USER_NAME DOES NOT EXIST

 

Regards,

Bhargav.

[kanbh02]

Since this step failed i started up the application and verified the Favorites menu for users. Some of them have it while some of them have it disabled.

 

Any insights will be helpful. If it is being caused by a faulty user , kindly help me in pinpointing that user or user base.

[Suman Pramanik]

Hi Bhargav,

 

The upgrade has failed and you need to roll back and start fixing rather starting the app when the upgrade is broken. We also need to take a look at full install log as well as the database configuration.

 

Regards

Suman Pramanik

[kanbh02]

Hi suman,

 

I have tried it multiple times, rolling back and retrying the upgrade after all the pre-upgrade activities are complete. The upgrade still error's out with the same issue.

 

I have reached out to CA Support on this. Below is their analysis until and since yesterday was an US holiday they still haven't updated the case.

 

error in install log: *********************************************** Executing Ant script: E:\Apps\Clarity\upgrade\13.0.0\postupgrade\npt.xml 6/29/16 6:06 AM (ExecTask) Provide favorites menu portlet for each existing user 6/29/16 6:07 AM (ExecTask) com.niku.tools.ant.ExecutableException: E:\Apps\Clarity\upgrade\13.0.0\postupgrade\npt.xml:28: com.niku.union.service.ServiceException: UpgradeUserFavoritesMenu: doUpgrade(). PersistenceApplicationException. Error message is: java.sql.SQLException: [CA Clarity][SQLServer JDBC Driver][SQLServer]-20005_USER_NAME DOES NOT EXIST  npt.xml.  appear to be missing install.dir ************************************************* project basedir="." default="upgrade" name="npt">  <taskdef name="if" classname="com.niku.tools.taskdefs.IfTask"/>  <taskdef name="optionalArgument" classname="com.niku.tools.taskdefs.OptionalArgument"/>   -<target name="init">   -<if isempty="true" property="install.dir">  <fail>Missing required property: install.dir</fail>