1 Reply Latest reply: Dec 18, 2012 1:23 PM by Stephen Karniotis RSS

    Problems using unixODBC Driver for 64-bit Linux

    Stephen Karniotis
      Good morning

      We are incurring a problem with the unixODBC Driver via Oracle Heterogeneous Services for connecting from a 64-bit SUSE Linux Server to a Windows PostgreSQL database (8.2). Oracle is 11.2.0.3. We are receiving an error when retrieving SMALLINT data from PostGreSQL. This should "automagically" convert to NUMBER(5) in Oracle but we are receiving a conversion error.

      Here is the text of the HS Trace file. Any help in diagnosing this would be much appreciated.



      Oracle Corporation --- MONDAY DEC 17 2012 17:14:36.779


      Heterogeneous Agent Release
      11.2.0.3.0




      Oracle Corporation --- MONDAY DEC 17 2012 17:14:36.778

      Version 11.2.0.3.0

      Entered hgogprd
      HOSGIP for "HS_FDS_TRACE_LEVEL" returned "DEBUG"
      Entered hgosdip
      HOSGIP returned value of "50" for HS_OPEN_CURSORS
      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
      HOSGIP returned value of "0" for HS_IDLE_TIMEOUT
      setting HS_FDS_TRANSACTION_ISOLATION to default of "READ_COMMITTED"
      setting HS_NLS_NCHAR to default of "AL32UTF8"
      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 "100" for HS_FDS_FETCH_ROWS
      setting HS_FDS_RESULTSET_SUPPORT to default of "FALSE"
      HOSGIP returned value of "TRUE" for HS_FDS_RSET_RETURN_ROWCOUNT
      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"
      setting HS_FDS_SUPPORT_STATISTICS to default of "FALSE"
      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 "64" 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 "dev"
      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:dev
      Exiting hgogprd, rc=0
      Entered hgoinit
      HOCXU_COMP_CSET=1
      HOCXU_DRV_CSET=178
      HOCXU_DRV_NCHAR=873
      HOCXU_DB_CSET=873
      HS_LANGUAGE is american_america.we8mswin1252
      LANG=en_US.UTF-8
      HOCXU_SEM_VER=112000
      HOSGIP for "HS_FDS_REMOTE_DB_CHARSET" returned "we8mswin1252"
      Entered hgolofn at 2012/12/17-17:14:36
      HOSGIP for "HS_FDS_SHAREABLE_NAME" returned "/usr/lib64/psqlodbcw.so"
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451f9530
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451f4e70
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451f8110
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451f4f30
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451f6d20
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451f5610
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451f98e0
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451f5790
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451f5880
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451f9b20
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451f5980
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451f5a60
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451f9de0
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451f5b20
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451f7370
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451f5d80
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451f5e00
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451f5f10
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451f5fa0
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451fa160
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451fa130
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451f97c0
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451f4f60
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451f52e0
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451f5530
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451f53a0
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451f5680
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451f6eb0
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451f9ec0
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451f9bf0
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451f9c60
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451f9c90
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451f9d40
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451f5bc0
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451f9f60
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451f5cd0
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451f5e80
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451f74f0
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451f77a0
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451f7af0
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451fa020
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451fa280
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451fa0b0
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451f63e0
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Entered hgolofns at 2012/12/17-17:14:36
      symbol_peflctx=0x451f66d0
      hoaerr:0
      Exiting hgolofns at 2012/12/17-17:14:36
      Exiting hgolofn, rc=0 at 2012/12/17-17:14:36
      HOSGIP for "HS_OPEN_CURSORS" returned "50"
      HOSGIP for "HS_FDS_FETCH_ROWS" returned "100"
      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 = 1
      Exiting hgoinit, rc=0 at 2012/12/17-17:14:36
      Entered hgolgon at 2012/12/17-17:14:36
      reco:0, name:onstar, tflag:0
      Entered hgosuec at 2012/12/17-17:14:36
      Exiting hgosuec, rc=0 at 2012/12/17-17:14:36
      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 "TRUE"
      HOSGIP for "HS_FDS_PROC_IS_FUNC" returned "FALSE"
      HOSGIP for "HS_FDS_REPORT_REAL_AS_DOUBLE" returned "FALSE"
      using onstar as default value for "HS_FDS_DEFAULT_OWNER"
      HOSGIP for "HS_SQL_HANDLE_STMT_REUSE" returned "FALSE"
      Entered hgocont at 2012/12/17-17:14:36
      HS_FDS_CONNECT_INFO = "PecanStreetDB"
      RC=-1 from HOSGIP for "HS_FDS_CONNECT_STRING"
      Entered hgogenconstr at 2012/12/17-17:14:36
      dsn:PecanStreetDB, name:onstar
      optn:
      Entered hgocip at 2012/12/17-17:14:36
      dsn:PecanStreetDB
      Exiting hgocip, rc=0 at 2012/12/17-17:14:36
      Exiting hgogenconstr, rc=0 at 2012/12/17-17:14:36
      Entered hgolosf at 2012/12/17-17:14:37
      Exiting hgolosf, rc=0 at 2012/12/17-17:14:37
      DriverName:psqlodbcw.so, DriverVer:08.03.0200
      DBMS Name:PostgreSQL, DBMS Version:PostgreSQL 8.2.15 (Greenplum Database 4.1.1.1 build 1 Community Edition) on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC)
      Exiting hgocont, rc=0 at 2012/12/17-17:14:37
      SQLGetInfo returns Y for SQL_CATALOG_NAME
      SQLGetInfo returns 0 for SQL_MAX_CATALOG_NAME_LEN
      Exiting hgolgon, rc=0 at 2012/12/17-17:14:37
      Entered hgoulcp at 2012/12/17-17:14:37
      Entered hgowlst at 2012/12/17-17:14:37
      Exiting hgowlst, rc=0 at 2012/12/17-17:14:37
      SQLGetInfo returns 0x1d for SQL_OWNER_USAGE
      TXN Capable:2, Isolation Option:0xa
      SQLGetInfo returns 64 for SQL_MAX_SCHEMA_NAME_LEN
      SQLGetInfo returns 64 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
      2 instance capabilities will be uploaded
      capno:1989, context:0x00000000, add-info: 0
      capno:1992, context:0x0001ffff, add-info: 0
      Exiting hgoulcp, rc=0 at 2012/12/17-17:14:37
      Entered hgouldt at 2012/12/17-17:14:37
      NO instance DD translations were uploaded
      Exiting hgouldt, rc=0 at 2012/12/17-17:14:37
      Entered hgobegn at 2012/12/17-17:14:37
      tflag:0 , initial:1
      hoi:0xcca42008, ttid (len 27) is ...
      00: 534D5254 47524444 2E306635 35343862 [SMRTGRDD.0f5548b]
      10: 352E392E 392E3732 323038 [5.9.9.72208]
      tbid (len 24) is ...
      00: 534D5254 47524444 5B392E39 2E373232 [SMRTGRDD[9.9.722]
      10: 30385D5B 312E345D [08][1.4]]
      Exiting hgobegn, rc=0 at 2012/12/17-17:14:38
      Entered hgodtab at 2012/12/17-17:14:38
      count:1
      table: dev.onstar_view
      Allocate hoada[0] @ 0x7794d0
      Entered hgopcda at 2012/12/17-17:14:38
      Column:1(dataid): dtype:5 (SMALLINT), prc/scl:5/0, nullbl:1, octet:0, sign:1, radix:10
      Exiting hgopcda, rc=0 at 2012/12/17-17:14:38
      Entered hgopcda at 2012/12/17-17:14:38
      Column:2(timestamp_localtime): dtype:93 (TIMESTAMP), prc/scl:19/0, nullbl:1, octet:0, sign:1, radix:10
      Exiting hgopcda, rc=0 at 2012/12/17-17:14:38
      Entered hgopcda at 2012/12/17-17:14:38
      Column:3(use): dtype:2 (NUMERIC), prc/scl:28/6, nullbl:1, octet:0, sign:1, radix:10
      Exiting hgopcda, rc=0 at 2012/12/17-17:14:38
      Entered hgopcda at 2012/12/17-17:14:38
      Column:4(gen): dtype:2 (NUMERIC), prc/scl:28/6, nullbl:1, octet:0, sign:1, radix:10
      Exiting hgopcda, rc=0 at 2012/12/17-17:14:38
      Entered hgopcda at 2012/12/17-17:14:38
      Column:5(grid): dtype:2 (NUMERIC), prc/scl:28/6, nullbl:1, octet:0, sign:1, radix:10
      Exiting hgopcda, rc=0 at 2012/12/17-17:14:38
      Entered hgopcda at 2012/12/17-17:14:38
      Column:6(air): dtype:2 (NUMERIC), prc/scl:28/6, nullbl:1, octet:0, sign:1, radix:10
      Exiting hgopcda, rc=0 at 2012/12/17-17:14:38
      Entered hgopcda at 2012/12/17-17:14:38
      Column:7(furnace): dtype:2 (NUMERIC), prc/scl:28/6, nullbl:1, octet:0, sign:1, radix:10
      Exiting hgopcda, rc=0 at 2012/12/17-17:14:38
      Entered hgopcda at 2012/12/17-17:14:38
      Column:8(car): dtype:2 (NUMERIC), prc/scl:28/6, nullbl:1, octet:0, sign:1, radix:10
      Exiting hgopcda, rc=0 at 2012/12/17-17:14:38
      The hoada for table dev.onstar_view follows...
      hgodtab, line 1092: Printing hoada @ 0x7794d0
      MAX:8, ACTUAL:8, BRC:1, WHT=6 (TABLE_DESCRIBE)
      DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
      5 SMALLINT Y 2 2 0/ 0 0 0 0 dataid
      91 DATE Y 16 16 0/ 0 0 0 0 timestamp_localtime
      3 DECIMAL Y 31 31 28/ 6 0 0 0 use
      3 DECIMAL Y 31 31 28/ 6 0 0 0 gen
      3 DECIMAL Y 31 31 28/ 6 0 0 0 grid
      3 DECIMAL Y 31 31 28/ 6 0 0 0 air
      3 DECIMAL Y 31 31 28/ 6 0 0 0 furnace
      3 DECIMAL Y 31 31 28/ 6 0 0 0 car
      Exiting hgodtab, rc=0 at 2012/12/17-17:14:38
      Entered hgodafr, cursor id 0 at 2012/12/17-17:14:38
      Free hoada @ 0x7794d0
      Exiting hgodafr, rc=0 at 2012/12/17-17:14:38
      Entered hgopars, cursor id 1 at 2012/12/17-17:14:38
      type:0
      SQL text from hgopars, id=1, len=40 ...
      00: 53454C45 43542022 64617461 69642220 [SELECT "dataid" ]
      10: 46524F4D 20226465 76222E22 6F6E7374 [FROM "dev"."onst]
      20: 61725F76 69657722 [ar_view"]
      Exiting hgopars, rc=0 at 2012/12/17-17:14:40
      Entered hgoopen, cursor id 1 at 2012/12/17-17:14:40
      hgoopen, line 87: NO hoada to print
      Deferred open until first fetch.
      Exiting hgoopen, rc=0 at 2012/12/17-17:14:40
      Entered hgodscr, cursor id 1 at 2012/12/17-17:14:40
      Allocate hoada @ 0x779478
      Entered hgodscr_process_sellist_description at 2012/12/17-17:14:40
      Entered hgopcda at 2012/12/17-17:14:40
      Column:1(dataid): dtype:5 (SMALLINT), prc/scl:5/0, nullbl:1, octet:0, sign:1, radix:0
      Exiting hgopcda, rc=0 at 2012/12/17-17:14:40
      hgodscr, line 464: Printing hoada @ 0x779478
      MAX:1, ACTUAL:1, BRC:100, WHT=5 (SELECT_LIST)
      DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
      5 SMALLINT Y 2 2 0/ 0 0 0 0 dataid
      Exiting hgodscr, rc=0 at 2012/12/17-17:14:40
      Entered hgoftch, cursor id 1 at 2012/12/17-17:14:40
      hgoftch, line 133: Printing hoada @ 0x779478
      MAX:1, ACTUAL:1, BRC:100, WHT=5 (SELECT_LIST)
      DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
      5 SMALLINT Y 2 2 0/ 0 0 0 0 dataid
      Performing delayed open.
      SQLBindCol: column 1, cdatatype: -15, bflsz: 2
      SQLFetch: row: 1, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 1, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 2, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 2, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 3, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 3, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 4, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 4, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 5, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 5, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 6, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 6, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 7, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 7, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 8, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 8, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 9, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 9, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 10, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 10, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 11, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 11, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 12, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 12, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 13, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 13, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 14, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 14, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 15, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 15, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 16, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 16, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 17, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 17, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 18, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 18, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 19, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 19, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 20, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 20, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 21, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 21, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 22, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 22, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 23, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 23, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 24, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 24, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 25, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 25, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 26, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 26, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 27, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 27, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 28, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 28, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 29, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 29, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 30, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 30, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 31, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 31, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 32, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 32, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 33, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 33, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 34, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 34, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 35, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 35, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 36, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 36, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 37, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 37, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 38, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 38, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 39, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 39, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 40, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 40, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 41, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 41, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 42, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 42, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 43, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 43, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 44, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 44, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 45, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 45, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 46, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 46, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 47, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 47, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 48, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 48, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 49, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 49, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 50, column 1, bflsz: 2, bflar: 2
      SQLFetch: row: 50, column 1, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
      SQLFetch: row: 51, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 51, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 52, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 52, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 53, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 53, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 54, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 54, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 55, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 55, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 56, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 56, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 57, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 57, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 58, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 58, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 59, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 59, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 60, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 60, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 61, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 61, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 62, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 62, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 63, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 63, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 64, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 64, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 65, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 65, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 66, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 66, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 67, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 67, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 68, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 68, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 69, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 69, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 70, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 70, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 71, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 71, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 72, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 72, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 73, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 73, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 74, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 74, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 75, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 75, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 76, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 76, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 77, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 77, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 78, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 78, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 79, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 79, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 80, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 80, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 81, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 81, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 82, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 82, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 83, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 83, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 84, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 84, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 85, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 85, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 86, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 86, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 87, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 87, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 88, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 88, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 89, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 89, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 90, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 90, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 91, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 91, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 92, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 92, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 93, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 93, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 94, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 94, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 95, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 95, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 96, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 96, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 97, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 97, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 98, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 98, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 99, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 99, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      SQLFetch: row: 100, column 1, bflsz: 2, bflar: 0
      SQLFetch: row: 100, column 1, bflsz: 2, bflar: 0, (bfl: 2, mbl: 2)
      100 rows fetched
      Exiting hgoftch, rc=0 at 2012/12/17-17:14:40
      HS Agent received unexpected RPC disconnect
      Network error 1003: NCR-01003: NCRS: Read error.
      Entered hgoroll at 2012/12/17-17:15:36
      tflag:0 , cmt(38):Unexpected EOF from Oracle - Rollback
      hoi:0x756988, ttid (len 27) is ...
      00: 534D5254 47524444 2E306635 35343862 [SMRTGRDD.0f5548b]
      10: 352E392E 392E3732 323038 [5.9.9.72208]
      tbid (len 24) is ...
      00: 534D5254 47524444 5B392E39 2E373232 [SMRTGRDD[9.9.722]
      10: 30385D5B 312E345D [08][1.4]]
      Entered hgocpctx at 2012/12/17-17:15:36
      Exiting hgocpctx, rc=0 at 2012/12/17-17:15:36
      Exiting hgoroll, rc=0 at 2012/12/17-17:15:36
      Entered hgodafr, cursor id 1 at 2012/12/17-17:15:36
      Free hoada @ 0x779478
      Exiting hgodafr, rc=0 at 2012/12/17-17:15:36
      Entered hgolgof at 2012/12/17-17:15:36
      tflag:0
      Exiting hgolgof, rc=0 at 2012/12/17-17:15:36
      Entered hgoexit at 2012/12/17-17:15:36
      Exiting hgoexit, rc=0