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 # 2 (Framework Manager) you may also see the following errors(s):
Switching to Limited Local processing on the data source and re-testing may then cause new errors:
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":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Report Studio","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.2.2;10.2.1;10.2;10.1.1;10.1","Edition":"Edition Independent","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"}}]
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:
08 May 2025
UID
swg21341782