IBM Support

QE-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-120'

Troubleshooting


Problem

Situation # 1: Running any report throws errors. Situation # 2: In Framework Manager, when trying to make a query subject based on two fact tables and a degenerate dimension throws errors.

Symptom

QE-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-120'.

UDA-SQL-0458 PREPARE failed because the query requires local processing of the data. The option to allow local processing has not been enabled.

For Situation # 1 (Report Studio) you may also see the following error:


UDA-SQL-0526 The DISTINCT clause is not supported by the database. This operation requires local processing of the data.


For Situation # 2 (Framework Manager) you may also see the following errors(s):


UDA-SQL-0462 The OLAP function 'sum' is not supported by the database. This operation requires
local processing of the data.


Switching to Limited Local processing on the data source and re-testing may then cause new errors:

QE-DEF-0177 An error occurred while performing operation 'sqlOpenResult' status='-28'.

UDA-SQL-0114 The cursor supplied to the operation "APICursor::OpenResult" is inactive.

UDA-SOR-0009 The key description is invalid.

[{"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Report Authoring v11x","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SS6G84","label":"IBM Cognos Analytics on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB77","label":"Automation 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.

Document Information

Modified date:
13 January 2026

UID

swg22000067

Page Feedback