-
Continue reading →: Base and Extension base tables Merge error – Upgrade from CRM 2011 to 2013
As we know till CRM 2011, CRM maintained two database tables for each Entity: Base table for the out-of-the-box fields of an entity Extension table for the custom fields added to an entity With CRM 2013, Now there is just one entity table for a given entity. So when you…
-
Continue reading →: Network Error while accessing external service from CRM web resource
We had a requirement to fetch and display data from external hosted service, on a HTML web resource hosted in CRM. So I created a HTML file with below logic to fetch data from external hosted service. var xmlhttp = new XMLHttpRequest(); xmlhttp.open(‘POST’, {External Service URL}, false); xmlhttp.onreadystatechange = function () {…
-
Continue reading →: Unable to get property ‘integer’ of undefined or null reference – Error jqGrid
We got a requirement to display XML data in table format in HTML file. We opted jqGrid for binding xml and display the XML content. $(“#grid”).jqGrid({ datatype: ‘xmlstring’, datastr: responseXml, xmlReader: { repeatitems: false, root: xmlRoot, row: xmlRow } I was getting this exception when I was binding XML to…
-
Continue reading →: Passing data between web resources CRM 2013
Assume you have 2 HTML web resources on your CRM form and you want to pass data from 1 resource to another, below are the steps. In my example I have 2 HTML pages with a Textbox and Button. On Button click, I am reading the value from current…
-
Continue reading →: Using ‘No Lock’ in FetchXML CRM
In one of our requirement we are retrieving records using FetchXML and we observed fetch taking long time when there are more concurrent user access. Reason: Records are being updated by other users when I perform Fetch Fix : Set “no-lock=’true’” in the FetxhXML as below <fetch mapping=’logical’ no-lock=’true’> </fetch>…
-
Continue reading →: Aggregate Query Record Limit Exceeded – Exception in CRM
I was getting below exception when using FetchXML aggregation to compute Average of one of my entities field. AggregateQueryRecordLimit exceeded. Cannot perform this operation. My Fetch XML : <fetch distinct=’false’ mapping=’logical’ aggregate=’true’> <entity name=’new-expenses’> <attribute name=’new_gross’ alias=’gross_avg’ aggregate=’avg’ /> </entity> </fetch>”; Reason : FetchXML Aggregation has a limitation, by default…
-
Continue reading →: Exclude namespaces from XML using Jscript
In one of my requirement I had to parse XML and find node values. My XML looks as below <NS1:Envelope xmlns:NS1=“http://schemas.xmlsoap.org/soap/envelope/“> <QueryBalanceResult> <NS1:AvailableCredit>17400</NS1:AvailableCredit> </QueryBalanceResult> </NS1:Envelope> Since the XML has got namespaces I need to exclude namespaces before I find the node. Below is the logic to exclude namespaces var xmlWithNamespaces={Your…
-
Continue reading →: Stack overflow error while disposing object – C#
I have a class “ABC” which implements “IDisposable” interface and having below Dispose method. Public Class ABC : IDisposable { public void Dispose() { this.Dispose(true); } } When I run the application I was getting “Stack Overflow” error because the Dispose() method getting called recursively and went in to an infinite loop.…
-
Continue reading →: Make your WCF service’s Operation/Method Fire and Forget
There are cases when an operation has no returned values and the client does not care about the success or failure of the invocation. To support this sort of fire-and-forget invocation, WCF offers one-way operations. It’s simple to implement. We just need to add “IsOneWay” property to ‘true’ to the…
-
Continue reading →: HTTP Error 404.17 – hosting Service in IIS
Recently when I hosted a web service project in IIS and browse that, I got below error. HTTP Error 404.17 – Not Found The requested content appears to be script and will not be served by the static file handler. Fix : In my case I missed a simple step,…


