Method to terminate running report

IdentityIQ (IIQ) IIQ Discussion and Questions
,
1

Which IIQ version are you inquiring about?

Version 8.4P2

Please share any images or screenshots, if relevant.

N/A

Please share any other relevant files that may be required (for example, logs).

N/A

Share all details about your problem, including any error messages you may have received.

We have a report which is used to report on IdentityEntitlements called the Business Unit User Entitlement Detail Report. This report is designed to allow for a wide range of filters to report on entitlements related to certain users. The report can be run for all users or a department, all users of a particular application, users in a population, and many many other filters. The issue with this report is that we don’t have any single filter which we can make as required, however we do want users to select at least one filter. From what I understand of the reporting framework, we can make specific filters required, but there is no way to implement a pattern to ensure the user has at least used one or two filters. This all said, we have encountered issues where users run this report without specifying any filters, or have used filters which will return millions, or tens of millions of results. When this happens we have not found a clean way to terminate the running report. The report then runs for hours upon hours, due to custom fields on the report which require additional API calls. We’ve seen the report then cause blocking issues as it seems the original query issued to the DB remains open until the report completes successfully. We’ve had DBA’s have to kill the blocking query (which then terminates the report), but this leaves a large amount of data open in TempDB in SQLServer, causing TempDB issues.

A couple of questions here.

  1. Is there a clean way to terminate a running report? From the reports tab there is a “delete” option, however this doesn’t seem to terminate the running report as we’ve observed the queries used by the report still open in SQL Server.
  2. Is there a way on a custom report form to implement logic that specifies that “at least one filter” must be specified when running the report? Or getting a bit more fancy and have logic, if you’ve only selected filter A, you must then also select at least one other filter?
2

Hi kevin,

Can you go to debug and search for task results, and then search for your report task and delete from their. Once done, please allow couple of minutes, to see if he task is now killed. If still it is running, see on which server it is running, and take a bounce of the server. It should fix your issue.

In your form for custom report, you can put a validation script, for the user to atleast select one input, if they have selected one input, Please select another field. you can follow the below for reference.

<Field columnSpan="1" displayName="firstname" helpKey="firstname" name="firstname" type="string">
      <ValidationScript>
        <Source>
      if (value == null || value.isEmpty()) {
        if (form.getField("firstname").getValue() == null) {
          return "At least one name field must be filled";
        }
      }
      return null; 
    </Source>
      </ValidationScript>
    </Field>

Please mark this post as solution, if it answers your questions.

Regards
Naveen Kumar