Highlighted
ran_b Outstanding Contributor.
Outstanding Contributor.
295 views

Support Tip: Workflow - Maintenance Tasks to Prevent Performance Issue

Jump to solution

When a Workflow (WF) executes, it creates records in the amWfInstance, amWfOccurEvent, and amWfWorkItem tables. These tables grow if number of Workflow Instances and frequency of execution is high. Performance of the system degrades over period of time.

 

Completed Workflow Instances can be deleted. However, Asset Manager does not perform the task since there can be a business requirement to retain the old records.

 

Workaround:

Completed WF Instances need be deleted periodically. Out-of-box Workflow "Delete completed workflow instances" is meant to achieve the task automatically. The scrip type action “Delete the executed workflow instances” called by the WF deletes Workflow Instances with ‘Finished’ status (seStatus).

fv_AutoCleaningDelay (Cleaning delay) feature can be used to retain Workflow Instances after completion. Record are deleted only when “Cleaning delay” expires. If 'fv_AutoCleaningDelay’ for a WF Instance is less than 0 (zero), a WF Instance is never delectated.

 

The amDeleteRecord() function used by the script also deletes the linked records in amWfOccurEvent and amWfWorkItem tables.

 

Ranjan Bhattacharya

HP SW-Global Center of Excellence

 

If this post resolves your issue, please mark it as an accepted solution.

Click the KUDOS star on the left to say 'Thanks'

Labels (1)
Tags (1)
1 Solution

Accepted Solutions
GoldenRatioRJP Honored Contributor.
Honored Contributor.

Re: Support Tip: Workflow - Maintenance Tasks to Prevent Performance Issue

Jump to solution

Ranjan - Thanks for the Support Tip!  Folks might also find this Knowledge Article interesting.

 

https://softwaresupport.hp.com/group/softwaresupport/search-result/-/facetsearch/document/KM48182

 

Title :  AssetCenter: How to keep workflow tables clean as part of workflow maintenance
Document ID :  KM48182
Product - Version:  assetcenter ; asset manager ;
Summary :  Asset Manager and AssetCenter workflow cleanup

 

I wrote this 12+ years ago back in my AC Support Days at Peregrine, but the Workflow Tables have not changed (AFAIK) since AC3.02 so it is still relevant.

 

Cheers...

 

Russell

Russell Parker, CITAM, CHAMP, CSAM
President - Golden Ratio, Inc.
Russ.Parker@GoldenRatioInc.com
2 Replies
GoldenRatioRJP Honored Contributor.
Honored Contributor.

Re: Support Tip: Workflow - Maintenance Tasks to Prevent Performance Issue

Jump to solution

Ranjan - Thanks for the Support Tip!  Folks might also find this Knowledge Article interesting.

 

https://softwaresupport.hp.com/group/softwaresupport/search-result/-/facetsearch/document/KM48182

 

Title :  AssetCenter: How to keep workflow tables clean as part of workflow maintenance
Document ID :  KM48182
Product - Version:  assetcenter ; asset manager ;
Summary :  Asset Manager and AssetCenter workflow cleanup

 

I wrote this 12+ years ago back in my AC Support Days at Peregrine, but the Workflow Tables have not changed (AFAIK) since AC3.02 so it is still relevant.

 

Cheers...

 

Russell

Russell Parker, CITAM, CHAMP, CSAM
President - Golden Ratio, Inc.
Russ.Parker@GoldenRatioInc.com
ran_b Outstanding Contributor.
Outstanding Contributor.

Re: Support Tip: Workflow - Maintenance Tasks to Prevent Performance Issue

Jump to solution

Hi Russell,

 

Thanks for sharing the information!

 

You are correct, KM48182 still holds good.

 

Regards

Ranjan Bhattacharya

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.