We have recently started receiving the 'General Failure in Scheduling
Engine' error when scheduling service activities. The error occurs after a
resource is selected and a user clicks save.
We receive the 'SQL Server Error, Contact your System Administrator' message
and when we close the window we see the 'General Failure in Scheduling
Engine' error.
I have done a bit of research around this, we have installed Update Rollup 1
and we have not removed the Status Reason field from the Appointment or
Service Activity forms.
Does anyone have any ideas as to why this could be occurring? Our service
department is getting quite irritated with this and a solution would be
really appreciated.
Many Thanks
Mark
Tim
I have no idea yet how to figure out the problem, any proposal will be
welcome.
1) We were missing some permissions under Service management. Make sure
your calendar has append and append to permissions as well as have your my
work hours across the board set to organization level
2) Above fixed most of the problems, but we also found that a hotfix, I
believe that was part of rollup3 has an issue, actually was bad and created
this new bug. Microsoft just developed a limited release hotfix under
KB950119 to address the problem of p_GrantAccessBulkForCreate failing under
appointments. Doing a search on the hotfix doesn't show very much yet, so
you will need to contact Microsoft.
I'm not sure if you guys are referring to v3 or v4 - in my case it
worked fine in v3 but I have run into the problem with v4.
I found the same as Chris above, i.e. the appointment creation fails
of you have a value in the regarding field, but works fine if you
create the apponitment without the regarding field and then update the
regarding field afterwards. This happens even as system administrator,
so it is not a permissions issue in my case.