Print Page - UDA-SQL-0223 A sort is attempted on a blob or text field

Title: UDA-SQL-0223 A sort is attempted on a blob or text field - Cognos FM
Post by: kadarla1 on 22 May 2012 05:32:55 AM

Hi Gurus,

we are using cognos 10 with sql server 2008, recently we concerted our database form oracle to sql server.In our FM model we have some parameter maps and filters.
In FM while validating Data source query subject we are getting below error message.

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='-253'.
UDA-SQL-0223 A sort is attempted on a blob or text field.

Please help me ASAP..As it is very urgent.

Thanks in Advance,
kadarla

Title: Re: UDA-SQL-0223 A sort is attempted on a blob or text field - Cognos FM
Post by: saumil287 on 14 Jun 2012 04:39:15 AM

Hi,
Have you gone to the links below.
It says it is not possible to sort on Blob columns
https://www-304.ibm.com/support/docview.wss?uid=swg21342987&wv=1.
You have to do RND on these fields.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: kadarla1 on 22 May 2012 05:32:55 AM