Forum Discussion

AKtcc007's avatar
AKtcc007
Copper Contributor
Nov 24, 2023

User DB maintenance plan failed

Hi All,

I have SQL failover cluster with active passive nodes. On active node the User DB maintenance plan is failing randomly. In the history it shows that the database update statistics task is failing for one particular table. But I can see that the last update timestamp of the statistics is current.


Executing the query "UPDATE STATISTICS [dbo].[database..." failed with the following error: "Cannot continue the execution because the session is in the kill state.
A severe error occurred on the current command. The results, if any, should be discarded.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

How I can fix this error?

 

No RepliesBe the first to reply

Resources