Rollback of Transactions

If the server crashes for whatever reason during processing, items which were being imported, have their status updated to lock code D which stands for Deletion. This is done so that no partially and possible corrupt data would become part of the database and endanger functionality and consistency. A periodically scheduled job will delete all data with lock code D.

Note that the job SYS_PurgeRolledbackLongTransaction must be scheduled to execute with a system user as profile as these “marked for deletion” records are only visible for system users.