Canned reports with custom filters generate error

RSS

» Canned reports with custom filters generate error

canned reports with custom filters applied are generating errors. Testing occurred for the appintments no kept report with a simple enrollment status = active filter applied. The following error was generated:

Source:  - Error retrieving the client without appointments data for domain.
If the problem persists, please contact technical support.
SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.
   at jProgBusiness.jBusiness.jSQLDatasetFillHelper.jTableDescriptor.FillTable(DataSet TheDataset, IDbConnection Connection, 
Int32 XMLHandle, jReportSpecification reportSpecification, jKeyLabelPair[] domains)
   at jProgBusiness.jBusiness.jSQLDatasetFillHelper.FillDataset(jServiceManager ServiceManager, ConnectionType 
ConnectionType, Boolean closeConnectionAfterUse, jReportSpecification reportSpecification, jKeyLabelPair[] domains)
   at jProgBusiness.jBusiness.jInternationalAdministration.GetClientWoApptRecordList(String SessionToken, String DomainPK, 
DateTime FromDate, DateTime ThroughDate, String PurposeFK, String SubserviceFK, String StatusRFK, String StaffFK, String 
sentToFK, Int32 gracePeriod, String filterPK)
   at jProgBusiness.jBusiness.jBusinessRemote.INT_Get_Client_Wo_Appt_Record_List(String SessionToken, String DomainPK, 
DateTime FromDate, DateTime ThroughDate, String PurposeFK, String SubserviceFK, String StatusRFK, String StaffFK, String 
sentToFK, Int32 gracePeriod, String filterPK)

Server stack trace:
   at jProgBusiness.jBusiness.jBusinessRemote.INT_Get_Client_Wo_Appt_Record_List(String SessionToken, String DomainPK, 
DateTime FromDate, DateTime ThroughDate, String PurposeFK, String SubserviceFK, String StatusRFK, String StaffFK, String 
sentToFK, Int32 gracePeriod, String filterPK)
   at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, 
Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
   at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] args, 
Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
   at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean 
fExecuteInContext)

Exception rethrown at [0]:
   at jProgBusiness.jBusiness.jClientSideRemote.INT_Get_Client_Wo_Appt_Record_List(String SessionToken, String DomainPK, 
DateTime FromDate, DateTime ThroughDate, String PurposeFK, String SubserviceFK, String StatusRFK, String StaffFK, String 
sentToFK, Int32 gracePeriod, String filterPK)
   at Client.SchedulerReports.ClientWoApptReport(DateTime FromDate, DateTime ThroughDate, String TextFromDate, String 
TextThroughDate, String SubserviceFK, String StatusRFK, String StaffFK, String sentToFK, String filterPK)
Error retrieving the client without appointments data for domain.

This bug was found in build	594
This bug was fixed in build	#
TTP #	1944

Back to Bugs

Back to Frequently Asked Questions