-
Continue reading →: Transaction count after EXECUTE indicates a mismatching number – SQL Error
I was getting the below exception when I execute a stored procedure from my C# console application. My Stored procedure executes in Transaction mode and wrapped in Try/Catch block (Refer below) CREATE PROCEDURE [Name] BEGIN TRY BEGIN TRANSACTION; — My SQL Script COMMIT TRANSACTION; END TRY BEGIN CATCH IF XACT_STATE()…
-
Continue reading →: Different ways of referencing web resources – CRM
If you have a HTML file added as a Web resource in CRM and it need to refer below web resources new_jquery new_dummy Below are 2 ways to achieve the same Standard Way One way is to follow below convention to refer the web resource files in your HTML file <script src=”../webresources/{webresourcename}”></script> Referencing by folders Assume…
-
Continue reading →: CRM 2015 Enhancements and new features
CRM 2015 is the latest advent of Microsoft Dynamics CRM and its previously code named as “Vega”. As you get lot of resources about CRM 2015 over internet, this article briefs you about major enhancements and new features. Calculated and Roll-up Fields Prior to Dynamics CRM 2015, to perform calculations or…
-
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…


