Clarity PPM: Export to CSV job failure when picklist is included for export

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Export to CSV jobs gets kicked off when trying to export more than 500 records. If Picklist columns are included in the fields and then exported, the Export to CSV job fails. 

Steps to Reproduce: 

1. Navigate to Modern UX 
2. Click on any object which has more than 500 instances of records. In this case, instances under any Custom Investment 
3. Create a new picklist - Color 
4. From the flyout menu, search for Color and check the box to add it to the display fields 
5. Make sure there are more than 500 records to download 
6. Click on the 'Export to CSV' icon on the top left 

Expected Results: The export completes successfully and can be downloaded from the Notifications on the top right corner. 

Actual Results: The notification shows the error - Could not export CSV. Under Reports and Jobs - Job log, the Export to CSV Job job would have failed. 

BG logs will have the below error  

ERROR 2021-07-14 12:54:32,173 [Dispatch Export to CSV Job : bg@servername (tenant=clarity)] niku.njs 
(clarity:user:16324039__A4265A49-CD2E-497F-A822-DB9EF8F4FD8B:Export to CSV Job) Error executing job: 5369190
java.lang.Exception: Export Job Failed: null
 at com.niku.njs.listeners.CSVExportJobListener.scheduledEventFired(CSVExportJobListener.java:217)
 at com.niku.njs.Dispatcher$BGTask.run(Dispatcher.java:746)
 at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
 at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
 at java.base/java.lang.Thread.run(Thread.java:834)  

Environment

Clarity PPM Version 15.9.2, 15.9.3 

Cause

DE61811 

Workaround: Remove the picklists from the selected fields when downloading to using Export to CSV. 

Resolution

Fixed in Release 16.0.0