戻る
-
タイトル
RegQueryValueEx() returned error 2, 'The system cannot find the file specified.' Msg 22001, Level 1, State 1 -
説明
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.
-
原因
POSSIBLE CAUSE 1
LiteSpeed Activity Service (SLSStatsService) is not activated
POSSIBLE CAUSE 2
The reason for that message is there is no registry key for SQL Server logs. -
対策
RESOLUTION 1 (for CAUSE 1)Verify on that server that is having this issue, under services, is LiteSpeed Activity Service (SLSStatsService) stopped / not running? If not, activate the service.
RESOLUTION 2 (for CAUSE 2)This procedure:exec [LiteSpeedLocal]..[LiteSpeed_ImportNativeHistory]is calling:exec master.dbo.xp_instance_regreadand there is no registry key for SQL Server logs and SQL Server attempting to read the registry.
This is not critical error and can be ignored. You will always see it when you run the job manually.exec master.dbo.xp_instance_regreadN'HKEY_LOCAL_MACHINE',N'Software\Microsoft\MSSQLServer\MSSQLServer',N'NumErrorLogs'