IBM Support

IT32484: WHEN A STORED PROCEDURE WITH 250+ ARGUMENTS IS DEFINED FOR CONFLICT RESOLUTION THE TARGET MAY REPORT AN AF IN DSISTOREDPROCEDURE

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 in an ER primary target environment a replicate is defined
    with SP conflict resolution and the SP has a very large
    parameter list, the target may abort with:
    
    16:19:28  stack trace for pid 26241 written to
    /opt/informix/IBM/11.70.FC9/tmp/af.48f45f0
    16:19:28  Assert Failed: No Exception Handler
    16:19:28  IBM Informix Dynamic Server Version 11.70.FC9
    16:19:28   Who: Session(153, informix@hostname, 0, 0x116ca77b8)
                    Thread(167, CDRD_22, 116c757b8, 1)
                    File: mtex.c Line: 490
    16:19:28   Results: Exception Caught. Type: MT_EX_OS, Context:
    mem
    16:19:28   Action: Please notify IBM Informix Technical Support.
    16:19:28   See Also: /opt/informix/IBM/11.70.FC9/tmp/af.48f45f0
    16:19:30  Thread ID 167 will NOT be suspended because
              it is deemed too critical to the server.
    16:19:30   See Also: /opt/informix/IBM/11.70.FC9/tmp/af.48f45f0,
    shmem.48f45f0.0
    16:19:30  Starting crash time check of:
    16:19:30  1. memory block headers
    16:19:30  2. stacks
    16:19:30  Crash time checking found no problems
    16:19:30  mtex.c, line 490, thread 167, proc id 26241, No
    Exception Handler.
    
    
    0x0000000001331ae6 (oninit) afstack
    0x0000000001338cac (oninit) mt_ex_throw_sig
    0x00000000012df593 (oninit) afsig_handler
    0x00007fb7c375fb10 (Linux) <signal frame>
    0x000000000106b4f6 (oninit) dsiStoredProcedure
    0x0000000001065ecd (oninit) dsiResolverThread
    0x0000000000fb4ce1 (oninit) cdrTrampolineThread
    0x000000000132f870 (oninit) th_init_initgls
    0x00000000012fc3a7 (oninit) startup
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of Informix Server prior to 12.10.xC15 and 14.10.xC5.  *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Informix Server 12.10.xC15 (when available) or    *
    * 14.10.xC5.                                                   *
    ****************************************************************
    

Problem conclusion

  • Fixed in Informix Server 12.10.xC15 and 14.10.xC5.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT32484

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    C10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-04-07

  • Closed date

    2020-12-21

  • Last modified date

    2020-12-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

    INFORMIX SERVER

  • Fixed component ID

    5725A3900

Applicable component levels

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU029","label":"Software"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10"}]

Document Information

Modified date:
23 December 2020