Cannot update SMTP server settings for site. An unspecified SQL error has occurred.
Article ID: 100071398
Updated On:
Cause
This happens if the pfx (PKCS #12) file was created with no password or passphrase set. EV requires a password or passphrase to be present on the .pfx (or PKCS #12) file.
Resolution
When creating the pfx, assign a password or passphrase. If using Windows to export an existing certificate and private key, select password check box and supply a password:
Fig 1: Windows certificate export wizard screenshot showing password field.
After successful import the certificate, the cmdlet Sync-EVSMTPServerSettings can be run in EV management shell to make sure the change takes effect immediately.
Issue/Introduction
---------------------------
Enterprise Vault
---------------------------
Cannot update SMTP server settings for site 'SiteEntryID'.An unspecified SQL error has occurred. See the Enterprise Vault Event log for more details.
---------------------------
OK
---------------------------A Dtrace of mmc and directoryservice reveals:
(DirectoryService) <22140> EV~I DirectoryService: ADO: dbo.UpdateSmtpSettings |
(DirectoryService) <22140> EV:H {CADODataAccess::ExecuteSQLCommand} HRXEX fn trace : Error [0x80040e10], ref(1): [ESC12], [d:\builds\57\ev\v-prod-s\sources\source\common\adointerface\adodataaccess.cpp, lines {1326,1328,1347,1365}, built Aug 29 11:38:35 2023].
(DirectoryService) <22140> EV:L CADODataAccess::ExecuteSQLCommand Encountered error. hr=<0x80040e10> Command retry count:{0}, Connection retry count {0}, retry flag {0}
(DirectoryService) <22140> EV:L DecodeAndLogError entry
(DirectoryService) <22140> EV:H {DecodeAndLogError:#922} Error Description: [Procedure or function 'UpdateSmtpSettings' expects parameter '@TLSPassphrase', which was not supplied.]
(DirectoryService) <22140> EV:H {LogADOError:#1112} Native error: [201]
(DirectoryService) <22140> EV~E Event ID: 13411 An error was detected while accessing the Vault Database 'EnterpriseVaultDirectory' (Internal reference: {CADODataAccess::ExecuteSQLCommand} [d:\builds\57\ev\v-prod-s\sources\source\common\adointerface\adodataaccess.cpp, lines {1326,1328,1347,1365}, built Aug 29 11:38:35 2023]), error code <0x80040e10>.| | |Description: No value given for one or more required parameters. | |
(DirectoryService) <22140> EV:H {LogADOError:#1326} Error Source:[Microsoft OLE DB Driver for SQL Server], Number:[0x80040e10] SqlState:[42000] Native error:[00000201] Result:[0x80040e10], Ref:[{CADODataAccess::ExecuteSQLCommand} [d:\builds\57\ev\v-prod-s\sources\source\common\adointerface\adodataaccess.cpp, lines {1326,1328,1347,1365}, built Aug 29 11:38:35 2023]] Command:[dbo.UpdateSmtpSettings]
(DirectoryService) <22140> EV:L DecodeAndLogError exit.
(DirectoryService) <22140> EV:H {CDirectoryServiceObject::ExecuteSQLCommandAndAudit:#40889} _com_error exception: [<0x80040e10>]
(DirectoryService) <22140> EV:H {CDirectoryServiceObject::ExecuteSQLCommandAndAudit} (Exit) Status: [<0x80040e10>]
(DirectoryService) <22140> EV:H {CDirectoryServiceObject::UpdateSmtpSettings} HRXEX fn trace : Error [0x80040e10], [d:\builds\57\ev\v-prod-s\sources\source\directory\directoryservice\directoryserviceobject.cpp, lines (21){...,40126,40127,40128,40129,40130,40131,40132,40133,40134,40135,40136,40142}, built Aug 29 11:38:52 2023].
(DirectoryService) <22140> EV:H {CADODataAccess::GetParameterCount} (Exit) Status: [Exception]
...
(mmc) <7156> EV:H {CDirectoryConnectionObject::UpdateSmtpSettings} HRXEX fn trace : Error [0x80040e10], [d:\builds\57\ev\v-prod-s\sources\source\directory\directoryconnection\directoryconnectionobject_2.cpp, lines {4021,4037,4038}, built Aug 29 11:38:52 2023].
(mmc) <Pipeline Execution Thread:7156> EV-H {AdminAPIUtils.RaiseCOMException} Exception: Cannot update SMTP server settings for site '[SiteEntryID]'.An unspecified SQL error has occurred. See the Enterprise Vault Event log for more details. Info: Diag:HRESULT: 80040e10 Type:System.Runtime.InteropServices.COMException ST: Inner:None
(mmc) <7500> EV-H {PowerShellHost.InvokeCmdlet} Exception: Cannot update SMTP server settings for site 'SiteEntryID'.An unspecified SQL error has occurred. See the Enterprise Vault Event log for more details. Info: Diag: Type:System.Management.Automation.CmdletInvocationException ST: at System.Management.Automation.Runspaces.PipelineBase.Invoke(IEnumerable input)| at Symantec.EnterpriseVault.Admin.PowerShellHost.InvokeCmdlet(String cmdletVerb, EVAdminBase adminObj, CRUDContextEnum crudContext) Inner:System.Runtime.InteropServices.COMException (0x80040E10): Cannot update SMTP server settings for site 'SiteEntryId'.An unspecified SQL error has occurred. See the Enterprise Vault Event log for more details.| at Symantec.EnterpriseVault.Admin.AdminAPIUtils.RaiseCOMException(String error, Int32 errorCode, Boolean trace)| at Symantec.EnterpriseVault.Admin.EVAdminBase.SetLastErrorAndRaiseComException(Int32 errorCode, String mainError, String errorMessage, String[] arguments)| at Symantec.EnterpriseVault.Admin.SMTPServerSettings.SaveSmtpObjectAttributes()| at Symantec.EnterpriseVault.Admin.SMTPServerSettings.Save()| at Symantec.EnterpriseVault.PowerShell.AdminAPI.SetSmtpServerSettings.ProcessRecord()| at System.Management.Automation.Cmdlet.DoProcessRecord()| at System.Management.Automation.CommandProcessor.ProcessRecord()
(mmc) <7500> EV:H {CAUISmtpServerSettingsPage::SaveSMTPServerSettings:#512} Failed to save SMTP settings. Error: [0x80131501] [Cannot update SMTP server settings for site 'SiteEntryID'.An unspecified SQL error has occurred. See the Enterprise Vault Event log for more details.]
Was this article helpful?
Yes
No
Powered by
