Archive for December, 2012

2012 in review of My Blog

December 31, 2012 Leave a comment

The stats helper monkeys prepared a 2012 annual report for this blog.

Here’s an excerpt:

19,000 people fit into the new Barclays Center to see Jay-Z perform. This blog was viewed about 91,000 times in 2012. If it were a concert at the Barclays Center, it would take about 5 sold-out performances for that many people to see it.

Click here to see the complete report.

Categories: Uncategorized

SSRS Extension Installation does not display SSRS Instances – CRM 2011

December 27, 2012 2 comments

The other day to configure CRM environment, we were installing “Microsoft Dynamics CRM 2011 Reporting Extension” and to our surprise

“SSRS Instance” dropdown was blank and we could not proceed further

Reporting Extensions Setup

Reporting Extensions Setup


  • We had 2 machines one with CRM application server and another with both “SQL server” & “SSRS Reporting services”
  • The reason in our case was, we were trying to install “Microsoft Dynamics CRM 2011 Reporting Extension” on the CRM application server machine


  • You must run CRM Reporting Extensions Setup on a computer that has Microsoft SQL Server 2008 Reporting Services or Microsoft SQL Server 2008 R2 Reporting Services installed

Here is the MSDN’s  CRM 2011 Reporting Extensions Installation Guide


CRM 2011 quick optimization guide

December 26, 2012 Leave a comment

Here is the MSDN article on quick optimization of CRM 2011

CRM 2011 Optimization Guide

It has optimization settings by sections and below are the direct links

Here is the link to white paper on “Optimizing and Maintaining Client Performance for Microsoft Dynamics CRM 2011 and Microsoft Dynamics CRM Online”

Optimizing and Maintaining Client Performance


CRM data load – Finding long running queries

December 17, 2012 Leave a comment

The other day when we were doing performance testing on our CRM application by importing huge data, we got few “Generic SQL Errors”.

One common reason for the “Generic SQL Errors” is either SQL timeout because of long running queries or dead locks.

So to find the root cause of the issue we wanted to find the long running query’s.

Here is the useful article which will give you the “Longest running queries” on your SQL Server.

P.S. You might get “Division by 0 errors” error when you run the query. Keep trying the query you will get results for sure.


Stack overflow at line 0 – script error while opening crm form

December 13, 2012 Leave a comment

You might get “Stack overflow at line 0” script error while opening CRM form or navgiation.

Below are the steps that will resolve the issue

  • Install IE 9 :
  • Delete cache and cookies
    • Tools→ Internet options → General →Browsing history →delete →check all the check-boxes →delete
  • Delete Internet temp files
    • Tools→ Internet options → General →Browsing history →settings → View files →delete
  • Verify the trusted sites

Here is a link to CRM form which talks about the same