MUX Native Report CSV Export Fails with NPE for Column Alias Over 26 Characters

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

When using the new Native Reporting module in the Modern UX (MUX), exporting a report to CSV fails with a java.lang.NullPointerException. In PostgreSQL environments, if a query based Data Provider utilizes a column or attribute alias name exceeding 26 characters, the reporting  fails to process data for that long alias.

Steps to Reproduce:

1. Navigate to the Modern UX and open the new reporting module.
2. Access a report built on a custom query based Data Provider containing a column alias name that exceeds 26 characters.
3. Enable the total row functionality in the report layout settings.
4. Click on the action to export the report to a CSV file.

Expected Results: The report should display the total row successfully, and exporting to a CSV file should complete without errors.

Actual Results: Total values fail to display when the total row is enabled, and the CSV export job fails with error: FAILED due to a java.lang.NullPointerException at CSVResponseBuilder.modifyMetadataListWithAggrFields.

Workaround:

• Disable the Totals / Grand Totals option within the report configuration settings.
• Attribute alias names are restricted to 26 characters or fewer.

Environment

Clarity 16.4.1 and 16.4.2

Cause

Due to DE209019

Resolution

Engineering is reviewing DE209019