IBM Support

IC65482: A DRDA .NET PROGRAM FAILS WHEN THE PROJECTION LIST CONTAINS A BYTE FIELD WHICH IS NOT RETRIEVED

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

  • A .Net program fails when the projection list contains a BYTE
    field which is not retrieved.
    This reproduces only with BYTE fields > 1 MB.
    
    The program returns an error like:
    
    ERROR [58005] [IBM][Ifx.NET] SQL0902 An unexpected exception has
    occurred ...
    
    or it hangs when the row with BYTE > 1 MB is the last one.
    
    
    Example:
    
    create table mybyte
    (
      id serial,
      mb byte
    ) lock mode row;
    
    select id, length(mb) from mybyte;
    
         id (expression)
    
          1      1048576 => works
          2      1048577 => fails
    
    Code snippet:
    
      using (IfxCommand cmd = conn.CreateCommand())
      {
    
         cmd.CommandText = "select id,mb from mybyte where id = 2
    order by id desc";
    
         using (IfxDataReader reader = cmd.ExecuteReader())
         {
            try
            {
              while (reader.Read())
              {
                 //retrieve column id only
                 Console.WriteLine("id = {0}", reader[0]);
              }
            }
            catch (Exception ie)
            {
               Console.WriteLine("DataReader: "+ie.Message);
            }
         }
      }
    
    Output from program:
    
    id = 2
    id = 1
    DataReader: ERROR [58005] [IBM][Ifx.NET] SQL0902 An unexpected
    exception has occurred ...
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * User with CLI based clients and having TEXT/BYTE columns.    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * When clients based on CLI are using byte or text data in     *
    * fetch, client application can hang or return protocol error. *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to 11.50.xC7 and above.                              *
    ****************************************************************
    

Problem conclusion

  • Problem first fixed in 11.50.xC7
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC65482

  • Reported component name

    IBM IDS ENTRP E

  • Reported component ID

    5724L2304

  • Reported release

    B15

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-01-08

  • Closed date

    2010-10-01

  • Last modified date

    2010-10-01

  • 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

    IBM IDS ENTRP E

  • Fixed component ID

    5724L2304

Applicable component levels

  • RB15 PSN

       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":"B15","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
01 October 2010