Clarity PPM

Expand all | Collapse all

Clarity 12.1.1 to Clarity 13.0 Upgrade Issue

Jump to Best Answer
  • 1.  Clarity 12.1.1 to Clarity 13.0 Upgrade Issue

    Posted 06-29-2016 09:35 AM


    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.



  • 2.  Re: Clarity 12.1.1 to Clarity 13.0 Upgrade Issue

    Posted 06-30-2016 12:06 AM

    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.



  • 3.  Re: Clarity 12.1.1 to Clarity 13.0 Upgrade Issue
    Best Answer

    Posted 06-30-2016 03:50 AM

    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



  • 4.  Re: Clarity 12.1.1 to Clarity 13.0 Upgrade Issue

    Posted 07-04-2016 11:45 PM

    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>