IBM Support

IT33709: ERROR 270 WHEN INSERTING TEXT/BYTE DATA INTO A REMOTE DATABASE

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

  • Using a cursor to insert blob data (TEXT/BYTE) into a remote
    database may fail with error:
    
       29056: Gateway cannot rollback savepoint (-270).
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of Informix Enterprise Gateway Manager 7.31.xD4 and    *
    * earlier versions.                                            *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Using a cursor to insert blob data (TEXT/BYTE) into a remote *
    * database may fail with error:                                *
    *                                                              *
    *    29056: Gateway cannot rollback savepoint (-270).          *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

  • Upgrade to EGM 7.31.xD5 if and when it becomes available or
    request a special build of 7.31.xD4.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT33709

  • Reported component name

    IFMX ENT GTWY M

  • Reported component ID

    5724C3100

  • Reported release

    731

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-07-27

  • Closed date

    2020-08-18

  • Last modified date

    2020-08-18

  • 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

    IFMX ENT GTWY M

  • Fixed component ID

    5724C3100

Applicable component levels

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSVT2J","label":"Informix Tools"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"731","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
20 August 2020