IC78112: AUTO-UPGRADE OF SPATIAL DATABLADE DURING MIGRATION TO 11.70.XC3 DOES NOT WORK

APAR status

• Closed as program error.

Error description

• The auto-upgrade of the Spatial Datablade during migration to
  11.70.xC3 does not work.
  
  sysblderrorlog contains the following messages after the
  auto-upgrade failed:
  
  select * from sysblderrorlog
  where err_expected = 'unexpected';
  
  order          135
  bld_id         spatial.8.21.FC4R1
  err_operation  SYSBldRegister
  err_expected   unexpected
  err_sql_stmt   create procedure SE_HDRLogReq(lvarchar)|  with
  (not variant)|  e
                 xternal name|
  '$INFORMIXDIR/extend/spatial.8.21.FC4R1/spatial_h
                 dr.bld(SE_HDRLogReq)'|  language c;
  err_sql_state  XIX000:-673 : Another routine (se_hdrlogreq) with
  same signature
                  already exists in database.
  
  order          136
  bld_id         spatial.8.21.FC4R1
  err_operation  SYSBldRegister
  err_expected   unexpected
  err_sql_stmt   EXCEPTION
  err_sql_state  Registration failed for DataBlade module
  "spatial.8.21.FC4R1".
  
  
  
  Beside this the manual upgrade to 8.21.xC4R1 is not possible.
  The blademanager drops and recreates it's tables but fails to
  re-insert the rows
  related to ifxrltree and spatial blade.
  
  The following tables are empty after the auto-upgrade failed.
  
    sysbldiprovided
    sysbldirequired
    sysbldobjdepends
    sysbldobjects
  
  This prevents the manual upgrade of the spatial datablade.
  The blademanager requires the registration of ifxrltree.2.00
  because it does not find the relevant entries in the tables
  listed above.
  But the ifxrltree objects are already present in the database.
  So it fails with the following error message:
  
  sirius1150ms_mig_shm>show last log
      blade: ifxrltree.2.00
  err expct: unexpected
   SQL stmt: insert into sysbldregistered| (bld_id)|values|(|
  "ifxrltree.2.00"|);
  SQL state: X23000:-268 : Unique constraint (informix.u104_56)
  violated.XIX000:-100 :  : ISAM error:  duplicate value for a
  record with unique key.
  
      blade: ifxrltree.2.00
  err expct: unexpected
   SQL stmt: insert into sysbldregistered| (bld_id)|values|(|
  "ifxrltree.2.00"|);
  SQL state: X23000:-268 : Unique constraint (informix.u104_56)
  violated.XIX000:-100 :  : ISAM error:  duplicate value for a
  record with unique key.
  
      blade: ifxrltree.2.00
  err expct: unexpected
   SQL stmt: EXCEPTION
  SQL state: Registration failed for DataBlade module
  "ifxrltree.2.00", recovery was unsuccessful.
  

Local fix

• Unload tables sysbldiprovided, sysbldirequired, sysbldobjdepends
  and sysbldobjects before migration and reload it after
  migration.
  Use condition "where bldi_id like 'ifxrltree%' or bldi_id like
  'spatial%' ".
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Spatial 8.21 with IDS 11.50 or 11.70                         *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * IDS 11.50 or 11.70 with spatial index/data is unable to      *
  * upgrade to next release.  Online.log would show failure      *
  * during RTREE conversion and cause following re-register of   *
  * any blade to fail.                                           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Either request a patch for ids00233409 or ids00233656, or    *
  * wait for the fixpack of 11.70.xC5 and 11.50.xC10.            *
  ****************************************************************
  

Problem conclusion

• RTREE conversion is not necessary to upgrade RTREE version since
  no change after 9.40, that conversion problem was exposed after
  sysbld cleanup issue was fixed. The fix will skip RTREE
  conversion when current version is greater than the latest
  version for RTREE change. This is fixed in ids00233409 for IDS
  11.70 and ids00233656 for IDS 11.50.
  

Temporary fix

Comments

APAR Information

• 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

  IFMX SPATIAL DB

• Fixed component ID

  5724C6100

Applicable component levels

• R821 PSN

     UP