Search code examples
sql-serverruby-on-railsactiverecordfreetds

FreeTDS Bad token from the server (SQL Server)

Today we had a lot more activity than normal between our Ruby on Rails application and our remote legacy SQL Server 2005 database, and we started getting the error below intermittently. What is is? How can I prevent it (besides avoiding the situation, which we're working on)?

Error Message:

ActiveRecord::StatementInvalid: DBI::DatabaseError: 08S01 (20020) [unixODBC][FreeTDS][SQL Server] Bad token from the server: Datastream processing out of sync: SELECT * FROM [marketing] WHERE ([marketing].[contact_id] = 832085)

Solution

  • This Microsoft article says:

    Often caused by an abruptly terminated network connection, which causes a damaged Tabular Data Stream token to be read by the client.

    Was the server network bound? I have no experience with SQL Server, but does it have a limit on the number of connections you can make?