Job Service Log Error: "[810143] Database error 3930" (212941)

The error below appears in the job service log and there is no job ID to correlate the error to a specific event:

"[810143] Database error 3930: The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction."

Full error from the log:

"2016-08-19 05:45:31 +02:00 - Exception occured in DbRequestQueue.Process (thread: Database Job Results):
[810023] Error during execution of statement: exec vid_JobUpdateState_3 @uid, @state, @success
[810143] Database error 3930: detected in (SRV=XXXXXX\YYYYY, DB=IAM) no procedure, no Code, Line 2
[810143] Database error 3930: The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.

Uncommittable transaction is detected at the end of the batch. The transaction is rolled back.
at VI.JobService.DbProvider.DbRequestQueue.Process(DbRequest request)
at VI.JobService.DbProvider.DbRequestSetResult.Process(ConnectData connData, RequestDispatcher dispatcher)
at VI.JobService.DbProvider.DbRequestSetResult.SetResult(SqlExecutor exec, ISqlFormatter f)
at VI.JobService.MSSqlJobProvider.MsSqlRequestSetResult.SetState(SqlExecutor exec, ISqlFormatter f, String uid, String state, Int32 success, String messages)
at VI.DB.SqlExecutor.SqlExecuteNonQuery(IQueryProvider provider, IDataParameter[] parms)
---- Start of Inner Exception ----
at VI.DB.SqlExecutor.SqlExecuteNonQuery(IQueryProvider provider, IDataParameter[] parms)
at VI.DB.SqlExecutor._SqlExecuteNonQuery(DbStatement stmt)
---- Start of Inner Exception ----"

This is a product defect (25262)

When an error with severity > 18 is raised on SQL level, error handling of Identity Manager fails because It executes RAISERROR (@ErrorMessage, @ErrorSeverity, @ErrorState) WITH NOWAIT. In order to reproduce such an error, the user must be a member of the sysadmin role. Furthermore, WITH NOWAIT option is not usable in this context but WITH LOG has to be used.

WORKAROUND

None

STATUS

This will be fixed on a future release of the product. If you require this immediately corrected, please contact Support for a hotfix referencing the defect ID 25262.