Tell me more ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.
up vote 3 down vote favorite

I'm quite familiar with the ArcSDE model and a few days ago we have major power issues here.

My problem (and this is a BIG one) is that one of the users, made thousands of edits correcting data, and I can't reconcile his tables.

I get a message saying that a certain feature class had a state lock. Ok, I look into Oracle, and I can see the locks, just fine. But it's the lock applied when I start the edition to reconcile.

I've tried several approaches. I'm even wondering if I could delete that specific lock from the table and try to reconcile. I tried sdegdbrepair, using the diagnose command, but it gives me 0 tables with problems.

Edit

The specific message is: Underlying DBMS error [owner.featuerclass][state_id = 12007].

Do you guys have ANY suggestions at all?

Could this be a permission on dbms problem? I'm at Oracle 11g.

Thanks!

share|improve this question

1 Answer

up vote 3 down vote accepted

I am not sure I understand the "But it's the lock applied when I start the edition to reconcile" remark but what I'd do in that case is have all users close edit sessions and disconnect from db (close ArcMap and ArcCatalog, stop AGS services if any), then remove locks and try again.

share|improve this answer
And if that doesn't work, then George is probably going to have to manually edit rows in multiple tables to return things to a normal state, which could require ESRI's assistance. – Michael Todd Oct 6 '10 at 14:07
For removing locks in an unused db ? Not gonna happen. – GuillaumeC Oct 6 '10 at 15:32
1  
We had a similar problem a couple of years ago and ended up having to manually edit the database tables so get it back to the correct state. ESRI helped us with exactly what to do, I wouldn't mess with the tables if thay haven't helped us. I don't remember the details though. – MathiasWestin Oct 6 '10 at 15:34
Hello guys. I could get in touch with ESRIs support because of the urgency in which we needed to get things back on track. What i did is to export the edited area (fortunately, it was a separate geographic area) and then deleted the problematic version, and loaded all over again. We lost some edits, but not as many as we would. – George Oct 6 '10 at 19:17
@George Surgery in the field is never fun. – Michael Todd Oct 7 '10 at 1:38
show 1 more comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.