Share via

SCOM - 26319 Errors

Gnana Balaji Kanagaraj 41 Reputation points
2021-07-30T12:03:26.127+00:00

Hi All, We are frequently receiving this error on SCOM Management server and we are not able to perform any tasks from OM Console.

We have checked our OM Database and SQL Server is performing fine and no issues reported there.

SCOM Version - SCOM 2019 UR1

An exception was thrown while processing SubmitTasks for session ID uuid:2b45a189-343f-455d-b233-e9ab7c0a4d23;id=298.
Exception message: The statement terminated. The maximum recursion 100 has been exhausted before statement completion.
Full Exception: The statement terminated. The maximum recursion 100 has been exhausted before statement completion.

Any help would be appreciated.

System Center Operations Manager
System Center Operations Manager
A family of System Center products that provide infrastructure monitoring, help ensure the predictable performance and availability of vital applications, and offer comprehensive monitoring for datacenters and cloud, both private and public.
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. XinGuo-MSFT 22,246 Reputation points
    2021-08-02T09:23:58.967+00:00

    Hi,

    According to this error, it seems that the execution of SQL recursive query exceed the maximum range.

    To troubleshoot this problem, we could use the SQL Server Profiler 17 to capture the command that reported this error, and try to manual execute it to see the result. Then use the OPTION (MAXRECURSION 1000) increase this range to see the result.

    119768-capture.png

    Note: Microsoft provides third-party contact information to help you find technical support. This contact information may change without notice. Microsoft does not guarantee the accuracy of this third-party contact information.

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.