Microsoft KB Archive/927021

= Error message when you run a report in Microsoft Dynamics CRM 3.0: &quot;The property 'nullable' of report parameter 'CRM_Locale' is set to false&quot; =

Article ID: 927021

Article Last Modified on 8/15/2007

-

APPLIES TO


 * Microsoft Dynamics CRM 3.0

-



SYMPTOMS
When you run a report in Microsoft Dynamics CRM 3.0 by clicking Run Report in the Report Review page, you receive the following error message:

Reporting Services Error

The property 'nullable' of report parameter 'CRM_Locale' is set to false. However, the corresponding parameter (default) value is null or contains an empty string. (rsProcessingError)



Cause 1
The NTAuthenticationProviders property is not set on the SQL Server Reporting Services (SSRS) Web site. See Resolution 1.

Cause 2
The Integrated Windows Authentication feature is not enabled in Windows Internet Explorer. See Resolution 2.

Cause 3
Duplicate service principal name (SPN) values exist. See Resolution 3.

Note If this condition causes this problem, the following error message is logged in the Application log on one or more of the domain controllers: Event Type: Error

Event Source: KDC

Event Category: None

Event ID: 11

Description: There are multiple accounts with name host/ .microsoft.com of type10.

Cause 4
Reports are waiting to be republished. See Resolution 4.

Cause 5
The domainname value in the SystemUserBase table of the MSCRM database is set to &quot; \ &quot; instead of &quot; \ .&quot; See Resolution 5.

Notes
 * The  placeholder represents the fully qualified domain name (FQDN). For example, the FQDN could be &quot;adventureworks.local.&quot;
 * The  placeholder represents the domain name. For example, the domain name could be &quot;adventureworks.&quot;
 * The  placeholder represents the user name. For example, the user name could be &quot;crmadmin.&quot;



RESOLUTION
To resolve this problem, use one or more of the following resolutions.

Resolution 1
Set the correct NTAuthenticationProviders property in the Internet Information Services (IIS) metabase for the Reporting Services Web site. To do this, follow these steps:  Set the correct NTAuthenticationProviders property at the root level. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

215383 How to configure IIS to support both the Kerberos protocol and the NTLM protocol for network authentication

 Determine the Web site identifier for the Reporting Services Web site. To do this, follow these steps:  Start Internet Information Services (IIS) Manager. Expand the server name, and then click Web Sites. Note the value in the Identifier column of the Web site that is hosted by the Microsoft Dynamics CRM 3.0 server.

Note Reporting Services is installed on this server.  Click Start, click Run, type cmd, and then click OK.</li> At the command prompt, locate the directory that contains the Adsutil.vbs file. The following directory is the default directory:

C:\Inetpub\Adminscripts

</li> Use the Web site identifier that you noted in step 2 to set the NTAuthenticationProviders property for the Web-site level. To do this, run the following commands: <ul> cscript adsutil.vbs set w3svc/ /NTAuthenticationProviders &quot;Negotiate,NTLM&quot;</li> cscript adsutil.vbs set w3svc/NTAuthenticationProviders &quot;Negotiate,NTLM&quot;</li></ul>

Note In the commands, the  placeholder represents the Web site identifier that you noted in step 2.</li></ol>

Resolution 2
Enable the Integrated Windows Authentication feature. To do this, follow these steps:
 * 1) Start Windows Internet Explorer.
 * 2) On the Tools menu, click Internet Options.
 * 3) In the Internet Options dialog box, click the Advanced tab, and then make sure that the Enable Integrated Windows Authentication check box is selected.
 * 4) Restart Windows Internet Explorer.
 * 5) On the Tools menu, click Internet Options.
 * 6) In the Internet Options dialog box, click the Security tab.
 * 7) Click Local intranet, and then click Sites.
 * 8) In the Local intranet dialog box, click Advanced.
 * 9) In the Add this Web site to the zone box, type the address of the Microsoft Dynamics CRM Web site, and then click Add.
 * 10) If you do not use the Secure Socket Layer (SSL) protocol, click to clear the Require server verification (https:) for all sites in this zone check box.
 * 11) Click Close, and then click OK.

Resolution 3
Warning If you use the ADSI Edit snap-in, the LDP utility, or any other LDAP version 3 client, and you incorrectly modify the attributes of Active Directory objects, you can cause serious problems. These problems may require you to reinstall Microsoft Windows 2000 Server, Microsoft Windows Server 2003, Microsoft Exchange 2000 Server, Microsoft Exchange Server 2003, or both Windows and Exchange. Microsoft cannot guarantee that problems that occur if you incorrectly modify Active Directory object attributes can be solved. Modify these attributes at your own risk.

Delete the duplicate SPN values. To do this, follow these steps:  Use the LDP utility to determine the exact locations of the duplicate SPN values.

Notes <ul> Only experienced administrators can use the LDP utility.</li> Typically, the duplicate SPN values are located in the ServicePrincipleName attribute of the User container. The user account of the User container is the user account under which Microsoft Dynamics CRM 3.0 is installed.</li></ul>

For more information about how to determine the duplicate SPN values, click the following article number to view the article in the Microsoft Knowledge Base:

321044 Event ID 11 in the System log of domain controllers

</li> Use the ADSI Edit snap-in to delete the duplicate SPN values. To do this, follow these steps.

Notes <ul> Only experienced administrators can use the ADSI Edit snap-in.</li> The ADSI Edit snap-in is included with the Microsoft Windows Support Tools on the Windows installation CD.</li></ul>

 Click Start, click Run, type mmc, and then click OK.</li> On the File menu, click Add/Remove Snap-in.</li> Click Add, click ADSI Edit in the Snap-in list, click Add, and then click Close.</li> <li>Right-click ADSI Edit, and then click Connect To to connect to the domain.</li> <li>Expand the domain node, right-click the user account under which Microsoft Dynamics CRM 3.0 is installed, and then click Properties.

Note If you want to delete the duplicate SPN values in a computer account, you can right-click the computer account in this step.</li> <li>In the Attributes column, double-click ServicePrincipleName.</li> <li>In the Values dialog box, remove all the values that begin with &quot;HOST/ .&quot;

Note The error message in the Application log shows these values.</li></ol> </li></ol>

Resolution 4
Republish the reports. To do this, follow these steps: <ol> <li>Click Start, click Run, type cmd, and then click OK.</li> <li>At the command prompt, locate the directory that contains the reports. The following directory is the default directory:

C:\Program Files\Microsoft CRM\Reports

</li> <li>Run the following command:

publishreports.exe &quot; &quot; &quot; \reportinggroup { }&quot;

Notes <ul> <li>The  placeholder represents the name of the company.</li> <li>The  placeholder represents the name of the domain.</li> <li>The  placeholder represents the actual ID of the pre-Windows compatible name of the ReportingGroup group in Active Directory. For example, the GUID resembles 74c1d4cf-5c5f-4531-bb7f-14d75dd33857.</li></ul> </li></ol>

Resolution 5
Run the following Microsoft SQL Server statement, and then send the result to technical support for Microsoft Dynamics CRM. select domainname from systemuserbase For more information about how to obtain technical support for Microsoft Dynamics CRM, visit the following Microsoft Web site:

http://www.microsoft.com/dynamics/crm/support/default.mspx

Keywords: kberrmsg kbexpertisebeginner kbtshoot kbexpertiseinter kbmbsmigrate kbprb KB927021

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.