IBM Support

UDA-SQL-0191 and RQP-DEF-0177 when testing a query subject in Framework Manager

Troubleshooting


Problem

When testing a query subject in Framework Manager, you receive the following error messages:

Symptom

RQP-DEF-0544 Metadata will be retrieved from the database, because table type is not set for the following query subjects(s): '[Database_view].[S_BU]'

UDA-SQL-0191 The column "BU_ID" was not found in the table or view "S_ASSET".
RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-205'.
UDA-SQL-0191 The column "BU_ID" was not found in the table or view "S_ASSET".

or:

This query contains an error and can not be executed.
It is recommended that you view the query feedback on the "Query Information" tab.

RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-205'.
UDA-SQL-0191 The column "c_name" was not found in the table or view "t_name".

[{"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Cognos Modeling v11x","Platform":[{"code":"PF033","label":"Windows"}],"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

swg22000065

Page Feedback