IBM Support

PI93776: INVALID DATA CONVERSION WITH SQL ERROR ERRORCODE=-4461 SQLSTATE=42815 AND ROUTED TO BACK OUT QUEUE

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.

Direct link to fix

 

APAR status

  • Closed as program error.

Error description

  • Invalid data conversion with SQL error ERRORCODE=-4461,
    SQLSTATE=42815 and routed to Risk management back out queue.
    
    
    <?xml version="1.0" encoding="UTF-8"?>
    <ibmPaymentsDirectorBridge>
    <header>
      <msgDesc>Service_Request</msgDesc>
      <msgType>cancelBatch</msgType>
      <version>1.0.0</version>
      <messageTime>2018-02-08T12:13:38.584-05:00</messageTime>
      <sourceId>TransactionServer</sourceId>
      <destinationId>Risk Management</destinationId>
      <unitOfWork type="PRESENTMENT_ID"
    track="true">XXXXXX</unitOfWork>
      <responseRequired>true</responseRequired>
    </header>
    <payload>
      <java version="1.7.0" class="java.beans.XMLDecoder">
       <object class="com.ibm.paydir.ima.txacc.app.bridge.
    PresentmentStatesEventPayload">
        <null/>
        <short>1</short>
        <null/>
        <null/>
       </object>
      </java>
    </payload>
    </ibmPaymentsDirectorBridge>
    
    Invalid data conversion: Requested conversion would result in a
    loss of precision of 279930. ERRORCODE=-4461, SQLSTATE=42815;
    State - 42815; Note: additional SQL statement shown
    

Local fix

  • n
    

Problem summary

Problem conclusion

  • A problem with a public method in PaymentMonitorXrefAccessor has
    been corrected.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI93776

  • Reported component name

    CHECK SERVICES

  • Reported component ID

    5725S7730

  • Reported release

    305

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-02-14

  • Closed date

    2019-11-11

  • Last modified date

    2019-11-11

  • 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

    ACH SERVICES FT

  • Fixed component ID

    5725S7630

Applicable component levels

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSPKQ5","label":"IBM Financial Transaction Manager"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"305","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
14 October 2021