Archive
Archive for August 29, 2015
SQL Server Timeout Error – Importing CSV file
August 29, 2015
Leave a comment
Other day I got a SQL Timeout error while importing Article’s using a CSV file which is of 75 KB size.
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.
- 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.
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
Refer MSDN AutoGrowth Settings article for more details
🙂
Categories: CRM
Autogrow file, CRM, CSV, Data Import, SQL Timeout
Why my Enhanced SLA not triggering – CRM 2015
August 29, 2015
1 comment
I was exploring ‘Enhanced SLA’ feature in CRM 2015. I created my first basic enhanced SLA with below steps
- Created a new 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’
- Set the Failure Duration as ‘5 minutes’ and Warn Duration as ‘1 Minute’
- Activated the SLA
- Created a new Case.
- But no Timer or ‘SLA KPI’ records logged when I expanded ‘Enhanced SLA Details’ section.
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.
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’
- Created a new Case and this time got the OOB Timer and SLA KPI record in sub-grid.
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)
- Go to the ‘Case’ and choose Status = ‘On hold’ and Save
- See the Resolve in set to ‘Paused’
🙂
Categories: CRM 2015
CRM 2015, Enhanced SLA, Entitlement, Pause SLA