Rebuild Indexes tool and Attribute Index limit

Question

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.

DanPatterson_Retired · Answer

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

rbae · Answer

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

DanPatterson_Retired · Answer

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