Archive

Archive for August 29, 2015

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

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

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

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

Auto Growth Setting

Refer MSDN AutoGrowth Settings article for more details

🙂

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
Enhanced 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

Applicable And Success Criteria

  • Set the Failure Duration as ‘5 minutes’ and Warn Duration as ‘1 Minute’
Duration

Duration

  • Activated the SLA
Enhanced SLA - Activation

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

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.
Entitlements

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

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

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

    Enhanced SLA – Set ‘HOLD’ status

    • Go to the ‘Case’ and choose Status = ‘On hold’ and Save
    Case - Choose 'On Hold' status

    Case – Choose ‘On Hold’ status

    • See the Resolve in set to ‘Paused’
Enhanced SLA - Case 'On Hold'

Enhanced SLA – Case ‘On Hold’

🙂