XQE-GEN-0002 on upgrade report

Product:
Cognos Analytics 11.1.7 fix pack 2
Microsoft Windows 2019 server

Problem:

When run some reports after a upgrade from previous version you get a error like this:

XQEGEN0002 An unexpected exception occurred: java.lang.StackOverflowError.

Report validation is OK but when you try to run it as HTML report you get a error.

Possible solution:

Check the report specification for any item or function that is common for the reports that does not work.

Can be that you have a filter in the Query parameters that you need to remove from the report to make it work.

You need to remove one part of the report at a time to find what part of the report specification that can give you the issue.

More information:

https://www.njit.edu/finance/sites/njit.edu.finance/files/finance-innovations/Cognos%20Analytics%20Reporting.pdf

https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ug_ca_dshb.doc/ug_ca_dshb.pdf

https://reports.nycenet.edu/Cognos84sdk/documentation/en/ug_cr_rptstd.pdf

standard-deviation From the old Cognos 8
Returns the standard deviation of selected data items. The keyword “distinct” is available for
backward compatibility of expressions used in previous versions of the product.
Syntax
standard-deviation ( [ distinct ] expr [ auto ] )
standard-deviation ( [ distinct ] expr for [ all | any ] expr {
, expr } )
standard-deviation ( [ distinct ] expr for report )
Example
standard-deviation ( ProductCost )
Result: A value indicating the deviation between product costs and the average product cost.