Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




A transport-level error has occurred when receiving results from the server.

web-app

I've been getting this error in Gemini for a long time, once every 1-4 days or so at different times... Got it in v2.0.5, got it in v2.2.2.  Not sure what causes it.  Tends to happen sporadically - for instance on a login operation.  Works fine for days/hours, then all of a sudden this happens repeatedly for several minutes, then with no human intervention, the error goes away and logins work as normal again.  Can also happen while updating issues, looking at issue lists, etc.

I've contacted Gemini Support and been told "It's a SQL Server error, contact your dba".  Well, I AM the dba, and I don't know why this problem exists.  I have no errors logged on the SQL server, and none of my other applications encounter this problem.  Has anyone got any ideas what would cause this, or how to fix it?

System info:
Gemini v2.2.2

.NET Framework version: v2.0.50727 Windows 2000 5.0.2195 Service Pack 4 Intel Pentium 4 CPU 2.93Ghz

915,948KB ram

DB/Network info:
The Gemini application is connecting to a SQL Server 2000 server in the same physical room, though in a different IP range.  The Gemini app is on a public IP address and the sql server is on an internal address.  They're separated by a Cisco 2501 router and HP Procurve 4108GL switch.  Both are behind the same firewall.  The SQL box is "healthy"... low avg CPU, 3gb ram, raid5 hard drives for data, etc.  It's fast for all other operations, and no other sql-intensive apps (with hundreds of concurrent users) run into problems anything like this.

It's not a blanket config/connect issue, since it tends to be random, and while this is happening, other connections from the same webserver to the same sql server work just fine.  It's only Gemini, and it goes away by itself after a few minutes of frustrating all my would-be users.

Any info/help is welcome.  Thanks.

Error info:

A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - Insufficient system resources exist to complete the requested service.) 10/1/2007 9:41:34 AM at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32 bytesExpected) at System.Data.SqlClient.TdsParserStateObject.ReadBuffer() at System.Data.SqlClient.TdsParserStateObject.ReadByte() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data .Net SqlClient Data Provider

JBroome
· 1
JBroome
Replies (3)
helpful
0
not helpful

Do all of your web app connect to SQL the same way as Gemini?

a search on google: http://forums.asp.net/p/1029927/1411161.aspx


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Do all of your web app connect to SQL the same way as Gemini?

Not exactly the same, no.  Gemini is the only .Net application in the list.  The others are Classic ASP (vbscript), PHP and PowerBuilder.

The Classic ASP apps use OleDB connection strings, connecting via TCP (not named pipes) to the same IP/Port as Gemini is using).  They query via ADO automation (COM) objects: adodb.connection, adodb.recordset, etc.  They're in-house created and I have access to the entire codebase for them.

Never dug into the PHP app to see how it's connecting... it's 3rd party code.

The PowerBuilder apps use the PB Native connection type which is just a wrapper for ODBC Connectivity.  They connect to the same IP/Port as Gemini.  They're also in-house created and I have access to the entire codebase for them, except for the compiled PowerBuilder objects used to create our own functionality.

I've noticed that stopping/restarting the IIS service while this problem is occuring does not resolve the problem, but rebooting the entire web server does.  That makes it sound like it's repeating because of a pooled connection on the server that is somehow "bad", but still in use.

I suspect this because the other application types don't have the repeating problem while the Gemini app does -- perhaps it's something about how the .Net code is operating.

Thanks for your attention to this


JBroome
· 1
JBroome
helpful
0
not helpful

As you say, this might be an ASP.NET (ADO.NET) pooling or connection issues.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=962333&SiteID=1&pageid=0 This is another one that i have found. Try setting the timeout on the connection strings (add to the connection string in web.config):

Connect Timeout=60


Saar Cohen
· 5000
Saar Cohen