ERROR
When using the sde.version_user_ddl.edit_version procedure in Oracle, the following error message displays when attempting to stop the edit operation:"SQL> exec sde.version_user_ddl.edit_version('DEFAULT',2);
BEGIN version_user_ddl.edit_version('DEFAULT',2); END;*
ERROR at line 1:
ORA-20048: Lock <893,1528,Y> not found, not deleted.
ORA-06512: at "SDE.VERSION_USER_DDL", line 765
ORA-06512: at line 1"
If the session has previously encountered the following error when calling sde.version_user_ddl.edit_version('DEFAULT',1) multiple times, the above error message displays when stopping an edit operation:
SQL> exec version_user_ddl.edit_version('DEFAULT',1);
BEGIN version_user_ddl.edit_version('DEFAULT',1); END;
*
ERROR at line 1:
ORA-20176: State 1528 from version DEFAULT is not closed.
ORA-06512: at "SDE.VERSION_USER_DDL", line 765
ORA-06512: at line 1
This error is expected, because the state is already open. Applications should not attempt to start multiple edit operations on the version prior to stopping the edit operation.
Article ID:000009431
Get help from ArcGIS experts
Download the Esri Support App