topic Re: Insert Fails at 1000 records in ArcObjects SDK Questions

Insert Fails at 1000 records

MichaelFischer — Fri, 11 Jun 2010 17:34:14 GMT

I'm trying to insert a number of points into an ArcSDE 9.3.1 gdb, in an edit session

I've found that at 1000 features, I get an exception HRESULT: 0x8005018B

This only happens on SDE .. a personal GDB is fine.

I've tried flushing the load cursor at 500 record intervals, but no difference.

Any ideas?

Thanks

Re: Insert Fails at 1000 records

AlexanderGray — Fri, 11 Jun 2010 19:00:19 GMT

Right off the bat seems like a problem with SDE or the RDBMS. Sounds like there is a buffer or temp table filling up or that has a max set on it. I am not really an SDE or Oracle guru but I would look in that direction.

Re: Insert Fails at 1000 records

KirkKuykendall — Mon, 14 Jun 2010 14:02:36 GMT

are you doing your inserts between IEditor.StartOperation and IEditor.StopOperation?

Re: Insert Fails at 1000 records

JamesGonsoski — Tue, 15 Jun 2010 14:10:08 GMT

It may or may not have anything to do with your issue, but check this help page on ArcSDE Initialization Parameters. Note the default size of the AUTOCOMMIT value.

Re: Insert Fails at 1000 records

JohnHauck — Tue, 15 Jun 2010 16:06:59 GMT

What type of underlying database? Is SDE also at 9.3.1? Can you post some example code? I tried a quick test with SQL Express and didn't see a problem with inserting 100,000 features.

Re: Insert Fails at 1000 records

RemigijusPankevicius — Wed, 16 Jun 2010 05:55:02 GMT

Must be that Oracle AUTOCOMMIT that is 1000 by default.
http://proceedings.esri.com/library/userconf/proc01/professional/papers/pap869/p869.htm

I've seen examples how to do that bulk inserts without DB tuning, at the cost of leaving transaction.