Cognos Migration Isssue

[raj.kanag.s]

Hi Guys,
            We are using SQL Server Database for Cognos Reporting.
Issue:
- Once DEV reports are migrated to QA Environment, When i try to run a report, I am getting an error message (ATTACHED)

Even though QA reports are pointing to QA DB, the error message shows object does not exist in DEV.

**** This error is quite confusing as QA reports are referring to DEV DB **********

Was that problem with Migration?????????

Thanks,
Raj

[bi4u2]

Raj,

Are your two environments using different versions of your Framework Model. Have you made modifications to the model in DEV that have not been promoted up to QA?

Cindy

[raj.kanag.s]

Cindy,
           This issue was resolved...

Issue:
         Two environments (DEV and QA) use the same Framework Model... The issue was , the catalog name corresponding to the DEV datasource was pointing to DEV DB... and hence when the same model was reused in QA, it was still referring to the DEV catalog name..

I manually removed the catalog name in DEV and published the same model for QA (ofcourse pointing to QA datasource :))

Thanks,
Raj