IBM Support

IT41784: Error 410 when executing a select with connect by using an lvarchar from base table

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

  • Getting a SQL error on server. At first glance the issue seems
    to be related to the "col3 lvarchar" column.
    Tried to modify the column as "col3 char(2048)" it works. And
    with the "col3 lvarchar" column it is not working and getting
    sql error
    
    Output -
    
    > create table table_a1
      (
        col1_id serial not null,
        col2_id integer,
        col3 lvarchar,
        col4 char(1),
    > > > > > >     col5 integer,
        col6 char(1),
        col7 datetime year to second,
        col8 char(15),
        col9 char(1),
        col10 char(1),
        col11 integer,
        col12 integer
      ) extent size 32768 next size 32768 lock mode row;
    
    begin work;
    
    lock table table_a1 in exclusive mode;
    
    > > > > > > > >
    Table created.
    
    > >
    Started transaction.
    
    > >
    Table locked.
    
    > > load from table_a1 insert into table_a1;
    
    commit work;
    2 row(s) loaded.
    
    > >
    
    Data committed.
    
    
    
    > select n.* , level, connect_by_isleaf
    from table_a1 n
    start with col2_id = 224960  and col10 = 'Y'
    connect by prior col1_id = col11 ;> > >
    
      410: Prepare statement failed or was not executed.
    Error in line 4
    Near character position 30
    
    
    
    Product Version : IDS 14.10.xC8
    Tested in : IDS 14.10.xC8
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of Informix Server 14.10.xC7 and 14.10.xC8.            *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Informix Server 14.10.xC9.                        *
    ****************************************************************
    

Problem conclusion

  • Fixed in Informix Server 14.10.xC9.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT41784

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    E10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2022-08-16

  • Closed date

    2023-02-17

  • Last modified date

    2023-02-17

  • 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

    INFORMIX SERVER

  • Fixed component ID

    5725A3900

Applicable component levels

[{"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"E10"}]

Document Information

Modified date:
17 February 2023