Activating Security Information

The BypassMRTLookupList parameter in the ADV30Params.ini file specifies a comma-separated list of tables that should bypass the MRT Generation process and the need to bounce the application. This parameter is optional. If no tables are specified, all tables listed in the MRT file require the MRT Generation process to run, and a bounce of the application may be necessary, depending on whether the MRT_REFRESH_ENABLED parameter on the ERPCTRL page is enabled.

If tables are added to the BypassMRTLookupList parameter, the application must be bounced once to apply the changes. This is because the parameter value is cached in memory to improve performance by avoiding repeated database lookups.

After the bounce, the application begins reading security information directly from the specified database tables. Any future changes to those tables will not require another application bounce. There is no need to re-save or modify records in the tables listed in the BypassMRTLookupList parameter. Each time a page is accessed, the system retrieves the relevant records directly from the database; the MRT file is no longer consulted for those tables. This includes records that existed before the table was added to the parameter.

This setup is particularly useful for environments where running the MRT Generation process and restarting the application is not practical such as in live production systems. For a reference list of security-related tables that are or are not included in the MRT file, see the “Security and Memory Resident Tables” section in this user guide.

When MRT_REFRESH_ENABLED is set to true, MRT data is automatically refreshed five minutes after the MRT file is generated. This enables security data updates to be reflected in the application without requiring a restart.

Note: Using the BypassMRTLookupList parameter may impact system performance, as security configurations are retrieved from the database at runtime. Therefore, it is recommended to use this feature primarily in testing or non-production environments.