IBM Support

IT29376: SET ENCRYPTION PASSWORD AND CALLING ENCRYPT_AES IN PROCEDURE FROM TRIGGER STORED PROCEDURE CAN ASSERT

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

  • The following failures can occur running IDS 12.10.FC12W1 and
calling a trigger
that calls a stored procedure that does a set encryption
password and then utilizes
the encrypt_aes() function.

Common stacks are like:

0x0000000001422ac9 (oninit) afstack
0x00000000014265b1 (oninit) mt_ex_throw_sig
0x000000000142f723 (oninit) afsig_handler
0x0000003ddfa0e4c0 (Linux) <signal frame>
0x000000000061b406 (oninit) init_cbs
0x0000000000623e65 (oninit) itexecinit
0x00000000005fb2cf (oninit) excommand
0x0000000000a49fcc (oninit) sq_execute
0x0000000000b0d281 (oninit) sqmain
0x000000000154feab (oninit) spawn_thread
0x0000000001414500 (oninit) th_init_initgls
0x0000000001459f57 (oninit) startup

0x0000000001422ac9 (oninit) afstack
0x00000000014265b1 (oninit) mt_ex_throw_sig
0x000000000142f723 (oninit) afsig_handler
0x0000003ddfa0e4c0 (Linux) <signal frame>
0x000000000061b406 (oninit) init_cbs
0x000000000061c0b3 (oninit) init_cbs
0x0000000000623e65 (oninit) itexecinit
0x00000000008c65b1 (oninit) evalwhen
0x00000000008c6e4b (oninit) dotrigs
0x00000000008c7450 (oninit) ferafttrig
0x00000000008bc95e (oninit) dodmlrow
0x00000000008be240 (oninit) dodelupd
0x00000000005fe063 (oninit) excommand
0x0000000000a49fcc (oninit) sq_execute
0x0000000000b0d281 (oninit) sqmain
0x000000000154feab (oninit) spawn_thread
0x0000000001414500 (oninit) th_init_initgls
0x0000000001459f57 (oninit) startup

and a customer reported stack also like:

0x0000000001422ac9 (/opt/informix/bin/oninit) afstack
0x00000000014265b1 (/opt/informix/bin/oninit) mt_ex_throw_sig
0x000000000142f723 (/opt/informix/bin/oninit) afsig_handler
0x0000003c8100f7e0 (Linux) <signal frame>
0x000000000061b406 (/opt/informix/bin/oninit) init_cbs
0x000000000061c0b3 (/opt/informix/bin/oninit) init_cbs
0x000000000061c0b3 (/opt/informix/bin/oninit) init_cbs
0x000000000061c0b3 (/opt/informix/bin/oninit) init_cbs
0x000000000061c0b3 (/opt/informix/bin/oninit) init_cbs
0x000000000061c0b3 (/opt/informix/bin/oninit) init_cbs
0x000000000061c0b3 (/opt/informix/bin/oninit) init_cbs
0x000000000061c0b3 (/opt/informix/bin/oninit) init_cbs
0x000000000061c0b3 (/opt/informix/bin/oninit) init_cbs
0x000000000061c0b3 (/opt/informix/bin/oninit) init_cbs
0x000000000061c0b3 (/opt/informix/bin/oninit) init_cbs
0x000000000061c0b3 (/opt/informix/bin/oninit) init_cbs
0x000000000061c0b3 (/opt/informix/bin/oninit) init_cbs
0x000000000061c0b3 (/opt/informix/bin/oninit) init_cbs
0x000000000061c0b3 (/opt/informix/bin/oninit) init_cbs
0x000000000061c0b3 (/opt/informix/bin/oninit) init_cbs
0x000000000061c0b3 (/opt/informix/bin/oninit) init_cbs
0x000000000061c0b3 (/opt/informix/bin/oninit) init_cbs
0x000000000061c0b3 (/opt/informix/bin/oninit) init_cbs
0x000000000061c0b3 (/opt/informix/bin/oninit) init_cbs
0x000000000061c0b3 (/opt/informix/bin/oninit) init_cbs
0x0000000000623e65 (/opt/informix/bin/oninit) itexecinit
0x00000000008c65b1 (/opt/informix/bin/oninit) evalwhen
0x00000000008c6e4b (/opt/informix/bin/oninit) dotrigs
0x00000000008c7450 (/opt/informix/bin/oninit) ferafttrig
0x00000000008bc95e (/opt/informix/bin/oninit) dodmlrow
0x00000000008be240 (/opt/informix/bin/oninit) dodelupd
0x00000000005fe063 (/opt/informix/bin/oninit) excommand
0x0000000000a49fcc (/opt/informix/bin/oninit) sq_execute
0x0000000000b0d281 (/opt/informix/bin/oninit) sqmain
0x000000000154feab (/opt/informix/bin/oninit) spawn_thread
0x0000000001414500 (/opt/informix/bin/oninit) th_init_initgls

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED:                                              *
* Users of IDS versions prior to 12.10.xC14.                   *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* Setting encryption password and calling encrypt_aes in       *
* procedure from trigger can cause assert failure.             *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************

    



Problem conclusion


    

  • Fixed in IDS 12.10.xC14.

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    IT29376
    • 

  • 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
    2019-06-07
    • 

  • Closed date
    2019-09-23
    • 

  • Last modified date
    2019-09-23
    • 





    

  • 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


    








      
              
                            

              

              [{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            23 September 2019
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback