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

Document created by RSA Customer Support Employee on Sep 29, 2017Last modified by RSA Customer Support Employee on Feb 24, 2018
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000035464
Applies ToRSA Product Set: RSA Identity Governance & Lifecycle
RSA Version/Condition: 7.0.x
IssueBusiness Description Processing jobs taking a long time to complete.
CausePotential 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.
  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"?>
    <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>
    <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>

  1. 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';

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