UDA-SQL-0223 A sort is attempted on a blob or text field - Cognos FM

[kadarla1]

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

[saumil287]

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.