NIM012970 for No Product Found

Bug ID Number	NIM012970
Submitted	November 9, 2007
Last Modified	June 5, 2024
Applies to	No Product Found
Version found	9.3
Version Fixed	9.4
Status	Fixed

Description

Creating a partitioned local st_spatial_index in parallel fails with the following Oracle error:

"ORA-12801: error signaled in parallel query server P000"

and Oracle error:

"ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine".

The following is an example on how to create a partitioned local st_spatial_index index with the parallel argument set to a value of 2:

Code:
CREATE INDEX st_shape_index
  ON parcels (shape)
  INDEXTYPE IS sde.st_spatial_index
  LOCAL (PARTITION quarter1 PARAMETERS('st_srid=1 st_grids=280 TABLESPACE q1_idx'),
         PARTITION quarter2 PARAMETERS('st_srid=1 st_grids=280 TABLESPACE q2_idx'),
         PARTITION quarter3 PARAMETERS('st_srid=1 st_grids=280 TABLESPACE q3_idx'),
         PARTITION quarter4 PARAMETERS('st_srid=1 st_grids=280 TABLESPACE q4_idx'),
         PARTITION qunknown PARAMETERS('st_srid=1 st_grids=280 TABLESPACE qunknown_idx'))
  PARALLEL 2

Cause

An internal error in the sde.spx_util package (a unique constraint violation), during the creation of the partitioned local st_spatial_index, prevents the indexes from being created in parallel.