Archive
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.
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
service.Update(organization);
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
SET
MaxRecordsForExportToExcel = 100000
🙂
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.
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.
Disabled Activity Feed Steps
🙂
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.
Data import error
Reason:
- My Data Import template had ‘Discount’ and ‘Discount (%)’ fields and I gave 0 in both fields
Contract Detail Data Template
- Since ‘Discount (%)’ is computational field which would auto calculated by system, it given error while import.
Fix:
- 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
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
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
🙂
Rajeev Pentyala - Microsoft Power Platform 