When trying to create or edit a section, user get an error similar to:
Domain index is marked LOADING/FAILED/UNUSABLE
Check the full error to see on which table/trigger this is failing. In this example the trigger was NM_POINTS_SDO_ROW so the table seemed to be NM_POINT_LOCATIONS.
To double check this and find the invalid domain indexes, run:
select index_name, table_name, owner, status, DOMIDX_status, domidx_opstatus from all_indexes where DOMIDX_opstatus is not null and DOMIDX_opstatus != 'VALID';
In this case this indeed returned NM_POINT_LOCATIONS.
Drop the index:drop index nm_point_locations_spidx
And then try to recreate it:
create index nm_point_locations_spidx on nm_point_locations(npl_location)indextype is mdsys.spatial_index
You may get an error that layer dimensionality does not match geometry directions. In this case first fine the layer's srid:
select srid from user_sdo_geom_metadata where table_name='NM_POINT_LOCATIONS'
Now find the geometries srid(s). THis should only return a single value:
select a.npl_location.sdo_srid, count(*) from nm_point_locations agroup by a.npl_location.sdo_srid
If it doesn't (returns null srid as well as the layer srid) you can change the geometries' srid by running the following (assuming that the layer's srid is 81989 and some geometries have null srids)
update nm_point_locations aset a.npl_location.sdo_srid=81989where a.npl_location.sdo_srid is null
Domain index is marked LOADING/FAILED/UNUSABLE error
Product TechNotes and FAQs
Bentley Technical Support KnowledgeBase
Bentley LEARN Server
Bentley's Technical Support Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!