Microsoft Dynamics CRM - CRMWRPCTokenKey Expired

Dynamics 365 onpremise unable to browse and down situation. On the findings from Event viewer events captured with below.

The validity of CRMTokenKey managed by Dynamics CRM Async service (Maintenance), and this Tokenkeys are automatically generated for every 24 hours, somehow or generic issue that sometime this key was unable to generate automatically and its makes the application down.

To Resolve this issue Restart of Dynamics CRM Services and IISRESET should fix the issue Or you can you can run the below command.

1) Open Command Prompt with Run as Administrator.

2) To Enter in to the location use CD  C:\Program Files\Microsoft Dynamics CRM\Tools

3)  Run Microsoft.Crm.Tools.WRPCKeyRenewal /R

4) Do IISRESET  

Gook Luck !

 

 

Dynamics 365 Timeout - Unable to export data in Spreadsheet above 10,000 records

Dynamics 365 - Timeouts exporting above 10000 records.

Below is the solution to Extend the limit in CRM database

Check the Default value

select maxrecordsforexporttoexcel 

from Organization

Execute below query to extend the limit on OrgName_MSCRM
 
update Organization set maxrecordsforexporttoexcel=15000

Check the updated value using select query and do IIS reset.

In my case I have Account and Contacts 15000 records so in order to get these records export I have extended the download limit to 15000

Direct update in the SQL database can cause serious data loss so make sure you have database backup. 

SharePoint Online Share URL "Anyone" Grayed Out

Following steps allows you to enable “Anyone” option for Guest Contributor

1) Run PowerShell as Administrator

   Should be installed with latest version SharePoint Online Management Shell

2) To Connect Online SharePoint the power shell

$adminUPN="<the full email address of a SharePoint administrator account, example: jdoe@contosotoycompany.onmicrosoft.com>"

$orgName="<name of your Office 365 organization, example: contosotoycompany>"

$userCredential = Get-Credential -UserName $adminUPN -Message "Type the password."

3) C:\Windows\system32>

Connect-SPOService -Url https://$orgName-admin.sharepoint.com -Credential $userCredential   (Sharepoint Admin URL)

4) C:\Windows\system32>

(Get-SPOSite -Identity https://Contoso.sharepoint.com/sites/TeamSite).SharingCapability

Result: ExternalUserSharingOnly

5) PS C:\Windows\system32>

Set-SPOSite -Identity https://Contoso.sharepoint.com/sites/TeamSite -SharingCapability ExternalUserAndGuestSharing

6) PS C:\Windows\system32> (Get-SPOSite -Identity 

https://Contoso.sharepoint.com/sites/TeamSite).SharingCapability

Result: ExternalUserAndGuestSharing

Now refresh the SharePoint Page and check for the Share link

Issue with the 'CRM 2013 Outlook Plugin' crash when you try to open it from Windows Start

Faulting application name: Microsoft.Crm.Application.Outlook.ConfigWizard.exe, version: 6.0.0.819, time stamp: 0x57a8f98f
Faulting module name: KERNELBASE.dll, version: 6.1.7601.24094, time stamp: 0x5abee073
Exception code: 0xe0434352
Fault offset: 0x0000c54f
Faulting process id: 0x2db4
Faulting application start time: 0x01d3dae0b2f11adb
Faulting application path: C:\Program Files (x86)\Microsoft Dynamics CRM\Client\ConfigWizard\Microsoft.Crm.Application.Outlook.ConfigWizard.exe
Faulting module path: C:\Windows\syswow64\KERNELBASE.dll
Report Id: f4a0ee1b-46d3-11e8-8e45-b083feb17d38


Resolution:

Resolve by replacing the value(C:\Program Files (x86)\MSCRM\Client\) of 'HKEY_CURRENT_USER\Software\Microsoft\MSCRMClient\InstallPath' in registery, with 'C:\Program Files (x86)\Microsoft Dynamics CRM\Client\'.

Reboot the PC once and try to open the putlook client.

For your info, I have installed the following updates on top of the 'Microsoft Dynamics CRM 2013 for Microsoft Office Outlook' 

- Service Pack 1 for Microsoft Dynamics CRM 2013 (KB2941390)

- Update Rollup 5 for Microsoft Dynamics CRM 2013 Service Pack 1 (KB3122951)

Dynamics 365 - SQL Server Custom Report run issue

Trace Log:

Webserver!ReportServer_0-10!187c!04/17/2018-05:26:11:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'DSMain'. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException:

Microsoft.Crm.CrmException: An unexpected error occurred.

System.ServiceModel.Security.SecurityNegotiationException: A call to SSPI failed, see inner exception.

System.Security.Authentication.AuthenticationException: A call to SSPI failed, see inner exception.

System.ComponentModel.Win32Exception: The target principal name is incorrect ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: An unexpected error occurred. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: A call to SSPI failed, see inner exception. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: A call to SSPI failed, see inner exception. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: The target principal name is incorrect

   --- End of inner exception stack trace ---

Resolution:  

The error is due to a negotiate exception that is occurring with a fail to the SSPI.  Given the rsProcessingAborted and SSPI failure, we are looking at an SPN issue as none are registered under the domain account currently running the CRM AppPool. 

To check the list of spn's registered:

C:\>setspn -l <user running CRM app pool>

Run the following setspn commands on all CRM app servers which should resolve this reporting issue:

setspn -a HTTP/<CRM application server name> <user running CRM app pool>

setspn -a HTTP/<CRM application server FQDN> <user running CRM app pool>

Example:

setspn -a HTTP/CRM1 crmuser

setspn -a HTTP/CRM1.test.com test\crmuser

Do IIS reset and run the report.

How to Determine The Installed Update Dynamics 365 Version With SQL Query

SELECT UpgradeToVersionNumber

FROM [Yourdatabase_MSCRM].[dbo].[UpgradeActionTracker]

order by UpgradeToVersionNumber desc

Google the build number.....

Error occurs when you install Microsoft Dynamics CRM App Server on a domain whose NetBIOS domain name contains a period (.)

Error | Installer complete: OrganizationCreator - Error encountered

Error | Exception occured during Microsoft.CRM.Tools.Admin.OrganizationCreator : Action Microsoft.crm.tools.Admin.provisionBusinessAction Failed.
Inner exception:
The domain logon for this user is invalid: (Domain\username).
Select another domain logon and try again.
At Microsoft.CRM.Authentication.UserManagementFactory.ValidateActiveDirectoryUser…

Error occurs when you install Microsoft Dynamics CRM App Server on a domain whose NetBIOS domain name contains a period (.)

Resolution : 

1. Open Registry Editor.
2. Browse to the following location: HKLM\Software\Microsoft
3. Create the MSCRM registry key if it does not already exist.
4. Browse to the following location: HKLM\Software\Microsoft\MSCRM
5. Create a new DWORD type registry value, and then name the registry value VerifyDomainName.
6. Set the datavalue of the VerifyDomainName value to 1

Restart the CRM app server and then try to re import.

Dynamics 365 (Online CRM) & Exchange online - Unable to track emails in Queue (Server side Synchronization)

In Case if CRM queues did not receive incoming (Track) emails from INTERNAL users and able to track outside users sent emails   without any problem.

1)     Navigate to SETTINGS –> ADMINISTRATION –>SYSTEM SETTINGS –> EMAIL, the box “Track emails

Sent between Dynamics 365 users as two activities” must be CHECKED

2)     Use the OrgDBOrgSettings tool and install it as a solution where it is called “OrganizationSettingsEditor”.

                                 

3)      After opening, look for the value DoNotIgnoreInternalEmailToQueues. The default is FALSE.  That must be changed to TRUE as the bottom text explains.

        As show in below screen shot…