Advanced Analytics Export to CSV/PDF Generates Only Headers, No Data Rows

IdentityIQ (IIQ) IIQ Discussion and Questions
1

I’m facing an issue with Advanced Analytics in IdentityIQ 8.5.

Scenario:

  • Search Type: Identity
  • Advanced Analytics query returns results successfully.
  • Results are visible in the UI grid.
  • Selected columns include Username, Display Name, Email, First Name, etc.

Issue: When exporting the search results to CSV or PDF, the generated file contains only the column headers and no actual data rows.

image
image1919×565 96.5 KB

2

How did you log in to SailPoint? Did you use an administrator account or a user account with limited privileges? Also, is any scope assigned to these users?

3

Could you please provide more details about this?

4

I am logged in using the spadmin account, which has full administrator privileges. The issue occurs even with this administrator account.

The Advanced Analytics search returns results successfully and the identities are visible in the UI (for example, 45 identities returned). However, when exporting to CSV or PDF, the generated file contains only the column headers and no data rows.

There are no scopes assigned that would restrict visibility to these identities.

Additionally, the IdentityIQ database is MySQL Server 8.0.

Have you encountered any known issues or limitations related to Advanced Analytics exports in MySQL environments?

5

using the same database server locally, and I am not experiencing any issues. I tested it on my end, and it is working as expected. Could you please clear your cache, log out, log back in, and try again?

6

tried by using the new browser, clearing cache, restarted the server, logging in the Incognito tab and retried to export the data, and still getting the same issue.

7

@PrakashV Please check network logs to see if underlying API calls are failing, that should give us some directions.

8

can you try it in a different browser say chrom or edge or vice versa. I have just tried it as well, and for me also it works fine.

if it still not working, can you bonce tomcat??

9

Krish mentioned that this might be a timeout issue when downloading large datasets.
Export Advanced Analytics Search as a pdf

10

As an alternative, please try the User Details Report, as it is similar to your current process. Additionally, perform a full identity refresh with only the necessary options enabled, and then check if the issue persists.

11

Thanks everyone for the suggestions.

I have already tried the recommended troubleshooting steps:

  • Cleared browser cache and tested in different browsers (Chrome/Edge).
  • Restarted the Tomcat application server.

Unfortunately, the issue still persists.

Some additional observations:

  • The problem occurs only with Advanced Analytics searches of type “Identity”.
  • The search itself executes successfully, and the results are displayed correctly in the UI.
  • However, exporting the results to CSV or PDF generates a file containing only the column headers, with no data rows.
  • Other search types, such as Account, can be exported successfully to both CSV and PDF with all expected data included.

Based on this behavior, the issue appears to be specific to the Identity search export functionality rather than a general export, browser, or application server problem.

I will also review the network logs. If anyone has encountered this specifically with Identity exports in IIQ 8.5, please let me know of any additional troubleshooting steps or known fixes

12

Issue Resolved
Thanks everyone for the suggestions.

After reviewing the IIQ logs, I found the following error during Identity Advanced Analytics export:

SQL Error: 3065
Expression #1 of ORDER BY clause is not in SELECT list, references column 'identityiq.identity0_.name' which is not in SELECT list; this is incompatible with DISTINCT

Environment:
IdentityIQ 8.5
MySQL 8.0

The root cause was MySQL SQL mode having ONLY_FULL_GROUP_BY enabled.

After removing ONLY_FULL_GROUP_BY from the MySQL sql_mode and restarting the application, the Identity Advanced Analytics exports started working correctly and both CSV/PDF files were generated with all data rows.

This appears to be related to the query generated by the Identity export process, which is not compatible with MySQL 8 strict SQL mode.

Hopefully this helps anyone facing the same issue. Thanks again to everyone who helped troubleshoot this

13

Good catch! Please mark your answer as the solution so others can find it easily.