Framework Manager issues in the DQM mode

Technote (troubleshooting)


Problem(Abstract)

A similar Framework Manager model returns validation errors in Dynamic Query Mode while works fine in compatible mode.

Symptom

A model designer can see any of below errors for queries which works fine in a compatible model:
BMT-MD-5002 The object <schema name> of type 'schema' does not exist in the database.
XQE-GEN-0018 Query Service internal error has occurred.
XQE-V5-0001 V5 syntax error found.


Cause

Dynamic Query Mode requires to have datasource name added to a query subject.

For example:
Select * from COUNTRY query may work in a classic model but will cause issues in DQM model.
Select * from [gosales].COUNTRY query will work in both classic and DQM model.

Resolving the problem

Add datasource name to all SQL queries whenever it is missing. For information on making the transition from the Compatible Query Mode to the Dynamic Query Mode in IBM Cognos 10 Business Intelligence, refer to the IBM Cognos 10 Dynamic Query Mode Migration Scenarios on IBM developerWorks at:

http://www.ibm.com/developerworks/data/library/cognos/upgrade_and_migration/bi/page568.html.


Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Cognos Business Intelligence
Framework Manager

Software version:

10.1, 10.1.1

Operating system(s):

Windows

Software edition:

Advanced, All Editions, Datacenter, Edition Independent, Enterprise, Essential, Foundation, Personal, Standard, Workgroup, Workstation

Reference #:

1611110

Modified date:

2012-11-13

Translate my page

Machine Translation

Content navigation