CRM2011 Setup and Upgrade Errors With Resolutions

When upgrading from CRM 4.0 to MS CRM 2011 you might bump into serveral issues, I've listed some of the most normal serarios :)

"Fragmented indexes were detected in the Microsoft Dynamics CRM database",
This might accure during the import of the organizations:

Resolution:
Re-index the organisation databases (A SQL script)

USE MyDatabase
GO
EXEC sp_MSforeachtable @command1="print '?' DBCC DBREINDEX ('?', ' ', 80)"
GO
EXEC sp_updatestats
GO

Updating statistics ensures that queries compile with up-to-date statistics

'System.ServiceModel.Channels.ReceivedFault' in Assembly 'System.ServiceModel, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b73a53451934e545' is not marked as serializable
Error when testing Email router:

Resolution:
Add the account running the email router services to PrivUserGroup security group.

SQLSERVERAGENT (SQLSERVERAGENT) service is not running on the server ......


Resolution:
· Check if SQLSERVERAGENT service is running
· Open the port 445 for SQL Server

Microsoft.Crm.Web.Reporting.SrsReportViewer.SetExecutionCredentials(ServerReport reportObj) Cannot create a connection to data source 'MSCRM'. (rsErrorOpeningConnection)
The error message gets received when accessing the reports from any of the organizations:

Resolution:
· Add SSRS service account to privreporting group.
· Reinstall the reporting extension again using deployment account.

The process to resolve was as follows:

1. Uninstall the Reporting Extensions.
2. Go to the CONFIG DB (MSCRM_CONFIG) of CRM and update your organization's row in the Organization table to set the AreReportsPublished boolean field to FALSE.
3. Re-install the Reporting Extensions and they should publish the reports again.

Note: You will see the message about installation is republishing the reports again

Unknown labels in settings group

Resolution:
Follow the Microsoft article for resolution: http://support.microsoft.com/kb/2530358.

Happy XRM'ing!

CRM 2011 server sloooooooow?

Have you checked you SQL memory usage? Do you have several applications running against the same SQL server? Are you using SQL 2008? well, then you realy should check the following:

• What kind of settings are set for memory usage for each application instance in the SQL?

g.ex: you're using SharePoint and CRM on the same SQL server, and total have 8GB memory on the SQL server.(This does NOT inc the CRM server and SharePoint server).

What should I think of?
- Number of users at once on each application.
- The requirements and usage of each application
- +++ other factors

Good rules: (This is ONLY an example. It's almost imposseble to say what's good for your enviorment)

1. Always let the OS have some memory. (Let's say 1,5GB) - 6,5GB left
2. Calculate how much memory to give CRM and SharePoint (in this case)
• Rember to think of application usage and number of users online at same time.
• NOTE (Often the memory usage get's Multiplyed with ca 1,5 from the max if server gets stressed)
• God practis is operating with 1024MB, so if we want 2GB we give 2048MB memory
• Let's say we give the CRM server 3072MB and SharePoint 3072MB
• (Do not foreget the 1,5 factor!!)
3. Set the max and min Memory for each application instance in SQL:
1. Go to: SQL Manager > The SQL instance > Properties > memory
2. (Make sure services and no users are using system)

(How to find memory setings pr SQL application instance)

If your setings are setup like this: You should consider changing the SQL memory settings. Default "Next, next, next install setings"!

(How to "eat" all memory on SQL. hehe...)

Adjust the max and min memory usage as calculated

(How to adjust the memory)

This is what happend when the memory is adjusted:

(SQL response faster, and memory usage lower)

Again, this is an example you'll have to figure out the correct numbers and settings yourself based on enviorment and numbers of users! Tip: If you use virtual SQL server; check your networkcard setings for TCP/IP aswell! ;)

Hope this gives you some tips on how to get faster response from SQL to Your CRM 2011!