English
Bug Number BUG-000091547
Submitted Oct 20, 2015
Modified Jun 11, 2020
Severity Medium
Applies To ArcSDE/Enterprise Geodatabase
Version Found 10.2.1
Prog Language N/A
Server Platform
Client Platform
Database Oracle
Locale N/A
Status Not in Current Product Plan
Version Fixed
SP Fixed

Bug BUG-000091547

Synopsis

Rebuild spatial index function on feature class property window failed with the following error, "Failed to add spatial index No shape selected or used".


Additional Information

Duplicate of NIM035228: See the KB article http://support.esri.com/en/knowledgebase/techarticles/detail/34984 The restored GDB provided by the customer was created Pre 9.2, upgraded later and contains a oracle generated type oid instead of default 'A618FA8DD1D84E13B35784E171530100'. The data was created using an antiquated st_geometry type. Upgrade does not (cannot) address this issue. There is no way to alter type set OID. This issue was addressed at 9.2 SP6/9.3. So, the only possible workaround to fix the data is: On a clean Oracle instance: - perform a fresh install of the SDE.ST_GEOMETRY type (enable or create GDB) with a current release of the software. - copy/paste the data from this instance using ArcGIS Desktop.


Alternate Solution