INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

When a database has 2 tables with a primary key based on a FOT
index
an attempt to create an FK constraint between the 2 tables will
fail with

 alter table uno add constraint (foreign key (kk)
    references dos  constraint ix0_uno);
  245: Could not position within a file via an index.

  102: ISAM error:  illegal argument to ISAM function.
Error in line 2
Near character position 37


10:51:14  Assert Failed: item_to_hashval called with improper
item
10:51:14  IBM Informix Dynamic Server Version 12.10.FC6
10:51:14   Who: Session(79, informix@server, 7641, 0x4a9bc340)
                Thread(114, sqlexec, 4a97ac28, 1)
                File: rsshash.c Line: 74
10:51:14  stack trace for pid 5286 written to
/opt/informix/12.10.FC6/tmp/af.45a9c81
10:51:14   See Also: /opt/informix/12.10.FC6/tmp/af.45a9c81
10:51:16  item_to_hashval called with improper item
10:51:16  Assert Failed: Page Check Error in btposition:bad
btree node
10:51:16  IBM Informix Dynamic Server Version 12.10.FC6
10:51:16   Who: Session(79, informix@server, 7641, 0x4a9bc340)
                Thread(114, sqlexec, 4a97ac28, 1)
                File: rsdebug.c Line: 1142
10:51:16   Results: Possible inconsistencies in index
'a:"holgerk".uno#ix0_uno'
10:51:16   Action: Run 'oncheck -cI a:"holgerk".uno#ix0_uno'
10:51:16  stack trace for pid 5286 written to
/opt/informix/12.10.FC6/tmp/af.45a9c81
10:51:16   See Also: /opt/informix/12.10.FC6/tmp/af.45a9c81
10:51:18  Page Check Error in btposition:bad btree node
10:53:16  Checkpoint Completed:  duration was 0 seconds.

(oninit) afstack
(oninit) afhandler
(oninit) affail_interface
(oninit) item_to_hashval
(oninit) btrootnode
(oninit) btposition
(oninit) kposition
(oninit) rsstart
(oninit) fmstart
(oninit) chkintegrity
(oninit) perform_alter
(oninit) ddalter
(oninit) aud_ddalter
(oninit) excommand
(oninit) sq_execute
(oninit) sqmain
(oninit) spawn_thread
(oninit) th_init_initgls
(oninit) startup

****************************************************************
* USERS AFFECTED:                                              *
* Users creating Foreign Keys based on Forest of Trees Index   *
* in the referenced table.                                     *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Update to IDS 12.10.FC9 when available                       *
****************************************************************

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

17.10.2016
10.07.2017
10.07.2017

12.10.FC9