Rebuild Indexes tool and Attribute Index limit

732
3
05-13-2017 05:26 PM
rbae
by
New Contributor III

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.

0 Kudos
3 Replies
DanPatterson_Retired
MVP Esteemed Contributor

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

rbae
by
New Contributor III

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

0 Kudos
DanPatterson_Retired
MVP Esteemed Contributor

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