Bring your code 2 life

Since CRM 2011 the is a Problem with customizing the OOTB Sales Performance Dashboard. Until today with CRM 2016 SP1 it still is not possible to modifiy the dashboard with the dashboard designer in CRM: https://support.microsoft.com/de-de/kb/2741768 Even in MS Connect, Microsoft does not pay a lot of attention to this issue, as its not having many votes. If you try to modify it you will get an error: "Cannot Edit Dashboard. The dashboard could not be opened. Maximum no. of columns allowed in the layout is 4." I also tried to make an unmanaged solution of the dashboard with no success. Even with the default solution you will not get out the required formxml that you want to change. If you have CRM on-prem you still have a chance to actually retrieve the required form XML from the database. This article helps you to find the right table in the ORG_MSCRM database: https://msdn.microsoft.com/en-us/library/gg327869.aspx In this case Need to search through the syste...

  This is how a CRM 2011 file menu look like on one of my customer's CRM system. Missing menu items and sometimes wrong translations of dialog contents at the wrong spot gave me headaches for quite some time. After trial and error I checked the patch level of their system. CRM Server was on UR 15 but the Dutch language pack was on UR6 causing such trouble. After installing the Dutch MUI UR 15 language pack update it worked like as it should. Lessions learned: Always check and keep customers patch level of server and language packs on the same level.

Today I tried to set up the email router for one of our customers. I opened the email router configuration manager and tried to load the data in the last step / last tab. I failed with a message "The caller was not authenticated by the service". Very annoying... but after googeling a while I found multiple posts that mention an issue with the Windows loopback check. Following the lines below resolved it without an issue: To specify the host names that are mapped to the loopback address and can connect to Web sites on your computer, follow these steps: Click Start , click Run , type regedit , and then click OK . In Registry Editor, locate and then click the following registry key: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa\MSV1_0 Right-click MSV1_0 , point to New , and then click Multi-String Value . Type BackConnectionHostNames , and then press ENTER. Right-click BackConnectionHostNames , and then click Modify . In the Value data box, type the ...

Lately I was fighting with an issue that on some CRM instances the default email templates view in the Templates section of CRM 2013 did not show up and only showed me this error message: Condition for attribute 'template.templatetypecode': null is not a valid value for an attribute. Use 'Null' or 'NotNull' conditions instead. After searching for a long time I found the simple bug. Throught migration from 4.0 to CRM 2013 over CRM 2011 and changing customizations it seemed that CRM got messed up or was not able to handle the changes very well. The issue here was to go to the views section of the Email Templates entity and to make sure there is only ONE default public view. If there are two you will get strange system behavior. I fixed this problem through updating the isdefault property of the second unwanted default view in the SavedQueryBase data table. The id of this view  you can retrieve by openen the view and by copying it out from the URL. Én voi...

This week a very evil error drove me nuts. In CRM 2013 I tried to import a translation file into an organization. It always ended up with this error message: The value passed for ConditionOperator.In is empty I was like what in the world does this message mean. If an old school approach in splitting up the file into serveral smaller Import files I finally figured out that the following lines in the "Localized Labels" sheet caused this trouble: RibbonCustomization 11a15acc-61f1-e311-93f9-00505681252e Mscrm.Isv.orb_input.HomepageGrid.Group0.Control0.LocLabel RibbonCustomization 11a15acc-61f1-e311-93f9-00505681252e Mscrm.Isv.orb_input.HomepageGrid.Group0.Control0.ToolTip.LocLabel RibbonCustomization 11a15acc-61f1-e311-93f9-00505681252e Mscrm.Isv.orb_input.SubGrid.Group0.Control0.LocLabel RibbonCustomization 11a15acc-61f1-e311-93f9-00505681252e Mscrm.Isv.orb_input.SubGrid.Group0.Control0.ToolTip.LocLabel To resolve t...

The customer had an issue with a custom CRM 4.0 report. It seems this error occured now because the SQL Server run with 2008 instead of 2005 or the report indeed had a bug. (Thanks to SQL Profiler, I found it.) The customer had this error coming up: Query execution failed for dataset '....'. Incorrect syntax near '20140913' After analysing the report XML I figured out the problem: DECLARE @SQL AS NVARCHAR(MAX) SET @SQL = ' SELECT CRMAF_FilteredAccount.accountid, CRMAF_FilteredContact.firstname, CRMAF_FilteredContact.jobtitle, CRMAF_FilteredContact.lastname, CRMAF_FilteredContact.telephone1 FROM (' + @CRM_FilteredAccount + ') AS CRMAF_FilteredAccount INNER JOIN FilteredContact AS CRMAF_FilteredContact ON CRMAF_FilteredAccount.accountid = CRMAF_FilteredContact.parentcustomerid ORDER BY CRMAF_FilteredContact.lastname' EXEC(@SQL) The red must be replaced with: DECLARE @SQL AS NVARCHAR(MAX) SET @SQL = ' SELECT CRMAF_FilteredAc...

Via browser or my REST Client app I was not able to upload files with sizes greater than 300KB. After some research I found out that some coworder mistakenly changed the web.config in a wrong manner. He set the value maxallowedcontentlength for the requestfiltering section to around 300KB. Luckily, SharePoint Health is smart to find this kind of errors. Resetting the line in the web.config helped: The requestLimits element has a maxAllowedContentLength attribute and its value is set to 2147483647. => according to Microsoft MSDN.