1 2 Previous Next 21 Replies Latest reply: Aug 30, 2012 6:33 AM by Kgronau-Oracle Go to original post RSS
      • 15. Re: Problems with dg4odbc after 11gr2 upgrade
        957289
        The driver i am using is sql anywhere 11. I've tried sql anywhere 12 odbc driver (the latest one i can find) and getting exactly the same results.
        • 16. Re: Problems with dg4odbc after 11gr2 upgrade
          957289
          I've set the trace to 255 in the init file and get this from the server that isn't working:

          1 rows fetched
          Exiting hgoftch, rc=0 at 2012/08/29-16:46:47
          hostmstr: 2022428672:      HOA After hoaftch
          hostmstr: 2022428672:      HOA Before hoaftch
          Entered hgoftch, cursor id 1 at 2012/08/29-16:46:47
          hgoftch, line 130: Printing hoada @ 02E07198
          MAX:12, ACTUAL:12, BRC:1, WHT=5 (SELECT_LIST)
          hoadaMOD bit-values found (0x200:TREAT_AS_CHAR)
          DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
          4 INTEGER Y 4 4 0/ 0 0 0 0 Lo_Code
          12 VARCHAR Y 6 10 0/ 0 0 0 200 Maintenance_Contract_Ref
          12 VARCHAR Y 19 60 0/ 0 0 0 200 Maintenance_Contract
          91 DATE Y 16 16 0/ 0 0 0 0 Last_Service_Date
          91 DATE Y 16 16 0/ 0 0 0 0 Previous_Service_Date
          5 SMALLINT Y 2 2 0/ 0 0 0 0 Last_Service_Over_12_Months
          5 SMALLINT Y 2 2 0/ 0 0 0 0 Last_Service_Over_11_Months
          5 SMALLINT Y 2 2 0/ 0 0 0 0 Total_Over_11_Months
          5 SMALLINT Y 2 2 0/ 0 0 0 0 Last_Service_Under_11_Months
          5 SMALLINT Y 2 2 0/ 0 0 0 0 Last_Service_Under_12_Months
          5 SMALLINT Y 2 2 0/ 0 0 0 0 Total_Under_12_Months
          5 SMALLINT Y 2 2 0/ 0 0 0 0 product_group_code
          0 rows fetched
          Exiting hgoftch, rc=1403 at 2012/08/29-16:46:47
          hostmstr: 2022428672:      HOA After hoaftch
          hostmstr: 2022428672: RPC After Fetch Row

          and this from the one that is ok:

          0 rows fetched
          Exiting hgoftch, rc=1403 at 2012/08/29-16:53:42
          hostmstr: 2022285312:      HOA After hoaftch
          hostmstr: 2022285312: RPC After Fetch Row
          hostmstr: 2022285312: RPC Before Commit Trans
          hostmstr: 2022285312:      HOA Before hoxclse
          Entered hgoclse, cursor id 1 at 2012/08/29-16:53:46
          Exiting hgoclse, rc=0 at 2012/08/29-16:53:46
          hostmstr: 2022285312:      HOA After hoxclse
          hostmstr: 2022285312:      HOA Before hoadafr
          Entered hgodafr, cursor id 1 at 2012/08/29-16:53:46
          Free hoada @ 02AA7AD8
          Exiting hgodafr, rc=0 at 2012/08/29-16:53:46
          hostmstr: 2022285312:      HOA After hoadafr
          hostmstr: 2022285312:      HOA Before hoacomm
          Entered hgocomm at 2012/08/29-16:53:46
          keepinfo:0, tflag:1
          00: 494C4956 452E6330 62356462 32632E32 [ILIVE.c0b5db2c.2]
          10: 372E3336 2E373134 3239 [7.36.71429]
          tbid (len 10) is ...
          0: 1B002400 05170100 0104 [..$.......]
          cmt(0):
          Entered hgocpctx at 2012/08/29-16:53:46
          Exiting hgocpctx, rc=0 at 2012/08/29-16:53:46
          Exiting hgocomm, rc=0 at 2012/08/29-16:53:46
          hostmstr: 2022285312:      HOA After hoacomm
          hostmstr: 2022285312: RPC After Commit Trans
          hostmstr: 2022285312: RPC Before Logoff
          hostmstr: 2022285312:      HOA Before hoalgof
          Entered hgolgof at 2012/08/29-16:53:46
          tflag:1
          Exiting hgolgof, rc=0 at 2012/08/29-16:53:46
          hostmstr: 2031304704:      HOA After hoalgof
          hostmstr: 2031304704: RPC After Logoff
          hostmstr: 2031304704: RPC Before Exit Agent
          hostmstr: 2031304704:      HOA Before hoaexit
          Entered hgoexit at 2012/08/29-16:53:46
          Exiting hgoexit, rc=0
          hostmstr: 2033340416:      HOA After hoaexit
          hostmstr: 2033340416: RPC After Exit Agent

          It's as if the server that isn't working doesn't finish the request
          • 17. Re: Problems with dg4odbc after 11gr2 upgrade
            Kgronau-Oracle
            The first point in your trace file is the way the numbers are treated - the precision and scale is always 0:
            5 SMALLINT Y 2 2 0/ 0 0 0 0 Last_Service_Over_12_Months

            Could you please upload the trace files to a public server so that I can download and compare the whole file?
            Also please provide your current gateway init file.
            • 18. Re: Problems with dg4odbc after 11gr2 upgrade
              957289
              The current init file reads:

              HS_FDS_CONNECT_INFO = PRO_WPH
              HS_FDS_TRACE_LEVEL = 255
              HS_LANGUAGE = AMERICAN_AMERICA.WE8ISO8859P1

              Sorry we don't have anywhere to post this really so I've put the whole trace file below.

              Oracle Corporation --- WEDNESDAY AUG 29 2012 16:46:46.456


              Heterogeneous Agent Release
              11.2.0.1.0




              Oracle Corporation --- WEDNESDAY AUG 29 2012 16:46:46.456

              Version 11.2.0.1.0

              Entered hgogprd
              HOSGIP for "HS_FDS_TRACE_LEVEL" returned "255"
              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"
              setting HS_NLS_NCHAR to default of "UCS2"
              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"
              setting HS_FDS_FETCH_ROWS to default of "100"
              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_CHARACTER_SEMANTICS 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"
              Parameter HS_FDS_QUOTE_IDENTIFIER is not set
              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"
              Default value of 32 assumed 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 "PRO_WPH"
              Product-Info:
              Port Rls/Upd:1/0 PrdStat:0
              Agent:Oracle Database Gateway for ODBC
              Facility:hsa
              Class:ODBC, ClassVsn:11.2.0.1.0_0008, Instance:PRO_WPH
              Exiting hgogprd, rc=0
              hostmstr: 2033819648:      HOA After hoagprd
              hostmstr: 2033819648:      HOA Before hoainit
              Entered hgoinit
              HOCXU_COMP_CSET=1
              HOCXU_DRV_CSET=31
              HOCXU_DRV_NCHAR=1000
              HOCXU_DB_CSET=31
              HOCXU_SEM_VER=112000
              Entered hgolofn at 2012/08/29-16:46:46
              Exiting hgolofn, rc=0 at 2012/08/29-16:46:46
              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"
              Invalid value of 32 given for HS_FDS_SQLLEN_INTERPRETATION
              treat_SQLLEN_as_compiled = 1
              Exiting hgoinit, rc=0 at 2012/08/29-16:46:46
              hostmstr: 2033819648:      HOA After hoainit
              hostmstr: 2033819648:      HOA Before hoalgon
              Entered hgolgon at 2012/08/29-16:46:46
              reco:0, name:SUPERUSER, tflag:0
              Entered hgosuec at 2012/08/29-16:46:46
              Exiting hgosuec, rc=0 at 2012/08/29-16:46:46
              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_CHARACTER_SEMANTICS" returned "FALSE"
              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 SUPERUSER as default value for "HS_FDS_DEFAULT_OWNER"
              HOSGIP for "HS_SQL_HANDLE_STMT_REUSE" returned "FALSE"
              Entered hgocont at 2012/08/29-16:46:46
              HS_FDS_CONNECT_INFO = "PRO_WPH"
              RC=-1 from HOSGIP for "HS_FDS_CONNECT_STRING"
              Entered hgogenconstr at 2012/08/29-16:46:46
              dsn:PRO_WPH, name:SUPERUSER
              optn:
              Entered hgocip at 2012/08/29-16:46:46
              dsn:PRO_WPH
              Exiting hgocip, rc=0 at 2012/08/29-16:46:46
              ##>Connect Parameters (len=39)<##
              ## DSN=PRO_WPH;
              #! UID=SUPERUSER;
              #! PWD=*
              Exiting hgogenconstr, rc=0 at 2012/08/29-16:46:46
              Entered hgolosf at 2012/08/29-16:46:46
              ODBC Function-Available-Array 0xFFFE 0x01FF 0xFF00 0xFFFF 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 0x3F5F
              Exiting hgolosf, rc=0 at 2012/08/29-16:46:46
              DriverName:dbodbc12.dll, DriverVer:12.00.0001
              DBMS Name:SQL Anywhere, DBMS Version:11.00.0001
              Exiting hgocont, rc=0 at 2012/08/29-16:46:46
              SQLGetInfo returns N for SQL_CATALOG_NAME
              Exiting hgolgon, rc=0 at 2012/08/29-16:46:46
              hostmstr: 2022428672:      HOA After hoalgon
              RPC Calling nscontrol(0), rc=0
              hostmstr: 2022428672: RPC Before Upload Caps
              hostmstr: 2022428672:      HOA Before hoaulcp
              Entered hgoulcp at 2012/08/29-16:46:46
              Entered hgowlst at 2012/08/29-16:46:46
              Exiting hgowlst, rc=0 at 2012/08/29-16:46:46
              SQLGetInfo returns 0x1f for SQL_OWNER_USAGE
              TXN Capable:2, Isolation Option:0xf
              SQLGetInfo returns 128 for SQL_MAX_SCHEMA_NAME_LEN
              SQLGetInfo returns 128 for SQL_MAX_TABLE_NAME_LEN
              SQLGetInfo returns 128 for SQL_MAX_PROCEDURE_NAME_LEN
              SQLGetInfo returns " (0x22) for SQL_IDENTIFIER_QUOTE_CHAR
              SQLGetInfo returns Y for SQL_COLUMN_ALIAS
              3 instance capabilities will be uploaded
              capno:1989, context:0x00000000, add-info: 0
              capno:1991, context:0x0001ffff, add-info: 0
              capno:1992, context:0x0001ffff, add-info: 0
              Exiting hgoulcp, rc=0 at 2012/08/29-16:46:46
              hostmstr: 2022428672:      HOA After hoaulcp
              hostmstr: 2022428672: RPC After Upload Caps
              hostmstr: 2022428672: RPC Before Upload DDTR
              hostmstr: 2022428672:      HOA Before hoauldt
              Entered hgouldt at 2012/08/29-16:46:46
              NO instance DD translations were uploaded
              Exiting hgouldt, rc=0 at 2012/08/29-16:46:46
              hostmstr: 2022428672:      HOA After hoauldt
              hostmstr: 2022428672: RPC After Upload DDTR
              hostmstr: 2022428672: RPC Before Begin Trans
              hostmstr: 2022428672:      HOA Before hoabegn
              Entered hgobegn at 2012/08/29-16:46:46
              tflag:0 , initial:1
              hoi:0x12f094, ttid (len 26) is ...
              00: 49425549 4C442E38 37336664 3061342E [IBUILD.873fd0a4.]
              10: 312E3331 2E363334 3339 [1.31.63439]
              tbid (len 23) is ...
              00: 49425549 4C445B31 2E33312E 36333433 [IBUILD[1.31.6343]
              10: 395D5B31 2E345D [9][1.4]]
              Exiting hgobegn, rc=0 at 2012/08/29-16:46:46
              hostmstr: 2022428672:      HOA After hoabegn
              hostmstr: 2022428672: RPC After Begin Trans
              hostmstr: 2022428672: RPC Before Describe Table
              hostmstr: 2022428672:      HOA Before hoadtab
              Entered hgodtab at 2012/08/29-16:46:46
              count:1
              table: DBA.VIEW_ASSET_SERVICESTATS
              Allocate hoada[0] @ 02E071E4
              Entered hgopcda at 2012/08/29-16:46:47
              Column:1(Lo_Code): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:0, sign:1, radix:10
              Exiting hgopcda, rc=0 at 2012/08/29-16:46:47
              Entered hgopcda at 2012/08/29-16:46:47
              Column:2(Maintenance_Contract_Ref): dtype:12 (VARCHAR), prc/scl:10/0, nullbl:1, octet:10, sign:1, radix:10
              Exiting hgopcda, rc=0 at 2012/08/29-16:46:47
              Entered hgopcda at 2012/08/29-16:46:47
              Column:3(Maintenance_Contract): dtype:12 (VARCHAR), prc/scl:60/0, nullbl:1, octet:60, sign:1, radix:10
              Exiting hgopcda, rc=0 at 2012/08/29-16:46:47
              Entered hgopcda at 2012/08/29-16:46:47
              Column:4(Last_Service_Date): dtype:91 (DATE), prc/scl:10/0, nullbl:1, octet:60, sign:1, radix:10
              Exiting hgopcda, rc=0 at 2012/08/29-16:46:47
              Entered hgopcda at 2012/08/29-16:46:47
              Column:5(Previous_Service_Date): dtype:91 (DATE), prc/scl:10/0, nullbl:1, octet:60, sign:1, radix:10
              Exiting hgopcda, rc=0 at 2012/08/29-16:46:47
              Entered hgopcda at 2012/08/29-16:46:47
              Column:6(Last_Service_Over_12_Months): dtype:5 (SMALLINT), prc/scl:5/0, nullbl:1, octet:60, sign:1, radix:10
              Exiting hgopcda, rc=0 at 2012/08/29-16:46:47
              Entered hgopcda at 2012/08/29-16:46:47
              Column:7(Last_Service_Over_11_Months): dtype:5 (SMALLINT), prc/scl:5/0, nullbl:1, octet:60, sign:1, radix:10
              Exiting hgopcda, rc=0 at 2012/08/29-16:46:47
              Entered hgopcda at 2012/08/29-16:46:47
              Column:8(Total_Over_11_Months): dtype:5 (SMALLINT), prc/scl:5/0, nullbl:1, octet:60, sign:1, radix:10
              Exiting hgopcda, rc=0 at 2012/08/29-16:46:47
              Entered hgopcda at 2012/08/29-16:46:47
              Column:9(Last_Service_Under_11_Months): dtype:5 (SMALLINT), prc/scl:5/0, nullbl:1, octet:60, sign:1, radix:10
              Exiting hgopcda, rc=0 at 2012/08/29-16:46:47
              Entered hgopcda at 2012/08/29-16:46:47
              Column:10(Last_Service_Under_12_Months): dtype:5 (SMALLINT), prc/scl:5/0, nullbl:1, octet:60, sign:1, radix:10
              Exiting hgopcda, rc=0 at 2012/08/29-16:46:47
              Entered hgopcda at 2012/08/29-16:46:47
              Column:11(Total_Under_12_Months): dtype:5 (SMALLINT), prc/scl:5/0, nullbl:1, octet:60, sign:1, radix:10
              Exiting hgopcda, rc=0 at 2012/08/29-16:46:47
              Entered hgopcda at 2012/08/29-16:46:47
              Column:12(product_group_code): dtype:5 (SMALLINT), prc/scl:5/0, nullbl:1, octet:60, sign:1, radix:10
              Exiting hgopcda, rc=0 at 2012/08/29-16:46:47
              The hoada for table DBA.VIEW_ASSET_SERVICESTATS follows...
              hgodtab, line 904: Printing hoada @ 02E071E4
              MAX:12, ACTUAL:12, BRC:1, WHT=6 (TABLE_DESCRIBE)
              hoadaMOD bit-values found (0x200:TREAT_AS_CHAR)
              DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
              4 INTEGER Y 4 4 0/ 0 0 0 0 Lo_Code
              12 VARCHAR Y 10 10 0/ 0 0 0 200 Maintenance_Contract_Ref
              12 VARCHAR Y 60 60 0/ 0 0 0 200 Maintenance_Contract
              91 DATE Y 16 16 0/ 0 0 0 0 Last_Service_Date
              91 DATE Y 16 16 0/ 0 0 0 0 Previous_Service_Date
              5 SMALLINT Y 2 2 0/ 0 0 0 0 Last_Service_Over_12_Months
              5 SMALLINT Y 2 2 0/ 0 0 0 0 Last_Service_Over_11_Months
              5 SMALLINT Y 2 2 0/ 0 0 0 0 Total_Over_11_Months
              5 SMALLINT Y 2 2 0/ 0 0 0 0 Last_Service_Under_11_Months
              5 SMALLINT Y 2 2 0/ 0 0 0 0 Last_Service_Under_12_Months
              5 SMALLINT Y 2 2 0/ 0 0 0 0 Total_Under_12_Months
              5 SMALLINT Y 2 2 0/ 0 0 0 0 product_group_code
              Exiting hgodtab, rc=0 at 2012/08/29-16:46:47
              hostmstr: 2022428672:      HOA After hoadtab
              hostmstr: 2022428672:      HOA Before hoadafr
              Entered hgodafr, cursor id 0 at 2012/08/29-16:46:47
              Free hoada @ 02E071E4
              Exiting hgodafr, rc=0 at 2012/08/29-16:46:47
              hostmstr: 2022428672:      HOA After hoadafr
              hostmstr: 2022428672: RPC After Describe Table
              hostmstr: 2022428672: RPC Before SQL Bundling
              hostmstr: 2022428672:      HOA Before hoxpars
              Entered hgopars, cursor id 1 at 2012/08/29-16:46:47
              type:0
              SQL text from hgopars, id=1, len=400 ...
              000: 53454C45 43542041 312E224C 6F5F436F [SELECT A1."Lo_Co]
              010: 6465222C 41312E22 4D61696E 74656E61 [de",A1."Maintena]
              020: 6E63655F 436F6E74 72616374 5F526566 [nce_Contract_Ref]
              030: 222C4131 2E224D61 696E7465 6E616E63 [",A1."Maintenanc]
              040: 655F436F 6E747261 6374222C 41312E22 [e_Contract",A1."]
              050: 4C617374 5F536572 76696365 5F446174 [Last_Service_Dat]
              060: 65222C41 312E2250 72657669 6F75735F [e",A1."Previous_]
              070: 53657276 6963655F 44617465 222C4131 [Service_Date",A1]
              080: 2E224C61 73745F53 65727669 63655F4F [."Last_Service_O]
              090: 7665725F 31325F4D 6F6E7468 73222C41 [ver_12_Months",A]
              0A0: 312E224C 6173745F 53657276 6963655F [1."Last_Service_]
              0B0: 4F766572 5F31315F 4D6F6E74 6873222C [Over_11_Months",]
              0C0: 41312E22 546F7461 6C5F4F76 65725F31 [A1."Total_Over_1]
              0D0: 315F4D6F 6E746873 222C4131 2E224C61 [1_Months",A1."La]
              0E0: 73745F53 65727669 63655F55 6E646572 [st_Service_Under]
              0F0: 5F31315F 4D6F6E74 6873222C 41312E22 [_11_Months",A1."]
              100: 4C617374 5F536572 76696365 5F556E64 [Last_Service_Und]
              110: 65725F31 325F4D6F 6E746873 222C4131 [er_12_Months",A1]
              120: 2E22546F 74616C5F 556E6465 725F3132 [."Total_Under_12]
              130: 5F4D6F6E 74687322 2C41312E 2270726F [_Months",A1."pro]
              140: 64756374 5F67726F 75705F63 6F646522 [duct_group_code"]
              150: 2046524F 4D202244 4241222E 22564945 [ FROM "DBA"."VIE]
              160: 575F4153 5345545F 53455256 49434553 [W_ASSET_SERVICES]
              170: 54415453 22204131 20574845 52452041 [TATS" A1 WHERE A]
              180: 312E224C 6F5F436F 6465223D 32393931 [1."Lo_Code"=2991]
              Exiting hgopars, rc=0 at 2012/08/29-16:46:47
              hostmstr: 2022428672:      HOA After hoxpars
              hostmstr: 2022428672:      HOA Before hoxopen
              Entered hgoopen, cursor id 1 at 2012/08/29-16:46:47
              hgoopen, line 87: NO hoada to print
              Deferred open until first fetch.
              Exiting hgoopen, rc=0 at 2012/08/29-16:46:47
              hostmstr: 2022428672:      HOA After hoxopen
              hostmstr: 2022428672:      HOA Before hoxdscr
              Entered hgodscr, cursor id 1 at 2012/08/29-16:46:47
              Allocate hoada @ 02E07198
              Entered hgopcda at 2012/08/29-16:46:47
              Column:1(Lo_Code): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:0, sign:1, radix:0
              Exiting hgopcda, rc=0 at 2012/08/29-16:46:47
              Entered hgopcda at 2012/08/29-16:46:47
              Column:2(Maintenance_Contract_Ref): dtype:12 (VARCHAR), prc/scl:10/0, nullbl:1, octet:10, sign:1, radix:0
              Exiting hgopcda, rc=0 at 2012/08/29-16:46:47
              Entered hgopcda at 2012/08/29-16:46:47
              Column:3(Maintenance_Contract): dtype:12 (VARCHAR), prc/scl:60/0, nullbl:1, octet:60, sign:1, radix:0
              Exiting hgopcda, rc=0 at 2012/08/29-16:46:47
              Entered hgopcda at 2012/08/29-16:46:47
              Column:4(Last_Service_Date): dtype:91 (DATE), prc/scl:10/0, nullbl:1, octet:60, sign:1, radix:0
              Exiting hgopcda, rc=0 at 2012/08/29-16:46:47
              Entered hgopcda at 2012/08/29-16:46:47
              Column:5(Previous_Service_Date): dtype:91 (DATE), prc/scl:10/0, nullbl:1, octet:60, sign:1, radix:0
              Exiting hgopcda, rc=0 at 2012/08/29-16:46:47
              Entered hgopcda at 2012/08/29-16:46:47
              Column:6(Last_Service_Over_12_Months): dtype:5 (SMALLINT), prc/scl:5/0, nullbl:1, octet:60, sign:1, radix:0
              Exiting hgopcda, rc=0 at 2012/08/29-16:46:47
              Entered hgopcda at 2012/08/29-16:46:47
              Column:7(Last_Service_Over_11_Months): dtype:5 (SMALLINT), prc/scl:5/0, nullbl:1, octet:60, sign:1, radix:0
              Exiting hgopcda, rc=0 at 2012/08/29-16:46:47
              Entered hgopcda at 2012/08/29-16:46:47
              Column:8(Total_Over_11_Months): dtype:5 (SMALLINT), prc/scl:5/0, nullbl:1, octet:60, sign:1, radix:0
              Exiting hgopcda, rc=0 at 2012/08/29-16:46:47
              Entered hgopcda at 2012/08/29-16:46:47
              Column:9(Last_Service_Under_11_Months): dtype:5 (SMALLINT), prc/scl:5/0, nullbl:1, octet:60, sign:1, radix:0
              Exiting hgopcda, rc=0 at 2012/08/29-16:46:47
              Entered hgopcda at 2012/08/29-16:46:47
              Column:10(Last_Service_Under_12_Months): dtype:5 (SMALLINT), prc/scl:5/0, nullbl:1, octet:60, sign:1, radix:0
              Exiting hgopcda, rc=0 at 2012/08/29-16:46:47
              Entered hgopcda at 2012/08/29-16:46:47
              Column:11(Total_Under_12_Months): dtype:5 (SMALLINT), prc/scl:5/0, nullbl:1, octet:60, sign:1, radix:0
              Exiting hgopcda, rc=0 at 2012/08/29-16:46:47
              Entered hgopcda at 2012/08/29-16:46:47
              Column:12(product_group_code): dtype:5 (SMALLINT), prc/scl:5/0, nullbl:1, octet:60, sign:1, radix:0
              Exiting hgopcda, rc=0 at 2012/08/29-16:46:47
              hgodscr, line 910: Printing hoada @ 02E07198
              MAX:12, ACTUAL:12, BRC:100, WHT=5 (SELECT_LIST)
              hoadaMOD bit-values found (0x200:TREAT_AS_CHAR)
              DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
              4 INTEGER Y 4 4 0/ 0 0 0 0 Lo_Code
              12 VARCHAR Y 10 10 0/ 0 0 0 200 Maintenance_Contract_Ref
              12 VARCHAR Y 60 60 0/ 0 0 0 200 Maintenance_Contract
              91 DATE Y 16 16 0/ 0 0 0 0 Last_Service_Date
              91 DATE Y 16 16 0/ 0 0 0 0 Previous_Service_Date
              5 SMALLINT Y 2 2 0/ 0 0 0 0 Last_Service_Over_12_Months
              5 SMALLINT Y 2 2 0/ 0 0 0 0 Last_Service_Over_11_Months
              5 SMALLINT Y 2 2 0/ 0 0 0 0 Total_Over_11_Months
              5 SMALLINT Y 2 2 0/ 0 0 0 0 Last_Service_Under_11_Months
              5 SMALLINT Y 2 2 0/ 0 0 0 0 Last_Service_Under_12_Months
              5 SMALLINT Y 2 2 0/ 0 0 0 0 Total_Under_12_Months
              5 SMALLINT Y 2 2 0/ 0 0 0 0 product_group_code
              Exiting hgodscr, rc=0 at 2012/08/29-16:46:47
              hostmstr: 2022428672:      HOA After hoxdscr
              hostmstr: 2022428672: RPC After SQL Bundling
              hostmstr: 2022428672: RPC Before Fetch Row
              hostmstr: 2022428672:      HOA Before hoaftch
              Entered hgoftch, cursor id 1 at 2012/08/29-16:46:47
              hgoftch, line 130: Printing hoada @ 02E07198
              MAX:12, ACTUAL:12, BRC:100, WHT=5 (SELECT_LIST)
              hoadaMOD bit-values found (0x200:TREAT_AS_CHAR)
              DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
              4 INTEGER Y 4 4 0/ 0 0 0 0 Lo_Code
              12 VARCHAR Y 10 10 0/ 0 0 0 200 Maintenance_Contract_Ref
              12 VARCHAR Y 60 60 0/ 0 0 0 200 Maintenance_Contract
              91 DATE Y 16 16 0/ 0 0 0 0 Last_Service_Date
              91 DATE Y 16 16 0/ 0 0 0 0 Previous_Service_Date
              5 SMALLINT Y 2 2 0/ 0 0 0 0 Last_Service_Over_12_Months
              5 SMALLINT Y 2 2 0/ 0 0 0 0 Last_Service_Over_11_Months
              5 SMALLINT Y 2 2 0/ 0 0 0 0 Total_Over_11_Months
              5 SMALLINT Y 2 2 0/ 0 0 0 0 Last_Service_Under_11_Months
              5 SMALLINT Y 2 2 0/ 0 0 0 0 Last_Service_Under_12_Months
              5 SMALLINT Y 2 2 0/ 0 0 0 0 Total_Under_12_Months
              5 SMALLINT Y 2 2 0/ 0 0 0 0 product_group_code
              Performing delayed open.
              SQLBindCol: column 1, cdatatype: -16, bflsz: 4
              SQLBindCol: column 2, cdatatype: 1, bflsz: 11
              SQLBindCol: column 3, cdatatype: 1, bflsz: 61
              SQLBindCol: column 4, cdatatype: 93, bflsz: 16
              SQLBindCol: column 5, cdatatype: 93, bflsz: 16
              SQLBindCol: column 6, cdatatype: -15, bflsz: 2
              SQLBindCol: column 7, cdatatype: -15, bflsz: 2
              SQLBindCol: column 8, cdatatype: -15, bflsz: 2
              SQLBindCol: column 9, cdatatype: -15, bflsz: 2
              SQLBindCol: column 10, cdatatype: -15, bflsz: 2
              SQLBindCol: column 11, cdatatype: -15, bflsz: 2
              SQLBindCol: column 12, cdatatype: -15, bflsz: 2
              SQLFetch: row: 1, column 1, bflsz: 4, bflar: 4
              SQLFetch: row: 1, column 1, bflsz: 4, bflar: 4, (bfl: 4, mbl: 4)
              0: AF0B0000 [....]
              SQLFetch: row: 1, column 2, bflsz: 11, bflar: 6
              SQLFetch: row: 1, column 2, bflsz: 11, bflar: 6, (bfl: 10, mbl: 10)
              0: 4741534E 5448 [GASNTH]
              SQLFetch: row: 1, column 3, bflsz: 61, bflar: 19
              SQLFetch: row: 1, column 3, bflsz: 61, bflar: 19, (bfl: 60, mbl: 60)
              00: 47617320 53657276 6963696E 67204E6F [Gas Servicing No]
              10: 727468 [rth]
              SQLFetch: row: 1, column 4, bflsz: 16, bflar: 16
              SQLFetch: row: 1, column 4, bflsz: 16, bflar: 16, (bfl: 16, mbl: 16)
              00: DC070100 17000000 00000000 00000000 [................]
              SQLFetch: row: 1, column 5, bflsz: 16, bflar: 16
              SQLFetch: row: 1, column 5, bflsz: 16, bflar: 16, (bfl: 16, mbl: 16)
              00: DB070400 04000000 00000000 00000000 [................]
              SQLFetch: row: 1, column 6, bflsz: 2, bflar: 2
              SQLFetch: row: 1, column 6, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
              0: 0000 [..]
              SQLFetch: row: 1, column 7, bflsz: 2, bflar: 2
              SQLFetch: row: 1, column 7, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
              0: 0000 [..]
              SQLFetch: row: 1, column 8, bflsz: 2, bflar: 2
              SQLFetch: row: 1, column 8, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
              0: 0000 [..]
              SQLFetch: row: 1, column 9, bflsz: 2, bflar: 2
              SQLFetch: row: 1, column 9, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
              0: 0100 [..]
              SQLFetch: row: 1, column 10, bflsz: 2, bflar: 2
              SQLFetch: row: 1, column 10, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
              0: 0000 [..]
              SQLFetch: row: 1, column 11, bflsz: 2, bflar: 2
              SQLFetch: row: 1, column 11, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
              0: 0100 [..]
              SQLFetch: row: 1, column 12, bflsz: 2, bflar: 2
              SQLFetch: row: 1, column 12, bflsz: 2, bflar: 2, (bfl: 2, mbl: 2)
              0: 0100 [..]
              1 rows fetched
              Exiting hgoftch, rc=0 at 2012/08/29-16:46:47
              hostmstr: 2022428672:      HOA After hoaftch
              hostmstr: 2022428672:      HOA Before hoaftch
              Entered hgoftch, cursor id 1 at 2012/08/29-16:46:47
              hgoftch, line 130: Printing hoada @ 02E07198
              MAX:12, ACTUAL:12, BRC:1, WHT=5 (SELECT_LIST)
              hoadaMOD bit-values found (0x200:TREAT_AS_CHAR)
              DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
              4 INTEGER Y 4 4 0/ 0 0 0 0 Lo_Code
              12 VARCHAR Y 6 10 0/ 0 0 0 200 Maintenance_Contract_Ref
              12 VARCHAR Y 19 60 0/ 0 0 0 200 Maintenance_Contract
              91 DATE Y 16 16 0/ 0 0 0 0 Last_Service_Date
              91 DATE Y 16 16 0/ 0 0 0 0 Previous_Service_Date
              5 SMALLINT Y 2 2 0/ 0 0 0 0 Last_Service_Over_12_Months
              5 SMALLINT Y 2 2 0/ 0 0 0 0 Last_Service_Over_11_Months
              5 SMALLINT Y 2 2 0/ 0 0 0 0 Total_Over_11_Months
              5 SMALLINT Y 2 2 0/ 0 0 0 0 Last_Service_Under_11_Months
              5 SMALLINT Y 2 2 0/ 0 0 0 0 Last_Service_Under_12_Months
              5 SMALLINT Y 2 2 0/ 0 0 0 0 Total_Under_12_Months
              5 SMALLINT Y 2 2 0/ 0 0 0 0 product_group_code
              0 rows fetched
              Exiting hgoftch, rc=1403 at 2012/08/29-16:46:47
              hostmstr: 2022428672:      HOA After hoaftch
              hostmstr: 2022428672: RPC After Fetch Row

              Thanks
              Paul
              • 19. Re: Problems with dg4odbc after 11gr2 upgrade
                Kgronau-Oracle
                from the trace file the date related columns are described as date:
                91 DATE Y 16 16 0/ 0 0 0 0 Last_Service_Date
                91 DATE Y 16 16 0/ 0 0 0 0 Previous_Service_Date

                According to your table description using dg4odbc database link it is shown as varchar:
                Connected to:
                Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

                SQL> desc dba.View_Asset_ServiceStats@promaster
                Name Null? Type
                -------- Lo_Code NUMBER(10)
                Maintenance_Contract_Ref VARCHAR2(10)
                Maintenance_Contract VARCHAR2(60)
                Last_Service_Date VARCHAR2(16)
                Previous_Service_Date VARCHAR2(16)
                Last_Service_Over_12_Months NUMBER(5)

                One problem could be the gateway release which is 11.2.0.1 and your database HS kernel is 11.2.0.2, especially when the gateway release 11.2.0.1 was used with 11.2.0.1 database release and the database is then upgraded to 11.2.0.2.

                In those cases the gateway capabilities get out of sync. The easiest way to fix it is to recreate the HS catalog. Not sure if it was suggested earlier or if you already tried it:
                * Connect to your Oracle database on the database server as sysdba user
                * run the script $ORACLE_HOME/rdbms/admin/catnohs
                * commit;
                * now recreate the HS catalog using $ORACLE_HOME/rdbms/admin/caths
                *commit;

                the catnohs deletes the gateway catalog and caths recreates it. As soon as you now use the gateway again, the gateway checks that no capabilities are present in the Oracle database and loads its capabilities into the Oracle database again => so there's no real impact on doing it.

                After recreating the HS catalog, please check again the select.
                • 20. Re: Problems with dg4odbc after 11gr2 upgrade
                  957289
                  Dropping the HS catalog and recreating it as you suggested fixed the problem.

                  Perfect, Thanks very much. I have looked for days for this answer and nowhere has suggested that so I can't thank you enough!

                  Cheers
                  Paul
                  • 21. Re: Problems with dg4odbc after 11gr2 upgrade
                    Kgronau-Oracle
                    Glad to hear!

                    Just for reference if somebody else hits the problem.

                    There's a note on My Oracle Support:
                    After Migrating an Oracle Database From 9.2, 10.1 or 10.2 to 11.2 Heterogeneous Gateway Connections using 11.2 Gateway Can Show Strange Data When The DB Link Already Exists Prior Migration (Doc ID 1203633.1)

                    This note describes the problem, the affected versions and suggest to drop and to recreate the gateway class. It also mentions that starting with upgrades to Oracle 11.2.0.3 the issue is fixed as the necessary upgrade scripts now automatically drop the gateway classes.
                    1 2 Previous Next