-
Continue reading →: Host a SSRS report which gets data from external Data Source – CRM on-premise
We got a requirement to host a SSRS report in CRM, which gets data from external data source (i.e., Data Base from another SQL server). CRM normally uses Shared Data Source when you upload any SSRS report which pulls data from CRM. In our case we had to Create a new…
-
Continue reading →: Post XML over HTTP and capture the response – C#
Recently we got a requirement to post the data from ‘CRM Plug-in’ to an external API and capture response. External API was built as XML over HTTP (i.e., Its not a SOAP based and no WSDL). In this approach we post the Request XML to a URL and in return…
-
Continue reading →: CRM 2016 Web API – Impersonate User
In CRM, Impersonation is possible in Plug-ins (using ‘Run As’ while registering Plug-in step) or using ‘CallerId’ property while instantiating OrganizationServiceProxy. What if I have to impersonate ‘Retrive’ operation from Jscript? This was not possible. With advent of CRM Web API with CRM 2016 we can impersonate in Jscript. What…
-
Continue reading →: CRM 2016 Web API – Optimistic Concurrency
Assume a scenario, you retrieved an Account and wanted to update the ‘Name’ field. But due to concurrency the same Account has changed on the server since you retrieved it and you may not want to complete the update. So how to detect this situation and avoid concurrency issues? The…
-
Continue reading →: CRM 2016 Web API – Retrieve a record
Below is the sample script to retrieve an Account record using Web API. Key Points to perform Retrieve: Use ‘GET’ request while performing Retrieve ‘Status’ code would be 200. Sample Script: function retrieveAccounts() { var clientURL = Xrm.Page.context.getClientUrl(); var req = new XMLHttpRequest() req.open(“GET”, encodeURI(clientURL + “/api/data/v8.0/accounts?$select=name&$top=1”), true); req.setRequestHeader(“Accept”, “application/json”);…
-
Continue reading →: Specified domain does not exist or cannot be contacted – Error connecting to SharePoint from CRM on premise Plug-in
In one of our Plug-in, we have logic to upload the note’s attachment to SharePoint server. Everything was working as expected until we got this unexpected exception ‘Specified domain does not exist or cannot be contacted’. Reason & Fix: Reason for this exception while updating Plug-in Assembly, I accidentally set…
-
Continue reading →: Boot failure reboot and select proper boot device – Error connecting to VM – Hyper V
I was getting below ‘Boot failure error’, while connecting to one of my VM with Windows Server 2012 OS, from Hyper V. Reason & Fix There could be many reasons for this problem. In my case below steps solved the issue. I initially chosen ‘Generation 1’ while configuring VM. Re-configuring the…
-
Continue reading →: Executing Informix DB Stored Procedure in SSRS
Recently we got a requirement to pull the data from IBM Informix DB and prepare report using SSRS. For who does not know what is Informix, refer here Below are Stored Procedure details Name: sp_getcustomersbycity Description: Accepts date range and City codes as parameters and returns Customer result set. Query…
-
Continue reading →: Access Denied Error – Case Reactivation
Recently we deployed a solution on Customer environment and few users complained of getting ‘Access Denied’ error message while trying to ‘Reactivate’ a resolved case. Issue was intermittent and we were unable to reproduce in our Development environment. After spending some time, we identified ‘Access Denied’ coming up only for Cases…
-
Continue reading →: Incorrect date (KPI) calculation – Enhanced SLA
We have an ‘Enhanced SLA’ configured in our CRM application which was working fine in development environment. Recently we deployed solution on Customer’s server and surprisingly SLA showing incorrect First Response\Resolve by KPI’s hence ‘SLA Counter’ showing wrong timer. Refer below screen where Timer showing 561 days however ‘Failure Date’ was…


