The following are some of the errors and their resolutions encountered during installation/upgrade
Error 1SQLSERVERAGENT (SQLSERVERAGENT) service is not running on the server ......
Resolution:· Check if SQLSERVERAGENT service is running
· Open the port 445 for SQL Server.
Error 2During the import of the organizations the following warning was received.
"Fragmented indexes were detected in the Microsoft Dynamics CRM database",
Re-index the organisation databases
"print '?' DBCC DBREINDEX ('?', ' ', 80)"
Updating statistics ensures that queries compile with up-to-date statistics
Error 3The following error message was received when testing the email router:
Type 'System.ServiceModel.Channels.ReceivedFault' in Assembly 'System.ServiceModel, Version=18.104.22.168, Culture=neutral, PublicKeyToken=b77a5c561934e089' is not marked as serializable
Add the account running the email router services to PrivUserGroup security group.
Error 4The following error message was received when accessing the reports from any of the organizations:
Microsoft.Crm.Web.Reporting.SrsReportViewer.SetExecutionCredentials(ServerReport reportObj) Cannot create a connection to data source 'MSCRM'. (rsErrorOpeningConnection)
The reason was SSRS connector(reporting extensions) was installed using user other than deployment account. The SSRS service account was missing in privreportinggroup group.
- · Add SSRS service account to privreporting group.
- · Reinstall the reporting extension again using deployment account.
- 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.
Issue 1Unknown labels in settings group as shown in the screen shot below. This had happened to all four organisations.
Resolution:Follow the Microsoft article for resolution: http://support.microsoft.com/kb/2530358.
Issue 2The main tab is closed by default as shown in the screen shot below:
It is noted that this happened on multiple different locations throughout all the organisations.
- Open the form in customisation mode.
- Expand the tab, save the changes and then publish the changes.
That’s all from me.