SQL Connection Pool Timeout Debugging

This is a follow up to two blog posts from back in 2009 which talked about leaked connections.  In Part 1 and Part 2 of that post, it was about how to determine that you actually filled your pool.  This was centered around the following error: Exception type: System.InvalidOperationException Message: Timeout expired.  The timeout period…

2

SQLCLR and sp_OA* procedures are not compatible

We ran into an issue today that is a bug you may need to be aware of because of its behavior.   When a SQLCLR procedure calls back into the SQL Server (in proc provider) and executes sp_OA*, during the callback activity, it triggers a bug (currently filed and being evaluated) that results in heap corruption…

1

SharePoint Adventures : AccessDeniedException when a user tries to Add Subscription

I’ve been seeing a few cases that relate to a previous blog post which involved an AccessDeniedException when trying to perform report operations.  However, I ran into a different variation that involved the same error.  The scenario was that the customer has users that were in a the Viewer role within SharePoint.  This could also…

2

SQL Server 2012: RML, XEvent Viewer and Distributed Replay

Bob Ward, Keith Elmore and I establish goals for every release of SQL Server.   A primary goal is always to make supporting the SQL Server easier.  Not just in the sense of Microsoft support, although it does play a factor, but more so for you (the customer). During SQL Server 2012 planning we spent a…

5

Intro to Debugging a Memory Dump

I was discussing debugging with some folk internally that didn’t really have much exposure to it, but wanted to learn.  I considered the items pretty basic and didn’t really dive into to much, but I had a few comments that the information was good.  One thing I found that was interesting was that I did…

0

Conversion issues moving from VS 2005 to VS 2008

I was asked to look at a case yesterday where the customer was hitting the following error after converting a VS 2005 Project to VS 2008. Error 3 Custom tool error: Failed to generate code. Failed to generate code. Exception of type ‘System.Data.Design.InternalException’ was thrown. Exception of type ‘System.Data.Design.InternalException’ was thrown. This was being produce…

3

When a full dump isn’t really a full dump…

I was working on a customer issue which involved debugging a dump.  The dump was generated via SQLDumper within Reporting Services.  So, the name of the dump was similar to SQLDmpr0001.mdmp.  When I opened the dump I saw the following: Loading Dump File [C:tempSQLDmpr0001.mdmp] User Mini Dump File with Full Memory: Only application data is…

0

InvalidReportParameterException with Data Driven Subscription

Worked on a case yesterday where the customer was getting errors when running a Data Driven subscription.  In the RS Log, we saw something similar to the following: library!WindowsService_15!950!12/10/2009-10:49:11:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter ‘Param1’ is not a valid value., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value…

3

SocketException when creating a new Report Server Database

We had a customer call up that encountered a problem when trying to create a new database for their Report Server through the Reporting Services Configuration Manager.  This is what they saw: When we clicked on the Error link, we saw the following details: System.Net.Sockets.SocketException: No such host is known    at System.Net.Dns.GetAddrInfo(String name)   …

7