Clarity

Expand all | Collapse all

Upgrade 14.2 to 15.1 - SQL Server version error

  • 1.  Upgrade 14.2 to 15.1 - SQL Server version error

    Posted 05-15-2017 01:19 PM

    We have a sandbox running PPM 14.2.  We upgraded the DBMS from SQL Server 2008 to SQL Server 2014, since 2008 is not supported in 15.1.  However, when trying to upgrade PPM to 15.1, we are now getting the following error message on pre-check:

    check-db-version.xmlERRORMSSQL Database cannot be 2014 when upgrading from pre-14.3 release. Please refer to the Product Architecture Stack (PAS) for supported database versions.

     

    Is 2014 not actually supported, at least when upgrading???  Do I REALLY need to install SQL Server 2012, upgrade, and then upgrade 2014 (with all the associated license costs that incurs to use two releases)?!?!?!  Is there any workaround?



  • 2.  Re: Upgrade 14.2 to 15.1 - SQL Server version error

    Broadcom Employee
    Posted 05-15-2017 04:40 PM
      |   view attached

    Hi Allison,

     

    MSSQL 2014 is supported, the reason we have the check there is that for CA PPM 14.3 MSSQL 2014 was only supported for new customers, and not upgrading customers (for them MSSQL 2012 was the supported version). However for you there should be no problem to go and apply a workaround that we have:

     

    1. Please copy the attached file check-db-version.xml into the checkinstall directory where you extracted the install files. The path would be :

    $install\checkinstall\scripts

    1. Ensure it replaces the existing file correctly
    2. Once done, start the upgrade again. Now it should show a Warning but not an Error and allow you to continue the upgrade.

     

    Please ensure you test on your test environment and everything looks good first before going to Prod.

     

    Hope this helps -Nika

    Attachment(s)



  • 3.  Re: Upgrade 14.2 to 15.1 - SQL Server version error

    Posted 05-15-2017 04:48 PM

    Thanks Nika!  We're going to try it now and I'll let you know!