This knowledge article may contain information that does not apply to version 21.05 or later which runs in a container environment. Please refer to Article Number 000385088 for more information about troubleshooting BMC products in containers.

When running reports, Smart Reporting sends the query via the ARJDBC driver to the AR System server, so that AR System then fetches the data from the AR database, before sending it back to Smart Reporting.

Following parameters dictate the amount of data to be retrieved from a single query:

• Jdbc-Row-Limit in AR System
• rowLimit in Smart Reporting
• Max Rows Returned in Smart Reporting
• Max Entries Returned by GetList in AR System

"Jdbc-Row-Limit" in AR System

This parameter has been introduced from version 20.02 ahead.

To improve performance, an administrator can restrict the number of rows that can be retrieved from the Remedy AR System database. For this, a new CCS parameter (Component Type: com.bmc.arsys.server.shared)  named Jdbc-Row-Limit is added in Remedy AR System. The Jdbc-Row-Limit parameter ensures that there is no adverse impact on IT Service Management solution because of any inadvertent changes to the rowLimit parameter in Remedy Smart Reporting. For more information visit below document.
https://docs.bmc.com/docs/itsm2002/20-02-enhancements-909627536.html

 

"rowLimit" in Smart Reporting

1. Log on to the Mid-Tier as the reporting administrator, and launch to Mid-Tier with report admin and launch Smart Reporting console
2. Go to Administration > Admin Console > Data Sources
3. Open the AR System data source
4. Expand Connection Settings, update the row limit in the Custom Parameters option:

Before:

refreshCache=10;DateTimeFormat=MM/dd/yyyy HH:mm:ss a;DateFormat=yyyy-MM-dd

refreshCache=10;DateTimeFormat=MM/dd/yyyy HH:mm:ss a;DateFormat=yyyy-MM-dd;rowLimit=50000;

 


"Max Entries Returned by GetList" in AR System

This setting applies for versions below 20.02

In the case that no rowlimit is defined in SR, the amount data to be retrieved is defined by the "Max Entries Returned by GetList" in AR. By default, this is set to 2000. And, in the case that the rowlimit parameter is defined in Smart Reporting, the "Max Entries Returned by GetList" in AR defines the chunk size instead. In this case, setting a rowlimit = 10,000 while having Max Entries Returned by GetList = 2000, means that data will be retrieved in chunks of 2000.

To define data restrictions in AR System server:

1.    Log on to BMC Remedy IT Service Management.
2.    Choose Applications> AR System Administration> AR System Administration Console.
3.    Choose System > General > Server Information.
4.    On the Configuration tab of the Server Information page, modify the value of the Max entries returned by GetList field. This field sets a row limit for any query sent using the JDBC driver.