Skip to content

BR Execution Parameters - Example Usages

This page gives some examples on situations when the BR Execution Parameters can be used, e.g. parameters mainly affecting server side SQL statement execution generated by IFS Business Reporter. The general execution parameters also affect SQL statements generated by other clients based on  Information Sources access.

Note: If the Published for BR Access Only check box is selected, then the report can only be executed via Order Report in report mode in IFS Business Reporter.

Published Report Takes Long Time To Execute

In this scenario we found that a published report takes a long time to execute. Possible actions are:

  1. Open the BR Report Level Execution Parameters page and populate the form with respect to the report identity that has the experienced problem. Check the Duration (sec) field to make sure that the report execution is really as bad as reported.
  2. Next use the DATA SETS tab to find the data set that consumes most of the execution time.
  3. Double click on the SQL Statement field to open a read-only dialog where the complete statement can be copied from.
  4. Paste the statement into a tool like e.g. PL/SQL Developer (or similar) to figure out what execution plan the Oracle optimizer is using. To find parameters values used, use the Go to Runtime Log command in the page header to navigate to the client runtime log window where more details can be found. However this requires that the BR Execution Parameter LOG_DURING_EXECUTION to be enabled.
  5. Try to figure out if any of the available execution parameter related functionality that can be used to enhance the execution. See General Tuning Advice.
  6. Make sure to open the BR Execution Parameters for Data Set page for the data set to be handled.
  7. Apply execution parameters, Save and use the Statement for Next Execution command to open a read-only dialog where the SQL statement with respect to current parameter settings will be presented. This is the statement that will be used in the next execution.
  8. Investigate that statement as described before or run the report again. This time only the enabled data sets will be executed.
  9. Test different parameters in the same was as described in previous bullets.
  10. Also read about general Tuning Advice.

Published Report Execution Has Been Interrupted

In this scenario there is a published report that takes a very long time to execute and the execution has been interrupted be the administrator or by a backup job. If the report execution has been interrupted, there will not be statistics available to find the data set or sets that takes most of the execution time.

  1. Open the BR Report Level Execution Parameters page and populate the form with respect to the report identity that has the experienced problem
  2. Now use the Disable All Data Sets command to disable execution of SQL statements for all data sets in the report.
  3. Make sure to enable server logging by enabling the BR Execution Parameter LOG_DURING_EXECUTION parameter.
  4. Run the report in the IFS client or in IFS Business Reporter (report mode) and go back to the report level parameter form to find out how many data sets that have been executed.
  5. Use the DATA SETS tab to copy some of the data set statements into e.g. PL/SQL Developer in order to evaluate the execution plan. By looking at estimated costs and IO reads in might be possible to find out if a specific statement will take long time to execute. It is of course also possible to execute the copied statements one-by-one and simply interrupt the execution if a statement takes really long time to execute. To find parameters values used, use the Go to Runtime Log command in the page header to navigate to the client log window where more details can be found.
  6. Another way is to enable one or maybe a few of the available data sets by modifying the Execute SQL Statement field to make sure that only the selected data sets will be executed. It is necessary to first make sure that the Execute SQL Statements field in the BR Report Level Execution Parameters page header has been enabled.
  7. Execute the report and go back to the report level parameter page and find out how long time it took to execute the enabled data sets.
  8. If nothing unexpected is found, enable one or a few more data sets and re-execute the report again. This is done until one or more statements are found that take long time to execute.
    Now these statements can be examined.
  9. Also read about general Tuning Advice.

Investigating Performance of Developed IFS Business Reporter Report

This scenario is related to a IFS Business Reporter designer that wants to test the performance of a newly developed report before publishing it to IFS Cloud for public use.

  1. Start by publishing the report for IFS Business Reporter access only. This action is handled in IFS Business Reporter and it means that the report is not available in IFS client but can be executed from Report Mode in IFS Business Reporter. After the execution there will be information available in the execution parameter pages.
  2. Start investigating number of statements and the time used for data set execution.
  3. Try to find the statement or statements that take most of the time (see previous cases).
  4. Perform actions like adding/modifying BR Execution Parameters and then run the report again from IFS Business Reporter. It is not necessary that all data sets are enabled for SQL execution, if the intention is to make sure that it so far works ok with respect to performance when executed from IFS Business Reporter. The report output and layout is a later issue to address. If not all data sets in the report has been examined, then continue the analysis as described previously.
  5. Also read about general Tuning Advice.