IBM Cognos 10 Platform > Upgrading to Cognos 10

Text BLOB field getting cut off in DQM - Upgrade from 10.2.1 to 10.2.2 (DQM)

(1/2) > >>

Mauri:
Can someone please confirm that they are successfully able to view text BLOB fields in Cognos 10.2.2 reports published using Dynamic Query Mode?  We've been using them successfully from v8 - 10.2.1.  We have determinants set in Framework Manager so the issue isn't there.  When we publish outside of DQM in Framework (v10.2.2) we see the entire field.  When we publish in 10.2.2 using DQM, we don't get errors but the field gets cut off at 1024 characters and our actual BLOB fields are MUCH larger than that.  It is being recognized as a text BLOB in Framework Manger so i'm just wondering if this issue is on our side or if 10.2.2 published in DQM really does have issues with BLOB fields.

MFGF:

--- Quote from: Mauri on 18 Nov 2016 07:30:22 am ---Can someone please confirm that they are successfully able to view text BLOB fields in Cognos 10.2.2 reports published using Dynamic Query Mode?  We've been using them successfully from v8 - 10.2.1.  We have determinants set in Framework Manager so the issue isn't there.  When we publish outside of DQM in Framework (v10.2.2) we see the entire field.  When we publish in 10.2.2 using DQM, we don't get errors but the field gets cut off at 1024 characters and our actual BLOB fields are MUCH larger than that.  It is being recognized as a text BLOB in Framework Manger so i'm just wondering if this issue is on our side or if 10.2.2 published in DQM really does have issues with BLOB fields.

--- End quote ---

Hi,

Yep - DQM does this. For an explanation of why (and a workaround you can add in your FM model), see the below IBM Support Doc:

http://www-01.ibm.com/support/docview.wss?uid=swg21657723

Cheers!

MF.

Mauri:
Well, that's getting a bit closer!  Thanks for the info.  I'm now getting the following error:

XQE-PLN-0286
The second argument to the 'cast' function is a character data type with a size that exceeds 65535.

The expression is:  cast(substring([BLOB Data Item],1,93000) as varchar(93000))
I also tried:  cast(substring([BLOB Data Item],1,65000) as varchar(65000))

The BLOB text field is approx. 93K characters. :(  Its huge, I know.

MFGF:

--- Quote from: Mauri on 18 Nov 2016 08:58:41 am ---Well, that's getting a bit closer!  Thanks for the info.  I'm now getting the following error:

XQE-PLN-0286
The second argument to the 'cast' function is a character data type with a size that exceeds 65535.

The expression is:  cast(substring([BLOB Data Item],1,93000) as varchar(93000))
I also tried:  cast(substring([BLOB Data Item],1,65000) as varchar(65000))

The BLOB text field is approx. 93K characters. :(  Its huge, I know.

--- End quote ---

I believe 65535 is the largest size you can cast a varchar to. 93000 is simply too large. The second statement should work, though.

Cheers!

MF.

Mauri:
FYI, I ended up opening a ticket for this through IBM and they currently have an request for enhancement (RFE) open for this exact issue.  If you are experiencing the same issue, PLEASE go in and vote so this enhancement is included in the next Cognos release.

Here is the link to vote:  https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=89829

Navigation

[0] Message Index

[#] Next page