Harvest

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

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:

• Bulk Update Projects
• Workbench List View Performance Improvements in Listing Large Folders and Files
• Reorder Linked Processes
• Remove User from User Group
• Harvest Work Area Synchronization Performance Improvements
• Incremental Delivery
• Support for Package Approval Process from Mobile Device
• Enhance Support for Large Data Files
• Plug-in for Microsoft Visual Studio - Rename a File in Online Mode
• Support Silent Installation on Linux 
• Refine Package Search 
• Independent BIRT Reports Plug-in
• Enhance Support to Find Versions for Inactive Users
• Enhance Support for Packages View
• Native 64-bit Support on Apple Mac for CA Harvest SCM Client and Eclipse Plug-in
• Native 64-bit Support on zLinux for CA Harvest SCM Components
• Native 64-bit Support on HP Itanium (HP IA) for CA Harvest SCM Server, Client, and Agent
• Native 64-bit Support on Linux for CA Harvest SCM Server, Client, and Agent

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.

Regards,

Balakrishna.

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
hudp.STATEOBJID = hs.STATEOBJID 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

Hi Ana Dias,

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

Regards,

Balakrishna.

Hello Ana,

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

Hi Dave,

Yes, I did.

Regards,

Ana