Print Page - XQE-PLN-0098 error while publishing package in FM

Title: XQE-PLN-0098 error while publishing package in FM
Post by: sunny8 on 29 Oct 2014 04:35:08 AM

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

Title: Re: XQE-PLN-0098 error while publishing package in FM
Post by: jayatu on 29 Oct 2014 05:44:49 AM

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

Title: Re: XQE-PLN-0098 error while publishing package in FM
Post by: sunny8 on 29 Oct 2014 08:15:11 AM

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

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: sunny8 on 29 Oct 2014 04:35:08 AM