CRM 2013 Invalid Argument FetchXML Report Errors on Premise

I love it when my former-self comes to the rescue of my present self.  I have been wrestling with an SSRS error that I knew I had seen before.  In searching for an answer, I ran across this blog post I wrote a couple years back.  I'm going to copy it here, just in case my former employer decides to take it down:

Even though the Report Wizard has some inherent limitations, it is still a useful tool for end-users that want ad-hoc reporting, or if you want to see beyond the 10,000 record limit when exporting to Excel.  You may find however that reports created by the Report Wizard return an "Invalid Argument" error. 

This happened to me recently so I followed my usual debugging steps but that did not help because the browser didn't return an error.  I checked the CRM and SSRS event logs, but there wasn't any helpful information in the errors that were logged.  Next I checked the SSRS HTTP Log and found some interesting information.  Note, the default location for the log is:

\Microsoft SQL Server\\Reporting Services\LogFiles

In the log I saw that I was getting a security error:

System.ServiceModel.Security.SecurityNegotiationException: A call to SSPI failed

When I looked up this error, I ran across KB2590774 which described the exact issue I was facing...unfortunately it involved SPNs; probably my least favorite administrative topic.

The instructions are a little contradictory.  It says that all you need to do is setup an SPN for the CRMAppPool...unless you are running IIS in Kernel Mode (generally the recommended configuration).  If running Kernel mode, you are supposed to review the information in the article about SPNs and IIS 7 Kernel Mode.

I read and confirmed that for my configuration (Scenario 2b - Custom app-pool and host header)the recommendation was to register an SPN for my custom URL on the NetBios name (aka, the computer name).  Unfortunately this did not resolve my issue, even after adding "trust for delegation" in AD.  So I tried the KB's recommendation which was an SPN for NetBios name on the CRMAppPool account:

setspn -s HTTP/my_server_name my_domain\my_CRM_app_pool_identity

After that SPN was applied (always using -S to check for duplicates) the FetchXML reports instantly started working!

Easy way to enable DevErrors for Dynamics CRM using IIS Manager

Windows Access Control prevents you from directly editing the Web.Config file for IIS site, so rather than copy/paste, you can use IIS Manager to edit keys via GUI.  To turn the DevErrors key to On you need to change the Section selector to appSettings and click the “…” button in the (Collection) property.  Make sure you click the Apply button (Action menu on right) after making a change:

How to Hide Alerts in CRM 2013 Sitemap Menu

Alerts appeared in 2013 to display server-side synchronization.  The information in the alerts can get pretty technical so they may not be appropriate for end-users.  In order to hide them from the menu, you can remove read permissions on the Trace entity (under Core Records).

Tricks for working with SetState and SetStateDynamic plugins

There are a couple of tricks to working with SetState and SetState Dynamic plugins.  To get the State that the record is "becoming" you can check the InputParameter "State":

var state = (OptionSetValue) context.InputParameters["State"];
localContext.Trace("Contact State: " + state.Value);

if (state.Value == (int)ContactState.Inactive) return;

To get the Guid of the record, check the PrimaryEntityId property:

Guid targetId = context.PrimaryEntityId;

Using PowerShell Get-ADPrincipalGroupMembership to find a user's groups

I needed to find a good AD group to grant organization wide permissions to an SSRS report and found the Get-ADPrincipalGroupMembership was really useful for querying AD.  The server needs to have the "Active Directory modul for Window PowerShell" feature enabled to allow import-module activedirectory to work:

import-module activedirectory
Get-ADPrincipalGroupMembership [username without domain prefeix] | Get-ADGroup -Properties * | select name, description
Get-ADGroup [group name]

Saving a CRM form with missing required fields

I ran across an interesting problem in that I needed to allow a CRM user to save the progress of a form that has required fields.  The required fields are not truly required until the user initiates a separate submission step.  I was able to "temporarily" remove the required from the fields and then put it back on after the save using this script:


function onSave() {
    var i = 0;
    Xrm.Page.ui.controls.forEach(function (control, index) {
        if (typeof control.getAttribute == 'function' && typeof control.getAttribute().getRequiredLevel == 'function' && control.getAttribute().getRequiredLevel() == "required") {
            reqControls[i] = control;
            control.getAttribute().setRequiredLevel("none");
            i++;
        }
    });
    Xrm.Page.data.save().then(onSaveComplete, onSaveFailed);
    
}

function onSaveComplete() {
    reqControls.forEach(function (control) {
        control.getAttribute().setRequiredLevel("required");
    });  
}

The lock value must exist error when resetting ADX auto-number

If you try to manually reset the "Last Number Used" field in ADXStudio's Productivity Pack, you will receive an error that says, "The lock value must exist."  This is actually a good thing, because it means the locking code is working properly.  Here are the steps for resetting the Last Number Used field:

1. Enter "1" in Lock Value field and Save
2. Enter "1" in Lock Verification field.  Now you can change Last Number Issued to any value you'd like (e.g. "1000") and Save
3. Clear the Lock Value field (blank) and enter "1" in Lock Verification field and Save

You are all done!