IBM Support

Framework Manager BMT-MD-5002 error when migrating from CQM to DQM

Technote (troubleshooting)


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


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.


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:

Document information

More support for: Cognos Business Intelligence
Framework Manager

Software version: 10.2, 10.2.1,, 10.2.2

Operating system(s): Windows

Software edition: Edition Independent

Reference #: 1611110

Modified date: 12 April 2017

Translate this page: