Skip to content


SmartConnect security Unhandled Exception

Lou Spevack asked 6 years ago
I am trying to add the service account for the eOne SmartConnect Service as a user in SmartConnect.  (The service is currently running with a different user login.) When I click OK to save, I get a SmartConnect security dialogue box with the error, \”An unhandled exception has occurred in your application.\”  The choices are Continue or Quit.  The full error is copied below.  This is a new, upgraded installation on a test server.  What actions should be taken to address this error?  Thanks.**********************Error Details:************** Exception Text **************System.Exception�  at eOne.SmartConnect.Engine.EntityBase.Save()�  at eOne.SmartConnect.Engine.User.Save()�  at eOne.SmartConnect.UI.FormSecurity1.Save()�  at eOne.SmartConnect.UI.FormSecurity1.buttonOk_ItemClick(Object sender, ItemClickEventArgs e)�  at DevExpress.XtraBars.BarItem.OnClick(BarItemLink link)�  at DevExpress.XtraBars.BarButtonItem.OnClick(BarItemLink link)�  at DevExpress.XtraBars.BarItemLink.OnLinkClick()�  at DevExpress.XtraBars.BarButtonItemLink.OnLinkClick()�  at DevExpress.XtraBars.BarItemLink.OnLinkAction(BarLinkAction action, Object actionArgs)�  at DevExpress.XtraBars.BarButtonItemLink.OnLinkAction(BarLinkAction action, Object actionArgs)�  at DevExpress.XtraBars.BarItemLink.OnLinkActionCore(BarLinkAction action, Object actionArgs)�  at DevExpress.XtraBars.ViewInfo.BarSelectionInfo.ClickLink(BarItemLink link)�  at DevExpress.XtraBars.ViewInfo.BarSelectionInfo.UnPressLink(BarItemLink link)�  at DevExpress.XtraBars.Controls.CustomLinksControl.OnMouseUp(MouseEventArgs e)�  at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)�  at System.Windows.Forms.Control.WndProc(Message& m)�  at DevExpress.XtraBars.Controls.DockedBarControl.WndProc(Message& msg)�  at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)�  at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)�  at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) *******************************Error as shown in Event Viewer:***********could not execute batch command.[SQL: SQL not available]Cannot insert the value NULL into column \’DisplayingExistingRecord\’, table \’SmartConnect.dbo.SystemPermission\’; column does not allow nulls. INSERT fails.Cannot insert the value NULL into column \’DisplayingExistingRecord\’, table \’SmartConnect.dbo.SystemPermission\’; column does not allow nulls. INSERT fails.The statement has been terminated.The statement has been terminated. The service account is mapped to the SmartConnect DB with dbo schema and with data_reader and data_writer roles assigned.

If you would like to submit an answer or comment, please sign in to the eOne portal.