Report Filter is not working in Scheduler appointment report setup form

Modified on Thu, 22 Dec 2011 17:31 by CAREWare Help Desk — Categorized as: FAQ

A client that is shared across domains and had appointment sharing turned off generates an error. Tried it with it being on as well and still does not work.

Source:  - Error retrieving the appoinment data for domain.
If the problem persists, please contact technical support.
Tables or functions 'cw_map_client_provider' and 'cw_map_client_provider' have the same exposed names. 
Use correlation names to distinguish them.
Incorrect syntax near the keyword 'As'.
Line 1: Incorrect syntax near ')'.
   at jProgBusiness.jBusiness.jSQLDatasetFillHelper.jTableDescriptor.FillTable(DataSet TheDataset, IDbConnection 
Connection, Int32 XMLHandle, jReportSpecification reportSpecification, jKeyLabelPair[] domains) in C:\Version Control 
vs 2005\Mainline\Code Files\jProgBusiness\jSQLDatasetFillHelper.vb:line 543
   at jProgBusiness.jBusiness.jSQLDatasetFillHelper.FillDataset(jServiceManager ServiceManager, ConnectionType ConnectionType, 
Boolean closeConnectionAfterUse, jReportSpecification reportSpecification, jKeyLabelPair[] domains) in C:\Version Control vs 
2005\Mainline\Code Files\jProgBusiness\jSQLDatasetFillHelper.vb:line 127
   at jProgBusiness.jBusiness.jInternationalAdministration.GetAppointmentListForReport(String SessionToken, String DomainPK, 
DateTime FromDate, DateTime ThroughDate, String Purpose, String Subservice, String Status, String Staff, String sentToFK, 
Int32 gracePeriod, String filterPK) in C:\Version Control vs 2005\Mainline\Code Files\jProgBusiness\jInternationalAdministration.
vb:line 4972
   at jProgBusiness.jBusiness.jBusinessRemote.INT_Get_Appointment_List_For_Report(String SessionToken, String DomainPK, DateTime 
FromDate, DateTime ThroughDate, String PurposeFK, String SubserviceFK, String StatusRFK, String StaffFK, String sentToFK, Int32 
gracePeriod, String filterPK) in C:\Version Control vs 2005\Mainline\Code Files\jProgBusiness\jBusinessRemote.vb:line 23779

Server stack trace: 
   at jProgBusiness.jBusiness.jBusinessRemote.INT_Get_Appointment_List_For_Report(String SessionToken, String DomainPK, DateTime 
FromDate, DateTime ThroughDate, String PurposeFK, String SubserviceFK, String StatusRFK, String StaffFK, String sentToFK, Int32 
gracePeriod, String filterPK) in C:\Version Control vs 2005\Mainline\Code Files\jProgBusiness\jBusinessRemote.vb:line 23783
   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_Appointment_List_For_Report(String SessionToken, String DomainPK, DateTime 
FromDate, DateTime ThroughDate, String PurposeFK, String SubserviceFK, String StatusRFK, String StaffFK, String sentToFK, Int32 
gracePeriod, String filterPK) in C:\Version Control vs 2005\Mainline\Code Files\ijBusinessRemote\jClientSideRemote.vb:line 18520
   at Client.SchedulerReports.AppointmentReport(DateTime FromDate, DateTime ThroughDate, String TextFromDate, String TextThroughDate, 
String SubserviceFK, String StatusRFK, String StaffFK, String sentToFK, String filterPK) in C:\Version Control vs 2005\Mainline\
Code Files\Client Internal Application\SchedulerReports.vb:line 667
Error retrieving the appointment data for domain.

This bug was found in build517
This bug was fixed in build#
TTP #1668

Back to Bugs

Back to Frequently Asked Questions