APAR status
Closed as fixed if next.
Error description
The pattern of concatenation("||") of varchar by order-by, returns -244/151 generating an AF failure. 244: Could not do a physical-order read to fetch next row. 151: ISAM error: Illegal value in varchar length field 11.70> 20:43:22 IBM Informix Dynamic Server Version 11.70.FC7W2 Software Serial Number AAA#B000000 20:43:22 Assert Failed: uncompress_row: Column data length exceeds the maximum length 20:43:22 Who: Session(4, informix@server, 63234218, 7000000203cc6f8) Thread(54, sqlexec, 7000000203903e8, 1) File: rssupp.c Line: 2614 20:43:22 Action: Please notify IBM Informix Technical Support. 20:43:22 Raw hex dump of stack located in /usr2/support/products/11.70.FC7W2/tmp/af.41e28b9.rawstk 20:43:22 Stack for thread: 54 sqlexec (oninit)afstack (oninit)afhandler (oninit)affail_interface (oninit)uncompress_row (oninit)decompress_row (oninit)physical_scan (oninit)rsseqscan_read (oninit)fmseqscan_read (oninit)readseq_batch (oninit)readseq (oninit)gettupl (oninit)scan_next (oninit)getrow (oninit)fetchrow (oninit)exfetch (oninit)sql_nfetch (oninit)sq_nfetch (oninit)sqmain (oninit)listen_verify (oninit)spawn_thread (oninit)th_init_initgls (oninit)startup 11.50> 09:50:49 IBM Informix Dynamic Server Version 11.50.FC9W3 Software Serial Number AAA#B000000 09:50:49 Assert Failed: read_record: decompress_row, source = 0x70000000bfaf382, target = 0x700000073eb85b8 09:50:49 Who: Session(193, informix@server, 4580, 7000000709d2568) Thread(1330, sqlexec, 700000070992e10, 1) File: rsread.c Line: 3606 09:50:49 Results: Record not read 09:50:49 Action: Please notify IBM Informix Technical Support. 09:50:49 Raw hex dump of stack located in /informix/tmp/af.91a9069.rawstk 09:50:49 Stack for thread: 1330 sqlexec base: 0x0700000074bf7000 len: 135168 pc: 0x000000010005bc48 tos: 0x0700000074c15150 state: running vp: 1 (oninit)afstack (oninit)afhandler (oninit)read_record (oninit)gather_records (oninit)rsread (oninit)fmread (oninit)readseq_single (oninit)gettupl (oninit)scan_next (oninit)getrow (oninit)fetchrow (oninit)exfetch (oninit)sql_nfetch (oninit)sq_nfetch (oninit)sqmain (oninit)listen_verify (oninit)spawn_thread (oninit)startup
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * distributed queries with orderby * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.70.xC9 or earlier PID. * ****************************************************************
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
IC96581
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
B70
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2013-10-02
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 PSN
UP
RB70 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":"B70","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
09 June 2017