Troubleshooting
Problem
User clicks 'Maintain - Rights - Reports'. The 'User Rights and Security Group Reports' selection box appears. User ticks/selects (checks) the option 'Menu Groups' (inside the Security Group Reports' sectuon). User clicks 'Preview' button. When the 'User Rights and Security Group Reports (Preview)' windows appears, user receives error message.
Symptom
The problem only affects some (very few) standard reports.
- In addition, it only affects some selections inside those standard reports.
Example
The problem is seen if the user ticks the option 'Menu Groups' inside 'User Rights and Security Group Reports':
- [HOWEVER, if you only tick 'User Groups' and 'Users' (in other words, you do not tick 'Menu Groups'), then the report will run successfully].
Below is the error seen (when you tick 'Menu Groups'):
User Rights and Security Group Reports (Preview)
IBM Cognos 8 Help
RQP-DEF-0177
X An error occurred while performing operation 'sqlPrepareWithOptions' status='-56'.
Details
UDA-SQL-0115 Inappropriate SQL request.UDA-SQL-0564 [Microsoft OLE DB Provider for SQL Server]Deferred prepare could not be completed.UDA-SQL-0564 [Microsoft OLE DB Provider for SQL Server]Statement(s) could not be prepared. (SQLSTATE=42000, SQLERRORCODE=8180)UDA-SQL-0564 [Microsoft OLE DB Provider for SQL Server]Invalid object name 'cognos.crdConnectedUsersSub'. (SQLSTATE=42S02, SQLERRORCODE=208)RQP-DEF-0149 The query specification is incorrect.RQP-DEF-0457 Referenced Query 'QueryConnectedUsers' is not defined or its query items contain unresolved references.RSV-SRV-0042 Trace back:....
[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.2.0;10.1.1;10.1;8.5.1;8.5;8.4;8.3","Edition":"All Editions","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSMRTZ","label":"IBM Cognos Controller on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
09 May 2025
UID
swg21378301