RS Error: An error occurred while performing operation 'sqlGetBlob' status='-9'

[kvchow]

Hi,

after running the report i am getting the data in the cognos viewer,but when i click on Bottom in the first page i am getting above error

Any Idea?

Thanks
Kvchow

[BigChris]

I don't think Cognos handles blob objects very well, although I don't have a lot of experience of them. Have you got an image or similar on the last page? Or possibly something like a notes field with a lot of data in it. Bit hard to tell I'm afraid - I'd be cutting things out of the report to see what causes it to fail...

[kvchow]

Hi Bigchris

Thanks for your reply
Here the problem is page by page i mean(click page down button) data is coming,but when i click on bottom only i am getting the error
How do i check the blob objects?

Thanks,
kvchow

[bdbits]

You should probably get some assistance from IBM if this is still an issue for you. Blobs can be problematic, especially if they are very large. We have implemented them for very long text here in one of our Oracle warehouses, but that developer is out at the IBM conference this week. I know there were some caveats that IBM helped work through.

I would pull the SQL and run it from the native query tool for your database (e.g. SSMS for SQL Server or PL/SQL for Oracle). You might also try removing the blob from the report and see if the report works normally, just to be sure the blob is the root problem.

[kvchow]

Hi,

Thanks BDbits

I will try you suggested method and i will keep posted you

Thanks,
Kvchow