COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: cogboy on 17 Sep 2007 05:23:02 PM

Title: Blob problem cant be solved
Post by: cogboy on 17 Sep 2007 05:23:02 PM
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
Title: Re: Blob problem cant be solved
Post by: COGNOiSe administrator on 18 Sep 2007 10:14:19 AM
Don't use BLOBs directly. What does the BLOB contain anyway?
Title: Re: Blob problem cant be solved
Post by: John Doe on 23 Sep 2007 06:55:39 PM
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.

Title: Re: Blob problem cant be solved
Post by: excelbase on 27 Sep 2007 07:42:31 AM
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