Access Keys:
Skip to content (Access Key - 0)

Cognos authorizations errors

If you do not have sufficient authorization to run a Cognos report, you will receive an error:

An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'.

Click on the Details link, to see the full text of the error. If this is an authorizations error, the error message will include:

table or view does not exist

The error message may be buried inside some additional text, such as

UDA-SQL-0107 A general exception has occurred during the operation "prepare".
ORA-00942: table or view does not exist


  • For authorization issues, contact the Central Authorizer team, at
  • If the error message does not include table or view does not exist, contact

Escalations info for Help Desk Business Help team

[se:For helpstaff - Cognos authorizations errors]

IS&T Contributions

Documentation and information provided by IS&T staff members

Last Modified:

January 14, 2016

Get Help

Request help
from the Help Desk
Report a security incident
to the Security Team
c-cognos c-cognos Delete
sql sql Delete
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.
This product/service is:
Easy to use
Difficult to use

This article is:
Adaptavist Theme Builder (4.2.3) Powered by Atlassian Confluence 3.5.13, the Enterprise Wiki