App Connect

 View Only
Expand all | Collapse all

while passing data to MQ we are getting .....data truncated to first 64 chars issue

  • 1.  while passing data to MQ we are getting .....data truncated to first 64 chars issue

    Posted Tue January 24, 2023 09:06 AM
    Hi Team, 

    While passing a Data to MQ we are getting below error, i am doing any kind of conversion and casting in this scenario just passing xml payload to MQ.

    Error: 
    RecoverableException
    File:CHARACTER:C:\ci\product-build\WMB\src\CommonServices\ImbConverter.cpp
    Line:INTEGER:733
    Function:CHARACTER:ImbConverterCPP::internalFromUnicode
    Type:CHARACTER:
    Name:CHARACTER:
    Label:CHARACTER:
    Catalog:CHARACTER:BIPmsgs
    Severity:INTEGER:3
    Number:INTEGER:2136
    Text:CHARACTER:Unconvertable character
    Insert
    Type:INTEGER:5
    Text:CHARACTER:1320
    Insert
    Type:INTEGER:5
    Text:CHARACTER:3c00650044004f0045006d00610069006c003e003c0062006f00640079003e003c00640065006c00690076006500720079004f00720064006500720075006d00 ...data truncated to first 64 chars
    Insert
    Type:INTEGER:2
    Text:CHARACTER:437

    ------------------------------
    Kaustubh Sawant
    ------------------------------


  • 2.  RE: while passing data to MQ we are getting .....data truncated to first 64 chars issue

    Posted Fri January 27, 2023 05:22 AM
    Hi Kaustubh.
    The error seems to happen while converting from Unicode to code page 437. As you say, it happens when writing message from ACE to MQ. So unless you have specified something in the CCSID field in your MQMD then I guess your MQ is running CCSID 437. 

    You could try to explicitly set the CCSID in MQMD of the message you're trying to write to the queue?
    Such as using a MQMD Header node or something like this in ESQL:
    SET OutputRoot.MQMD.CodedCharSetId = 1208; 

    Do you have any special characters in your XML structure?

    Cheers,
    Lars

    ------------------------------
    Lars Dehli
    ------------------------------