IBM Support

RSV-VAL-0010 Failed to load the report specification. XQE-PLN-0098 The vendor specific function "X" is not supported.

Troubleshooting


Problem

RSV-VAL-0010 Failed to load the report specification. XQE-PLN-0098 The vendor specific function "X" is not supported. Where X could be any of the following functions:
a. to_char
b. chr
c. nvl
d. instr

Cause

The reports were working in CQM(Compatible Query Mode). The user started getting this error after conversion from CQM to DQM(Dynamic Query Mode)

Environment

This specific technote deals with Oracle as DB. But this could be any DB and any platform.

Diagnosing The Problem

Here report queries were going against two different Oracle database, and are being joined in the report. When Cognos has to join results from multiple database, it has to perform the join operation locally and this was causing the error.

Resolving The Problem

The report was using Oracle specific function like "to_char" in the join expression, and since the join cannot be pushed to the database the to_char function is failing.

Example SQL for DQM:

QueryA as (Select ColumnA from DatabaseA )

QueryB as (Select ColumnB from DatabaseB)

Select QueryA.ColumnA , QueryB.ColumnB

from QueryA, QueryB

where to_char(QueryA.ColumnA ) = QueryB.ColumnB <--"This will be proceed locally by Cognos."

 

CQM handles the query differently, it does not try and handle the to_char function in the join expression, it pushes it down in the Select Statement.

 

Example SQL for CQM

QueryA as (Select to_char(ColumnA) from DatabaseA )

QueryB as (Select ColumnB from DatabaseB)

Select QueryA.ColumnA , QueryB.ColumnB

from QueryA, QueryB

where QueryA.ColumnA = QueryB.ColumnB

 

DQM is stricter in terms of it's SQL rules. To workaround this,  you should move the to_char like function to the data item expression and not in the join expression or you can use the Cognos Cast function.

Document Location

Worldwide

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
29 July 2019

UID

ibm10961300

Page Feedback