Enrollment status on canned reports generates SQL exception

Modified on Tue, 21 May 2013 10:17 by CAREWare Help Desk — Categorized as: FAQ

When adding any enrollment status field as a custom filter to the no test in X days or any other canned report the following SQL Error is generated. The is no way to edit these reports for enrollment status currently. 

SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 
at System.Data.SqlTypes.SqlDateTime.FromTimeSpan(TimeSpan value) 
at System.Data.SqlTypes.SqlDateTime.FromDateTime(DateTime value) 
at System.Data.SqlClient.MetaType.FromDateTime(DateTime dateTime, Byte cb) 
at System.Data.SqlClient.TdsParser.WriteValue
(Object value, MetaType type, Byte scale, Int32 actualLength, Int32 encodingByteSize, Int32 offset, TdsParserStateObject stateObj) 
at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, 
SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj, Boolean isCommandProc) 
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) 
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) 
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) 
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) 
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) 
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) 
at jProgBusiness.jBusiness.jSQLDatasetFillHelper.jTableDescriptor.doFirstPass(DataSet TheDataset, IDbConnection Connection, Int32 XMLHandle, jReportSpecification reportSpecification, IDbDataAdapter adaptor, Int32 domainsHandle) 
at jProgBusiness.jBusiness.jSQLDatasetFillHelper.jTableDescriptor.processAggregateReport(DataSet TheDataset, IDbConnection Connection, Int32 XMLHandle, jReportSpecification reportSpecification, IDbDataAdapter adaptor, Int32 domainsHandle)

This bug was found in build594
This bug was fixed in build#
TTP #1973

Back to Bugs

Back to Frequently Asked Questions