COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: inu on 10 Aug 2015 08:34:52 AM

Title: Getting error while trying to get more records in HTML
Post by: inu on 10 Aug 2015 08:34:52 AM
Hi Team,

I ran one report, got data as well, But if i click on "page down" for other more records , it throws error (blob error), please find the attached screen shot.

Can you please suggest me in this regards

Regards
Inam
Title: Re: Getting error while trying to get more records in HTML
Post by: MFGF on 10 Aug 2015 08:51:16 AM
Quote from: inu on 10 Aug 2015 08:34:52 AM
Hi Team,

I ran one report, got data as well, But if i click on "page down" for other more records , it throws error (blob error), please find the attached screen shot.

Can you please suggest me in this regards

Regards
Inam

It's an error from Oracle saying that an argument you are passing in a function call is not valid.

MF.
Title: Re: Getting error while trying to get more records in HTML
Post by: xyz on 12 Aug 2015 05:37:30 AM
Hi Inam,

We get this kind of error in Cognos, because of the data type for  particular column is set a BLOB in the database, which takes lot of space, basically I use sql server as my database, If I encounter such kind of error in cognos, in order to overcome the error I cast particular to some defined size. Example given below

cast(column, varchar(100))


Thanks & Regards,
XYZ