XQE-PLN-0098 error while publishing package in FM

[sunny8]

Hi,

I'm facing issue in the cognos reports as "XQE-PLN-0098 - to_char function is not supported" some times. For this report I have connected to a dynamic query mode framework package. But, the same report I'm not facing this issue when it is connected to normal package without dynamic mode.

My Cognos version is 10.2, DB: Oracle 11g. Please help !!!!!

Thanks

[jayatu]

Hi Sunny8,

This is a limitation of DQM, Vendor Specific Relational Functions in a DMR Report is not supported in DQM.

Check out this link for details & other Dynamic Query Mode Migration Scenarios
http://www.ibm.com/developerworks/data/library/cognos/upgrade_and_migration/bi/page568.html

Jayatu

[sunny8]

Hi Jayatu,

But the model I'm using for this report is relational not DMR. Note that I'm facing the error only few times not all the time while running the report. Also, do we require to install any patches for dynamic query mode packages to work better in cognos.

Thanks