IBM Support

IC94346: USING TIMESERIES AS A VARIABLE IN A STORED PROCEDURE GIVES AN ASSERT FAILED DURING CREATE PROCEDURE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • If you use a timeseries as a variable in a stored procedure the
    server fails with
    
    12:09:33  Assert Failed: No Exception Handler
    12:09:33  IBM Informix Dynamic Server Version 11.70.FC7W1
    12:09:33   Who: Session(5, informix@server, 22644, 0x4b83fd80)
                    Thread(57, sqlexec, 4b7fe488, 1)
                    File: mtex.c Line: 490
    12:09:33   Results: Exception Caught. Type: MT_EX_OS, Context:
    mem
    12:09:33   Action: Please notify IBM Informix Technical Support.
    12:09:33   See Also: /opt/informix/11.70.FC7W1/tmp/af.421a7dc
    
    in
    
    (Linux) <signal frame>
    (oninit) stcmpr
    (oninit) p_smdotted
    (oninit) p_smexpr
    (oninit) p_smassign
    (oninit) p_smstmt
    (oninit) p_smbegin
    (oninit) p_smstmt
    (oninit) p_smbegin
    (oninit) p_smproc
    (oninit) p_smstmt
    (oninit) spparse
    (oninit) parsecmd
    (oninit) sqcmd
    (oninit) sq_cmnd
    (oninit) sq_prepare
    (oninit) sqmain
    (oninit) spawn_thread
    (oninit) th_init_initgls
    (oninit) startup
    
    when you create this stored procedure
    
    CREATE PROCEDURE wrong_init();
    DEFINE p_myrowtype  timeseries(myrowtype);
    LET p_myrowtype.timestamp=current;
    END PROCEDURE;
    
    Row datatype:
    CREATE ROW TYPE myrowtype
    (
      timestamp datetime year to fraction(5),
      value decimal(9,3),
      status smallint
    );
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users on all platforms                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to 11.70.xC9 or 12.10.xC3 where a syntax error is    *
    * now reported as expected.                                    *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IC94346

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    C10

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2013-07-24

  • Closed date

    2017-06-09

  • Last modified date

    2017-06-09

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

  • RB70 PSY

       UP

  • RC10 PSY

       UP

[{"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":"","label":""}}]

Document Information

Modified date:
09 June 2017