question

GnanaBalajiKanagaraj-7688 avatar image
0 Votes"
GnanaBalajiKanagaraj-7688 asked XinGuo-MSFT edited

SCOM - 26319 Errors

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.

msc-operations-manager
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

XinGuo-MSFT avatar image
0 Votes"
XinGuo-MSFT answered XinGuo-MSFT edited

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.



capture.png (46.4 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.