AnsweredAssumed Answered

Upgrade CA PPM 12.1.3 to 14.2 - Stuck at PRCALENDAR (CalendarSQLCurveUpgrade)

Question asked by David_Marchal_CoPrime on Jul 15, 2015
Latest reply on Jul 16, 2015 by David_Marchal_CoPrime

Hi guys,

 

I'm trying to upgrade a Clarity database 12.1.3 to 14.2.

My environment is on Windows Server 2008R2 - SQL Server 2008R2 - Clarity 12.1.3 (8 Go, 4 cores, 50 Go fs).

The database is quite small : only 1500 projects / 1500 resources.

 

Everything's going fine to 13.3. But then the upgrade is stuck at the update of the resource calendars : adding SQL Curve on the prcalendar table ( great feature by the way ).

 

The problem is located on the file :

install.jar\install-packages\14.1.0\upgrade-repack.14.1.0.431tpexcludes.jar\package.jar\upgrade\14.1.0\component\postupgrade\projmgr.xml

 

At the step :

  <!--
    upgrade prcalendar to create sql curves for each prvalue
  -->
  <target name="calendarupgrade">
    <echo message="Upgrading PRCALENDAR"/>
    <upgrade.java classname="com.ca.clarity.projmgr.CalendarSQLCurveUpgrade" fork="true" failonerror="true"
                  classpathref="lib.path">
    </upgrade.java>
  </target>

 

I've tried the following things :

 

  • Allocate more memory for the upgrade process by adding the file $NIKU_HOME/config/memory.properties
  • Change the property fork to "false" in the upgrade process

 

But still no improvement : the java process is stuck, its allocated memory is just decreasing slowly.

Don't know if it's the combination Java / Windows or Java / SQL Server which causes the problem ?

 

The only thing I could do is kill the process and restart the installation "install.bat force" (resume doesn't work on this release).

Doesn't seem to cause any problem at the end.

 

Could use some advice.

 

Thx in advance,

David

Outcomes