Blob problem cant be solved

[cogboy]

Hi Everyone

I am facing following problem in my project and even work around given by cognos dint work.Can any one give me some guidance.

I am getting following error when i am using view in my model and one of the field is text(null).


Error is as foolows
BMT-MD-0003 UDA-SQL-0539 Blob data cannot be accessed in the context of a scrollable cursor because one of the following reasons: a view/stored procedure does not have unique indices, or the database does not allow use of IS NULL on expression


what should i do ?

Thanks

With Regards

Cogboy

[COGNOiSe administrator]

Don't use BLOBs directly. What does the BLOB contain anyway?

[John Doe]

The error is pretty clear.  Basically Cognos requires use of a key to reference a BLOB field.  The Query Subject will require a determinant reflective of this.

Because you are referencing the BLOB from a view, this isn't possible.

[excelbase]

Cogboy,
Firstly i will not use BLOB
Also
Since Framework Manager treats  Numeric fields without keys or indexes are treated as facts you may need to recheck the usage properties