Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: kskanth on 27 Jul 2010 02:57:30 PM

Title: I am getting the following error while Im trying to edit and test the query item
Post by: kskanth on 27 Jul 2010 02:57:30 PM


RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-16'.

UDA-SQL-0107 A general exception has occurred during the operation "open cursor".
UDA-SQL-0327 An invalid object name was detected in the SQL request.
UDA-SQL-0333 The table "DFWRPT.SP_ZONES" was not found in the dictionary.


Can any one help me please...!
Title: Re: I am getting the following error while Im trying to edit and test the query item
Post by: tupac_rd on 27 Jul 2010 03:09:06 PM
I think,the userid you are using to qury the table from cognos, does not have access to that table DFWRPT.SP_ZONES

or

http://www-01.ibm.com/support/docview.wss?rs=3442&context=SS9RTN&q1=%2bUDA-SQL-0333&uid=swg21386684&loc=en_US&cs=utf-8&cc=us&lang=all
Text only | Text with Images