Hello everyone,
I'm running ArcSDE 10 SP1 with Microsoft SQL Server 2008 R2.
I've got some strange behavior in one of our utility feature classes. It's participating in a feature dataset, and when my editors create new features, the ObjectID they're getting assigned is out of sequence. For example, the first thirteen features all had objectID's of 1-13, but the fourteenth had an objectID of 413, and the fifteenth had an objectID of 813. It goes up by 400 each new feature. We had a similar problem with another feature class, except it would be two successive numbers before the big jump in ObjectID (412, 413, 812, 813, etc). This was fixed by exporting the feature class and bringing it back in so the ObjectID's were reassigned in the new feature class. Since this seems to be recurring at this point, I really want to know what's going on.
This hasn't caused any immediate problems but I'm curious if anyone knows what could be causing this behavior? I find it unsettling at the very least, and want to make sure it's not a symptom of a greater problem.
Thank you!