-
Continue reading →: SQL Server Error While Exporting Advanced Find Records To Excel
Few Users reported that they were getting “SQL Server Error” while trying to export the Advanced Find records to Excel. Reason : The filter they used in Advanced Find resulted more than 10000 records. CRM has OOB limit of 10000 records to export. If your CRM instance is on premise,…
-
Continue reading →: There is no active transaction – Error on Case Resolution
I have an on demand workflow which Resolve the Case’s. I got below exception when I run the workflow against a Case. Reason & Fix – There is no active transaction Error – message usually denotes the failure in any other Plug-in steps already registered on the same event. In…
-
Continue reading →: Both ‘amount’ and ‘percentage’ cannot be set – CRM Data Import Error
I got below error when I tried to import OOB ‘ContractDetail’ record using Data Import. Reason: My Data Import template had ‘Discount’ and ‘Discount (%)’ fields and I gave 0 in both fields Since ‘Discount (%)’ is computational field which would auto calculated by system, it given error while…
-
Continue reading →: Instance is inactive and unavailable for sign in – CRM online
Recently i signed up for 30 days trail version of CRM online. After provisioning, I was unable to access the Organization as it was inactive and not allowing me to log-in. I did not find resolution myself for this issue, however contacting CRM support team solved the issue. You can also create a Service…
-
Continue reading →: Duplicate record execution with System.Timer Elapsed event
We have a windows service with System.Timer control which periodically polls the records from Data Base and processes in its Elapsed event as below. protected void Timer1_Elapsed(object sender, System.Timers.ElapsedEventArgs e) { // Business logic goes here } Everything seems working fine until we noticed few records executing twice causing…
-
Continue reading →: Hierarchy Visualization – CRM 2015
With CRM 2015, you can represent self-referenced records in Chart format, this feature called as ‘Hierarchy Visualization’. If the Entity is configured for ‘Hierarchy Visualization’, a symbol as below will appear for Self referenced records. By clicking the chart symbol you will be redirected to below Chart. Every rectangle, contain…
-
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…


