COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: bibat on 06 Dec 2010 08:42:20 AM

Title: Framework Error RQP-DEF-0177 (Table not found in dictionary)
Post by: bibat on 06 Dec 2010 08:42:20 AM
Hi friends,

I need some urgent help in framework modelling.

We have two instances on cognos installed in single server (Dev and QA).
I designed a framework Model in dev and then exported the same to QA.
Data sources connections are already defined but gives following error after i export model from DEV to QA.

RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-201'.
UDA-SQL-0196 The table or view "Table" was not found in the dictionary.   ???

Any suggestions plz...
--Bibat

Title: Re: Framework Error RQP-DEF-0177 (Table not found in dictionary)
Post by: cognostechie on 06 Dec 2010 03:15:18 PM
This would happen when the schema of QA is different than that of DEV. Check the data source connections to see where the QA is pointed to and check if that table exists in the schema.