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

PROBLEM

Starting the Workforce Scheduling application results in an unhandled exception.



SYMPTOMS

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)



CAUSE

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.



WORKAROUND

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



RESOLUTION

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.


 

APPLIES TO

CCM version 5.7 SP1

Keywords: 39674





Rate this Article:
     
Tags:

Add Your Comments


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

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