Reports generated by the CRM Report Wizard fails to run after being modified a couple of times.
The SQL Server Reporting Services log reads:
An exception has occurred in data set ‘DSMain’.
Cannot read the next data row for the dataset DSMain.
Number of link entities in query exceeded maximum limit.
Duplicate link-entity lines have been inserted in the query of the RDL file by the Wizard.
This is a bug in Microsoft Dynamics CRM 2011 Rollup 16. MS Support is on the case, hoping for a hot-fix soon. -UPDATE- This issue will be fixed in Rollup 17 due to be released by late April. – UPDATE-
You can temporarily extend the number of link entities in query exceeded maximum limit by using this unsupported method:
INSERT INTO DeploymentProperties(Id,ColumnName,IntColumn,Encrypted)
select * from DeploymentProperties where ColumnName=’QueryLinkEntityLimit’
Thanks to: http://www.comunidadcrm.com/2012/09/28/fetchxml-error-crm-2011-number-of-link-entities-in-query-exceeded-maximum-limit/
I you want to find the guid (id) of an entity record in CRM 2013 do this:
1) Right-click the record in a list, for example a Contact, and select “Open in a New Window”.
2) The URL of the page will now display in the address bar. Copy the URL to notepad:
3) Now select the text between “&id=%7b” and “%7d&newWindow” since this is where you’ll find the GUID: 4362F996-893C-E311-9B5D-6C3BE5BEEF3C
We received following error messages when updating to Rollup 15:
Cannot drop the procedure ‘p_GetAllOrgsFromAuthInfo’, because it does not exist or you do not have permission.
Cannot drop the procedure ‘dbo.p_DisableCreateUser’, because it does not exist or you do not have permission.
After finding more info here we solved this by dropping the procedures and letting the setup re-create them.
If you are using the Microsoft Dynamics Connector for CRM you can submit accounts to be transferred by settings these CRM account fields:
address1_dynamics_integrationkey = address1_Name
address1_dynamics_integrationkey = address2_Name
dynamics_integrationkey = accountnumber
dynamics_isreadyforintegration = true
Here’s how to change the default value from “Create a revised quote” to “Do not revise this quote” in the Close Quote dialog box.
- Find the file dlg_close.aspx in folder %programfiles%\Microsoft Dynamics CRM\CRMWeb\SFA\quotes and backup a copy of it.
- Edit the file and insert the following script lines at:
//Custom code to set default radio button Daniel Bergsten 130902
document.getElementById(“rdNoRevisedQuote”).checked = true;
document.getElementById(“rdCreateRevisedQuote”).checked = false;
In my example the “Cancel Sales Order” event is caught and prevented by calling the function CatchCancelEvent on the onSave method of the Sales Order form with the execution context passed as the first parameter.
SYMPTOMS: Custom reports do not work with an SSRS log error similar to:
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 —>
PROBLEM: This happens if the SPNs of the CRM web service is not set properly and SSRS server is unable to get a Service Ticket from the Ticket Granting Server (TGS).
SOLUTION: Register the following SPNs:
setspn -a http/<CrmApplicationServerName> <CrmAppPoolServiceUserAccount> (E.g. setspn -a http/crm DOMAIN\SVCCRM)
setspn -a http/<CrmApplicationServer FQDN> <CrmAppPoolServiceUserAccount> (E.g. setspn -a http/crm.domain.com DOMAIN\SVCCRM)