Clarity

  • 1.  Benefit Plan custom fields data deleted after CA PPM 15.2 upgrade

    Posted Sep 24, 2018 02:56 PM

    Hi,

     

    We have completed the upgrade from CA PPM 14.2 SP11 version CA PPM 15.2 SP in our non-production environment. During the unit testing phase we have noticed the issue in benefit Plan.

    We are creating a benefit plan using a template at the time of Idea Convert to a project via Process (Gel/Xog). Our benefit plan has three custom fields of type string with drop down lookup value. We have noticed the data has been wiped out from all the custom fields of benefit plan. However total benefit cost is still there and all other out of the box fields data is available as is. This behavior is pretty random because we have noticed 95% project benefit plan has no data in custom three fields however there are few benefit plan with some data in custom fields.

     

    Any idea about this issue. Not sure if it is bug as I found this. We have also installed PMO Accelerator in our instance.

     

    “Benefit Plan is one of the many objects that got affected by PMO installation.  This means that your configurations would get overwritten during installation/upgrade.  This is documented in docops at the following link: 

    https://docops.ca.com/ca-ppm/15-2/en/add-ins-and-integrations/add-in-pmo-accelerator/

     

    Excerpt from section "PMO Accelerator Add-In Items Automatically Installed"

     

     

    I am also attaching the behavior of this issue.

     

     

    Any suggestion is much appreciated!

     

     

    Thanks,

    Shalinee



  • 2.  Re: Benefit Plan custom fields data deleted after CA PPM 15.2 upgrade

    Posted Sep 26, 2018 12:29 AM

    Have you checked the database to see the data has been deleted?  The upgrade may have included additional security where the data in the List View is not showing as it resides on a Secure Page which your account doesn't have access to? 

     

    As you indicate that these attributes are a look-up, are you sure the look-ups are still working after the upgrade?  Again, checking the database will confirm if something is there or not.

     

    In the above, I am assuming you are looking at data that was perviously there prior to the upgrade, otherwise, you need to review the process which is creating the Benefit Plan.

     

    Out of interest, why do an upgrade to V15.2?  You will have to do another upgrade by Sep-2019 when V15.2 has end-of-service date.



  • 3.  Re: Benefit Plan custom fields data deleted after CA PPM 15.2 upgrade

    Posted Sep 26, 2018 05:45 PM

    Yes. We checked the database too and there is no data available for most of the projects benefit plan. The strange behavior is that some of the projects have data in benefit plan or some of the projects have data in few line items of benefit plan . This is very intermittent kind of situation. We have open and case with CA support as well and they have suggested to re-upgrade. Lookup values are available  as prior to upgrade. Also the gel process which takes data for benefit plan from a project template" is working fine. However after upgrade we notice the benefit plan template data itself was gone for both the custom fields. after fixing the template we tried the process and it is working fine.

     

    We can not move on higher version because of SQL server limitation. We are on SQL Server 2012.

     

    Thanks,

    Shalinee