Problem:

Why do I get the error "Msg = ConnectionWrite"?

Resolution:

• Product Name: StarTeam
• Product Version: 2005 & 2005R2
• Product Component: Server
• Platform/OS Version: Windows

Question:

Why do I get the following error in the server log?

Server dropped a bad connection (pool size = 19)
Attempt to reserve a connection after a bad connection was dropped (pool size = 20)
Exception handled at CStServer::DoCommand: Class = CDBException, Code = 4294967295(0xffffffff)
Msg = ConnectionWrite (send()).
General network error. Check your network documentation.

[ComponentID] = -1
[Client IP Address] = (Your_ip_here)
[User Name] = ABC
[Table Name] = Change
[ClassID] = 36
[Function Name] = CStDbObjectSet::Query
[ODBC Error] = State:01000,Native:10054,Origin:[Microsoft][ODBC SQL Server Driver][DBNETLIB]
State:08S01,Native:11,Origin:[Microsoft][ODBC SQL Server Driver][DBNETLIB]
[CommandID] = 2002
[ServiceID] = 524288

Answer:

This is a generic communication error between StarTeam and the Database. The exception is most typically associated with either the Database shutting down when StarTeam Server was still connected and using it or a network connection was lost between the server and database.

The StarTeam server needs an uninterrupted connection to the database so if you are going to backup, perform maintenance or restart the database server you need to shutdown/stop the StarTeam server first and then bring it back up only after the database is available again.

If the database was not shutdown then it may be network related and you should consider increasing the amount of pooled connections. You can find this setting in the Server Administration tool but please consult the documentation before doing so. If you suspect other network issues then please monitor the network for any trends in peak usage times which may be causing network bottlenecks.

Author: Ja?Mille Wilborn