{"action":"created","issue":{"url":"https://api.github.com/repos/anlek/mongify/issues/72","labels_url":"https://api.github.com/repos/anlek/mongify/issues/72/labels{/name}","comments_url":"https://api.github.com/repos/anlek/mongify/issues/72/comments","events_url":"https://api.github.com/repos/anlek/mongify/issues/72/events","html_url":"https://github.com/anlek/mongify/issues/72","id":116097564,"number":72,"title":"\"Statement invalid\" error with SQL Server 2012","user":{"login":"jbwl","id":2697194,"avatar_url":"https://avatars.githubusercontent.com/u/2697194?v=3","gravatar_id":"","url":"https://api.github.com/users/jbwl","html_url":"https://github.com/jbwl","followers_url":"https://api.github.com/users/jbwl/followers","following_url":"https://api.github.com/users/jbwl/following{/other_user}","gists_url":"https://api.github.com/users/jbwl/gists{/gist_id}","starred_url":"https://api.github.com/users/jbwl/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jbwl/subscriptions","organizations_url":"https://api.github.com/users/jbwl/orgs","repos_url":"https://api.github.com/users/jbwl/repos","events_url":"https://api.github.com/users/jbwl/events{/privacy}","received_events_url":"https://api.github.com/users/jbwl/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-11-10T12:28:44Z","updated_at":"2015-11-10T18:28:35Z","closed_at":null,"body":"I have set up mongify to use with SQL Server 2012 using activerecord-sqlserver-adapter 3.2.13 (because mongify depends on activerecord ~> 3.2)\r\n\r\nmongify check gives me an OK on both connections. When I try to process a translation (one table for testing), I get this strange error:\r\n\r\n/home/user/.rbenv/versions/2.2.2/lib/ruby/gems/2.2.0/gems/activerecord-sqlserver-adapter-3.2.13/lib/active_record/connection_adapters/sqlserver/database_statements.rb:416:in `each': TinyTds::Error: Adaptive Server connection timed out: EXEC sp_executesql N'SELECT COUNT(*) FROM MYBIGTABLE' (ActiveRecord::StatementInvalid)\r\n\r\n(full dump here: https://gist.github.com/jbwl/62e8cb3a041499373d41)\r\n\r\nThe statement itself: \r\n`EXEC sp_executesql N'SELECT COUNT(*) FROM MYBIGTABLE' `\r\nis valid and executes on other database clients with no problem, so I am thinking this error message is misleading and the problem is actually elsewhere."},"comment":{"url":"https://api.github.com/repos/anlek/mongify/issues/comments/155523178","html_url":"https://github.com/anlek/mongify/issues/72#issuecomment-155523178","issue_url":"https://api.github.com/repos/anlek/mongify/issues/72","id":155523178,"user":{"login":"anlek","id":11052,"avatar_url":"https://avatars.githubusercontent.com/u/11052?v=3","gravatar_id":"","url":"https://api.github.com/users/anlek","html_url":"https://github.com/anlek","followers_url":"https://api.github.com/users/anlek/followers","following_url":"https://api.github.com/users/anlek/following{/other_user}","gists_url":"https://api.github.com/users/anlek/gists{/gist_id}","starred_url":"https://api.github.com/users/anlek/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/anlek/subscriptions","organizations_url":"https://api.github.com/users/anlek/orgs","repos_url":"https://api.github.com/users/anlek/repos","events_url":"https://api.github.com/users/anlek/events{/privacy}","received_events_url":"https://api.github.com/users/anlek/received_events","type":"User","site_admin":false},"created_at":"2015-11-10T18:28:35Z","updated_at":"2015-11-10T18:28:35Z","body":"I'm sorry to hear you're having issues. Sql Server is one of those things I'm unable to test as I don't have a Windows machine. However it seems the adapter is timing out. See if there is a way to add a longer timeout for `TinyTds`. Again, this is just a guess as I am not very familiar with Sql Server.\r\nGood luck!"}}