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.
