Return
-
Title
RegQueryValueEx() returned error 2, 'The system cannot find the file specified.' Msg 22001, Level 1, State 1 -
Description
The [LiteSpeed for SQL Server Update Native Backup statistics] job began failing yesterday with the following error message:RegQueryValueEx() returned error 2, 'The system cannot find the file specified.' [SQLSTATE 01000] (Message 22001) Replicate statistics request failed - is the LiteSpeed replication service started? [SQLSTATE 42000] (Error 50000). The step failed.The job runs the following T-SQL code, and we verified both stored procedures do indeed exist:exec [LiteSpeedLocal]..[LiteSpeed_ImportNativeHistory]exec [master]..[xp_replicate_activity_statistics]This job is still running successfully on our other secondary node Server.
-----
This seems to be a native LiteSpeed job that tries to execute this stored procedure called [LiteSpeedLocal]..[LiteSpeed_ImportNativeHistory].I tried to execute it but this is the error message: RegQueryValueEx() returned error 2, 'The system cannot find the file specified.' Msg 22001, Level 1, State 1
This job is still running successfully on our other secondary node Server.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.