If you are unable to create a new account, please email support@bspsoftware.com

 

Validate a report gives "XQE-PLN-0001 Internal error. The query could not be pla

Started by Sunchaser, 19 Jul 2019 01:05:14 PM

Previous topic - Next topic

Sunchaser

Hi All,

I have a report that have been created a long time ago in Cognos 8, then migrated to Cognos 10, then now in Cognos 11.
It is working perfectly fine in Cognos 10, and the validation of this report gives only a warning "XQE-WRN-0018 The dimensionInfo in V5 query has been deprecated. The query will be planned regardless of dimensionInfo.". Warning I've never been able to solve, and that is not blocking for Cognos 10.

Now in Cognos 11. when trying to validate, the only message I get is "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.NullPointerException ".
I have checked all queries: they are all working when using "view tabular data". No errors, some data are displayed, etc...

Does anybody know how to solve this?
Any help, advice, etc.. will be appreciated...
Thanks!
Vinc

saumil287

Hello,

Instead of directly deploying from cognos 8 to cognos 11, First deploy it to cog 10, since your rep is working in cog 10, then from 10 deploy it to 11, The issue might be because the components that is used in cog 8 might have been deprecated in cognos 11, and that's issue is of cognos xml of report.


Sunchaser

Hi saumil287,

Thanks for your answer.

As I said: "Cognos 8, then migrated to Cognos 10, then now in Cognos 11." So, yes, the report was first in Cognos 10 before being in Cognos 11.

The problem is solved now, and I copy here what I answered also in another forum:
. Some data-items where containing things like "NVL(my_field_as_number, 0)", for example. Or a "TO_CHAR(my_date_field, 'dd-Mon-YY')".
I just moved this code to the SQL source - (I'm using direct SQL) - so that they are a part of the direct SQL itself.
So, I would tend to say to others with the same error message: review carefully each of your data-items, and don't trust the fact that you can view the tabular data.

;)
Vinc