"Could not export CSV" if an API Attribute ID contains the word offset

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Could not export CSV if the API Attribute ID contains the word offset on a column of the view being exported

STEPS TO REPRODUCE:

1. Go to the Idea common grid (or any other common grid, like Project Grid)
2. Actions > Export to CSV 
3. The export is successful
4. Go to Studio > Objects > Idea > Attributes
5. Create an attribute (string, money ...) and add the z_offset API Attribute ID (or any ID containing the word offset)
6. Add the new field to the Idea grid view in MUX
7. Actions > Export to CSV 

Expected Results: The export is successful
Actual results: Could not export CSV

Environment

Clarity 16.2.0, 16.2.1

Cause

This is caused by DE79695

Resolution

This is fixed in 16.2.2

Workaround: Update the API Attribute ID to remove the word offset, i.e. z_offet 

Additional Information

bg-ca.log file states:

ERROR 2024-02-19 04:07:22,556 [Dispatch Export to CSV Job : bg@myserver (tenant=clarity)] niku.njs (clarity:myuser:5595283__CDD7D12F-2B3C-47D6-A415-391393ABFF60:Export to CSV Job) () Error executing job: 5049075
java.lang.Exception: Export Job Failed: Cannot invoke "com.niku.union.odf.object.ODFObject.getDisplayName(String)" because "odfObject" is null
    at com.niku.njs.listeners.CSVExportJobListener.scheduledEventFired(CSVExportJobListener.java:330)
    at com.niku.njs.BGTask.run(BGTask.java:113)
    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
    at java.base/java.lang.Thread.run(Thread.java:833)
Caused by: java.lang.NullPointerException: Cannot invoke "com.niku.union.odf.object.ODFObject.getDisplayName(String)" because "odfObject" is null
    at com.niku.njs.listeners.CSVExportJobListener.updateJobFailureDetails(CSVExportJobListener.java:566)
    at com.niku.njs.listeners.CSVExportJobListener.scheduledEventFired(CSVExportJobListener.java:325)
    ... 4 more