topic Rebuild Indexes tool and Attribute Index limit in Geoprocessing Questions

Rebuild Indexes tool and Attribute Index limit

rbae — Sun, 14 May 2017 00:26:02 GMT

The Rebuild Indexes tool seems to fail if a feature class or table has more than 8 attribute indexes (includes OBJECTID and GLOBALID) and the "ALL" option is used. "ONLY_DELTAS" works fine.

Does anyone know why there would be an 8 index limit?

ArcGIS 10.2.1, Oracle 11g.

Re: Rebuild Indexes tool and Attribute Index limit

DanPatterson_Retired — Sun, 14 May 2017 03:01:24 GMT

fail? what is the error?

all tables? or just one?

always at 8 if all tables?

I don't suppose you can test the same files on a more recent version of arcmap

Re: Rebuild Indexes tool and Attribute Index limit

rbae — Mon, 22 May 2017 03:10:45 GMT

Dan,

The error is the generic "DBMS Error", which doesn't tell us much about what might be going on. All the tables/feature classes that have more than 8 will fail - there are about 6 of them. All of those that have less work fine.

I am running this with ArcGIS 10.5 now and it does appear to be working fine. It gives a more detailed error message ("Specified Index does not exist") for 2 tables, so it does appear that there are some issues at the Database level.

Due to some feature class extensions, I would prefer to have this run at 10.2.1, but at least it looks like using 10.5 will be a reasonable workaround for now.

Thank you for your help

-Ryan

Re: Rebuild Indexes tool and Attribute Index limit

DanPatterson_Retired — Mon, 22 May 2017 03:14:44 GMT

no problem, at least you have narrowed the issue to the version specific level. I can't find anything useful on that generic error.