IBM Support

IT32345: ASSIGNING BLOB FIELDS TO A JSON PARSER RESULTS IN AN EMPTY VALUEIF THE LENGTH IS OVER 2047 CHARS

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • When assigning a BLOB field to a field in a JSON parser the
    result will be empty if the size of the BLOB is greater than
    2047 Characters.
    
    For example:
    
    CREATE LASTCHILD OF OutputRoot DOMAIN('JSON');
    
    SET OutputRoot.JSON.Data.Folder.message.content = myBlob;
    SET OutputRoot.JSON.Data.Folder.message.size = LENGTH(myBlob);
    
    
    Produces the following output if myBlob is larger than 2047
    chars:
    
    
    {"Folder":{"message":{"content":"{"Folder":{"message":{"content"
    :"","size":15005}}}
    

Local fix

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    All users of IBM Integration bus version 10 or App connect
    Enterprise version 11 using the JSON parser.
    
    
    Platforms affected:
    MultiPlatform
    
    ****************************************************************
    PROBLEM DESCRIPTION:
    <span style="background-color:rgb(255, 255, 255)">When assigning
    a BLOB field to a field in a JSON parser the </span><span
    style="background-color:rgb(255, 255, 255)">result will be empty
    if the size of the BLOB is greater than </span><span
    style="background-color:rgb(255, 255, 255)">2047 Characters.
                                                  </span>
    <span style="background-color:rgb(255, 255, 255)">
    
    </span>
    <span style="background-color:rgb(255, 255, 255)">For example:
                                                      </span>
    <span style="background-color:rgb(255, 255, 255)">
    
    </span>
    <span style="background-color:rgb(255, 255, 255)">CREATE
    LASTCHILD OF OutputRoot DOMAIN('JSON');                 </span>
    <span style="background-color:rgb(255, 255, 255)">
    
    </span>
    <span style="background-color:rgb(255, 255, 255)">SET
    OutputRoot.JSON.Data.Folder.message.content = myBlob;
    </span>
    <span style="background-color:rgb(255, 255, 255)">SET
    OutputRoot.JSON.Data.Folder.message.size = LENGTH(myBlob);
    </span>
    <span style="background-color:rgb(255, 255, 255)">
    
    </span>
    <span style="background-color:rgb(255, 255, 255)">
    
    </span>
    <span style="background-color:rgb(255, 255, 255)">Produces the
    following output if myBlob is larger than 2047 </span><span
    style="background-color:rgb(255, 255, 255)">chars:
                                                            </span>
    <span style="background-color:rgb(255, 255, 255)">
    
    </span>
    <span style="background-color:rgb(255, 255, 255)">
    
    </span>
    <span style="background-color:rgb(255, 255,
    255)">{"Folder":{"message":{"content":"{"Folder":{"message":{"co
    ntent"</span>
    <span style="background-color:rgb(255, 255,
    255)">:"","size":15005}}}
        </span>
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IT32345

  • Reported component name

    APP CONNECT ENT

  • Reported component ID

    5724J0550

  • Reported release

    B00

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-04-02

  • Closed date

    2020-05-21

  • Last modified date

    2020-05-21

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    APP CONNECT ENT

  • Fixed component ID

    5724J0550

Applicable component levels

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSDR5J","label":"IBM App Connect Enterprise"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
22 May 2020