Server Error in '/' Application.

Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.ConstraintException: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

Source Error:


Line 16498:                dataTable.Clear
Line 16499:            End If
Line 16500:            Dim returnValue As Integer = Me.Adapter.Fill(dataTable)
Line 16501:            Return returnValue
Line 16502:        End Function

Source File: C:\Users\arowland\AppData\Local\Temp\2\Temporary ASP.NET Files\root\5f99f8eb\ad88133\App_Code.uk2jszqr.32.vb    Line: 16500

Stack Trace:


[ConstraintException: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.]
   System.Data.DataSet.EnableConstraints() +526
   System.Data.DataSet.set_EnforceConstraints(Boolean value) +76
   System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) +391
   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +219
   System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) +160
   System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) +108
   dsReportTLCTableAdapters.spTLCEfficiencyNonTxBreakdownTableAdapter.Fill(spTLCEfficiencyNonTxBreakdownDataTable dataTable, String FacilityID, Nullable`1 StartDate, Nullable`1 EndDate) in C:\Users\arowland\AppData\Local\Temp\2\Temporary ASP.NET Files\root\5f99f8eb\ad88133\App_Code.uk2jszqr.32.vb:16500
   wsJBSReports.TLCEfficiencyNonTxBreakdown(String FacID, DateTime StartDate, DateTime EndDate) in C:\Source\Andrew\JBSReports\App_Code\wsJBSReports.vb:1946
   Reports_Report.Page_Load(Object sender, EventArgs e) in C:\Source\Andrew\JBSReports\Report.aspx.vb:897
   System.Web.UI.Control.OnLoad(EventArgs e) +92
   System.Web.UI.Control.LoadRecursive() +54
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +772

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.18055