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
Don't use BLOBs directly. What does the BLOB contain anyway?
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.
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