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