manjunathcbhat's blog

the report execution has expired or cannot be found. (rsexecutionnotfound)

I was working on some reports and the report was rendered successfully. Then i went to have my lunch and then came back and to fetch the latest data, I clicked on referesh and Bammmm!!, I was hit with a error "the report execution has expired or cannot be found. (rsexecutionnotfound)"

Specific Error: the report execution wouibt55ln003rijpxkrbu45 has expired or cannot be found. (rsexecutionnotfound)

The Cluster service is shutting down because quorum was lost.

You may witness that a SQL Services on a cluster you have maintained failed over to another node unexpectedly. You might see the below error.

"The Cluster service is shutting down because quorum was lost."

You then try to troubleshoot and you will come across series of errors as below.

SQL Server Central Management Server (CMS)

Microsoft always comes up with some really interesting features in its every release. Central Management Server popularly known as CMS was one such interesting and useful feature which was introduced in SQL Server 2008. So what is Central Management Server, is this a New Server, New license required, a new product or what? Answer is no.

Multiple Active Result Sets (MARS) in SQL Server

Multiple Active Result Sets (MARS) is a feature that works with SQL Server to allow the execution of multiple batches on a single connection. When MARS is enabled for use with SQL Server, each command object used adds a session to the connection. The MARS feature is disabled by default. It can be enabled by adding the "MultipleActiveResultSets=True" keyword pair to your connection string and disable MARS by adding the "MultipleActiveResultSets=False" keyword pair to your connection string.

A nonrecoverable I/O error occurred on file "" 64(The specified network name is no longer available.).

You have scheduled your backups to a Shared Location or Network Path. Your backup was running fine, one fine day you suddenly come across an error saying "A nonrecoverable I/O error occurred on file "" 64(The specified network name is no longer available.)."

When you check for more information in logs you will find more description such as

Pages