{"action":"created","issue":{"url":"https://api.github.com/repos/GeoffMontee/tds_fdw/issues/59","repository_url":"https://api.github.com/repos/GeoffMontee/tds_fdw","labels_url":"https://api.github.com/repos/GeoffMontee/tds_fdw/issues/59/labels{/name}","comments_url":"https://api.github.com/repos/GeoffMontee/tds_fdw/issues/59/comments","events_url":"https://api.github.com/repos/GeoffMontee/tds_fdw/issues/59/events","html_url":"https://github.com/GeoffMontee/tds_fdw/issues/59","id":132910937,"number":59,"title":"Getting timeout error while connecting to SQL server 2012","user":{"login":"shithin-qburst","id":16540962,"avatar_url":"https://avatars.githubusercontent.com/u/16540962?v=3","gravatar_id":"","url":"https://api.github.com/users/shithin-qburst","html_url":"https://github.com/shithin-qburst","followers_url":"https://api.github.com/users/shithin-qburst/followers","following_url":"https://api.github.com/users/shithin-qburst/following{/other_user}","gists_url":"https://api.github.com/users/shithin-qburst/gists{/gist_id}","starred_url":"https://api.github.com/users/shithin-qburst/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/shithin-qburst/subscriptions","organizations_url":"https://api.github.com/users/shithin-qburst/orgs","repos_url":"https://api.github.com/users/shithin-qburst/repos","events_url":"https://api.github.com/users/shithin-qburst/events{/privacy}","received_events_url":"https://api.github.com/users/shithin-qburst/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2016-02-11T07:51:31Z","updated_at":"2016-02-15T09:55:44Z","closed_at":null,"body":"While executing SQL queries, we are getting the timeout errors. \r\n--\r\n2016-02-03 01:05:42.055 EST gmprod psql 172.17.0.1(54888) 172.17.0.1 >ERROR: DB-Library error: DB #: 20004, DB Msg: Read from the server failed, OS #: 110, OS Msg: Connection timed out, Level: 9\r\n--\r\nWe have verified the queries initiated from PostgreSQL(select query) reaches SQL server using 'sp_who'  and script mentioned in http://blog.sqlauthority.com/2009/01/07/sql-server-find-currently-running-query-t-sql/ . "},"comment":{"url":"https://api.github.com/repos/GeoffMontee/tds_fdw/issues/comments/184139451","html_url":"https://github.com/GeoffMontee/tds_fdw/issues/59#issuecomment-184139451","issue_url":"https://api.github.com/repos/GeoffMontee/tds_fdw/issues/59","id":184139451,"user":{"login":"shithin-qburst","id":16540962,"avatar_url":"https://avatars.githubusercontent.com/u/16540962?v=3","gravatar_id":"","url":"https://api.github.com/users/shithin-qburst","html_url":"https://github.com/shithin-qburst","followers_url":"https://api.github.com/users/shithin-qburst/followers","following_url":"https://api.github.com/users/shithin-qburst/following{/other_user}","gists_url":"https://api.github.com/users/shithin-qburst/gists{/gist_id}","starred_url":"https://api.github.com/users/shithin-qburst/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/shithin-qburst/subscriptions","organizations_url":"https://api.github.com/users/shithin-qburst/orgs","repos_url":"https://api.github.com/users/shithin-qburst/repos","events_url":"https://api.github.com/users/shithin-qburst/events{/privacy}","received_events_url":"https://api.github.com/users/shithin-qburst/received_events","type":"User","site_admin":false},"created_at":"2016-02-15T09:55:44Z","updated_at":"2016-02-15T09:55:44Z","body":"I have enabled msg_handler to \"notice\" for the foreign table. The psql client returned the same error. This is what I got in PostgreSQL logs. \r\n\r\n```\r\n< 2016-02-15 04:17:16.133 EST gmprod psql 127.0.0.1(57276) 127.0.0.1 >ERROR:  DB-Library error: DB #: 20004, DB Msg: Read from the server failed, OS #: 110, OS Msg: Connection timed out, Level: 9\r\n< 2016-02-15 04:17:16.133 EST gmprod psql 127.0.0.1(57276) 127.0.0.1 >STATEMENT:  INSERT INTO automapper_datadictionary\r\n                (\r\n                                        data_dictionary_id,\r\n                                        major_group_name,\r\n                                        minor_group_name,\r\n                                        item_name,\r\n                                        master_hierarchy_id,\r\n                                        master_item_id,\r\n                                        master_item_name,\r\n                                        enterprise_id,\r\n                                        map_user,\r\n                                        map_dt,\r\n                                        qa_user,\r\n                                        qa_dt\r\n                )(\r\n                    SELECT  a.datadictionaryid,\r\n                                    a.majorgroupname,\r\n                                        a.minorgroupname,\r\n                                        a.itemname,\r\n                                        a.masterhierarchyid,\r\n                                        a.masteritemid,\r\n                                        a.masteritemname,\r\n                                        a.enterpriseid,\r\n                                        a.addedby,\r\n                                        cast(a.addeddate as timestamp),\r\n                                        a.reviewedby,\r\n                                        cast(a.revieweddate as timestamp)\r\n                        FROM  mssql_automapper_datadictionary a\r\n                );\r\n\r\n```\r\n"}}