View Only
  • 1.  CA Harvest - how to do a mass update in custom UDP name

    Posted Dec 04, 2017 10:25 AM

    Hello all,


    we would like to do a mass rename update in some custom UDP's name, namely appending a string to its original name.


    We have seen this is possible by updating the column PROCESSNAME in table harudp but we would like to know if there is another way of doing this through the Administrator GUI or command line.


    We are using Harvest 12.5 with an Oracle database.


    Thanks in advance.

    Ana Dias

  • 2.  Re: CA Harvest - how to do a mass update in custom UDP name
    Best Answer

    Broadcom Employee
    Posted Dec 04, 2017 12:51 PM

    Hi Ana Dias,


    Thanks for participating in the communities.

    Yes, it is correct that it is possible to update it  in the HARUDP table .Any script  written for this purpose would also update the same table.


    Unfortunately this is not possible in r12.5

    But this is possible in the latest release of CA Harvest SCM V13 -latest increment through a utility called Administrator Bulk update  available from the administrator interface of harvest


    Here is a short video which you can review it further for a better understanding.


    CA Harvest SCM V13 IR2 Overview - YouTube 


    and also about the bulk update feature:


    Bulk Update Projects

    The Bulk Update Projects feature expedites the Harvest Process and Access administration of Harvest projects simultaneously with the criteria of doing it once and replicating the same.

    As a Harvest Administrator, you are often faced with a challenge of updating multiple projects with similar or exactly same change which is cumbersome, time-intensive, and error-prone. This feature enhances your productivity and experience by introducing an automated way of applying specific type change across projects. This feature works with an ideology of do it once, do it right in one place and replicate the same change across projects simultaneously. This feature allows you to perform simultaneous modification of process definition across projects

    As a Harvest Administrator or CM Administrator, you can perform the harvest operations such as:

    • Adding a new process
    • Deleting a process
    • Modifying access type and linked processes of existing processes
    • Access maintenance at state and project level of several projects simultaneously

    For more information, see How to Apply Bulk Update to your Projects


    There are many new additional capabilities included in the latest release of  CA Harvest SCM V13 .Here is the link that includes the complete list


    New Features and Enhancements - CA Harvest SCM - 13.0 - CA Technologies Documentation 


    List is  also copied here for reference:



    Request you to actively consider upgrading to the latest release of Harvest to  leverage these capabilities and have  continued support from CA.


    Please let us know if you have further questions.




  • 3.  Re: CA Harvest - how to do a mass update in custom UDP name

    Posted Dec 05, 2017 05:45 AM

    Hi Balakrishna,


    Thanks for your quick reply.


    For the moment we can't upgrade to version 13 so we need to do this bulk update through the database.


    However I am facing a problem. When I run the query:


    update harudp hudp set hudp.PROCESSNAME = hudp.PROCESSNAME || ' [N/A]'
    where hudp.processobjid in (
    select hudp.processobjid
    from harudp hudp, harstate hs, harenvironment he
    where (hudp.PROCESSNAME = '<udp name A>' and hs.statename = '<state A>') and
    hs.ENVOBJID = he.ENVOBJID and
    he.ENVIRONMENTNAME in '<list of projects>');


    the UDP name appears correctly updated in the database but that change is not reflected in the workbench and the Administrator GUI.

    This behaviour does not happen if I update the name directly in the Administrator.


    Have you ever seen this? Am I missing an update in another table?


    Thanks in advance.


    Best regards,

    Ana Dias

  • 4.  Re: CA Harvest - how to do a mass update in custom UDP name

    Broadcom Employee
    Posted Dec 05, 2017 12:55 PM

    Hi Ana Dias,


    Request you to raise a ticket with the CA support and we can review it more closely.




  • 5.  Re: CA Harvest - how to do a mass update in custom UDP name

    Posted Dec 06, 2017 07:32 AM

    Hello Ana,


    Did you do a "COMMIT" on the database after the script was done?

  • 6.  Re: CA Harvest - how to do a mass update in custom UDP name

    Posted Dec 06, 2017 12:37 PM

    Hi Dave,


    Yes, I did.