Archive for the ‘MS Dynamics CRM’ Category

Performance Optimization of CRM 2011 Quick Find Queries

October 21, 2014

Quick Find is a basic navigation tool to help you find specific records in CRM 2011. Quick Find optimizations have been included in Dynamics CRM 2011 Update Rollup 10 (UR10). By default, these are enabled after applying UR10; however, you can disable them using the option in System Settings:

(Settings | Administration | System Settings | General Tab)

The setting is at the bottom of the “General” tab called “Enable Quick Find Record Limits,” which is set to “Yes” by default.

Engable or disable CRM 2011 quick find records

When the optimizations are enabled, if more than 10,000 records are returned by a Quick Find query, the following error will occur:  “Quick find limit exceeded. Please use a more selective search value, or use Advanced Find for your search.”

If users need to search using terms that will potentially match over 10,000 records, this setting can be disabled. However, disabling the setting may result in slower overall performance for Quick Find queries. A more appropriate tool for such queries would be to use Advanced Find.

In order to take full advantage of the new Quick Find optimizations, customers will need to implement custom SQL indexes on their Find Columns.  As SQL indexes currently cannot be created in CRM Online, this can only be done in On Premise.

Example:

If you have a custom field on the Contact entity called po_CustomField, and you have enabled this as a Find Column for Quick Find searches.  In order to take full advantage of the new optimizations, create the index:

CREATE NONCLUSTERED INDEX IndexName

ON [dbo].[ContactExtensionBase] ([po_CustomField])

GO

You can optimize the way query performance by modifying the way CRM displays the query results. With the release of Dynamics CRM 2011 UR10, we can now limit the search results returned by quick find and also utilize the new Quick Find query structure by implementing SQL indexes on the column or set of columns used in a Quick Find query.

For more information on performance improvements in Dynamics CRM 2011 UR10 and Quick Find queries please Optimizing and Maintaining a Microsoft Dynamics CRM 2011 Server Infrastructure Performance white paper.

Source: Power Objects Blog

Update Rollup 18 for Microsoft Dynamics CRM 2011 (KB 2958724)

October 10, 2014

Microsoft has released Update Rollup 18 for Microsoft Dynamics CRM 2011 Server, Microsoft Dynamics CRM for Microsoft Office Outlook, Microsoft Dynamics CRM 2011 Language Packs, and Microsoft Dynamics CRM 2011 Email Router.

For more information about this release, see Microsoft Knowledge Base article 2958724:

Update Rollup 18 is available for Microsoft Dynamics CRM 2011

To maintain parity between the application components of Microsoft Dynamics CRM 2011, this update rollup includes packages for Microsoft Dynamics CRM Server, Microsoft Dynamics CRM for Outlook, Microsoft Dynamics CRM Language Packs, and Microsoft Dynamics CRM Email Router.

Download

Reporting error. Report cannot be displayed. (rsProcessingAborted)

October 9, 2014

I was getting the above error while running one of the custom SSRS report inside CRM 2011.

To resolve this issue I had to follow these steps

  1. Start SQL Server Management Studio
  2. Expand Security, then expand Logins
  3. Select and right click the account under which the SQL Server Reporting Services is running.
  4. Select User Mapping and select YouOrg_MSCRM database and specify following role membership
  • CRMReaderRole,
  • db_owner
  • public.

Source: Nishant Rana’s Weblog

Refresh for Connector for Microsoft Dynamics V3 CU 3 now available

October 3, 2014

It has been brought to our attention that the Windows updates associated with KB 2977766 & KB 2977765 can cause the following issue when running the Microsoft Dynamics CRM Adapter Configuration Utility to configure a Microsoft Dynamics CRM organization.

Upon launching the Microsoft Dynamics CRM Configuration Utility from within Connector for Microsoft Dynamics you may receive an error message like the following: “Unhandled app domain exception caught”.

Installing the refreshed version of Connector for Microsoft Dynamics V3 CU 3 (3.3.823.1) will resolve this issue.  This version can be downloaded at the following links:

Please note:

If you have previously worked around this issue by copying the Microsoft.Dynamics.Xrm.Sdk.dll from the Adapters\Microsoft Dynamics CRM 2011 Adapter\ folder to the root folder of the Connector for Microsoft Dynamics installation you will need to remove that .dll from the root folder before upgrading to this or any subsequent release of Connector for Microsoft Dynamics.

All Microsoft Dynamics CRM 2013 Downloads

September 4, 2014

APPLICATIONS

Microsoft Dynamics CRM Server 2013
(90 day trial, 5 CAL limit): NX77Y-BTBCV-JP3T3-8W7JH-94QJP
(90 day trial, no CAL limit): CQWW3-TNXBF-HRQWC-CVTW9-M968H

Microsoft Dynamics CRM 2013 for Microsoft Office Outlook (Outlook Client)

Microsoft Dynamics CRM 2013 Email Router

Microsoft Dynamics CRM 2013 Report Authoring Extension (with SQL Server Data Tools support)

Microsoft Dynamics CRM 2013 Language Packs

MOCA

IPAD Client for CRM 2013 currently available in the iTunes App Store

SDK

Microsoft Dynamics CRM 2013 Software Development Kit (SDK)

DOCUMENTATION

Microsoft Dynamics CRM 2013 Implementation Guide

Using multi-tenancy in Microsoft Dynamics CRM 2013 to address challenges in enterprise business environments

Connectivity and Firewall Port Requirements for Microsoft Dynamics CRM 2013

Manage Your Microsoft Dynamics CRM Online Subscription

TOOLS

Microsoft Dynamics CRM 2013 Custom Code Validation Tool

Microsoft Dynamics CRM 2013 performance counters

SHAREPOINT

Microsoft Dynamics CRM 2013 List Component for Microsoft SharePoint Server 2010 and Microsoft SharePoint Server 2013 (for multiple browsers)

Microsoft Dynamics CRM 2011 List Component for Microsoft SharePoint Server 2010 and Microsoft SharePoint Server 2013 (for multiple browsers)

Microsoft Dynamics CRM 2013 Disable Welcome Screen

August 27, 2014

Checking “dont show this to me again” does not disable the welcome screen.

To remove permanently an registry update is necessary.

1. Start Registry Editor.

2. Locate registry subkey: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM.

3. Right-click MSCRM, point to New, click DWORD (32-bit) Value, enter DisableNavTour, and then press ENTER.

4. Right-click DisableNavTour, click Modify.

5. In the Value data box, type 1, and then press ENTER.

6. Close the Registry Editor.

Source: James OConnor Dynamics MS CRM Blog

Microsoft Demo Builder 2013

August 17, 2014

Demo builder helps you build demos with data which can be used in your corporate demo.

It also comes with OOB SharePoint integration, Azure Integration as well as customer portal. Very handy for setting up quick demo environment.

clip_image003

Check this link for details:

https://www.microsoftdynamicsdemos.com/

Guid Finder Solution for Microsoft Dynamics CRM 2011

August 5, 2014

Guid Finder Solution for Microsoft Dynamics CRM 2011.
This Solution helps to find any record “GUID” across all entities in Dynamics CRM.

The Solution includes a new Entity (called “Guid Finder”) and a plugin.

This solution enables the users to find any record Guid acress all entities.
You can query in two ways:

1) query in all entities (the plugin will retrieve all entities and will try to find the record guid in each one)
2) query just in filter entities (separeted by comas “,”).

img1.jpg

In the form you can write a guid, and when you créate this record, a pre-créate plugin will query all the information.
You can also see an execution log in the form after creation:

img2.jpg

Download

Update Rollup 3 for Microsoft Dynamics CRM 2013 (KB 2930480)

August 4, 2014

Microsoft has released Update Rollup 3. This is a tested, cumulative set of updates for Microsoft Dynamics CRM 2013. It includes performance enhancements that are packaged together for easy deployment.

Download

Microsoft Dynamics CRM 2013 for Android, iPhone, Windows Phone released

August 2, 2014

Microsoft just released Dynamics CRM 2013 mobile apps for mobile devices, including Android, iPhone and Windows Phone devices!

While still it is not as comprehensive as Ipad & Windows 8 mobile applications, but the mobile apps improve the usability for users and allows them to access quickly CRM information on the go.

You can download the app directly from App Store’s:

Dynamics CRM 2013 Mobile Client for Android:

https://play.google.com/store/apps/details?id=com.microsoft.crm.crmhost&hl=en

Dynamics CRM 2013 Mobile Client For iPhone:

https://itunes.apple.com/us/app/microsoft-dynamics-crm-for/id723891307?mt=8

Dynamics CRM 2013 Windows Phone App:

http://www.windowsphone.com/en-us/store/app/dynamics-crm/bdf6ad14-8ff3-4db1-a9d5-336c50ef13ee


Follow

Get every new post delivered to your Inbox.

Join 30 other followers