Remedy - Server - How to add the Parameter: "Disable-New-RLS-Implementation" in AR System

Version 7
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    Remedy AR System Server


    COMPONENT:

    AR System


    APPLIES TO:

    BMC Remedy AR System Server v8.1.02, v.9.0.01, v9.1.x



    PROBLEM:

    When performing a search in AR System it is observed that it takes some considerable time and when checking the query in the SQL log it is observed the "RLS_split" is used.

    Example:
    .....................................
    <SQL >..........> /* Mon Aug 08 2016 16:50:01.4840 */ WITH AR_SQL_Alias$1 AS (SELECT T1436.C1000000161, T1436.C1000000018, T1436.C1000000019, T1436.C1000000000, T1436.C303497300,
    T1436.C1000000164, T1436.C7, T1436.C1000000217, T1436.C1000000218, T1436.C1000005261, T1436.C1000003009, T1436.C1, ROW_NUMBER() OVER (ORDER BY T1436.C1000000161
    DESC, T1436.C1 ASC) AS 'AR_RowNumber_Alias$1' FROM T1436 WHERE ((T1436.C2 = 'abcde') OR (T1436.C4 = 'abcde') OR EXISTS(SELECT 1 FROM(SELECT Item FROM
    RLS_split(T1436.C60901, ';')
    UNION ALL SELECT Item FROM
    RLS_split(T1436.C112, ';') UNION ALL SELECT Item FROM RLS_split(T1436.C60989, ';') UNION ALL SELECT Item FROM RLS_split(T1436.C60900, ';'))
    privs join 
    RLS_split('1000000023;1000000024;1000000021;1000000027;803;''neth84'';1000000028;1000000025;1000000026;804;0;1058;20316;13006;20315;13007;20313;20012;20078;20055;20077;
    20032;-20032;1000000034;1000000032;1000000033;-1098;1000000214;1000000038;1000000212;1000000036;1000000213;13010;-20003;20403;20003;1000000180;20000;-20000;1000000040', ';') u
    ON privs.Item = u.Item))) SELECT AR_SQL_Alias$1.C1000000161, AR_SQL_Alias$1.C1000000018, AR_SQL_Alias$1.C1000000019, AR_SQL_Alias$1.C1000000000, AR_SQL_Alias$1.C303497300,
    AR_SQL_Alias$1.C1000000164, AR_SQL_Alias$1.C7, AR_SQL_Alias$1.C1000000217, AR_SQL_Alias$1.C1000000218, AR_SQL_Alias$1.C1000005261, AR_SQL_Alias$1.C1000003009, AR_SQL_Alias$1.C1
    FROM AR_SQL_Alias$1 WHERE (AR_SQL_Alias$1.AR_RowNumber_Alias$1 BETWEEN 0 AND 30001)
     
    <SQL >..........> /*
     Mon Aug 08 2016 16:50:25.4460 */ OK
    .....................................

    We can set the parameter Disable-New-RLS-Implementation in the main AR System Configuration.

    How can this be applied to avoid using RLS while AR System generates the SQL statements?


    SOLUTION:

    Please be aware this parameter is available in version 9.x and also has been made available for version 8.1.02.

    For version 8.1.02 :
    1- Apply the latest Hot Fix bundle available by requesting it to BMC Support.
    2- Once applied, please also add in the ar.cfg/ar.conf the parameter: Disable-New-RLS-Implementation: T
    3- Restart the AR System.


    For version 9.0.01 and 9.1.x :
    To set this parameter in the Centralized Configuration form please follow these steps:

    1- Applications panel > AR System Administration > AR System Administration Console

              User-added image


    2-  System > General > Centralized Configuration

              User-added image


    3- In the Centralized Configuration form select the following:
    - Component Namecom.bmc.arsys.server.shared > shared

              User-added image


    4- Add the parameter following these steps:
    - Press Add.
    - In the new line created enter:
             - Setting NameDisable-New-RLS-Implementation
             - Setting Value: T
    - Press Apply.

              User-added image

    5- A restart of ARSystem is not required.

    Additional Information
    This parameter is documented in the online documentation: 
    v.9.0.01: https://docs.bmc.com/docs/ars9000/configuration-settings-c-d-524477460.html
    v.9.1: https://docs.bmc.com/docs/display/public/ars91/Configuration+settings+C-D



     


    Article Number:

    000119056


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles