Hello experts,
I have a report which works fine in Cognos 10.2 version but shows the below mentioned error when migrated to Cognos Analytics
'RSV-VAL-0010 Failed to load the report specification. XQE-PLN-0001 Internal error. The query could not be planned by the Query Service: java.lang.StackOverflowError '
Datasource is TM1 cubes
The report contains several lists on a page,out of which only the last one (summary) has a master detail relationship.
I tried everything- checking the conditional styles, report properties, keeping/removing masterdetail etc. but couldn't figure out the issue.
This report works absolutely fine in 10.2 version.
Any suggestion/idea on what am I missing? Or how cognos analytics is interpreting reports in a different way?
Please help.
Thanks in advance
I would start by ripping the report apart and trying to figure out where it is failing exactly. Some function call, some other reason. Look at it piece by piece and try to simplify the problem to isolate it.
It seems that there is probably something in there that is "a little odd" somewhere in the report and xqe doesn't know what to do with it. Tightening up of rules or something..
Ie start deleting stuff to the point where it starts to work, and slowly add stuff to see what breaks it.