Scheduler not working

bartthefish

Maybe I'm doing something wrong. I installed v4.9 Build 1301, and being eager to see the scheduler at work I loaded the CRM sample bsv. The Scheduler is where it is supposed to be, under staff > team tasks. However none on the appointments show up on the scheduler

I just see the resources. Anyone else having this problem?

aware_support

Most probably this means that all scheduled tasks are not at the dates you are looking at. Define a standard query to find where the scheduled tasks(appointments) are and then point the scheduler to these dates.

We are quite sure that the scheduler is working fine.

tford

I loaded the CRM sample app yesterday & the scheduler appeared as expected with appointments.

bartthefish

I've re-installed on a separate PC running Windows XP, and same results. The calendar has a large number of appointments created during initialization, but none of them appear on the schedule presentation.

bartthefish

I've tried again...Still no luck

Below is a screenshot of the CRM sample app's calendar with the demo data loaded. As you can see there are a number of appointments on the calendar view.

However when I activate the Scheduler View as shown below, no appointments.

I've tried this on a number of installations, and have also created a scheduler query in one of my other apps. Also no joy.

What am I doing wrong?

bartthefish

PS. I have tried this on IE, Chrome and Firefox. All with the same results

aware_support

Our sample application that you can see on the web site is driven by 4.9 - exactly the same setup.

Check if your appointments instances have references to "resources" - if they don't, for whatever reason, they will not be shown.

bartthefish

I must be doing something wrong. This is so frustrating.

I've reinstalled Windows and SQL on my PC, I've downloaded a brand new SETUPVAR.exe and installed it. I then go to Sample applications CRM, and then load sample data. I then create an appointment in the calendar (the exact same way as on the online demo, which does display the scheduler query correctly) and still nothing.

I have installed this on a completely different machine and the same results. (I'm going to install it on my laptop now too as a final test)

Please does any one know what I am missing???

ab042

I had not played with the Scheduler feature and after reading this post decided to take a look.

I DID NOT test this more than ONCE so this may have nothing to do with your issue. In fact it may not even be an issue. I'm posted just in case it may help.

I originally went into the Control Panel, clicked on Help, Sample Applications and loaded the CRM sample app. When I looked at the CRM sample in the browser I couldn't get the TEAM task to show.

I then went into the Configuration Tool and DELETED the CRM app. Exited and went back into the Configuration Tool, Right clicked on Business Space, selected NEW and Create from SAMPLE and selected CRM. When I loaded the CRM app in the browser this time Team Task was working fine.

Again, I didn't spend more then 10 minutes. But it did working. Good luck.

aware_support

Don't know what to say. Try deleting and recreating the CRM app as ab042 did to make sure that Aware IM automatically creates data for the scheduler. If it still doen't work check the output of Tomcat and Aware IM server for some clues.

bartthefish

I have tried what ab042 did, but still no luck. I then checked the AwareIM Server Output and found this:

com.bas.basserver.executionengine.ExecutionException: Internal error. Element DATE_PART in query condition DATE_PART(Appointment.StartTime)>=14/03/2010 AND DATE_PART(Appointment.EndTime)<=14/03/2010 of query FIND Appointment WHERE DATE_PART(Appointment.StartTime)>=14/03/2010 AND DATE_PART(Appointment.EndTime)<=14/03/2010 cannot be converted to the currently installed version of SQL

I'm running MS SQL Server 2008 on my machines, so now I guess I will have to wait for a fix to this before I can use the scheduler

aware_support

Now I see - the query used in a sample application is not supported on SQL Server. You don't need to wait for a fix - the problem has nothing to do with the scheduler. Just make sure that your scheduler queries do not use the unsupported functions on your database.

bartthefish

Any direction how I can customize the Scheduler Query? The

FIND Appointment WHERE DATE_PART(Appointment.StartTime)>=14/03/2010 AND DATE_PART(Appointment.EndTime)<=14/03/2010

is constructed automatically by the Display Query Results > Scheduler, and there is no where to edit this that I can see as the Rule Form Contains (FIND ALL Appointment)

aware_support

We'll fix this

bartthefish

Thank you. 😃

aware_support

Please test it in build 1309

bartthefish

Good news: The scheduler on SQL Server 2008 is working now in the CRM app.

Bad News: The Staff Responsible reference in my application has multiple allowed and this does not work with the scheduler.

aware_support

This has been fixed in build 1321