Return
-
Title
Update Native Backup statistics job error. RegQueryValueEx() returned error 2, -
Description
Update Native Statistics job fails with the following error:
'ACTIVE_TRANSACTION'. [SQLSTATE 42000] (Error 9002) RegQueryValueEx() returned error 2, 'The system cannot find the file specified.' [SQLSTATE 01000] (Error 22001). The step failed.
May also result in the transaction log for tempdb to fill.
Job failure message: The transaction log for database 'tempdb' is full due to 'ACTIVE_TRANSACTION'. [SQLSTATE 42000] (Error 9002) RegQueryValueEx() returned error 2, 'The system cannot find the file specified.' [SQLSTATE 01000] (Error 22001). The step failed.
-
Resolution
Waiting for fix in a future release of LiteSpeed for SQL Server
WORKAROUND:
If Native backups are not run, then disable job.
-
Defect ID
118737