Clarity

Expand all | Collapse all

CA PPM upgrade to 14.3 fails for DWH error

  • 1.  CA PPM upgrade to 14.3 fails for DWH error

    Posted Aug 25, 2016 07:15 AM
      |   view attached

    We are upgrading from 14.2 to 14.3 and the upgrade is failing with below error:

     

     

    Error while comparing PPM and DWH versions. Check the checkinstall.log for before you continue. We are not using Data Warehouse. How we can skip the step for Data Warehouse connection.

     

    I have attached precheck-results.html

    Attachment(s)

    zip
    precheck-results.html.zip   2 KB 1 version


  • 2.  Re: CA PPM upgrade to 14.3 fails for DWH error

    Broadcom Employee
    Posted Aug 25, 2016 08:31 AM

    Hi Piyush,

     

    You can but first and foremost the error is below and needs to be corrected in order to prevent further problems 

     

    check-db-dwh-sync.xmlERRORError while comparing PPM and DWH versions. Check the checkinstall.log for before you continue.

     

    So you can run the below command to get to sync and then upgrade. 

     

    admin db dwh-upgrade -Dupgrade.phase=maintenance

     

    Regards

    Suman Pramanik 



  • 3.  Re: CA PPM upgrade to 14.3 fails for DWH error

    Posted Aug 25, 2016 10:54 AM

    Hi Suman,

     

    I am getting below message after running this command:

     

    Info: The data warehouse could not be upgraded, the connection was unavailable or the data warehouse database has not been installed



  • 4.  Re: CA PPM upgrade to 14.3 fails for DWH error

    Broadcom Employee
    Posted Aug 25, 2016 11:02 AM

    Hi Piyush,

     

    You need to login to CSA and ensure DWH is available, if its not then its bound to fail because there is no connectivity.

     

    Regards

    Suman Pramanik



  • 5.  Re: CA PPM upgrade to 14.3 fails for DWH error

    Posted Aug 26, 2016 03:52 AM

    Thanks Suman, but we are not using Data Warehouse and we don't have any set up for that



  • 6.  Re: CA PPM upgrade to 14.3 fails for DWH error

    Posted Jan 09, 2018 06:03 PM

    CA PPM upgrade to 14.3 fails for DWH error,

    Hi Piyush,

    What was the solution to resolve this error. We are upgrading from 14.2 to 15.2 and getting the same error. Also we are not using the DWH setup in 14.2 in our instance. There should be some workarond to do the same.

     

    Thanks,

    Shalinee



  • 7.  Re: CA PPM upgrade to 14.3 fails for DWH error

    Posted Jan 09, 2018 06:04 PM

    Hi Suman,

    What was the solution to resolve this error. We are upgrading from 14.2 to 15.2 and getting the same error. Also we are not using the DWH setup in 14.2 in our instance. There should be some workarond to do the same.

     

    Thanks,

    Shalinee



  • 8.  Re: CA PPM upgrade to 14.3 fails for DWH error

    Broadcom Employee
    Posted Jan 10, 2018 12:57 AM

    Hi Shalinee,

     

    Can you post the exact error please 

     

    Regards

    Suman Pramanik 



  • 9.  Re: CA PPM upgrade to 14.3 fails for DWH error

    Posted Jan 10, 2018 12:10 PM

    Attached the files.

    Attachment(s)

    zip
    install.log.zip   24 KB 1 version
    zip
    precheck-results.html.zip   3 KB 1 version


  • 10.  Re: CA PPM upgrade to 14.3 fails for DWH error

    Posted Apr 24, 2018 08:36 AM

    We are also facing problem while upgrading from 14.2 to 14.4. Upgrade is failing while trying to install db driver for DWH.But we are not using datawarehouse.

    How can we proceed with installation?



  • 11.  Re: CA PPM upgrade to 14.3 fails for DWH error

    Posted Apr 24, 2018 09:31 AM

    There is one way to skip the DWH set up. Go to Administration -> General Settings -> System Options.

    Go to DataWarehouse options and remove Entity for Fiscal Periods. Click on Save. After this proceed with upgrade, Your upgrade should pass through.

    And don't forget to input the same value post upgrade.



  • 12.  Re: CA PPM upgrade to 14.3 fails for DWH error

    Posted Apr 25, 2018 02:57 AM

    Piyush ,Thanks for reply.

    Fiscal Periods under DataWarehouse is already blank, still we are facing issue.

    Do you know any other workaround?

     

    Thank you. 



  • 13.  Re: CA PPM upgrade to 14.3 fails for DWH error

    Posted Apr 25, 2018 09:24 AM

    Can you post the exact error showing up in checkinstall logs



  • 14.  Re: CA PPM upgrade to 14.3 fails for DWH error

    Posted Jan 24, 2019 08:16 AM

    hi,

     

    I am facing the same issue,  did you manage to fix this problem. If yes, can you please explain how?

     

    Thank you