Skip to main content
Planview Customer Success Center

Issue in cognos filters

SYMPTOMS:
Every time we try to create a value prompt filter on the prompt page we get RQP-DEF-0577 and the drop down list of filter is not populated.
The error refers to "Prompts involving blob query items are not supported"


ERROR/WARNING MESSAGES:
RQP-DEF-0577. "Prompts involving blob query items are not supported"



REASON:
Cognos does not allow large text fields.


RESOLUTION:
Any time a custom SQL query is used to create a Cognos query subject, any large text field in it must be cast to something lower. You can use nvarchar(2048)). It’s not specific to filters; it’s query items in general.