Error when creating a new appointment

Robert Feenstra, working for Atlanticasset, has informed me about an issue that he had when he created a new appointment. He did not only tell me his issue, he also was able to give the solution! To be able to help more people, here is the error and the solution.

When trying to create a new appointment, upon save get the error:

The record that you are requesting is currently unavailable. Either the record was not found or you do not have sufficient security permissions to view it.


Upon clicking "Ok", I get the error:
General failure in scheduling engine


with a "Ignore and Save" buttonwhich will save the appointment, but still marks the appointment as having a General failure in scheduling engine from then on.

This is caused by an orphan record in the database. To find out which one it is, run the following script against the MSCRM database.

select r.ResourceId, r.OrganizationId, r.BusinessUnitId, r.Name, u.FullName from Resource as r left outer join SystemUserBase as u on r.ResourceId = u.SystemUserId where r.ObjectTypeCode = 8


If the 4th and 5th columns do not match, this CRM user record has been deleted from the SystemUserBase table, then we need to remove the orphan record from the Resoursebase table. To do so, please run the following script.

delete from ResourceBase where ResourceId in (select r.ResourceId from Resource as r left outer join SystemUserBase as u on r.ResourceId = u.SystemUserId where r.ObjectTypeCode = 8 and u.FullName is null)


That should solve the issue. Ofcourse you should always make a backup before trying these kind of actions!

Thanks Robert for sharing!

17 comments:

Anonymous said...

Working on deploying CRM 3.0 Analytics. Ran into a problem at step 5.28 of Deployment Guide. Completed deployment steps(step 2 appears to have a typo..rather than "copy...in" looks like it should be "copy....to"). But when I tried to access site, received "The page cannot be displayed" message. Thinking I have a config issue with site setup. Anyone been through this?

Thanks for your help!

Anonymous said...

Thanks for the fix. I can't imagine how long it would have taken me to find the orphan record in ResourceBase table without this post.

Kent

Anonymous said...

Hello Ronald,

With regard to "Error when creating a new appointment" I have the same issue when I try to create an appointment, even though I applied CRM Rollup 1; also I checked if there were any orphan records, but all of them match very well.

Any suggestion on this?

Anonymous said...

I have the same problem, i think it may be a bad configuration of the crmmail mailbox but it's installed on SBS 2003.

Anonymous said...

ronald, i love you :)
thanks!

Anonymous said...

I have the same error, but it seems to relate to some users, not all users. I could not find any Orphan records. Any other suggestions? SW

Vinodkumar said...

i m facing the same error but there are no orphan records. Also I face error while opening service calendar

Utsav said...

Thanks for your help ! :)

It would have taken really long to find where the issue was.

Utsav
CRM Developer
Ennovate Tech. - Einfochips
http://www.ennovatetech.com

Eric W. Cahoon said...

Thank you for this post. It would have been nice of Microsoft to include a foreign key relationship between the ResourceBase and SystemUserBase table to prevent deletion of SystemUser records without deleting the record(s) from the Resource tables.

Ronald Lemmen said...

Hi Eric,

Good idea! You should tell Microsoft about this.

You can submit product requests like these on http://connect.microsoft.com/
All the requests on this site are directly viewed by the CRM development team. That's the best approach to inform Microsoft about your ideas.

Ronald

Anonymous said...

Ronald, thank you thank you thank you thank you! Your post sure saved my bacon today!

Ronald Lemmen said...

That's one beer please :)

Anonymous said...

C# create new appointment in scheduler

Michael Williams said...

I can't tell you how stressful it is trying to set up an appointment. When trying to work it around your time and theirs, it can end up not working out too well. I almost wish companies had a system which would give out the times you can schedule an appointment. http://www.answerall.com/pages/services_answerall.html

Anonymous said...

Thanks a lot Ronald. You save my day. Much appreciated for your contribution.

Valy Greavu said...

It works perfect for me. Thank you!

meto mayo said...

Really impressive post. I read it whole and going to share it with my social circules. I enjoyed your article and planning to rewrite it on my own blog.
https://www.roknelbeet.com/نقل-اثاث-بجدة/
https://www.roknelbeet.com/نقل-اثاث-بالدمام/
https://www.roknelbeet.com/نقل-اثاث-بمكة/
https://www.roknelbeet.com/تخزين-اثاث-بالرياض/