Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







DB Connection Is Closed After It Is Idle For Some Time


 

I am using MS JDBC driver 2005 1.2 and in-house written connection pooling  that was working fine for a number of years. This combination worked OK with SQLserver 2000.  But recently we switched to SQLServer 2005 (x64) on WIN Server 2003 Standard x64 eddition.  Everything seems work OK during business hours, however, after business hours when there are lesser users and connection stays idle for sometime, I am getting the following error:
com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
 at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
 at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(Unknown Source)
 at com.microsoft.sqlserver.jdbc.SQLServerConnection.setAutoCommit(Unknown Source)
 at com.nms.serverframework.dbaccess.OnlineTransactionManager.freeConnection(OnlineTransactionManager.java:420)
 at com.nms.serverframework.dbaccess.OnlineTransactionManager.releaseConnection(OnlineTransactionManager.java:707)
 at com.nms.serverframework.dbaccess.OnlineTransactionManager.releaseConnection(OnlineTransactionManager.java:688)
 at com.nms.serverframework.dbaccess.OnlineTransactionManager.finalize(OnlineTransactionManager.java:399)
 at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method)
 at java.lang.ref.Finalizer.runFinalizer(Finalizer.java:83)
 at java.lang.ref.Finalizer.access$100(Finalizer.java:14)
 
Any help would be appreciated
 
thanks in advance


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Idle Time
Dear ,

If a user not doing in the database for more than 30 minutes i want
to disconnect his connection.

Kindly help me

Thanks

G Selvam

View Replies !   View Related
Performance Gap After Some Time Of Idle.
 Hello everybody,I have a ASP.NET (3.5) Web site which uses an data connection to my Sql Server 2005 Express. When I browse in my data-driven pages of my website, I am satisfied with the performance. But when I try my website after a long break, e.g. in the morning, the data-driven pages take a long time to come up, about 10 seconds. After this gap, when surfing on the other pages, there is no problem. It is only the first page. So it seems that my SQL Server goes "to sleep" after a certain time of idle.First I read a post about this problem which came up with the user instances of Sql Server. So I got rid of my user instance and set up my database "normally". But still I have that performance gap.I am using Linq To SQL and a couple of ListViews. I am totally confused how to manage this problem.Any suggestions?Thanks in advance,Hannes 

View Replies !   View Related
Database Is Slow To Access After Being Idle For Some Time
I've noticed that after the database have been idle for some time, it takes up to 10 seconds to get it started when something needs to access it. In the event viewer it says that the database <name> have been started.

Obviously, there is some idle timeout setting.

I saw an option in the database properties that is called "Auto Close" which is set to true. I assume this is what i'm looking for. Can someone confirm that? (it could take some time to test myself...)

But what i'm actually wondering is:

1. Is it possible to adjust how long it would wait before timing out?
2. What advantages does closing the database bring? Does it free up (a noticeable amount of) ressources? Or is it only that it's unlocking the files, so that it's possible to copy the database source files?

View Replies !   View Related
Idle Connection
How can one remove idle connections that are just sitting/sleeping.
Most of the time the developers are hitting the database through some
front end app like VB, the front end app may perform a insert, update,
select, or delete after they log out you can still see their spid
in sleep mode.

View Replies !   View Related
Problem With Performance After Leaving SQL Server Express Idle For Some Time
Hi, everyone!
I have this strange problem... After every time my application leaves sql-server idle (doesn't send anything, doesn't retrieve anything) next command to sql-server processes really long.
I've also noticed this bug/feature/misconfiguration even if I open a DB in Management Studio...
Please, could someone tell me, is there any timer that "puts a DB to sleep" if no one is using it for some time? Can I change the way server behaves in this situation?

View Replies !   View Related
Close Unattended Multi-user Applications Automatically After Idle Time
Auto Close Idle helps you utilize your multi-user concurrent users licensesmore efficiently. It closes unattended clients remotely after a certainperiod of time or manually. Furthermore, clients can close the most idleuser automatically without the need for the administrator's intervention.For more information visit our web site...http://www.autocloseidle.com

View Replies !   View Related
What's The Idle Timeout Of SQL Login Connection?
Hi.. I have application which is connected to my SQL 2000 database. Normally our users use Terminal service to the SQL 2000 and application (same box) remotely and connect to the database. But some time the connection break and I have idle login stuck there.

For example, if I use sp_who, I can see many logins still login to DB even they are out. And sometimes I see duplicate logins too even there is only one person using that login to logon to DB. Is there a way to find out what is the idle timeout of the user login session??

Is that under SQL server properties -->remote server connections-->Query time-out--> >> sec ?

Is there a way to limit only 1 session can be allow for each login ??

View Replies !   View Related
ExecuteReader Requires An Open And Available Connection. The Connection's Current State Is Closed.
I am accessing SQL2005 with C# code using  OleDbConnection.

 

A try and catch block catches the following error once a while between the Open() and Close() of the connection:

ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.

 

I do not even have any idea where to start to debug this.  The ExecuteNonQuery() runs a delete SQL query. It works 99.9% of the time. I do not see anything wrong when this error happens. 

 

Any hint would be greatly appreciated.

 

 

View Replies !   View Related
The Connection Gets Closed Right After It Opens.
I have the Function, that fires from onLoad even of one of the asp:Label controls on my main page.
Here is it's code:
 SqlConnection conn = new SqlConnection();                conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["UkraineConnectionString"].ToString();                SqlCommand comm = new SqlCommand("SELECT [Greeting] FROM [Misc]", conn);
        try        {            conn.Open();        }        catch        {            Response.Write("Error opening connection in Page_Load of default.aspx to retrieve the greetings");        }
        string MyGreet = (string)comm.ExecuteScalar();
        Greetings.Text = MyGreet;
        try        {            conn.Close();        }        catch        {            Response.Write("Error closing connection in Page_Load of default.aspx after retrieving the greetings");        }        }
When it gests to conn.Open() in the debugging mode I see that the ServerVersion = 'conn.ServerVersion' threw an exception of type 'System.InvalidOperationException'.
The most interesting thing is that it used to work before.
Here is the connection string it retrieves fine.
"Data Source=MDM1;AttachDbFilename=|DataDirectory|Ukraine.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"
 As I said it used to work, but one day I tried to access the web site and it said this error that I get, that the connection is closed. Then I was using the SQL Server Express. When in the Visual studio if I would run this same site in debug, everything was working fine. I decided to uninstall the SQL Express and installed the SQL Server.
If I open the SQL Server Managment Studio in the Server name field I see MDM1(this is the name of the PC, but probably it is the same name for the Server. Well, in the MAnagment Studio it conects fine to the MDM1 so it is no probably the naming problem. Ithink it has something to do with permisssions.
If someon can - please help. Thanks.

View Replies !   View Related
Connection ODBC Closed
That is an app ACCESS 2000 wih Named Pipe ODBC to SQL Server 6.5.

After 10 minutes without use this app, the connection closed !

Have-you idea for correct this probleme ?
Regards
Alain

View Replies !   View Related
TCP Connection Forcibly Closed
Hello,

My first issue is with errors that I'm getting from SQL stating that the connection was forcibly closed.  After googling this error as well as searching this forum, I haven't been able to find much.  I've had our IT guys check the network configuration and everything seems to be fine.  I tried the SynAttackProtect key and it still kicks back the error even after restarting the server.  I've also checked the SQL logs as well as Event Viewer and have yet to find anything useful. 

Does anyone have any other ideas/solutions for me to try?  Thanks in advance.

I'm running SQL 2005 SP 1 on a Win2k3 SP2 server.

View Replies !   View Related
This Connection Cannot Be Used To Perform This Operation. It Is Either Closed Or Inv
I'm trying to create a connection string to access SQL Server 2000 stored procs from MS Access 2003. I created a connection string using UDL and attempted to execute a stored proc. When the stored proc executes, I get the following error.

This connection cannot be used to perform this operation. It is either closed or invalid in this context.

I know the connection is open. Any thoughts about what could cause this?

Thanks in advance for your help.

View Replies !   View Related
The Underlying Connection Was Closed - Localhost Vs Machine Name ?
Someone Im helping is having trouble getting reports to be viewable from BOTH his machine and another developer on the same domain.  The problem is seen when we enter the url, using the machine name.  When we use "localhost" things work ok and the report comes up when viewed locally.  The error we are getting is the following

"The underlying connection was closed: An unexpected error occurred on a send. Authentication failed because the remote party has closed the transport stream. "

Now, after digging around on google and msdn for a while, im still stuck on a resolution.  I seen references in other articles talking about long running requests being closed etc, but this request doesnt take very long, and besides it works at least when using localhost in the address.

View Replies !   View Related
The Underlying Connection Was Closed: The Remote Name Could Not Be Resolved
Our system administrators have renamed the server that our Reporting Service 2000 runs on. The database that RS2000 uses is on the same server.
 
Now when I navigate to the Report Manager, the following error appears:
 
The underlying connection was closed: The remote name could not be resolved

 
Obviously I need to tell Reporting Services 2000 the name of the new server (even though it's just the same server??). Where do I do that?

View Replies !   View Related
A Connection That Was Expected To Be Kept Alive Was Closed By The Server.
hye everyone,

i have problem .
when i deploy the report, its failed and the error mesage :

The underlying connection was closed: A connection that was expected to be kept alive was closed by the server.    d:
ptdemoClaimOTReport.rdl

any suggestion or idea


thank in advance

 

View Replies !   View Related
User Instance Db File Not Get Detached After Connection Has Been Closed
Hi experts,
I have sql express installed on my machine and i'm using visual studio to create database files. After i've build a connection to my database file thru Server Explorer (choose Add attach files) i opened Management Studio Express and  found that the new database has been attached to sqlexpress database engine----technically speaking it's under the user instance which i use to run my visual studio. right?? that's totally fine.My question is, after i'v closed the connection in visual studio, that attached database file still exist.I want it to be detached immediately after i've closed the connection in visual studio.How can i do that?
 I've searched through internet and was told that sp_config can solve this problem by setting the user instance time out. I ran sp_config against my database but did not find that item. Could anybody give me some directions? thanks in advance.

View Replies !   View Related
An Existing Connection Was Forcibly Closed By Remote Host
Hi all
I have run a stranger issue:
I use ADO.NET 2.0 to access sql2000 database. during the whole process, I need stop sql server service which the program is connecting. my setup is like following:
1.Open a conection to access table and then close the connection;
2.restart sql server service ;
3.Re-open a connection to access table and then an exception was thrown out:
 A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed bythe remote host.)
4. try re-open a connection to access table and then no exception was thrown out.
I think this maybe related with connection pool. any guy know the detail, please give me a response. Thank you very much!
 

View Replies !   View Related
An Existing Connection Was Forcibly Closed By The Remote Host
Hi,
I'm running a website using MSSQL 2000. Sometimes (not always) I get this error message on the website:
A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
I have also websites running with MySQL and those don't have this problem.I searched google but I couldn't find usefull information on this problem.
Someone who knows what's going on here ?

View Replies !   View Related
The Underlying Connection Was Closed: Could Not Establish Secure Channel For SSL/TLS.
 

Help.
 
Today while trying to get the Windows NT security working i upgraded my reporting services IIS server to a domain controller and it screwed up all of my settings. First it changed password for ASPNET user and so I reinstalled .net framework.
 
Now i get the



The underlying connection was closed: Could not establish secure channel for SSL/TLS.


error message.
 
I do not want to use an SSL certificate for I do not have one right now. How can I configure my SQL Server 2000 Reporting services to not use SSL. I see they added something to SQL Reporting Services 2005 in the configuration tools but I cant find out how to modify the config files with SQL 2000 RS to eliminate the SSL.
 
Please help, my company is down waiting for me to get this back up.
 
Thanks a ton,
 
deep

View Replies !   View Related
EM Error 'connection Forcibly Closed By The Remote Host' (ouch)
I am getting this error in Enterprise Manager:
TCP Provider: An existing connection was forcibly closed by the remote host.

But, my web app can still connect just fine to the db, so it's still in
the same place with the same login/password.  And my registration
in EM was working just fine (for years) until yesterday I got this
error.  I've tried deleting the registration and re-creating it
but the same thing.  What could have gone wrong to cause this to
happen? 

Thanks for any pointers, I have no idea where to start looking on this one, the host says they haven't changed anything...

View Replies !   View Related
Sql Server Reporting Services Error The Underlying Connection Was Closed
 

Hi,

 
We have a mature instance of SQL Server 2000 reporting services that has stopped working for no apparent reason. When browsing to http://reportserver/reports we receive the following error

 

Error



The underlying connection was closed: Unable to connect to the remote server.



Home

The installation is running on three servers - 1 sql cluster (sql 2000 sp4) and two IIS servers all running windows 2000 sp4.
 
The Reportserver website runs using identity impersonation using the .net machine.config file pointing to an encrypted registry key entry holding the userid and password. It has been moved from the default website to it's own website but has been working with no issues for years. No obvious patches have been applied or security changes made that could effect the application
 

When browsing to http://reportserver/reportserver we can view the loaded reports and even run them with no issues, only ther report manager isn't working.

I have tried changing the impersonation registry key ( using aspnet_setreg ) and the account the reportserver web service runs under ( using the rsconfig utiltity) to be a domain admin to no effect and I have checked and set specififc permission for the reportserver database on all registry keys to no effect.
 
None of the online solutions for this issue have worked for me. Any help or ideas would be greatly appreciated
 

Cheers
 

Daniel Worby

Database Administrator

AMP Capital Investors

(p) +61 2 9257 1746

(m)+61 434 327 150

(f) + 61 2 9257 1090

(e) daniel.worby@ampcapital.com

(w) www.ampcapital.com.au

View Replies !   View Related
3709-The Connection Cannot Be Used To Perform This Operation. It Is Either Closed Or Invalid In This Context
 
We have a nagging issue here in our application side, which I was trying to troubleshoot and reach no where. Can I have your valuable inputs for resolving/understanding the root cause of the issue?
 
3709-The connection cannot be used to perform this operation. It is either closed or invalid in this context
 
This error is not coming regularly (twice it happened and after the program is running successfully with out any problem). Problem having exe is running every 2 minutes interval.  
 
Most of the sites saying this is something related to code written in the application but if that is the case why this error is not happening continuously?  The problem having exe is running past 4 months with 2 minutes interval and suddenly thrown this error.
 
I found one MS site describing about this error but not able to find any fixes for this issue (http://support.microsoft.com/kb/839428). We are on the process of upgrading the operating system with SP2; will this help us to resolve this issue? Please advice.
 
Details
 
1.        Windows 2003 with SP1
2.        MDAC 2.8
3.        SQL 2005 with SP1
4.        VB Application.

View Replies !   View Related
The Underlying Connection Was Closed: Could Not Establish Trust Relationship With Remote Server
I am getting the above error on a windows 2003 server when I go to report manager(https://localhost/Reports) . I have installed a self-signed SSL certificate on this machine so that it can be accessed using https over the internet. Does anyone know how to fix this.

I did get the following message at the end of SQL Report Services installation:

Setup could not initialize the report server. You must
manually initialize the report server before using it for
the first time. For more information, see the Reporting services
setup documentation.

Thanks for all the help.

View Replies !   View Related
TCP Provider, Error: 0 - An Existing Connection Was Forcibly Closed By The Remote Host
We are getting a problem when the below error Log

Server: SQL Server 2005 and SP1.

 

Then, All the Web Servers will drop all connections and stop the network service. Later, the network service will start up automatically but all the before service is dropped.

We would like to know the error coming from?

 

Error Log

================

 TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host 

 

Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date:  4/29/2006
Time:  10:48:47 AM
User:  N/A
Computer: 88DBWEB0
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 4/29/2006 10:48:47 AM
Event time (UTC): 4/29/2006 2:48:47 AM
Event ID: 77910e6688484582bb1c29808feef883
Event sequence: 128
Event occurrence: 13
Event detail code: 0
 
Application information:
    Application domain: /LM/W3SVC/24978983/Root/ph-3-127907437121075328
    Trust level: Full
    Application Virtual Path: /ph
    Application Path: D:DB88ph
    Machine name: 88DBWEB0
 
Process information:
    Process ID: 1568
    Process name: w3wp.exe
    Account name: NT AUTHORITYNETWORK SERVICE
 
Exception information:
    Exception type: SqlException
    Exception message: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
 
Request information:
    Request URL: http://88db.jobsdb.com/ph/Views/MediaUpload.aspx?PostID=50202&Type=I&panelid=postimagediv
    Request path: /ph/Views/MediaUpload.aspx
    User host address: 192.168.10.10
    User: 50077
    Is authenticated: True
    Authentication Type: Forms
    Thread account name: NT AUTHORITYNETWORK SERVICE
 
Thread information:
    Thread ID: 15
    Thread account name: NT AUTHORITYNETWORK SERVICE
    Is impersonating: False
    Stack trace:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParserStateObject.WriteSni()
   at System.Data.SqlClient.TdsParserStateObject.ExecuteFlush()
   at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader()
   at System.Web.SessionState.SqlSessionStateStore.DoGet(HttpContext context, String id, Boolean getExclusive, Boolean& locked, TimeSpan& lockAge, Object& lockId, SessionStateActions& actionFlags)
 
 
Custom event details:

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.


 

View Replies !   View Related
The Underlying Connection Was Closed: Could Not Establish Trust Relationship For The SSL/TLS Secure Channel
I'm using SQL Server 2005 (SP1) Reporting Services on Windows Server 2003 SP1. I access the report server from Internet using SSL, but the server is not exposed directly to the internet. It is behind a firewall, where the required ssl port is setup and is working fine.

In my Reporting Server, the /ReportServer folder works perfect and I can navigate and view all reports. It is the /Reports folder the one that does not work fine. I can enter the /Reports folder, and can list all the reports. But, when I select one of the reports, and it starts rendering, I get the error message:

"The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. The remote certificate is invalid according to the validation procedure."

How can I fix this?

Thanks,

Julio

View Replies !   View Related
The Underlying Connection Was Closed: Could Not Establish Trust Relationship With Remote Server.
 
I am trying to setup SQL Server 2000 Reporting services with an SSL connection.  The SQL Server (Windows Server 2003 SP2 Standard) and Reporting Server (Windows Server 2003 R2 SP2 Standard) are on separate machines.  I have tried setting up Certificates from both and Stand-Alone and Enterprise CA.  I have tried several combinations of the Issue To name (server | server.company | server.company.local) I have modified the rsWebApplication.config and rsReportServer.config to match the certificate€™s Issue to exactly.  I have tried installs with both Domain Accounts and  NT AUTHORITYSYSTEM logins.  I have managed to get https://server/ReportServer to work but I have had no luck with the report manager https://server/reports. How do I fix this error?

 
Thankyou

View Replies !   View Related
Framework 2.0 Changes - TCP Provider, Error: 0 - An Existing Connection Was Forcibly Closed By The Remote Host.
If you connect to a server and open a query in SQL Managment studio (2005) and looses connection and then regain the connection, when you try to run the query it gives me a "TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host."   This happens against both 2005 and 2000 servers.   If I re-run the query it works.   However, this happens in our VB.NET app as well for clients with Wireless connections.   So, something has changed in Framework 2.0 regarding this, does anyone know how to tell the client to not throw this error and just try connecting the server instead which will work?  

View Replies !   View Related
An Error Occurred While Receiving Data: '10054(An Existing Connection Was Forcibly Closed By The Remote Host.)'.
What does this error mean? I get this in the transmission_status column of  sys.transmission_queue

An error occurred while receiving data: '10053(An established connection was aborted by the software in your host machine.)'.

Also, does the number in this message correspond to error 10053 in sys.messages?

Thanks

 

 

 

View Replies !   View Related
Can No Longer Access Report Manager - The Underlying Connection Was Closed: An Unexpected Error Occurred On A Receive.
 

Hi,
 
For a long time I've had SQL Server 2000 with RS on a Server2003 machine. 
When I want to publish a report from my Dev box, I remove anon. access on the Production machine, deploy the report, then go into report manager to tweak a couple of parameters.  I then re-enable anon. access so users can continue.

 
Yesterday, I removed anon. access and deployed the report but when I went into Report Manager I received the above error message... "The underlying connection was closed: An unexpected error occurred on a receive."

 
I can get into report manager with anonymous access enabled, but I don't have authority to do anything.
 
 
What's happened!!!?   More importantly, how do I fix it?

View Replies !   View Related
Provider: TCP Provider, Error: 0 - An Existing Connection Was Forcibly Closed By The Remote Host.
Hi,

One of our customers is getting this error about 3-4 times a day, in an .NET application that runs 24/7:

(provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)

They have several App servers, Windows 2003 SP1 32 bit... connecting to several SQL 2005 SP 1 servers, 64 bit. All of their 4 application servers have had this error with 3 or 4 different SQL instances running on 4 different SQL servers.

There is a firewall in between but that does not seem to be the problem. We use the same firewall setup in dozens of environments without any issues like this, and the firewalls are not imposing any maximum TCP session times.

There are lots of people reporting this same problem with SQL 2005 only - it does not seem to be an issue with the same applications running against SQL 2000.

Any hints as to how to fix these errors? I am going to try adjusting the Keep Alive setting in the SQL client config to 10000 instead of 30000 but judging by the number of people getting this error, this seems to be some sort of bug with .NET's connection pooling and SQL 2005.

People are saying the easiest way to reproduce this is to do a SQL query.... unplug the network cable and plug it back in again... then run another query. They say it causes this error every time, but I have not tested this since we are only seeing this problem in a production environment.

Thanks for your help,
Jeremy

View Replies !   View Related
Cannot Acquire A Managed Connection From The Run-time Connection Manager
How would one go about using an ODBC connection with SSIS. I'm trying to ETL some Sybase ASE data, but I get the error when I try it:

"cannot acquire a managed connection from the run-time connection manager"

 

This wasn't any help:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=169777&SiteID=1

 

 

View Replies !   View Related
Large Reports - Error: &&"The Underlying Connection Was Closed: An Unexpected Error Occurred On A Receive.&&"
First off I understand that it is a horrible idea to run extremely large/long running reports, but sometimes it ends up being the best possible solution due to external forces.




I've got a 25,000 page report that we recently converted from crystal reports to SSRS. The SSRS server is a 64bit 2003 server with 32 gigs of ram running SSRS 2005. When running the report through the report manager web application, it renders in the browser/viewer after about 12 minutes. Exporting to pdf through the browser/viewer in the report manager takes an additional 55 minutes. It does work and it produces a whopping 1.03gb pdf.




Unfortunately, I've run into a problem when trying to do this from a console application using the SSRS client API. After about 30-35 minutes I get an exception on the client with the following error:
Exception Message: The underlying connection was closed: An unexpected error occurred on a receive.
InnerException = Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.

Here is the api call:




Code Snippet

byte[] m_data = reportingService.Render(this.ReportPath, this.ExportFormat, null,
deviceInfo, selectedParameters, null, null, out encoding, out m_mimeType,

out usedParameters, out warnings, out streamIds);
Here are some things I've tried so far:


set the HttpRuntime ExecutionTimeout value to 3 hours on the report server
disabled http keep alives on the report server
increased the script timeout on the report server
set the report to never time out on the server
set the report timeout to several hours on the client call
Disabled antivirus on the client side, and verified there was no antivirus running on the reporting server.
Tried using default credentials in the ReportingService object as opposed to supplying credentailsAny ideas would be appreciated. I understand the best solution is to split the report up into smaller reports, which is the backup option, but being able to keep it as one report is the goal.

View Replies !   View Related
&&"The Underlying Connection Was Closed: An Unexpected Error Occurred On A Receive.&&" Endpoint Error
what can cause the above error when connecting to an endpoint via a c# app? the app, and sql are both on my machine ( im just doing this for test purposes and to learn something new.)

View Replies !   View Related
Failed To Generate A User Instance Of SQL Server Due To Failure In Retrieving The User's Local Application Data Path. Please Make Sure The User Has A Local User Profile On The Computer. The Connection Will Be Closed
This is my first time to deploy an asp.net2 web site. Everything is working fine on my local computer but when i published the web site on a remote computer i get the error "Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed" (only in pages that try to access the database)
Help pleaseee

View Replies !   View Related
@@cpu_busy And @@idle
Should these two stats added together give me the time (ms) since SQL Server has been restarted? Maybe I don't understand but @@cpu_busy is the amount of time sql server has accessed the cpu and @@idle is the amount of time sql server has no cpu activity. When I add these two figures together, I don't get the total amount of time (ms) SQL Server has been running. What am I not doing? Any help is appreciated.
Thanks

View Replies !   View Related
Session Idle Timeout Over
Hi all,
We got this message on our production server event viewer for source MSDTC.

"String message: Session idle timeout over,tearing down the session"..
Even though it is marked as informational, just wanted to know what it is?..

thanks guys,
Marx

View Replies !   View Related
Idle Connections Termination
folks
We have a situation where people just login run complex queries and then just don't shut off their query analyzer of apps.

Some of these chew up a lot of CPU cycles and unless we kill the query the CPU cycles are not released.

I see some of them are idle for over 1-2 hours or more, their last_batch would be at least 2 hours old.

The question is, "Is there a setting in the sql server whereby we can automatically disconnect idle threads?"

Regards
Paresh Motiwala
Boston, USA

View Replies !   View Related
Slow Startup From Idle
Is it possible to stop the server from going to sleep when it is idle to improve responsiveness to new connections?

View Replies !   View Related
Removing Idle Client Connections
Is there any parameters/procedures one can use to remove idle client connections (sql65sp5a)from the server or odbc side?
The only parameter that looks like a remote possibility is
remote conn timeout, but this appears to work server to server?
TIA
Yvonne

View Replies !   View Related
Replication - Distribution Agent Becomes Idle
I have been seeing this issue for several weeks now. The distribution agent will become idle even though there is activity occurring within the replicated database. If I manually start the distribution agent, it will begin retrieving the transactions. I thought that this might be due to inactivity but I have modified the inactivity threshold and I am not receiving an actual inactive agent warning. There are no warnings -- it simply sits there and does not resume sending transactions.

Any thoughts? This is a transactional replication with a distribution agent that is run at the subscriber.

Thanks,

MV

View Replies !   View Related
Locating Idle Sessions Using Dm_exec_... DMV's
Hi

I have been looking at the new DMV's prefixed with dm_exec_....and found a limitation with them.

Books online says sysprocesses is replaced with sys.dm_exec_connections, sys.dm_exec_requests and sys.dm_exec_sessions. The problem I came accross is identifying any sessions connected to a specific database which were idle. This is the sort of thing you need to know if you tried to restore a database and it says the database is in use.

I wonder if this is a bug or by design?

 

 

View Replies !   View Related
Can't Connect To DB When SqlServer Exp Has Been Idle For A Couple Hours.
Does SQLServer go to sleep when it's been idle?  How can I connect without an error?
 
I have SQLExpress on a server.  Server Name is SqlExpress.  I have 2 DBs on that server... Tuna & Guppy.  I'm connecting to the DBs from a remote PC which runs my App... an exe created with Visual Studio 2008, Visual Basic.
 
If I run my App at say 9:30PM, after the server has been idle for several hours, I get a "Can't open connection to Guppy" error, which is my error message when the connection attempt fails.  If I quit & relaunch the app, it connects fine, and will continue connecting fine unless you leave the server idle for serveral hours again.
 
If I'm developing a 2nd app all evening... which connects to a 2nd DB...Tuna, that activity seems to keep the SqlServer awake and then launching the 1st app at 9:30PM connects to Guppy just fine.
 
I tried adding a "Connection Timeout=30" to my connection string but that did not help.
 
My connection code is as follows (note the server's name is SQLExpress):
 
Dim strConnG As String = "Data Source=SQLEXPRESSSQLEXPRESS;Initial Catalog=Guppy;Integrated Security=True;Connection Timeout=30"
Using ConnG As New SqlConnection(strConnG)
       'open Guppy connection
       Try
           ConnG.Open()
       Catch ex As Exception
            MsgBox("Can't open connection to guppy")
            Return False
       End Try
       'Code that does stuff
End using

 
Can anyone tell me how to fix this so I can connect without error, even if the server has been idle?
 
Thank you,
 
Joe A

View Replies !   View Related
SQL Express 2005 Going Idle And Not Allowing Connections.
Just upgraded to SQL Express 2005 from MSDE for Firehouse. Upgrade went great and the db is accessable and running fine. Except when not used for a while. Then I need to restart the db to allow connections of any kind. If I don't I get an error that the db is not accessable and I can't connect. Everything runs fine after until it goes to "sleep" on me again. We upgraded to make use of the 4GB limit as we were at 1.9GB and MSDE was getting a little unhappy.

 

Any suggestions? Is this a "feature" and if so, is there a script I can run to kick it into working mode again?

 

Thanks

Chris

View Replies !   View Related
Kill A Session After An Idle Duration In SQL Server 2005
Hi all;

I want to implement "Auto disconnection" (or kill) of user session that exceed a specified idle duration in SQL Server 2005.

I know how do that in oracle by creating a profile and set the IDLE_TIME paramter and asign that profile to all users. But in SQL Server i don't know how to do it.

Can anyone help me.



Kindly

View Replies !   View Related
Connection Time-out
Hello, All!
Good Afternoon!

I'm having a strange situation in my SQL SErver 2000 SP3a with 4 Processors, 4GB of RAM and high-end disk sub-system.
I migrate a specific database from another instance with SQL SErver 2000 SP3a too to this new server with more hardware resource than another one.
The application that access this DataBase stablish a connection with SQL SErver using TCP/IP, everything works fine. So, if I let the connection "sleeping", or better, if I let the connection idle for amount of time, I need to stablish the connection to ther SQL SErver again.
I hadn't the same situation in the old instance as I having. I think that it's happening because the other instance was dedicated to this application and that new Instance don't.
In this new Instance I have many other connections simultaneously, about 200 processes.

Anybody knows what's going on? Are there any settings to change this time-out configuration just for a specific connections?

Thanks

Best Regards

View Replies !   View Related
Connection Time Out
Hi,

Can someone help me on this

When I run simple select query "Select * from Aadata" it works but when I filter with date it doesn't work please see below error:



Error Source : .Net SqlClient data provider

Error Messge: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding



I fixed connection properties:



Connection timeout = 30000

Execution timeout = 30000



Thanks in advance



AA





AA

View Replies !   View Related
Connection Time Out
Hi,

Can someone help me on this

When I run simple select query "Select * from Aadata" it works but when I filter with date it doesn't work please see below error:



Error Source : .Net SqlClient data provider

Error Messge: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding



I fixed connection properties:



Connection timeout = 30000

Execution timeout = 30000



Thanks in advance



AA





AA

View Replies !   View Related
Very Strange Connection Time Out
I am sure I am using the same connection string for all connection.open, and closing all connections as soon as possible… but

When I try to debug my web app with vs, it runs for some time then I get:

The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached exception

However, if I just access the application normally form the url (not using vs.net) it runs flawlessly.

Has some one had the same problem? i can't debug help!!

View Replies !   View Related
Connection Time Out Error
Hai,I am using an VB application using SQL Server 2000 as the database. I amusing BeginTrans and CommitTrans methods to save data into the SQLServer 2000 Database in the VB Application. If the system get structedbefore executing commitTrans method,the database become inaccessible andthe other applications cant communicate with the database showingconnection Time Out Error. How can the Database be accessible?I want ur help.--Posted via http://dbforums.com

View Replies !   View Related
FTP Connection Manager Time-out
According to http://msdn2.microsoft.com/en-us/library/ms187682(SQL.90).aspx you should be able to set the time-out of an FTP Connection Manager to 0 for infinite. When ever i try to configure this through the editor it resets it back to the default of 60. If i try to configure it through the properties pane it tells me it must be a value between 1 and 300. I have tried to set it using a variable and assigning it to the timeout expression and have also tried to override it in the package.dtsx

Has anyone encountered this and is there a work around?

View Replies !   View Related
Mirroring Connection Time Out
 

Hi,
I have Mirroring setup for 3 databases without a witness.
The database mirroring monitor shows me that both Principal and Mirror are "Synchronized".
SSMS also shows that the both instances are "Synchronized".
 
However, the following error message appears couple of times in the event viewer:
The mirroring connection to "TCP://abc.xyz.com:5022" has timed out for database "DB" after 10 seconds without a response.  Check the service and network connections.
 
Also came across this article.
http://support.microsoft.com/kb/947462
 
Should i be worried?
 
 
thanks 
 
 

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved