IBM Support

IC96581: REMOTE QUERY RETURNS 244/151 WITH A VARCHAR COLUMN

Subscribe

You can track all active APARs for this component.

 

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