Archive for February, 2015

SQL Server Error While Exporting Advanced Find Records To Excel

February 18, 2015 Leave a comment

Few Users reported that they were getting “SQL Server Error” while trying to export the Advanced Find  records to Excel.

SQL Server Error while exporting records

SQL Server Error while exporting records

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, you can check the limit by querying OrganizationName_MSCRM database.
  • Below is the query
    • SELECT MaxRecordsForExportToExcel FROM OrganizationBase

Fix :

  • You can increase the value of “MaxRecordsForExportToExcel”.

Supported Way

  • Updating the MaxRecordsForExportToExcel using CRM SDK call is Supported.
  • This will work for both on premise and online instances

Organization organization = new Organization();

organization.Id = {Oragnization GUId}; // Get Org GUID from MSCRM_Config DB’s Organization table.

organization.MaxRecordsForExportToExcel = 300000; // Set desired value


Unsupported Way

  • As you aware its strictly not recommended to update CRM database directly and also this approach only works for on premise.
  • Run below query by connecting to your OrganizationName_MSCRM Database.

UPDATE OrganizationBase


MaxRecordsForExportToExcel = 100000



There is no active transaction – Error on Case Resolution

February 9, 2015 Leave a comment

I have an on demand workflow which Resolve the Case’s. I got below exception when I run the workflow against a Case.

No Active Transaction Error

No Active Transaction Error

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 my scenario, there were OOB Activity Feeds Plug-in steps registered on Case entity ‘SetDynamicState’ message.
  • So the Activity Feeds  ‘SetDynamicState’ message failing when my workflow tried to change status of Case, causing “no active transaction Error “.
  • By deactivating the Activity Feed step on Case entity ‘SetDynamicState’ message solved the problem.
Disable Activity Feed Steps

Disabled Activity Feed Steps


Both ‘amount’ and ‘percentage’ cannot be set – CRM Data Import Error

February 6, 2015 Leave a comment

I got below error when I tried to import OOB ‘ContractDetail’ record using Data Import.

ContractDetial import error

Data import error


  • My Data Import template had ‘Discount’ and ‘Discount (%)’ fields and I gave 0 in both fields
Contract Detail Data Template

Contract Detail Data Template


  • Since ‘Discount (%)’ is computational field which would auto calculated by system, it given error while import.


  • You don’t need to input ‘Discount (%)’. Remove ‘Discount (%)’ field from your data file and import the file.


Instance is inactive and unavailable for sign in – CRM online

February 5, 2015 Leave a comment

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.

CRM Instance is inactive

CRM Instance is inactive

I did not find resolution myself for this issue, however contacting CRM support team solved the issue.

You can also create a Service request from your Office 365 portal.

Office 365 Service Request

Office 365 Service Request