KB39674: Starting WFS application results in Unhandled Exception...

Expand / Collapse

KB39674: Starting WFS application results in Unhandled Exception Failed to enable constraints

Article ID: 50978 - Last Review: April 4, 2013


Starting the Workforce Scheduling application results in an unhandled exception.


Starting the WFS application results in the following unhandled exception which can be found in the CCSClient.txt log file:

eError 28/09/2010 10:23:17 Unhandled Exception Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints. | Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
at System.Data.DataSet.FailedEnableConstraints()
at System.Data.DataSet.EnableConstraints()
at System.Data.DataSet.set_EnforceConstraints(Boolean value)
at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
at System.Data.Common.LoadAdapter.FillFromReader(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
at System.Data.DataTable.Load(IDataReader reader, LoadOption loadOption, FillErrorEventHandler errorHandler)
at System.Data.DataTable.Load(IDataReader reader, LoadOption loadOption)
at prairieFyre.CCS.Data.RemoteDataAccessManager.LoadEmployeeTableData() in e:\TeamBuild\CCS\CI_CcsClient_5.7\Sources\Source\Applications\CcsClient\Data\RemoteDataAccessManager.cs:line 2153
at prairieFyre.CCS.Data.RemoteDataAccessManager.LoadRemoteConfigurationData() in e:\TeamBuild\CCS\CI_CcsClient_5.7\Sources\Source\Applications\CcsClient\Data\RemoteDataAccessManager.cs:line 2009
at prairieFyre.CCS.Data.SchedulingData.LoadConfigurationData() in e:\TeamBuild\CCS\CI_CcsClient_5.7\Sources\Source\Applications\CcsClient\Data\SchedulingData.cs:line 494
at prairieFyre.CCS.Client.CCSClientForm.OnLoad(EventArgs e) in e:\TeamBuild\CCS\CI_CcsClient_5.7\Sources\Source\Applications\CcsClient\Client\ClientForm.cs:line 361
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at Syncfusion.Windows.Forms.Tools.RibbonForm.WndProc(Message& m)
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)


An error in SQL logic when a user unchecks an Employee as a Supervisor in YSE or CCM Website.  The Employees which he was previously supervising, still show that Employee has his supervisor.  WFS code on application start-up will exception on this data integrity violation.


Prior to unchecking an Employee from being a Supervisor, clear the Supervisor fields from all the Employees which he is supervising.


This hotfix has been included in all subsequent software versions.  For our latest software and updates, please go to www.mitel.com .

If you have a business need for this hotfix and are unable to update to a supported software version, please contact Customer Support for assistance.



CCM version 5.7 SP1

Keywords: 39674

Rate this Article:

Add Your Comments

Name: *
Email Address:
Web Address:
Verification Code:

Last Modified:Friday, April 05, 2013
Last Modified By: amontpetit
Article not rated yet.
Article has been viewed 4,770 times.