Avoid UDA-SQL-0220 error while using native SQL

[Sunchaser]

error: UDA-SQL-0220 A database key or unique index is required to access blob data.

Hi,

I would like to avoid an error to appear in the cogserver.log, but (strange thing) in the same time the report is running fine.
I'm working with CLOB fields, native SQL, and the datas are retrieved by a function table (oracle).
The table containing  the CLOB fields has a primary key, so when I try and use the "classical way" in Cognos to get my datas by selecting the fields in the insertable object of the model, there are no errors in the log.

I don't see what I can do to get rid of this error.

Thanks.

[Md37]

This might be really late, but if someone else runs into this, maybe this will help:

I was having the same problem using pass-through SQL, getting the same error. I added one column at a time, and finally it came to a column that in the database was set as a VARCHAR(MAX).  I talked to another guy here at work and he thought he saw something to the effect that Cognos will interpret a VARCHAR(MAX) as a blob.  I cast it as VARCHAR(4000) and the error went away.  Hope that helps.

[venkiatmaruthi]

Yes, I too experienced this error.

I too did the same thing like adding one column by column so that I have feedback description column where it is having CLOB as a data type at database side. Later DB team changed to Varchar(5000)  then it was set.


Thanks.