Unable to export to CSV (missing months) in NSQL portlet

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

I am exporting to CSV from a custom NSQL portlet. The data displays correctly in the portlet, however once I export, some of the months in future (columns) are not there (missing). Some of the months for the next year which show in the portlet are not exported to the CSV at all.

Environment

Release : Any

Resolution

The incomplete export to CSV happens when you have hit the governor limit on export to CSV. The default limit is 25k rows. You have two options:

• Filter your data more to go under the limit 
  or
• Increase the governor limit for CSV exports (Increasing Governor Limits)

Note that we do not recommend increasing the limit as it may lead to instability in the application. If you are using the portlet for data extract, we recommend using reports instead.