Managing Language Translations for multiple Organizations

I was implementing CRM for a manufacturing company which had their operations in multiple geographies and wanted the CRM solution to be available in different languages. We do have ability to enable languages and get the translations done.

Everything is fine if we have only one environment to work with; which is never the case. We always have Dev, QA, UAT and Production environments at a bare minimum. The limitation with exporting language translations is that we can only import the translations to the Organization from which we have exported it.

What this essentially means is that if we export the translation from Dev then we can only import them back to Dev, then the question arises How do we move these translated text from Dev to Production?. There is a very simple solution to it.
Continue reading

Invalid Action – The selected action was not valid

The other day while working on Dynamics CRM 2015 and one of the users came up to me saying everyone is getting a weird error trying to open CRM “Invalid Action – The selected action was not valid”.

Without wasting any further time, went ahead and opened the Front End Server and logged into the event viewer, which was logging the following error and the source was MSCRMKeyGenerator

CrmKey(Id:, ScaleGroupId:, KeyType:CrmWRPCTokenKey, Expired:True, ValidOn:05/27/2015 06:31:05,
ExpiresOn:06/29/2015 06:31:05, CreatedOn:05/27/2015 06:31:05, CreatedBy:NT AUTHORITY\NETWORK SERVICE
CrmKeySetting(Id:, KeyType:CrmWRPCTokenKey, KeyLength:128, KeyGenerationInterval:720, KeyTimeToLive:792,
CryptoTimeToLive:72, Algorithm:HMACSHA256, ArchiveLength:1, Enabled:True,

This error usually means that the Async service (maintenance) has not performed its task, mainly for two reasons

  • Service is not running
  • Service is not able to start due to login issues or any other issue

What’s the fix?

It is very simple, all you need to do is just check that the Microsoft Dynamics CRM Asynchronous Service (maintenance) is up and running. If it is stopped, go ahead and enable it.

  1. Go To Run and type services.msc
  2. Look for Microsoft Dynamics CRM Asynchronous Service (maintenance) and press the Start button or Right Click service name and select Start

If you still see this error then there is an additional thing you can try. Basically, renew the key manually and you should be fine. To do this, open Command Prompt

  1. Go to installation directory of Dynamics CRM, typically it would be %PROGRAMFILES%\Microsoft Dynamics CRM
  2. Navigate to the tools directory
  3. Run the command Microsoft.Crm.Tools.WRPCKeyRenewal.exe /R
  4. CRM should be good now.

Complex Calculations in Business Rules Dynamics CRM

Business Rules have been one of the greatest additions in Dynamics CRM, I just personally love them. Lately, there was a lot of feedback as to complex calculations were not possible using them.
I had a simple requirement where we just needed to do a very simple Percentage Calculation I.e. ProbableValue = (Est. Revenue * Probability) / 100. Previously this was being done in the JavaScript.

The idea to do this calculation in Business Rule is to divide the equation into multiple parts with each part containing only single operation, my case looks like below

**Probable Value = Est. Revenue * Probability**
**Probable Value = Probable Value / 100**

Hope you get the idea. This is how you should break your calculations and have only one operation per statement. It will also enable you to do any complex calculations as well. Possibilities are endless 🙂

See my Business Rule below

Export Translations

Clear field value in Business Rule CRM 2015 Update 1

With the introduction of Business Rules in CRM, it is now very easy for end users (non-developers) to perform simple tasks like Set value, show/hide field, etc based on conditions without writing any code. Previously these simple tasks were performed by developers using JavaScript.

Having said that, Business Rules also came with some limitations, one such limitation is the inability to clear field value. Lots of feedback’s were provided and finally the developers have listened and they have introduced this functionality in the latest update i.e. CRM 2015 Update 1.
Continue reading

FormType based Business Rules in CRM 2015

Ever been in a situation where you need to write a JavaScript code to show/hide, Enable/Disable or set certain field on the form, am sure there were a lot. The dev’s at Microsoft eased up this task by introducing the concept of Business Rules, but did you ever wondered what if all this needs to be done based on the form type?

Let’s say you want to show certain field if the FormType is Create or Update, unfortunately the first thing that will come to mind is that this cannot be achieved using Business Rules.

Today I’m going to show you a little/neat trick which will allow you to do this without writing a single piece of JavaScript code.
Continue reading

COMException: The server is not operational

Recently there were a couple of network changes done at our client’s side which we weren’t aware of and ultimately it led to a downtime for CRM application. Users were not able to log-in to CRM and instead were getting an error which read as

CrmException: Failed to get priv user group information. k = 1b3b9610-36e3-e111-8aef-0050568b60d0 privUserGroupId: 47cbacdc-081f-4457-850f-bc66ef3a2137, localSystemAdGuid: 0005972b-bd43-4de4-8364-51f4b3ef27a8, Exception: System.Runtime.InteropServices.COMException: The server is not operational.

Upon researching a bit, it was clear that the issue was somehow related to Domain Controller which was not able to route any of the user requests thus none of users were able to get authenticated and get into the system. This is how we managed to fix it.
Continue reading

Dynamics CRM 2013 Step by Step Part 4: Installing CRM 2013 Server

Welcome again to yet another part in the series “Dynamics CRM 2013 Step by Step Part 4: Installing CRM 2013 Server”. In this post we will primarily be focussing on setting up the Microsoft Dynamics CRM 2013 Server.

Before moving forward, as usual I would assume that you have already walked through the previous parts in the series and have Windows Server 2012, SQL Server 2012 and the Active Directory configured. If not then go ahead and take a look at the previous posts in this series from the box above. Let’s begin.
Continue reading

Dynamics CRM 2013 Step by Step Part 3: Installing SQL Server 2012

Alright, so now we are done with installation of Windows Server 2012 and configured the Active Directory; it’s now time to install the SQL Server 2012 on the VM.

If you are reading this post for the first time and are not ready with the Server setup, I would recommend you to take a look at the previous posts in the series (Navigate to other posts from the box above).
Continue reading

Dynamics CRM 2013 Step by Step Part 2: Setting up Active Directory

Previously in the series we had seen how to make a Windows Server 2012 system up and running, if not take a look here Step by Step Windows Server 2012 Installation. Moving on, I would assume you have read the previous article and followed along.

The next step in order to install Dynamics CRM 2013 is create Server Roles. The One that we are actually interested in is “Active Directory Domain Services”. Follow the steps and configure the role.
Continue reading