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.
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: