CRM

Microsoft CRM IFD The SSL certificate does not contain all UPN suffix values that exist in the enterprise – Cannot Login

Cannot Login to a Previously working Microsoft CRM IFD A previously working IFD deployment of CRM 2016 (but could be CRM 2015 or CRM 2013). About 1 year after you set the system up, you start receiving: An error has occurred. Try this action again. If the problem continues, check the Microsoft Dynamics CRM Community for solutions or contact your organization’s Microsoft Dynamics CRM Administrator. Finally, you can contact Microsoft Support. When researching this error, we suspected what it was, and related to an article we covered here: http://www.interactivewebs.com/blog/index.php/crm-2013/microsoft-crm-2013-or-2015-event-id-1309-adfs-ifd-resolution/ However we never found and EVENT ID 1309 or anything close to that in our logs. The closest error we found (and we are not even certain that it… Read More »Microsoft CRM IFD The SSL certificate does not contain all UPN suffix values that exist in the enterprise – Cannot Login

Microsoft CRM global search fails causing in-line search SQL error

CRM in-line search fails with SQL error After upgrading Microsoft CRM from earlier versions we found that the global search function when enabled failed to return any results, and once the index for the global search had run over a 24-hour period, the in-line search function for any entity would cause a crash and SQL error message to be displayed on page. The problem In our particular instance this CRM environment had been upgraded from much earlier versions of CRM and included an attempt to solve some upgrade issues by dropping indexes. Initially our thoughts were that the dropping of the indexes were responsible for the problems. However it appears retrospectively that was a fragmentation… Read More »Microsoft CRM global search fails causing in-line search SQL error

ZenDesk to Microsoft CRM integration password change

Changing your password in ZenDesk may affect your Microsoft CRM integration  if you are to upgrade or change the password that you utilise in your ZenDesk system for the account that has been set to synchronise data with the Microsoft CRM platform, you will notice that the synchronisation may not function correctly or may only perform a one-way synchronisation.  You will remember from the instructions that you likely followed in your initial configuration: http://www.interactivewebs.com/blog/index.php/zendesk/zendesk-to-crm-2015-integration/    that part of these configuration settings is to set up your password and username in the SETTINGS / ZD Personal Settings –  area of your Microsoft CRM system.  Below is an extract from the vendor’s configuration portal found here Step 2:… Read More »ZenDesk to Microsoft CRM integration password change

Microsoft.Crm.CrmException: Database having version 7.0.1.129 is not supported for upgraded Microsoft.Crm.CrmException: Database having version 7.0.1.129 is not supported for upgraded.

When upgrading from CRM 2013 to CRM 2015 you get an error: Microsoft.Crm.CrmException: Database having version 7.0.1.129 is not supported for upgraded. Cause: This is usually because there is already a database that exists with the same ID. You will need to delete that Organisation in CRM deployment manager before upgrading the new organisation from the same name.

CRM 2016 Import Upgrade from CRM 2015 Failure: Timeout expired

CRM 2016 Import  Upgrade from CRM 2015 Failure: Timeout expired On attempting to upgrade a Microsoft CRM Dynamics 2015 Database to CRM 2016 (without service pack) you receive a Failure: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.. This happens at the System Check stage. There are a bunch of suggestions online from earlier releases of CRM like 4.0 etc suggesting that you may need to change the timeout settings on the settings with some DWord changes in the registry. In this case it is not the cause. Cause Microsoft has again released an initial version of their software with some significant bugs. The biggest of these… Read More »CRM 2016 Import Upgrade from CRM 2015 Failure: Timeout expired

How to Set Up Microsoft CRM 2016 IFD on Windows 2012 R2 Server

How to Set Up Microsoft CRM 2016 IFD on Windows 2012 R2 Server We already have a popular post for the configuration of IFD setup with CRM 2015, CRM 2013, CRM 2011. Now we are updating this post to support CRM 2016. Microsoft have a compatibility listing for CRM 2016 here: https://support.microsoft.com/en-us/kb/3124955 The Development Setup  Once again we are running this configuration as a test environment for development. As such we will be running, we are running the server on a Hyper V server. A single VM machine, that is running a fully patched version of: Windows 2012 R2 SP2 64 Bit – (MSDN File: en_windows_server_2012_r2_x64_dvd_2707946)  SQL 2014 R2 64 Bit – SQL Server 2014 Standard Edition x64… Read More »How to Set Up Microsoft CRM 2016 IFD on Windows 2012 R2 Server

CRM 2013 IFD Setup with ADFS 3.0 on Windows 2012 R2 Hosted Setup

We already have a popular post for the configuration of IFD setup with CRM 2011, and recently we updated this blog to support CRM 2015 here:  http://www.interactivewebs.com/blog/index.php/crm/how-to-set-up-crm-2015-ifd-on-windows-2012-and-adfs-3-0/ Many of you may find that better for setting up CRM 2013 than this blog, as the data is mostly exactly the same as this blog, but some of the order of things is better described. Upgrading from CRM 2011 to CRM 2013 and need help? InteractiveWebs offer professional Microsoft CRM Upgrade Services and Support. The Existing Setup Because this is a test environment, we are running the server on a Hyper V server. A single VM machine, that is running a fully patched version of: Windows 2012… Read More »CRM 2013 IFD Setup with ADFS 3.0 on Windows 2012 R2 Hosted Setup

Microsoft CRM IFD Event 364 and 111 in ADFS

Microsoft CRM IFD Event ID 364 and 111 We got the ADFS login screen as expected, but on trying to login we received an error: Activity ID: 00000000-0000-0000-0400-0080020000f4 Relying party: CRM IFD Relying Party Associate with two errors in the ADFS Event Log. Event ID: 111 Additional Data Exception details: System.ArgumentException: ID4216: The ClaimType ‘* Name’ must be of format ‘namespace’/’name’.Parameter name: claimTypeat Microsoft.IdentityModel.Threading.AsyncResult.End(IAsyncResult result)at Microsoft.IdentityModel.Threading.TypedAsyncResult`1.End(IAsyncResult result)at Microsoft.IdentityModel.SecurityTokenService.SecurityTokenService.EndIssue(IAsyncResult result)at Microsoft.IdentityServer.Web.WSTrust.SecurityTokenServiceManager.Issue(RequestSecurityToken request, IList`1& identityClaimSet)  Event ID: 364 Encountered error during federation passive request. Additional Data Protocol Name: wsfed Relying Party: https://crm2016.iwebscrm16.com:444/ Exception details: Microsoft.IdentityServer.RequestFailedException: MSIS7012: An error occurred while processing the request. Contact your administrator for details. —> System.ArgumentException: ID4216: The ClaimType ‘* Name’ must be of format ‘namespace’/’name’.Parameter name: claimTypeat… Read More »Microsoft CRM IFD Event 364 and 111 in ADFS

Microsoft CRM Restore Database Failed Only Enterprise edition of SQL Server supports partitioning

Upgrading from CRM 2011 to CRM 2013 you cannot restore SQL on a Non Enterprise Server An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)Database ‘Org_MSCRM’ cannot be started in this edition of SQL Server because it contains a partition function ‘AuditPFN’. Only Enterprise edition of SQL Server supports partitioning. Database ‘Org_MSCRM’ cannot be started because some of the database functionality is not available in the current edition of SQL Server. (Microsoft SQL Server, Error: 905) CAUSE When Microsoft Dynamics CRM 2011 is installed using a Microsoft SQL Server Enterprise edition, a partition is created for the auditing functionality of Dynamics CRM 2011. The AuditBase table uses partitioning which is only available for… Read More »Microsoft CRM Restore Database Failed Only Enterprise edition of SQL Server supports partitioning

Microsoft CRM Solution Import Fields that are not valid were specified for the entity

While importing a solution to CRM 2011, CRM 2013, or CRM 2015 you receive an error  Fields that are not valid were specified for the entity   The Cause The cause of this is likely that one of the attributes that you are importing (from a dev environment) already exists in the CRM instance, but with a different attribute. For Example: In your Live Environment Within Accounts, you create a new attribute called “Friendly Cusomter” and mark it TEXT  Publish and all is well and good. In you Dev Environment Within Accounts, you create a new attribute called “Friendly Customer” and make it a PICK LIST   in other words, the same name for the… Read More »Microsoft CRM Solution Import Fields that are not valid were specified for the entity

The e-mail address for one or more recipients is either blank or not a valid e-mail address

The message cannot be sent to all selected recipients.  When running a workflow / process in Microsoft CRM, you receive a message that looks like this: The e-mail address for one or more recipients is either blank or not a valid e-mail address The Cause This error message is a little misleading as it points to an email address problem. As the title of the error suggests, the problem could be from: 1. A blank email address. 2. An email address with an error, such as a “.” at the end of it: email@addresss.com. 3. The more likely one is that the contact or account record associated with the flow has a setting to  E-mail… Read More »The e-mail address for one or more recipients is either blank or not a valid e-mail address

How to Set up CRM 2015 IFD on Windows 2012 and ADFS 3.0

We already have a popular post for the configuration of IFD setup with CRM 2013 and CRM 2011. Now we are updating this post to support CRM 2015. Microsoft have a compatibility listing for CRM 2015 here: http://support.microsoft.com/kb/3018360 The Development Setup  Once again we are running this configuration as a test environment for development. As such we will be running, we are running the server on a Hyper V server. A single VM machine, that is running a fully patched version of: Windows 2012 R2 SP2 64 Bit – (MSDN File: en_windows_server_2012_r2_x64_dvd_2707946)  SQL 2014 R2 64 Bit – SQL Server 2014 Standard Edition x64 – (MSDN File: en_sql_server_2014_standard_edition_x64_dvd_3932034) – Patched to SP2 Microsoft Dynamics CRM Server 2015 (x86 and… Read More »How to Set up CRM 2015 IFD on Windows 2012 and ADFS 3.0

CRM 2013 Warning Data encryption will be active after the install or upgrade.

When importing a database from CRM 2011 to CRM 2013, you may receive an error: Data encryption will be active after the install or upgrade. We strongly recommend that you copy the organization encryption key and store it in a safe place. For more information, see http://go.microsoft.com/fwlink/?LinkId=316366. Understanding This Microsoft Dynamics CRM 2013 uses standard SQL Server cell level encryption for a set of default entity attributes that contain sensitive information, such as user names and email passwords for Server-Side Sync and authentication tokens for Yammer integration capabilities.  This feature can help organizations meet FIPS 140-2 compliance by ensuring that the data is encrypted “at rest” so that local database admins cannot read the data in… Read More »CRM 2013 Warning Data encryption will be active after the install or upgrade.

CRM 2011 to 2013 "Database cannot be started in this edition of SQL Server" error when restoring a Microsoft Dynamics CRM database.

When restoring a database that is a backup of a CRM 2011 database and you are restoring it to a CRM 2013 server running SQL 2012 but not Enterprise, you may receive an error:  “Database cannot be started in this edition of SQL Server” error when restoring a Microsoft Dynamics CRM database. This error only happens when the original SQL instance was running an enterprise version and the destination server is not. The Cause When Microsoft Dynamics CRM 2011 is installed using a Microsoft SQL Server Enterprise edition, a partition is created for the auditing functionality of Dynamics CRM 2011. The AuditBase table uses partitioning which is only available for Microsoft SQL Server Enterprise. The… Read More »CRM 2011 to 2013 "Database cannot be started in this edition of SQL Server" error when restoring a Microsoft Dynamics CRM database.

Microsoft CRM 2011 Defaults to Mobile Site /m

Microsoft CRM 2011 Defaults to Mobile Site /m When hitting our CRM 2011 website after recent rollup updates, the website defaults to to a URL with a /m/  and shows a mobile site. The FIX This is really simple. When the site reformats to:  /m/defualt.aspx  Just replace that with /main.aspx So this: https://acc.interactivewebs.com:444/m/default.aspx Becomes: https://acc.interactivewebs.com:444/main.aspx It’s that easy!

Microsoft CRM 2011 Exception message: ID4175: The issuer of the security token was not recognized by the IssuerNameRegistry

Error When attempting to login to an IFD (Internet Facing Deployment of CRM) you receive this error: Event code: 3005 Event message: An unhandled exception has occurred. Event time: 10/06/2014 1:54:52 AM Event time (UTC): 9/06/2014 3:54:52 PM Event ID: 6da606a9a6794c2a8f504cc6b8b3be3e Event sequence: 2 Event occurrence: 1 Event detail code: 0  Application information:     Application domain: /LM/W3SVC/2/ROOT-1-130468028783689054     Trust level: Full     Application Virtual Path: /     Application Path: C:\Program Files\Microsoft Dynamics CRM\CRMWeb\     Machine name: VSERVER08  Process information:     Process ID: 1540     Process name: w3wp.exe     Account name: NT AUTHORITY\NETWORK SERVICE  Exception information:     Exception type: SecurityTokenException     Exception message: ID4175: The issuer of the security token was not recognized by the IssuerNameRegistry. To accept security tokens from this issuer, configure the IssuerNameRegistry… Read More »Microsoft CRM 2011 Exception message: ID4175: The issuer of the security token was not recognized by the IssuerNameRegistry

Microsoft CRM IFD SSL Certificate Renewal

Following on from our very popular IFD configuration for Microsoft CRM. [gard] http://www.interactivewebs.com/blog/index.php/server-tips/microsoft-crm-2011-how-to-configure-ifd-hosted-setup/ The time will come around where you need to renew the SSL certificate for your CRM IFD configuration. This will include the renewal of the SSL certificate as used by IIS and and ADFS. Couple of steps we followed based exactly on the configuration outlined in our above linked blog post. Generate a new SSL Request. 1. Open IIS Manager and click on server certificates. 2. Create certificate request 3. Fill in the data: Next 4. Change to 2048 Bit 5. Give it a name: Finish and you are done. Now Open the certificate text file and copy the text to your… Read More »Microsoft CRM IFD SSL Certificate Renewal

CRM 2011 Email Router Setup and Settings

Often with the setup of CRM 2011. Users experience messages about Pending e-mail warning and sometimes email messages are not sending. [gard] This can be especially frustrating as both the CRM email queuing and tracking system and the Email router application are terrible to help you understand exactly what is going on with your CRM e-mail. We mentioned some of the issues we have experience here: http://www.interactivewebs.com/blog/index.php/server-tips/crm-2011-email-router-problemsshes-a-fickle-bitch/ Here are some basic setup tips for email in Microsoft CRM 2011 1. Out of the box, CRM does not send email messages. You need to configure an application known as CRM 2011 Email Router to have email messages send. 2. You also need a working SMTP (email… Read More »CRM 2011 Email Router Setup and Settings

Download Rollup 12 for Microsoft Dynamics CRM 2011 is Available–Finally

Reposted: Today the update Rollup 12 for Microsoft CRM 2011 (CRM 2011 Polaris on premises) is available for download at this location: Download http://www.microsoft.com/en-us/download/details.aspx?id=36229   This update is the long awaited one that is doing the UI update that will add the support for multiple browsers apart from Internet Explorer. The image above depicts the functionality included in Polaris. I will now touch upon some of the key ones in a little more detail, hopefully in plain English! Flow User Experience – this is a whole new UX development approach for CRM to remove the number of screen pops that occur during a standard process. In the case of Polaris, Lead and Opportunity and Case… Read More »Download Rollup 12 for Microsoft Dynamics CRM 2011 is Available–Finally

Import KB Articles from Microsoft CRM to Zendesk

Zendesk KB Import Tool / Sync We have created a tool that allows the importing of Microsoft CRM (IFD) into your Zendesk setup. The simple tool will look at your Microsoft CRM 2011 Articles (also known as KB articles) and draw them into your Zendesk support portal. This is powerful if you have an existing CRM system with useful client data that you wish to expose to your support portal as a way of helping your customers find answers to their questions before they directly lodge a support ticket. Additionally, the tool is smart enough to remove duplications. So if you run it against more than one instance of CRM, you can import KB articles… Read More »Import KB Articles from Microsoft CRM to Zendesk

CRM 2011 Rollup 10 Invalid Argument Error

CRM 2011 Rollup 10 Killed My CRM After installing CRM 2011 Rollup 10 (not 9 as that is MIA) you receive an Invalid Argument messages as per the image above. This happens after you login to an IFD deployment. For all we know it may happen on the CRM on premises but we have not managed to test that. You may also have a CRM Platform Trace Error: Crm Exception: Message: A non valid page number was received: 0, ErrorCode: –2147220989 CRM’s Fetch Throttling abilities have been disabled or modified from the default values. Re-enable CRM’s default Fetch Throttling settings. The solution 1. START | RUN | “regedit” | OK 2. Locate and select the… Read More »CRM 2011 Rollup 10 Invalid Argument Error

AD FS certificate rollover CRM 2011

You find that you can’t logon to your CRM 2011 IFD deployment that you have configured around 12 months earlier. In the browser you may see: HTTP Error 401 - Unauthorized: Access is denied <html><body><p> An error has occurred. <br/><br/> Try this action again. If the problem continues, check the Microsoft Dynamics CRM Community for solutions or contact your organization's Microsoft Dynamics CRM Administrator. Finally, you can contact Microsoft Support. </p></body></html>   Looking at the server log may show: SERVER Log Error show: 1309 Event code: 3005 Event message: An unhandled exception has occurred. Event time: 9/07/2012 12:09:59 PM Event time (UTC): 9/07/2012 2:09:59 AM Event ID: 50c7c9d7c3ba4b839bca7c72b9edf410 Event sequence: 51779 Event occurrence: 11 Event… Read More »AD FS certificate rollover CRM 2011

Event ID 17137 from source MSSQL$MICROSOFT##SSEE

  Cleaning up the Event Log On a system running the CRM 2011 IFD as described here: http://www.interactivewebs.com/blog/index.php/server-tips/microsoft-crm-2011-how-to-configure-ifd-hosted-setup/ You may notice in the Event Log some errors that look like: The description for Event ID 17137 from source MSSQL$MICROSOFT##SSEE cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer. If the event originated on another computer, the display information had to be saved with the event. The following information was included with the event: AdfsArtifactStore The specified resource type cannot be found in the image file The Solution 1) Open SQL server… Read More »Event ID 17137 from source MSSQL$MICROSOFT##SSEE

CRM Anywhere – CRM Q2 CY 2012 Service Update Now Live

CRM Anywhere Q2 CY 2012 Service Update Now Live   Microsoft CRM 2012 – CRM Anywhere Q2 2012   Preview some upcoming features in Q2 "R8" such as mobility, BI and Analytics enhancements from Reuben Krippner a MSFT Technical Product Management Lead in this video. One of the most talked about improvements in CRM Anywhere is the introduction of a new mobility component dubbed Microsoft Dynamics CRM Mobile. Cross-Browser Support Microsoft Dynamics CRM Mobile isn’t the only reason Microsoft is calling the coming update CRM Anywhere. Users of CRM Online 2011 will now be able to access the application using the following browser versions (see below). To understand why this is so important for CRM… Read More »CRM Anywhere – CRM Q2 CY 2012 Service Update Now Live

Microsoft CRM 2011 and Custom Silverlight Development

I noticed a question today on a Microsoft Dynamics CRM discussion site asking “is there anyone who is not trying to sell me their product, that has done something interesting with CRM and Silverlight?” Well yes there is… InteractiveWebs have done several interesting projects with Silverlight as an interface to Microsoft CRM. One of the most interesting of these is a Silverlight membership login system for a grain trading company based in Australia. The business is an organisation that trades produce in a similar way to how shares are traded in the stock market. The difference being that the commodity being traded has been grown by “growers” (farmers) and represents the produce that their farm… Read More »Microsoft CRM 2011 and Custom Silverlight Development

Disable SSL 2.0 IIS 7 Windows 2008 64bit with CRM 2011 for PCI Compliance

PCI Failure Today we received notification during a PCI compliance check that our Microsoft CRM 2011 server was not PCI Compliant. The cause of the lack of compliance was due to the server accepting connections via an SSL v 2.0 protocol. Synopsis : The remote service encrypts traffic using a protocol with known weaknesses . Description : The remote service accepts connections encrypted using S S L 2.0, which reportedly suffers from several cryptographic flaws and has been deprecated for several years . An attacker may be able to exploit these issues to conduct man-in-the-middle attacks or decrypt communications between the affected service and clients . See also : http://www.schneier.com/p Download File – ZipSource aper-ssl.pdf… Read More »Disable SSL 2.0 IIS 7 Windows 2008 64bit with CRM 2011 for PCI Compliance

CRM 2011 Server Error 404 – File or directory not found

Cannot Access CRM 2011 site 404 Something strange that we have encountered with CRM 2011 is a 404 – File or directory not found error. What is particularly strange about this one is that the error happens from IE 9 on one computer, but the same URL and site loads correctly with another browser on another computer AND loads correctly to the authentication screens on the same computer but with a different browser. Go figure right!   Microsoft show it as: So what is the Solution? We tried a number of things that did not work, and we will not bother to list them all, but interesting the clearing the browser history and cache etc… Read More »CRM 2011 Server Error 404 – File or directory not found

Your session in Microsoft Dynamics CRM is about to expire. CRM 2011 2013 Extend Session Time

Sick of seeing the message “Your session in Microsoft Dynamics CRM is about to expire. To continue working, you must sin in again.” and would like to extend the session time so as not to bother you as often? This is quite easy with an IFD setup of CRM 2011. We have an IFD configuration and setup that we use to test settings and some of our CRM Portal – Linking to DotNetNuke on. Taking the server as configured as described here: http://www.interactivewebs.com/blog/index.php/server-tips/microsoft-crm-2011-how-to-configure-ifd-hosted-setup/ We ended up with an ADFS Relying Party Trust that is named “CRM IFD Relaying Party” This is the name we must use in the Windows PowerShell program to make the necessary… Read More »Your session in Microsoft Dynamics CRM is about to expire. CRM 2011 2013 Extend Session Time

CRM 2011 XRM Performance Problem IIS Dynamic Compression

Microsoft CRM 2011 allows XRM services that use application/soap+xml content type. When you install Microsoft CRM 2011 in an IFD / hosted environment, it is smart enough to automatically configure IIS gzip compression on the website. What it does not do, is configure the C:\Windows\System32\Inetsrv\Config\applicationHost.config file to compress XRM calls out of the CRM database. In a test we were performing for an update to our Microsoft CRM 2011 Portal technology, we found that retrieving a list of around 20,000 items returned a 19 MB data package without gzip dynamic compression. Not huge but pretty big! What amazed us was that after enabling dynamic compression on the XRM data, this reduced from 19 MB to… Read More »CRM 2011 XRM Performance Problem IIS Dynamic Compression

Turn off Microsoft CRM 2011 5000 limit on data retrieval via SDK

[gard] With CRM 4.0 and Microsoft CRM 2011 there is a default limit for the number items that can be retrieved when making various types of web service calls into the CRM. Typically this limit is set to 5000 but with some types of calls it will return 7000. In any case, the process to remove the limit and set it to 20,000 is very easy. On the server running CRM Click Start, click Run, type regedit in the Open box, and then click OK. Locate and then select the following registry subkey:HKEY_LOCAL_MACHINE\Software\Microsoft\MSCRM On the Edit menu, point to New, and then click DWORD Value. Type TurnOffFetchThrottling, and then press ENTER. Right-click TurnOffFetchThrottling, and then… Read More »Turn off Microsoft CRM 2011 5000 limit on data retrieval via SDK