Continuously receiving the error message: ConfigMgr Error Object: instance of SMS_ExtendedStatus

Question

I get the below error message while opening the MEM console. Please help to solve the issue.

ConfigMgr Error Object:

instance of SMS_ExtendedStatus

{

Description = "Can't create instance of CSecuredSource for SMS_MigrationJob";

ErrorCode = 3250653696;

File = "D:\dbs\sh\cmgm\0502_134106\cmd\1g\src\SiteServer\SDK_Provider\SMSProv\sspobjectquery.cpp";

Line = 2082;

ObjectInfo = "SMS_MigrationJob";

Operation = "ExecQuery";

ParameterInfo = "select * from SMS_Alert where AlertState = 0 and FeatureGroup = 4 and IsIgnored = 0";

ProviderName = "WinMgmt";

SQLMessage = "[HY000][596][Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Cannot continue the execution because the session is in the kill state.";

SQLSeverity = 21;

SQLStatus = 596;

StatusCode = 2147749889;

};

---

Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlQueryException

The SMS Provider reported an error.

Answer 1

Hi,

Hope everything is going well.

1,The message is stating that you are having record looking within SQL. This likely means SQL is undersized or that you are running SQL Queries that are taking too long. Please help check your SQL server configurations.

2,If possible, please restart your server to have a try.

Feel free to contact me if you have any concerns/queries.

Best regards,

Simon

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.