Forum Discussion
AKtcc007
Nov 24, 2023Copper Contributor
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