Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I'm working with a heavily customized version of ArcMap 9.3.1. It's heavily customized, but it mostly uses class extensions and special validations.

Environment:

  • ArcSDE installed in: linux, red-hat, version 9.3.1, no service packs;
  • Oracle 10g;
  • Versioned database, moving edits to base, single DEFAULT version;
  • ArcMap connecting via direct connection;

I have an user, creating simple points using a custom tool we made. This tool basically fires other actions, but nothing too deep. The user, after a while, creating points (simple points!) get's a weird database message, specifying:

ORA-01400

Cannot insert null into sde.state_locks.sde_id

[sde.default][state_id]=6935

After this any point he creates fails, with the same message.

Anyone has a clue of what is happening? Has anyone ever see this?

Edit: just to be clear, the error is intermitent. The tool we made works just fine, with unit tests and everything.

PS: ESRI, I hate ArcSDE :P

share|improve this question
    
I wonder if it has to do with orphans as describe in this article: Getting Rid of Orphan State Locks in SDE with Oracle. –  Kirk Kuykendall Mar 15 '13 at 0:53
    
Master Kirk! THank you for answering the question. Unfortunately, this has nothing to do with the locks itself, since I can compress the database to state zero. :( –  George Mar 15 '13 at 14:53

1 Answer 1

This sounds like you may have lost your connection, or at least something tried to free it. I don't know of a different way to get your SDE_ID to null. Can you perform any other actions?

I would check the log files to see if there is there are any errors prior to this. You could also try to run an SDE Intercept or trace.

share|improve this answer
    
Hi travis! Well, the logs do not show anything, but it's weird. We moved back to service connection and we've been getting a few Network IO errors, typical of that issue. i'm still investigating. –  George Mar 19 '13 at 17:22
    
When you get the network IO errors, is your connection's gsrvr process still running on the server machine? –  travis Mar 19 '13 at 18:34

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.