Blogs

In Dynamics CRM 2011, after migrating an organization from Dynamics CRM Online to Dynamics CRM On Premise or Partner Hosted, you recieve a generic SQL Error when attempting to create a new entity.

In researching this, we found two issues:

1. CRM is trying to execute a stored procedure called sp_MS_marksystemobject and the CRM Application Service Account does not have execute permissions on this stored procedure.
2. the stored procedure p_FreeProcCache does not exist.

The first issue surfaced in the following error message in the CRM Trace Logs:

CRM Trace Log Error:
System.Data.SqlClient.SqlException
(0x80131904): The EXECUTE permission was denied on the object 'sp_MS_marksystemobject',
database 'mssqlsystemresource', schema 'sys'.

You can resolve this issue by running a grant execute script on sp_MS_marksystemobject on the SQLAccessGroup login in the Master Database. Now, don't go looking for this stored procedure in the master database. You will not find it. It is actually in a hidden system database called mssqlsystemresource. However, running the grant statement in the Master database still works.

Completing this step may solve your problem. So, you should try adding an entity after this step is complete. If it still does not work, you may see the following error in the CRM Traced Log:

CRM Trace Log Error:
System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'p_FreeProcCache'

If this is the issue, it means that the p_FreeProcCache procedure is missing entirely from your CRM Database. Run the following two scripts to (1) create the procedure in your CRM Organization database (Organization_MSCRM) and to (2) convert it to a system object. Once this is done, you should be able to create entities in CRM.

Statement 1:
Create proc [dbo].[p_FreeProcCache] AS
begin declare @i intselect @i =db_id();
DBCC FLUSHPROCINDB(@i);
end
Exec sys.sp_MS_marksystemobject 'p_FreeProcCache'

Statement 2:
Exec sys.sp_MS_marksystemobject 'p_FreeProcCache'

Recently I was asked to create a SmartList for a table that was in a none Dynamics GP database. I logged into the SQL Server Management Studio as sa and created a view of the table in each of the GP Company databases. Then I logged into GP and created a SmartList of the view, set security, ran the GP grant.sql script against the company databases. I tested the view as the 'sa' user and it worked well but when I logged in as any other user I could see the SmartList but it returned no data. To fix the issue I had to give the DYNGROUP read/select access to the physical table.

We have seen CRM Outlook Client users receive the following message:

A Microsoft Dynamics CRM window was unable to open, and may have been blocked by a pop-up blocker. Please add the Microsoft Dynamics CRM server to the list of sites your pop-up blocker allows to open new windows: servername

CRM Pop-up Blocker Error: CRM Pop-up Blocker Error

We fixed this by running the Automated fix from Microsoft to solve the issue Hyperlinks not working from Outlook.

http://support.microsoft.com/kb/310049

We discovered that KB2699988 breaks the ability of DYNAMICS CRM Reports to be exported when the report is run from Outlook. Uninstalling the patch fixes the problem.

I have the Microsoft WPC App installed in my Facebook. This morning, I eagerly poured a cup of coffee, got onto the app and began watching the Keynotes. Steve Ballmer spoke extensively about the new Surface tablet coming out soon. Then he turned over the presentation to Tami Reller -- VP at Microsoft. Tami and I worked together when I was at FRx Software and she was at Great Plains.

She demonstrated the Windows 8 applications, OS and hardware. She announced that Windows 8 will release to manufacturing in August and on machines by end of October, 2012. She demonstrated many touchscreen machines and one that I liked a lot, the Lenovo Yoga -- a laptop that folds into a Tablet form factor.

If you buy a Windows 7 PC today you can upgrade to Windows 8 Pro for $14.99 (she said 1499... I believe that would be $14.99 and not $1,499!) Every PC will have a Skydrive account which is an awesome Cloud file storage application that will give you "on the go" capabilities. Apps are the heart of Windows 8. Every app's touch response seems to be very quick. The Windows App store with e-commerce sellability will be open with the release of Windows 8.

She showed Windows RT running on a Qualcomm device (tablet). She demonstrated all the regular business productivity applications you would want. Instead of going through each, let's just say that for my demands, there is more than sufficient functionality for my needs.

WOW! I was going to refill my cup of coffee but I waited! I am glad that I did. Tami is now showing Windows To Go -- Windows 8 on a thumb drive. This is a 32 GB thumb drive plugged into a Windows 7 machine but now the machine is booting up with Windows 8 Professional with all the IT Security built into it! She booted into Windows 8 with all of her apps, security and personalization! Okay, now I will refill the coffee. That was totally cool!