How to improve performance with business description processing in RSA Identity Governance & Lifecycle

[#1]

Article Number

000035464

Applies To

RSA Product Set: RSA Identity Governance & Lifecycle
RSA Version/Condition: 7.0.x

Issue

Business Description Processing jobs taking a long time to complete.

Cause

Potential causes of poor Business Description Processing job performance:

1. The use of wildcards versus using exact match.
2. There are a large number of "soft" deleted records in table T_AV_BUSINESS_DESCRIPTION.
3. Using a huge volume of Business Descriptions when they are not needed.
4. Under-configured hardware.

Resolution

1. Change any wildcard matches to do an exact match. In the User Interface go to Admin > Descriptions and for each tab, do an Export (all) and save them to a file. Search for exactmatch="false" and change the filter value to remove any wildcards (%) and match the object name exactly. You may need to split them out into multiple entries, each with a unique filter matching the object name and ensure to set exactmatch="true".

<?xml version="1.0"?>
<BusinessDescriptions>
    <BusinessDescription filter="BLR Technical board" exactmatch="true" type="UserGroup">
        <AltName>Alternate Name for Group BLR Technical board</AltName>
        <Tooltip>ToolTip for Group BLR Technical board</Tooltip>
        <LongDesc>Long Description for Group BLR Technical board</LongDesc>
        <HelpURL>http://www.aveksa.com</HelpURL>
    </BusinessDescription>
    <BusinessDescription filter="B" exactmatch="false" type="UserGroup">
        <AltName>Alternate Name for Group starting with B</AltName>
        <Tooltip>ToolTip for Group starting with B</Tooltip>
        <LongDesc>Long Description for Group starting with B</LongDesc>
        <HelpURL>http://www.aveksa.com</HelpURL>
    </BusinessDescription>
</BusinessDescriptions>

2. Check the number of "soft" deleted Business Descriptions. If the number is large, it is suggested that you contact RSA Customer Support to aid in deleting them.

SELECT COUNT(*) FROM t_av_business_description WHERE is_deleted='TRUE';

3. Avoid unnecessary use of Business Descriptions.  Do not add a Business Description if the current collected information is understandable by the end user.