1 Reply Latest reply on Feb 26, 2019 1:59 PM by 3898041

    Solaris 10 Sparc lost RPC connection to heterogeneous remote agent

    3898041

      Hi. I have Solaris 10 spark architecture server. I have compiled "unixODBC", postgre-sql-odbc and oracle.

      lost RPC connection to heterogeneous remote agent

       

      -bash-3.2$ /nariman/local4/unixODBC/bin/isql -v PG

       

      1) I can execute isql from this server and everything work properly.

      +---------------------------------------+

      | Connected!                            |

      |                                       |

      | sql-statement                         |

      | help [tablename]                      |

      | quit                                  |

      |                                       |

      +---------------------------------------+

      SQL> select * from _own;

      +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+

      | pin          | name                | surname             | middle_name         | vo             | vo_name           | rol                 | payer_type          |

      +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+

      | 27KB           | John                | User                | JohnUser            |           | Test     | 3                   | P                   |

      +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+

      SQLRowCount returns 1

      1 rows fetched

      --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

      file /nariman/local4/unixODBC/lib/libodbc.so

      /nariman/local4/unixODBC/lib/libodbc.so:        ELF 64-bit MSB dynamic lib SPARCV9 Version 1, dynamically linked, not stripped, no debugging information available

      --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

      ldd /nariman/local4/unixODBC/bin/isql

              libodbc.so.2 =>  /nariman/local4/unixODBC/lib/libodbc.so.2

              libthread.so.1 =>        /lib/64/libthread.so.1

              libc.so.1 =>     /lib/64/libc.so.1

              libgcc_s.so.1 =>         /usr/lib/64/libgcc_s.so.1

              libm.so.2 =>     /lib/64/libm.so.2

              /lib/sparcv9/../libm/sparcv9/libm_hwcap1.so.2

              /platform/sun4v/lib/sparcv9/libc_psr.so.1

      --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

      cat /nariman/etc4/odbc.ini

      [PG]

      Description     = PG

      Driver          = /usr/local/lib/psqlodbcw.so

      FileUsage       = 1

      cat /nariman/etc4/odbc.ini

      [PG]

      Description     = PG

      Driver          = /usr/local/lib/psqlodbcw.so

      FileUsage       = 1

      Debug           = 0

      CommLog         = 0

      Servername = 10.120.43.3

      Username = postgres

      Port = 5432

      Database = yeke

      Password = pstg

      Protocol            =

      ReadOnly            = Yes

      RowVersioning       = No

      ShowSystemTables    = No

      ShowOidColumn       = No

      FakeOidIndex        = No

      ConnSettings        =

      TraceFile               = sql.log

      TRACE = ON

      --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

       

      file /usr/local/lib/psqlodbcw.so

      /usr/local/lib/psqlodbcw.so:    ELF 64-bit MSB dynamic lib SPARCV9 Version 1, dynamically linked, not stripped, no debugging information available

       

      --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

      -bash-3.2$ ldd /usr/local/lib/psqlodbcw.so

              libpq.so.5 =>    /usr/lib/64/libpq.so.5

              libpthread.so.1 =>       /lib/64/libpthread.so.1

              libodbcinst.so.2 =>      /nariman/local4/unixODBC/lib/libodbcinst.so.2

              libthread.so.1 =>        /lib/64/libthread.so.1

              libc.so.1 =>     /lib/64/libc.so.1

              libgcc_s.so.1 =>         /usr/lib/64/libgcc_s.so.1

              libnsl.so.1 =>   /lib/64/libnsl.so.1

              libsocket.so.1 =>        /lib/64/libsocket.so.1

              libmp.so.2 =>    /lib/64/libmp.so.2

              libmd.so.1 =>    /lib/64/libmd.so.1

              libscf.so.1 =>   /lib/64/libscf.so.1

              libdoor.so.1 =>  /lib/64/libdoor.so.1

              libuutil.so.1 =>         /lib/64/libuutil.so.1

              libgen.so.1 =>   /lib/64/libgen.so.1

              libm.so.2 =>     /lib/64/libm.so.2

              /lib/sparcv9/../libm/sparcv9/libm_hwcap1.so.2

              /platform/sun4v/lib/sparcv9/libc_psr.so.1

              /platform/sun4v/lib/sparcv9/libmd_psr.so.1

      --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

       

      cat /u01/app/11.2.0/grid/network/admin/listener.ora

       

      SID_LIST_LISTENER =

           (SID_LIST =

             (SID_DESC =

             (SID_NAME=PG)

               (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)

               (ENVS="LD_LIBRARY_PATH=/usr/lib:/usr/local/lib:/home/oracle/app/oracle/product/11.2.0/dbhome_1/lib:/nariman/local4/unixODBC/lib:/usr/local/lib/:/lib/64/:/usr/lib/64")

                (PROGRAM=dg4odbc)

             )

         )

       

      --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

       

      -bash-3.2$ lsnrctl status

      Service "PG" has 1 instance(s).

        Instance "PG", status UNKNOWN, has 1 handler(s) for this service...

       

      ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

       

      -bash-3.2$ cat /u01/app/oracle/product/11.2.0/dbhome_1/hs/admin/initPG.ora     

      HS_FDS_CONNECT_INFO = PG

      HS_FDS_SUPPORT_STATISTICS=FALSE

      HS_FDS_TRACE_LEVEL = ON

      HS_FDS_SHAREABLE_NAME = /nariman/local4/unixODBC/lib/libodbc.so

      HS_LANGUAGE=AMERICAN_AMERICA.AL16UTF16

      HS_FDS_TRACE_LEVEL = 4

      HS_FDS_CONNECT_PROPERTIES="disableExtendedFetch='true'"

      HS_FDS_FETCH_ROWS=1

      HS_FDS_SQLLEN_INTERPRETATION=32

      HS_NLS_NCHAR = UCS2

       

       

      set ODBCINI=/nariman/etc4/odbc.ini

       

      ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

      file /u01/app/oracle/product/11.2.0/dbhome_1/bin/dg4odbc

      /u01/app/oracle/product/11.2.0/dbhome_1/bin/dg4odbc:    ELF 64-bit MSB executable SPARCV9 Version 1, dynamically linked, not stripped

      ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

       

      SQL> select * from "_own"@PG;

      select * from "_own"@PG

                           *

      ERROR at line 1:

      ORA-28511: lost RPC connection to heterogeneous remote agent using SID=ORA-28511: lost RPC connection to heterogeneous remote agent using

      SID=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.110.15.3)(PORT=1521))(CONNECT_DATA=(SID=PG)))

      ORA-02063: preceding line from PG

      Process ID: 3211

      Session ID: 470 Serial number: 21163

      ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

       

       

      -bash-3.2$ cat PG_agt_3213.trc

       

       

       

       

      Oracle Corporation --- TUESDAY   FEB 26 2019 17:54:40.246

       

       

       

       

      Heterogeneous Agent Release

      11.2.0.3.0

       

       

       

       

       

       

       

       

      Oracle Corporation --- TUESDAY   FEB 26 2019 17:54:40.245

       

       

          Version 11.2.0.3.0

       

       

      Entered hgogprd

      HOSGIP for "HS_FDS_TRACE_LEVEL" returned "4"

      Entered hgosdip

      setting HS_OPEN_CURSORS to default of 50

      setting HS_FDS_RECOVERY_ACCOUNT to default of "RECOVER"

      setting HS_FDS_RECOVERY_PWD to default value

      setting HS_FDS_TRANSACTION_LOG to default of HS_TRANSACTION_LOG

      setting HS_IDLE_TIMEOUT to default of 0

      setting HS_FDS_TRANSACTION_ISOLATION to default of "READ_COMMITTED"

      HOSGIP returned value of "UCS2" for HS_NLS_NCHAR

      setting HS_FDS_TIMESTAMP_MAPPING to default of "DATE"

      setting HS_FDS_DATE_MAPPING to default of "DATE"

      setting HS_RPC_FETCH_REBLOCKING to default of "ON"

      HOSGIP returned value of "1" for HS_FDS_FETCH_ROWS

      setting HS_FDS_RESULTSET_SUPPORT to default of "FALSE"

      setting HS_FDS_RSET_RETURN_ROWCOUNT to default of "FALSE"

      setting HS_FDS_PROC_IS_FUNC to default of "FALSE"

      setting HS_FDS_MAP_NCHAR to default of "TRUE"

      setting HS_NLS_DATE_FORMAT to default of "YYYY-MM-DD HH24:MI:SS"

      setting HS_FDS_REPORT_REAL_AS_DOUBLE to default of "FALSE"

      setting HS_LONG_PIECE_TRANSFER_SIZE to default of "65536"

      setting HS_SQL_HANDLE_STMT_REUSE to default of "FALSE"

      setting HS_FDS_QUERY_DRIVER to default of "TRUE"

      HOSGIP returned value of "FALSE" for HS_FDS_SUPPORT_STATISTICS

      setting HS_FDS_QUOTE_IDENTIFIER to default of "TRUE"

      setting HS_KEEP_REMOTE_COLUMN_SIZE to default of "OFF"

      setting HS_FDS_GRAPHIC_TO_MBCS to default of "FALSE"

      setting HS_FDS_MBCS_TO_GRAPHIC to default of "FALSE"

      HOSGIP returned value of "32" for HS_FDS_SQLLEN_INTERPRETATION

      setting HS_CALL_NAME_ISP to "gtw$:SQLTables;gtw$:SQLColumns;gtw$:SQLPrimaryKeys;gtw$:SQLForeignKeys;gtw$:SQLProcedures;gtw$:SQLStatistics;gtw$:SQLGetInfo"

      setting HS_FDS_DELAYED_OPEN to default of "TRUE"

      setting HS_FDS_WORKAROUNDS to default of "0"

      Exiting hgosdip, rc=0

      ORACLE_SID is "PG"

      Product-Info:

        Port Rls/Upd:3/0 PrdStat:0

        Agent:Oracle Database Gateway for ODBC

        Facility:hsa

        Class:ODBC, ClassVsn:11.2.0.3.0_0011, Instance:PG

      Exiting hgogprd, rc=0

      Entered hgoinit

      HOCXU_COMP_CSET=1

      HOCXU_DRV_CSET=31

      HOCXU_DRV_NCHAR=1000

      HOCXU_DB_CSET=873

      HS_LANGUAGE is AMERICAN_AMERICA.AL16UTF16

      rc=2147471760 attempting to get LANG environment variable.

      HOCXU_SEM_VER=112000

      Entered hgolofn at 2019/02/26-17:54:40

      HOSGIP for "HS_FDS_SHAREABLE_NAME" returned "/nariman/local4/unixODBC/lib/libodbc.so"

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLAllocHandle

      symbol_peflctx=0x77715510

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLBindCol

      symbol_peflctx=0x77715838

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLBindParameter

      symbol_peflctx=0x7771676c

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLCancel

      symbol_peflctx=0x77719458

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLDescribeParam

      symbol_peflctx=0x777292e8

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLDisconnect

      symbol_peflctx=0x77729c18

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLEndTran

      symbol_peflctx=0x7772fe8c

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLExecute

      symbol_peflctx=0x7773244c

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLFetch

      symbol_peflctx=0x777335b0

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLFreeHandle

      symbol_peflctx=0x777367f0

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLFreeStmt

      symbol_peflctx=0x77736838

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLGetData

      symbol_peflctx=0x77739b04

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLGetEnvAttr

      symbol_peflctx=0x7773f410

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLGetFunctions

      symbol_peflctx=0x7773fa48

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLMoreResults

      symbol_peflctx=0x777435c0

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLNumResultCols

      symbol_peflctx=0x77744c18

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLParamData

      symbol_peflctx=0x777451e4

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLPutData

      symbol_peflctx=0x77748e34

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLRowCount

      symbol_peflctx=0x777496bc

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLSetEnvAttr

      symbol_peflctx=0x7774de0c

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLSetDescRec

      symbol_peflctx=0x7774d998

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLColAttribute

      symbol_peflctx=0x7771aee0

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLColumns

      symbol_peflctx=0x7771e160

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLConnect

      symbol_peflctx=0x77724f14

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLDescribeCol

      symbol_peflctx=0x77728618

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLDriverConnect

      symbol_peflctx=0x7772b55c

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLExecDirect

      symbol_peflctx=0x777318c0

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLForeignKeys

      symbol_peflctx=0x77734a34

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLGetConnectAttr

      symbol_peflctx=0x77736f70

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLGetDescField

      symbol_peflctx=0x7773aa48

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLGetDescRec

      symbol_peflctx=0x7773b6a4

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLGetDiagField

      symbol_peflctx=0x7773dbf8

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLGetDiagRec

      symbol_peflctx=0x7773ee4c

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLGetInfo

      symbol_peflctx=0x7774132c

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLGetStmtAttr

      symbol_peflctx=0x77741400

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLGetTypeInfo

      symbol_peflctx=0x77742d98

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLPrepare

      symbol_peflctx=0x777460f0

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLPrimaryKeys

      symbol_peflctx=0x77746b4c

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLProcedureColumns

      symbol_peflctx=0x7774771c

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLProcedures

      symbol_peflctx=0x77748378

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLSetConnectAttr

      symbol_peflctx=0x77749bd4

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLSetStmtAttr

      symbol_peflctx=0x7775108c

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLSetDescField

      symbol_peflctx=0x7774ce8c

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLStatistics

      symbol_peflctx=0x77754d9c

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Entered hgolofns at 2019/02/26-17:54:40

      libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLTables

      symbol_peflctx=0x777567e4

      hoaerr:0

      Exiting hgolofns at 2019/02/26-17:54:40

      Exiting hgolofn, rc=0 at 2019/02/26-17:54:40

      HOSGIP for "HS_OPEN_CURSORS" returned "50"

      HOSGIP for "HS_FDS_FETCH_ROWS" returned "1"

      HOSGIP for "HS_LONG_PIECE_TRANSFER_SIZE" returned "65536"

      HOSGIP for "HS_NLS_NUMERIC_CHARACTER" returned ".,"

      HOSGIP for "HS_KEEP_REMOTE_COLUMN_SIZE" returned "OFF"

      HOSGIP for "HS_FDS_DELAYED_OPEN" returned "TRUE"

      HOSGIP for "HS_FDS_WORKAROUNDS" returned "0"

      HOSGIP for "HS_FDS_MBCS_TO_GRAPHIC" returned "FALSE"

      HOSGIP for "HS_FDS_GRAPHIC_TO_MBCS" returned "FALSE"

      treat_SQLLEN_as_compiled = 0

      Exiting hgoinit, rc=0 at 2019/02/26-17:54:40

      Entered hgolgon at 2019/02/26-17:54:40

      reco:0, name:postgres, tflag:0

      Entered hgosuec at 2019/02/26-17:54:40

      Exiting hgosuec, rc=0 at 2019/02/26-17:54:40

      HOSGIP for "HS_FDS_RECOVERY_ACCOUNT" returned "RECOVER"

      HOSGIP for "HS_FDS_TRANSACTION_LOG" returned "HS_TRANSACTION_LOG"

      HOSGIP for "HS_FDS_TIMESTAMP_MAPPING" returned "DATE"

      HOSGIP for "HS_FDS_DATE_MAPPING" returned "DATE"

      HOSGIP for "HS_FDS_MAP_NCHAR" returned "TRUE"

      HOSGIP for "HS_FDS_RESULTSET_SUPPORT" returned "FALSE"

      HOSGIP for "HS_FDS_RSET_RETURN_ROWCOUNT" returned "FALSE"

      HOSGIP for "HS_FDS_PROC_IS_FUNC" returned "FALSE"

      HOSGIP for "HS_FDS_REPORT_REAL_AS_DOUBLE" returned "FALSE"

      using postgres as default value for "HS_FDS_DEFAULT_OWNER"

      HOSGIP for "HS_SQL_HANDLE_STMT_REUSE" returned "FALSE"

      Entered hgocont at 2019/02/26-17:54:40

      HS_FDS_CONNECT_INFO = "PG"

      RC=-1 from HOSGIP for "HS_FDS_CONNECT_STRING"

      Entered hgogenconstr at 2019/02/26-17:54:40

      dsn:PG, name:postgres

      optn:

      Entered hgocip at 2019/02/26-17:54:40

      dsn:PG

      Exiting hgocip, rc=0 at 2019/02/26-17:54:40

      ##>Connect Parameters (len=27)<##

      ## DSN=PG;

      #! UID=postgres;

      #! PWD=*

      Exiting hgogenconstr, rc=0 at 2019/02/26-17:54:40

      Entered hgolosf at 2019/02/26-17:54:40

      ODBC Function-Available-Array 0xFFFE 0x01FF 0xFF00 0xFE7F 0x03FF 0x0000

                                    0x0000 0x0000 0x0000 0x0000 0x0000 0x0000

                                    0x0000 0x0000 0x0000 0x0000 0x0000 0x0000

                                    0x0000 0x0000 0x0000 0x0000 0x0000 0x0000

                                    0x0000 0x0000 0x0000 0x0000 0x0000 0x0000

                                    0x0000 0x0000 0x0000 0x0000 0x0000 0x0000

                                    0x0000 0x0000 0x0000 0x0000 0x0000 0x0000

                                    0x0000 0x0000 0x0000 0x0000 0x0000 0x0000

                                    0x0000 0x0000 0x0000 0x0000 0x0000 0x0000

                                    0x0000 0x0000 0x0000 0x0000 0x0000 0x0000

                                    0x0000 0x0000 0xFE00 0x3B5D

      Exiting hgolosf, rc=0 at 2019/02/26-17:54:40

      DriverName:psqlodbcw.so, DriverVer:11.00.0000

      DBMS Name:PostgreSQL, DBMS Version:11.0.1

      Exiting hgocont, rc=0 at 2019/02/26-17:54:40

      SQLGetInfo returns Y for SQL_CATALOG_NAME

      SQLGetInfo returns 0 for SQL_MAX_CATALOG_NAME_LEN

      Exiting hgolgon, rc=0 at 2019/02/26-17:54:40

      Entered hgoulcp at 2019/02/26-17:54:40

      Entered hgowlst at 2019/02/26-17:54:40

      Exiting hgowlst, rc=0 at 2019/02/26-17:54:40

      SQLGetInfo returns 0x0 for SQL_OWNER_USAGE

      TXN Capable:2, Isolation Option:0x0

      SQLGetInfo returns 63 for SQL_MAX_SCHEMA_NAME_LEN

      SQLGetInfo returns 63 for SQL_MAX_TABLE_NAME_LEN

      SQLGetInfo returns 0 for SQL_MAX_PROCEDURE_NAME_LEN

      HOSGIP returned value of "TRUE" for HS_FDS_QUOTE_IDENTIFIER

      SQLGetInfo returns " (0x22) for SQL_IDENTIFIER_QUOTE_CHAR