Problem to setup email Notification Channel on SCOM 2019

%3CLINGO-SUB%20id%3D%22lingo-sub-2369915%22%20slang%3D%22en-US%22%3EProblem%20to%20setup%20email%20Notification%20Channel%20on%20SCOM%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2369915%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20are%20running%20SCOM%202019.%20We%20have%20a%20problem%20to%20setup%26nbsp%3Bemail%20Notification%20Channel%20with%20Failed%20to%20save%20the%20Notification%20Channel%20error.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENote%3A%20The%20following%20information%20was%20gathered%20when%20the%20operation%20was%20attempted.%20The%20information%20may%20appear%20cryptic%20but%20provides%20context%20for%20the%20error.%20The%20application%20will%20continue%20to%20run.%3C%2FP%3E%3CP%3ESystem.InvalidOperationException%3A%20The%20endpoint%20could%20not%20be%20inserted.%20See%20inner%20exception%20for%20details.%20---%26gt%3B%20Microsoft.EnterpriseManagement.Common.ManagementPackException%3A%20Database%20error.%20MPInfra_p_ManagementPackInstall%20failed%20with%20exception%3A%3CBR%20%2F%3EDatabase%20error.%20MPInfra_p_ManagementPackInstall%20failed%20with%20exception%3A%3CBR%20%2F%3E%5BSQL%20Error%20Code%3A%20-2146232060%5D%5BMP%20ID%3A%20dcfdedc4-68bd-42b4-1e9a-ba94b1577732%5D%5BMP%20Version%3A%2010.19.10050.0%5D%5BMP%20PKT%3A%20%5D%20Procedure%20or%20function%20p_MPImportXML%20has%20too%20many%20arguments%20specified.%3CBR%20%2F%3Eat%20Microsoft.EnterpriseManagement.Common.Internal.ServiceProxy.HandleFault(String%20methodName%2C%20Message%20message)%3CBR%20%2F%3Eat%20Microsoft.EnterpriseManagement.Common.Internal.MonitoringNotificationServiceProxy.UpsertNotificationEndpoint(String%20name%2C%20String%20displayName%2C%20String%20description%2C%20String%20languageCode%2C%20String%20endpointImplementation%2C%20Int32%20innerNotificationEndpoint%2C%20Boolean%20isUpdate)%3CBR%20%2F%3Eat%20Microsoft.EnterpriseManagement.MonitoringNotificationManagement.UpsertNotificationEndpoint(NotificationEndpoint%20notificationEndpoint%2C%20ManagementGroup%20managementGroup%2C%20Boolean%20isUpdate)%3CBR%20%2F%3Eat%20Microsoft.EnterpriseManagement.MonitoringNotificationManagement.UpdateNotificationEndpoint(NotificationEndpoint%20notificationEndpoint)%3CBR%20%2F%3Eat%20Microsoft.EnterpriseManagement.Administration.NotificationEndpoint.Update()%3CBR%20%2F%3E---%20End%20of%20inner%20exception%20stack%20trace%20---%3CBR%20%2F%3Eat%20Microsoft.EnterpriseManagement.Administration.NotificationEndpoint.Update()%3CBR%20%2F%3Eat%20Microsoft.EnterpriseManagement.Mom.Internal.UI.Notification.ChannelCompletionPage.CommitChanges(Object%20sender%2C%20DoWorkEventArgs%20e)%3CBR%20%2F%3E%3A%20Database%20error.%20MPInfra_p_ManagementPackInstall%20failed%20with%20exception%3A%3CBR%20%2F%3EDatabase%20error.%20MPInfra_p_ManagementPackInstall%20failed%20with%20exception%3A%3CBR%20%2F%3E%5BSQL%20Error%20Code%3A%20-2146232060%5D%5BMP%20ID%3A%20dcfdedc4-68bd-42b4-1e9a-ba94b1577732%5D%5BMP%20Version%3A%2010.19.10050.0%5D%5BMP%20PKT%3A%20%5D%20Procedure%20or%20function%20p_MPImportXML%20has%20too%20many%20arguments%20specified.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20try%20to%20restart%20all%20System%20center%20servcies%20and%20restart%20the%20server%2C%20but%20that%20doesn't%20fix%20the%20problem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2369915%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOperations%20Manager%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2370548%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20to%20setup%20email%20Notification%20Channel%20on%20SCOM%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2370548%22%20slang%3D%22en-US%22%3EI%20find%20the%20fix.%20The%20details%20can%20be%20found%20here%3A%20Fixing%20Problem%20to%20setup%20email%20Notification%20Channel%20on%20SCOM%202019%20-%20%3CA%20href%3D%22http%3A%2F%2Fwww.chicagotech.net%2FWordPress%2F2021%2F05%2F19%2Ffixing-problem-to-setup-email-notification-channel-on-scom-2019%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.chicagotech.net%2FWordPress%2F2021%2F05%2F19%2Ffixing-problem-to-setup-email-notification-channel-on-scom-2019%2F%3C%2FA%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

We are running SCOM 2019. We have a problem to setup email Notification Channel with Failed to save the Notification Channel error.

 

 

 

Note: The following information was gathered when the operation was attempted. The information may appear cryptic but provides context for the error. The application will continue to run.

System.InvalidOperationException: The endpoint could not be inserted. See inner exception for details. ---> Microsoft.EnterpriseManagement.Common.ManagementPackException: Database error. MPInfra_p_ManagementPackInstall failed with exception:
Database error. MPInfra_p_ManagementPackInstall failed with exception:
[SQL Error Code: -2146232060][MP ID: dcfdedc4-68bd-42b4-1e9a-ba94b1577732][MP Version: 10.19.10050.0][MP PKT: ] Procedure or function p_MPImportXML has too many arguments specified.
at Microsoft.EnterpriseManagement.Common.Internal.ServiceProxy.HandleFault(String methodName, Message message)
at Microsoft.EnterpriseManagement.Common.Internal.MonitoringNotificationServiceProxy.UpsertNotificationEndpoint(String name, String displayName, String description, String languageCode, String endpointImplementation, Int32 innerNotificationEndpoint, Boolean isUpdate)
at Microsoft.EnterpriseManagement.MonitoringNotificationManagement.UpsertNotificationEndpoint(NotificationEndpoint notificationEndpoint, ManagementGroup managementGroup, Boolean isUpdate)
at Microsoft.EnterpriseManagement.MonitoringNotificationManagement.UpdateNotificationEndpoint(NotificationEndpoint notificationEndpoint)
at Microsoft.EnterpriseManagement.Administration.NotificationEndpoint.Update()
--- End of inner exception stack trace ---
at Microsoft.EnterpriseManagement.Administration.NotificationEndpoint.Update()
at Microsoft.EnterpriseManagement.Mom.Internal.UI.Notification.ChannelCompletionPage.CommitChanges(Object sender, DoWorkEventArgs e)
: Database error. MPInfra_p_ManagementPackInstall failed with exception:
Database error. MPInfra_p_ManagementPackInstall failed with exception:
[SQL Error Code: -2146232060][MP ID: dcfdedc4-68bd-42b4-1e9a-ba94b1577732][MP Version: 10.19.10050.0][MP PKT: ] Procedure or function p_MPImportXML has too many arguments specified.

 

I have try to restart all System center servcies and restart the server, but that doesn't fix the problem.

 

 

 

 

 

 

1 Reply
I find the fix. The details can be found here: Fixing Problem to setup email Notification Channel on SCOM 2019 - http://www.chicagotech.net/WordPress/2021/05/19/fixing-problem-to-setup-email-notification-channel-o...