COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: vgk on 11 Dec 2017 05:21:00 AM

Title: RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions
Post by: vgk on 11 Dec 2017 05:21:00 AM
Hi,

When i run the reports i am getting below error message.

RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-201'. UDA-SQL-0107 A general exception has occurred during the operation "columns". ORA-00942: table or view does not exist UDA-SQL-0196 The table or view "AGBPLDG"

Thanks,
Title: Re: RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions
Post by: Lynn on 11 Dec 2017 05:40:38 AM
Quote from: vgk on 11 Dec 2017 05:21:00 AM
Hi,

When i run the reports i am getting below error message.

RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-201'. UDA-SQL-0107 A general exception has occurred during the operation "columns". ORA-00942: table or view does not exist UDA-SQL-0196 The table or view "AGBPLDG"

Thanks,

The error message is telling you that you are trying to report on a table that does not exist in the database. Perhaps the connection information for the data source is incorrect (e.g., pointing to the wrong database or connecting with a signon that does not have privilege to the necessary tables).