Archive
2012 in review of My Blog
The WordPress.com 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.
SSRS Extension Installation does not display SSRS Instances – CRM 2011
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
Reason
- 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
Fix
- 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
Here is the MSDN article on quick optimization of CRM 2011
It has optimization settings by sections and below are the direct links
- Authentication
- IIS
- CRM Registry Keys
- Database
- Outlook Client
- Internet Explorer
- Email Router
- SQL Jobs
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
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
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 : http://www.microsoft.com/india/windows/ie/IE9.aspx
- 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
- Tools→ Internet options → Security →Trusted sites →sites → https://*.crm.dynamics.com
Here is a link to CRM form which talks about the same
🙂