Archive
SQL Server Timeout Error – Importing CSV file
Other day I got a SQL Timeout error while importing Article’s using a CSV file which is of 75 KB size.
SQL Timeout Error – Data Import
Below are my troubleshooting steps and Fix .
Troubleshoot steps
- Verified both SQL Server and CRM App server’s event viewer.
- On CRM App server there was only one warning with an ‘Insert’ query. However there was no error information in the log, it’s just that Query was not completely written in the log.
CRM Warning – Insert Query
- On SQL Server machine there were no Error or Warning event logs. But there was an Information log around same time which had useful information.
Log – Autogrow of file
Reason
- In the SQL Server event log, there was an event with below details
“Autogrow of file ‘mscrm’ in database ‘XXXX_MSCRM’ was cancelled by user or timed out after 30824 milliseconds” information.
- So, the issue was with my CRM DB (i.e.XXXX_MSCRM) setting’s “AutoGrowth” property which has higher ‘File Growth’ value.
- It is recommended to keep 1024 MB for data files and 256 MB for log files.
Fix
- Open ‘XXXX_MSCRM’ AutoGrowth setting by following below steps
- Right click on the database.
- Go to Properties.
- Then go to the Files section.
- Click on either the data or log autogrowth column (Click the …)
- Provide the recommended ‘File Growth’ setting
Auto Growth Setting
Refer MSDN AutoGrowth Settings article for more details
🙂
Why my Enhanced SLA not triggering – CRM 2015
I was exploring ‘Enhanced SLA’ feature in CRM 2015. I created my first basic enhanced SLA with below steps
- Created a new SLA
Enhanced SLA
- Added a new ‘SLA Item’ with no ‘Applicable When’ criteria (i.e., SLA should kick in for all Case’s if no criteria given) and ‘Success Criteria’ as Case Status ‘Resolved’
Applicable And Success Criteria
- Set the Failure Duration as ‘5 minutes’ and Warn Duration as ‘1 Minute’
Duration
- Activated the SLA
Enhanced SLA – Activation
- Created a new Case.
- But no Timer or ‘SLA KPI’ records logged when I expanded ‘Enhanced SLA Details’ section.
Enhanced SLA Details
Reason
- There was no ‘Entitlement’ configured
- So what is an Entitlement? ‘Entitlements’ are correlated to Customers (i.e., Either Account or Contact) in the system and define what kind of support your customers are eligible for.
Enhanced SLA – Entitlements
Note : If you don’t want to configure ‘Entitlement’ make to set SLA as Default which will be applicable for all Customers.
Fix
- Since I am just exploring SLA’s, I did not create an ‘Entitlement’ instead I made my SLA as ‘Default’
Enhanced SLA – Set Default
- Created a new Case and this time got the OOB Timer and SLA KPI record in sub-grid.
Enhanced SLA – Triggered
Additional Details
- How to Pause a SLA
- Using ‘Enhanced SLA’ you can put SLA on ‘HOLD’ by choosing Case ‘Status’ with pre-configured ‘Case Status’ (Refer screen how to configure Status)
Enhanced SLA – Set ‘HOLD’ status
- Go to the ‘Case’ and choose Status = ‘On hold’ and Save
Case – Choose ‘On Hold’ status
- See the Resolve in set to ‘Paused’
Enhanced SLA – Case ‘On Hold’
🙂
