question

LeonTaljaard-1502 avatar image
0 Votes"
LeonTaljaard-1502 asked LeonLaude commented

SCOM 2019 Command Channel Error

Hi Guys,

I have an issue with my command channel all of a sudden, this has been working for some time now and I am suddenly getting errors like the below. Even if I try create a new one I get the same error. I am wondering if this might be SQL related.

Please could someone perhaps point me in the right direction

35493-capture.png


msc-operations-manager
capture.png (53.9 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.

AlexZhu-MSFT avatar image
0 Votes"
AlexZhu-MSFT answered LeonLaude commented

Hi,

Have we make some changes recently? For example, upgrading to UR2 of SCOM 2019? Based on the error, it seems it relates to database, like to say, the table structure changing.

procedure or function p_MPImportXML has too many arguments specified

If there is any backup, suggest to restore from backup and have a try.

Hope the above information helps.

Alex Zhu


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

· 2
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.

Hi Alex,

I think it was exactly that, I reran the UR2 update following Kevins step by step and the new installer and all started working again.

ur2-for-scom-2019-step-by-step


0 Votes 0 ·

This would have been good to know earlier, because changes are often the root cause of issues :-)

0 Votes 0 ·
LeonLaude avatar image
0 Votes"
LeonLaude answered LeonLaude commented

Hi @LeonTaljaard-1502,

Could you please paste the full exception of the error you're receiving?

I've seen similar errors when the SCOM database is full, you will not able to insert data in to the SCOM database if its full, could you double check this?

Also check the Operations Manager event log for any errors, if any errors are found, post them here, thanks.


(If the reply was helpful please don't forget to upvote or accept as answer, thank you)


Best regards,
Leon

· 2
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.

Hi @LeonLaude

Thank you for the quick reply, I have attached the full exception.

35576-document.txt





0 Votes 0 ·
document.txt (4.2 KiB)

It's a pretty cryptic error, did you check the database disk status, and the Operations Manager event log?

0 Votes 0 ·