POWEROBJECTS

718 Washington Ave. N. Suite #101
Minneapolis, MN 55401
View map and all Locations

Send us a message

We recently came across an interesting issue in one of our environments.

crm2011

The client was reporting the following:

-When attempting to create an appointment with the REGARDING set as a contact the user owns, an error message displays stating ‘General Scheduling Engine Failure.’ Enabling DevErrors in the web.config did not produce a more verbose error message.

-When attempting to ‘Track’ an email in CRM an error message is thrown stating ‘A SQL Error Has Occurred.’ Again, enabling DevErrors in web.config did not give us a more verbose error.

-The event viewer on the CRM server (and SQL server) did not record any of these errors.

Obviously not being able to track email or create appointments in the system is quite the show-stopper!

Our first instinct was to check the Security Role the user was assigned. Perhaps they were missing Create or Append privileges somewhere? This proved to be a fruitless endeavor as a quick test with a System Administrator role showed us that the error was occuring for that role as well.

We then performed a stack trace and uncovered the following:

After a bit of research I found a KB article which referenced the error and behavior I was experiencing: http://support.microsoft.com/kb/956129

The KB article described the error I was seeing but it indicated that it was fixed in UR1 and my environment was on UR6!

I decided to reapply the KB I found as a final, deperate “Hail Mary” pass, and much to my surprise, it worked! After applying the KB users were able to create Appointments and Track Email as normal.

It turns out that the KB in question makes a change to the p_GrantAccessBulkForCreate stored procedure. For whatever reason, our SP was not updated when we applied UR1.

Strange Issue with a very easy fix!

Avatar for JoeCRM

JoeCRM

Joe CRM is a CRM superhero who runs on pure Microsoft Dynamics CRM adrenaline. As the face of PowerObjects, Joe CRM’s mission is to reveal innovative ways to use Dynamics CRM and bring the application to more businesses and organizations around the world.