RQP-DEF-0177 Error When Upgrading Reports

When you upgrade your report from IBM® Cognos® Business Intelligence, version 8.2, you encounter the following errors:

RQP-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.

This error occurs when the query requires local processing because some or all of its constructs are not supported by the database vendor. In IBM Cognos BI, version 8.2 and earlier, IBM Cognos BI proceeded with local processing. In version 8.3 and later versions, you must explicitly set the query Processing property to Limited Local in order to enable local processing.

Procedure

  1. In IBM Cognos Report Studio, pause the pointer over the query explorer button queries explorer icon and click the query.
  2. In the Properties pane, set the Processing property to Limited Local.
Parent topic: Upgrading Reports from IBM Cognos BI Version 8.1 or 8.2