BUG
Editing an archive enabled table with SQL through a multi-version view referencing the DEFAULT version does not maintain the table's archive class.
For example, if an application using SQL starts editing the sde.DEFAULT version by calling the database procedure sde.version_user_ddl.edit_version, updates a few rows and proceeds to stop editing by calling sde.version_user_ddl.edit_version, the changes are not archived to the archive class.
When using SQL to modify a versioned table through a multi-version view, the DML (insert, update or delete) is applied directly to the delta tables for the state the version references. Because the changes are being applied directly to the version being edited, there's no ability for the archiving operation to archive the changed objects to the archive class.
Since the changes are not correctly archived, future edits to these same objects can lead to inconsistencies in the archive class.
Code:
SQL> EXEC sde.version_user_ddl.edit_version('WORK ORDER',1);
PL/SQL procedure successfully completed.
SQL> UPDATE admin.parcels_view SET usage = 'REC' WHERE apn = '10-ARC-9842';
1 row updated.
SQL> COMMIT;
Commit complete.
SQL> EXEC sde.version_user_ddl.edit_version('WORK ORDER',2);
PL/SQL procedure successfully completed.
Get help from ArcGIS experts
Download the Esri Support App