QE-DEF-0030 QE-DEF-0360 2-part Reference

 I recently encountered this error in one of the crosstabs of a report I am editing:

QE-DEF-0030 Expression parsing error.

QE-DEF-0360 The query contains a reference to at least one object '[SQL2].[migratedColumn]' that does not exist. Possible cause is the use of 2-part reference to a model query item, which is a deprecated feature.

This happens when I run or preview the report. Tabular view of the query is ok and returns data.

The root query, let us call it YTD, has SQL as its source. The crosstab's query source, is using YTD as its source:

I check everything in the query and crosstab, including the data items for sorting, etc and everything seems to be ok. .Took me several hours to figure out what is wrong.

Turns out, I edited the SQL and somehow did not validate it. Validating the SQL made the error go away.

FM Datasource Configuration

I was having a little bit of a hard time figuring out why the numbers is my cognos report do not match with the data from my SQL Server query. After some tests, I realized I might not have same datasource. After some more checking, I noticed this configuration in my Framework Manager model:

I need to do some test again to describe my observations and infer what is happening.