Reports failing with a "The maximum columns of 20 for this report has been exceeded. Requested number is 116"

[RobW]

Hi, is anyone else experiencing this with reports which were previously working up until yesterday?

Have encountered it on a couple of reports (both scheduled and manual) where reports which were working up until yesterday are showing as Failed and upon opening the csv/xls just get "The maximum columns of 20 for this report has been exceeded. Requested number is 116".

Admittedly the reports which failed are ones I inherited which export a lot of columns which we don't actually use in various daily/weekly/monthly reports (I doubt senior management care about the Activity Stream ID or the BPM ID columns somehow) so this is good motivation to pull my finger out and do some housekeeping to slash these reports back!

Thanks!

[Dan Munns]

We are also having this issue (although our report is 24 columns rather than 116 )

[HGrigsby]

This is happening for us too.  

Really need this to work as trying to run the monthly reports for stats that all have more than 20 columns

Helen 

[Deen]

@RobW @Dan Munns @HGrigsby This is a change that is covered in the latest ESP release notes:
 

• Stops the system from processing the reports further when the maximum is reached and to return an error report as the output. Updated the HTML templates for the reports so that the error message can be produced and displayed.

Now I believe that previously these reports would fail silently, if you correct the column count to match the configured limit there shouldn't be a problem.

[HGrigsby]

Thanks Deen

We have never had a limit before and not had issues running our reports, many of which have over 20 columns. The one below worked fine last week but not today.

thanks 

Helen

[Dan Munns]

@Deen same for us. Many reports that have worked fine for a number of years with over 20 columns suddenly don't work anymore. I cant find a place to change the column limit so assume that this is hard coded somewhere. 

This isn't a change in error reporting, it is a change of behaviour of reports. Can this be looked at urgently as I dont really want to have to create all our monthly ExCo reporting manually.

[Deen]

As a further update to this, we have temporarily upped the column limit to 200 and there will also be a fix in the next ESP release as the column restriction was not meant to apply to all report types.

[HGrigsby]

Thanks @Deen

Our reports now run.  We now have an issue where the reports fail when they hit 5000 rows, the report fails rather than stops at 5000 rows and ignores what we have set in api.xmlmc.queryExec.maxResultsAllowed  (25000)

Before these changes were made if the report was more than the limit it would return 25000 rows and stop, the current setting makes the report fail rather than collect 5000 and stop running.

Could you amend this setting too?

thanks

Helen 

[HGrigsby]

Sorry but something has changed again and I can no longer run the reports.   Back to the message about 20 columns

Please fix this

Helen

[Deen]

A patch was applied to all instances yesterday that should have resolved this issue for all affected instances.  Please let me know however if any issues persist.

[Dan Munns]

@Deen we are getting the limit again. Report with 31 columns is failing with the same message as last time. 

I have saved a copy of the report and removed a column and still have the issue.

[Victor]

@Dan Munns the PDF/HTML variant of the report will fail (meaning it is limited in the platform) if the generated outcome has more than 20 columns and/or 5000 rows. However this only applies to the PDF/HTML outputs. If the same report also has a CSV option, this should generate fine.

[Dan Munns]

@Victor can I up the limit for pdf? They use if for an ExCo report and it worked once (02/11) so they want it like that now.

Edit: Looking at the report it seems to have cut off everything past column 8 anyway so don't worry about it. I'll tell them that just like it is  

[Victor]

@Dan Munns I'm afraid the limit cannot be lifted nor changed