ERROR: DB-Library error: DB #: 20018, DB Msg: General SQL Server error: Check messages from the SQL Server, OS #: -1, OS Msg: , Level: 16 SQL state: HV00L

[travisas]

We recieve this error when trying to access MYSQL Link table via FDW from Postgres. Couldnt find on the web what level: 16 references. Any help would be appreciated.

Thank you
Travis

[juliogonzalez]

Hi @travisas,

Could you share with us more details, such as tds_fdw version, freetds config, table(s) structure(s) at both MSSQL and PostgreSQL, and the query that provokes the issue?

[travisas]

Information Below. I have three screen captures to share. how can I do that?

Postgres version 9.6

Microsoft SQL Server 2008 (SP3) - 10.0.5538.0 (X64) Apr 3 2015 14:50:02 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.0 (Build 6002: Service Pack 2)

------------------------- Process being used

As mentioned below, If the views are pointing to different server( with linked server) we are not able to retrieve the data from SQL Server. Please find the below steps which we performed for executing the task.

1.   Connecting to Dev Server, IMASCDB.
   

2.   Please find the below screenshot for  View Definition for [META].[MEASURE_TYPE]
   

3.   Please find the below screen shot for Data Types of  Meta.Measure_Type
   

4.   We are able to create Foreign Table for the view.
   

5.   When we are trying to execute the query it is throwing below error.
   

ERROR: DB-Library error: DB #: 20018, DB Msg: General SQL Server error: Check messages from the SQL Server, OS #: -1, OS Msg: , Level: 16
SQL state: HV00L

[travisas]

Free TDS version: freetds-0.95.81

Global settings are overridden by those in a database

server specific section

[global]
# TDS protocol version
; tds version = 4.2

    # Whether to write a TDSDUMP file for diagnostic purposes
    # (setting this to /tmp is insecure on a multi-user system)

; dump file = /tmp/freetds.log
; debug flags = 0xffff

    # Command and connection timeouts

; timeout = 10
; connect timeout = 10

    # If you get out-of-memory errors, it may mean that your client
    # is trying to allocate a huge buffer for a TEXT field.
    # Try setting 'text size' to a more reasonable limit
    text size = 64512

A typical Sybase server

[travisas]

[travisas]

Any help would be appreciated.. let me know if you have any questions about the uploaded images.

Postgres fdw -> mysql link table -> mysql static table

is what we are trying to do here.

[ilkosta]

same problem and seem same use-case:

pg (fdw) -> mssql (linked server) -> mssql

[pembo13]

Seeing this when I try to update a materialized view

DB-Library error: DB #: 20004, DB Msg: Read from the server failed, OS #: 4, OS Msg: Interrupted system call, Level: 9

[julqui]

modificar la base de datos SQLSERVER a:

ALTER DATABASE [...]SET ANSI_NULL_DEFAULT ON
ALTER DATABASE [...]SET ANSI_NULLS ON
ALTER DATABASE [...]SET ANSI_warnings ON