RegQueryValueEx() returned error 2, 'The system cannot find the file specified.' Msg 22001, Level 1, State 1 (4330820)

Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

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.
Cause

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

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_regread
and 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_regread
N'HKEY_LOCAL_MACHINE',
N'Software\Microsoft\MSSQLServer\MSSQLServer',
N'NumErrorLogs'

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Request a KB Article

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

RegQueryValueEx() returned error 2, 'The system cannot find the file specified.' Msg 22001, Level 1, State 1 (4330820)

Title

Description

Cause

Resolution

Leave a Comment