I am working in an ArcSDE 10.1 instance sitting on Oracle that I believe was upgraded from a previous ArcSDE version. It has a versioned view for the table I am trying to edit (specifically, delete rows). However, the views isn't called feature_class_name_vw, which seems to be the naming convention for views generated in 10.1. Which makes me think that it was created manually in a previous version of SDE.
This is the error I'm getting:
ORA-20025: State 118977 is closed.
ORA-06512: at "SDE.VERSION_UTIL", line 2495
ORA-06512: at "DATA.V109_DELETE", line 1
ORA-04088: error during execution of trigger 'DATA.V109_DELETE'
Originally, it was giving a Not owner of state 0 error. State 0 is owned by SDE, so that makes sense. I created an edit session in ArcMap with the same user that I am executing my SQL as, and that generated a state in the DB with the correct user - but also the state is closed error I mentioned above. So it seems like it isn't generating a state when editing the view.
Any ideas why this is?
I asked our DBA to regenerate the versioned views and that did the trick.