9 Replies Latest reply: Jan 9, 2013 12:40 AM by 978005 RSS

    tg4msql.exe hung!!!

    978005
      I am just a freshman to oracle, I found many tg4msql.exe processes hung with any single query of my gateway to sqlserver2005. I don't know how to post my screen shot, and my settings as follow:

      initokfoc.ora:

      HS_FDS_CONNECT_INFO="SERVER=my_server;DATABASE=my_sqlserver"

      HS_FDS_TRACE_LEVEL=OFF

      HS_FDS_RECOVERY_ACCOUNT=RECOVER

      HS_FDS_RECOVERY_PWD=RECOVER

      HS_FDS_SUPPORT_STATISTICS=TRUE

      listener.ora:

      SID_LIST_LISTENER =

      (SID_LIST =

      (SID_DESC =

      (SID_NAME = PLSExtProc)

      (ORACLE_HOME = E:\oracle\product\10.2.0\tg_1)

      (PROGRAM = extproc)

      )

      (SID_DESC =

      (SID_NAME = OKFOC)

      (ORACLE_HOME = E:\oracle\product\10.2.0\tg_1)

      (PROGRAM = tg4msql)

      )

      (SID_DESC =

      (SID_NAME = SCHEDULE)

      (ORACLE_HOME = E:\oracle\product\10.2.0\tg_1)

      (PROGRAM = tg4msql)

      )

      )

      LISTENER =

      (DESCRIPTION_LIST =

      (DESCRIPTION =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

      (ADDRESS = (PROTOCOL = TCP)(HOST = KAIFA01)(PORT = 1521))

      )

      )

      LOGGING_LISTENER = OFF

      tns:

      (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = sqlserver_address)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = OkFoc) ) (HS = OK) )
        • 1. Re: tg4msql.exe hung!!!
          Kgronau-Oracle
          Please be aware that tg4msql has been desupported and replaced by the follow up product Database Gateway for MS SQL Server since March 2008.

          You stated that the gateway hangs with any single query. Just to confirm, are you able to select from the SQL Server and get some data back or does it hang for every statement using the gateway?
          Best would be also to post a gateway trace by changing in the gateway init file HS_FDS_TRACE_LEVEL=5.
          Once set in the gateway init file just open a new SQL*Plus session and run another statement using the gateway. When it hangs again, che ck out the gateway home directory and you'll find a gateway trace file located in tg4msql/trace. Post it to this thread.

          Also please post a telnet output where you connect to the SQL Server host and port using telnet to verify the connect details.
          • 2. Re: tg4msql.exe hung!!!
            978005
            Heterogeneous Agent Release
            10.2.0.1.0


            (0) hoagprd (2): ; hoagprd Entered.
            (0) HOACONN.C (244): ; [Transparent gateway for MSSQL] version: 4.6.1.0.0070
            (0) HOACONN.C (295): ; Class version: 200
            (0) hoagprd (2): ; hoagprd Exited with retcode = 0.
            (0) hoainit (3): ; hoainit Entered.
            (0) (0): ; connect string is: defTdpName=OKFOC;SYNTAX=(ORACLE8_HOA,
            (0) BASED_ON=ORACLE8, IDENTIFIER_QUOTE_CHAR="",
            (0) CASE_SENSITIVE=CASE_SENSITIVE_QUOTE);BINDING=<navobj><binding><datasources><da-
            (0) tasource name='OKFOC' type='MSSQLODBC'
            (0) connect='SERVER=172.16.3.202;DATABASE=foc'><driverProperties/></datasource></d-
            (0) atasources><remoteMachines/><environment><optimizer noFlattener='true'/><misc
            (0) year2000Policy='-1' consumerApi='1' sessionBehavior='4'/><queryProcessor
            (0) parserDepth='2000' tokenSize='1000' noInsertParameterization='true'
            (0) noThreadedReadAhead='true'/><debug gdbTrace='true' bindingTrace='true'
            (0) driverTrace='true' generalTrace='true'/></environment></binding></navobj>
            (0) ORACLE SQL SERVER GATEWAY Log File Started at 2013-01-08T15:10:14
            (0) binding.c (515): ; Binding dump at 08-01-13 15:10:
            (0) binding.c (518): ; Last binding error: None:
            (0) <binding name='NAV'>
                 <remoteMachines name='NAV'></remoteMachines>
                 
                 <datasources name='NAV'>
                      <datasource name='NAV_ADMIN' type='ADM' connect='E:\oracle\product\10.2.0\tg_1\tg4msql\systdp' syntaxName='ADM'>
                           <objectStoreConfig></objectStoreConfig>
                      </datasource>
                      
                      <datasource name='NAV_PROC' type='PROC' connect='E:\oracle\product\10.2.0\tg_1\tg4msql\systdp' syntaxName='PROC'>
                           <objectStoreConfig></objectStoreConfig>
                      </datasource>
                      
                      <datasource name='NAV_SYSTEM' type='SYS' connect='E:\oracle\product\10.2.0\tg_1\tg4msql\systdp' syntaxName='SYS'>
                           <objectStoreConfig></objectStoreConfig>
                      </datasource>
                      
                      <datasource name='OKFOC' type='MSSQLODBC' syntaxName='MSSQLODBC'>
                           
                           <config sqlServerConnect='SERVER=172.16.3.202;DATABASE=foc'/>
                           <objectStoreConfig></objectStoreConfig>
                      </datasource>
                      
                      <datasource name='ORACLE' type='ORACLE8' connect='@main' syntaxName='ORACLE8'>
                           <objectStoreConfig></objectStoreConfig>
                      </datasource>
                      
                      <datasource name='sys' type=
            (0) 'dsm' syntaxName='dsm'>
                           <objectStoreConfig></objectStoreConfig>
                      </datasource>
                      
                      <datasource name='___sys' type='ADD-DISAM' syntaxName='dsm' objectStoreName='sys'>
                           
                           <config newFileLocation='E:\oracle\product\10.2.0\tg_1\tg4msql\systdp'/>
                           <objectStoreConfig></objectStoreConfig>
                      </datasource>
                 </datasources>
                 
                 <environment name='NAV'>
                      <misc tempDir='E:\oracle\product\10.2.0\tg_1\tg4msql\tmp' year2000Policy='-1' consumerApi='1' sessionBehavior='4'></misc>
                      
                      <debug logFile='E:\oracle\product\10.2.0\tg_1\tg4msql\tmp\nav.log' traceDir='E:\oracle\product\10.2.0\tg_1\tg4msql\tmp\' generalTrace='true' gdbTrace='true' driverTrace='true' apiTrace='true' bindingTrace='true'></debug>
                      
                      <queryProcessor noThreadedReadAhead='true' noInsertParameterization='true' parserDepth='2000' tokenSize='1000'></queryProcessor>
                      
                      <optimizer noFlattener='true'></optimizer>
                      
                      <transactions></transactions>
                      
                      <odbc></odbc>
                      
                      <oledb></oledb>
                      
                      <tuning></tuning>
                      
                      <comm sockT
            (0) ypeOfService='default'></comm>
                      
                      <tempFeatures></tempFeatures>
                 </environment>
                 
                 <adapters name='NAV'></adapters>
            </binding>

            (0) hoainit (3): ; hoainit Exited with retcode = 0.
            (0) hoalgon (7): ; hoalgon Entered. name = okfoc.
            (0) binding.c (515): ; Binding dump at 08-01-13 15:10:
            (0) binding.c (518): ; Last binding error: None:
            (0) <binding name='NAV'>
                 <remoteMachines name='NAV'></remoteMachines>
                 
                 <datasources name='NAV'>
                      <datasource name='NAV_ADMIN' type='ADM' connect='E:\oracle\product\10.2.0\tg_1\tg4msql\systdp' syntaxName='ADM'>
                           <objectStoreConfig></objectStoreConfig>
                      </datasource>
                      
                      <datasource name='NAV_PROC' type='PROC' connect='E:\oracle\product\10.2.0\tg_1\tg4msql\systdp' syntaxName='PROC'>
                           <objectStoreConfig></objectStoreConfig>
                      </datasource>
                      
                      <datasource name='NAV_SYSTEM' type='SYS' connect='E:\oracle\product\10.2.0\tg_1\tg4msql\systdp' syntaxName='SYS'>
                           <objectStoreConfig></objectStoreConfig>
                      </datasource>
                      
                      <datasource name='OKFOC' type='MSSQLODBC' syntaxName='MSSQLODBC'>
                           
                           <config sqlServerConnect='SERVER=172.16.3.202;DATABASE=foc'/>
                           <objectStoreConfig></objectStoreConfig>
                      </datasource>
                      
                      <datasource name='ORACLE' type='ORACLE8' connect='@main' syntaxName='ORACLE8'>
                           <objectStoreConfig></objectStoreConfig>
                      </datasource>
                      
                      <datasource name='sys' type=
            (0) 'dsm' syntaxName='dsm'>
                           <objectStoreConfig></objectStoreConfig>
                      </datasource>
                      
                      <datasource name='___sys' type='ADD-DISAM' syntaxName='dsm' objectStoreName='sys'>
                           
                           <config newFileLocation='E:\oracle\product\10.2.0\tg_1\tg4msql\systdp'/>
                           <objectStoreConfig></objectStoreConfig>
                      </datasource>
                 </datasources>
                 
                 <environment name='NAV'>
                      <misc tempDir='E:\oracle\product\10.2.0\tg_1\tg4msql\tmp' year2000Policy='-1' consumerApi='1' sessionBehavior='4'></misc>
                      
                      <debug logFile='E:\oracle\product\10.2.0\tg_1\tg4msql\tmp\nav.log' traceDir='E:\oracle\product\10.2.0\tg_1\tg4msql\tmp\' generalTrace='true' gdbTrace='true' driverTrace='true' apiTrace='true' bindingTrace='true'></debug>
                      
                      <queryProcessor noThreadedReadAhead='true' noInsertParameterization='true' parserDepth='2000' tokenSize='1000'></queryProcessor>
                      
                      <optimizer noFlattener='true'></optimizer>
                      
                      <transactions></transactions>
                      
                      <odbc></odbc>
                      
                      <oledb></oledb>
                      
                      <tuning></tuning>
                      
                      <comm sockT
            (0) ypeOfService='default'></comm>
                      
                      <tempFeatures></tempFeatures>
                 </environment>
                 
                 <adapters name='NAV'></adapters>
            </binding>
            • 3. Re: tg4msql.exe hung!!!
              978005
              (0) XmlProto.c (5554): ; Datasource configuration for 'OKFOC' is:
              (0) <config sqlServerConnect='SERVER=172.16.3.202;DATABASE=foc' server='' dbName='' ansiNull='true' quoteIdentifiers='true' timeout='60' isolationLevel='dynamicIsolation' reportRealAsDouble='false'></config>

              (0) i: 924 0 SQLAllocConnect:- henv=1424718,phd=12E1C4
              (0) i: 938 0 SQLSetConnectOption:- hdbc=14247C0, fop=103 , vprm=0
              (0) i: 945 1 SQLDriverConnect:- hdbc=14247C0, hwnd=0, scsi=12E254, ccsi=-3, s
              cso=12E354, ccsom=1020, pcso=12E1CA, fdc=0,
              (0) i: 955 0 SQLGetInfo:- hdbc=14247C0, fit=18 ,rif=12e1d0, civm=130, piv=12E
              1CC
              (0) i: 960 0 SQLSetConnectOption:- hdbc=14247C0, fop=1217 , vprm=1
              (0) Created new MSSQLODBC connection (21120960)
              (0) i: 723 0 SQLGetInfo:- hdbc=14247C0, fit=28 ,rif=12e770, civm=2, piv=0
              (0) i: 733 0 SQLGetInfo:- hdbc=14247C0, fit=93 ,rif=12e770, civm=2, piv=0
              (0) i: 741 0 SQLGetInfo:- hdbc=14247C0, fit=72 ,rif=12e774, civm=4, piv=0
              (0) r:1347 0 SQLAllocStmt:- hdbc=14247C0,pst=12E624
              (0) r:1356 0 SQLBindCol:- hst=14254F0,icl=1,fct=1,rgv=12E650,cbvm=128,pcv=123
              8592
              (0) r:1357 0 SQLBindCol:- hst=14254F0,icl=2,fct=5,rgv=12E62C,cbvm=0,pcv=12385
              92
              (0) r:1358 0 SQLBindCol:- hst=14254F0,icl=3,fct=4,rgv=12E64C,cbvm=0,pcv=12385
              88
              (0) r:1359 0 SQLBindCol:- hst=14254F0,icl=6,fct=1,rgv=12E6D4,cbvm=128,pcv=123
              8584
              (0) r:1360 0 SQLBindCol:- hst=14254F0,icl=10,fct=5,rgv=12E62A,cbvm=0,pcv=1238
              600
              (0) r:1361 0 SQLBindCol:- hst=14254F0,icl=14,fct=5,rgv=12E632,cbvm=0,pcv=1238
              596
              (0) r:1363 0 SQLFetch:- hst=14254F0
              (0) r:1363 0 SQLFetch:- hst=14254F0
              (0) r:1363 0 SQLFetch:- hst=14254F0
              (0) r:1363 0 SQLFetch:- hst=14254F0
              (0) r:1363 0 SQLFetch:- hst=14254F0
              (0) r:1363 0 SQLFetch:- hst=14254F0
              (0) r:1363 0 SQLFetch:- hst=14254F0
              (0) r:1363 0 SQLFetch:- hst=14254F0
              (0) r:1363 0 SQLFetch:- hst=14254F0
              (0) r:1363 0 SQLFetch:- hst=14254F0
              (0) r:1363 0 SQLFetch:- hst=14254F0
              (0) r:1363 0 SQLFetch:- hst=14254F0
              (0) r:1363 0 SQLFetch:- hst=14254F0
              (0) r:1363 0 SQLFetch:- hst=14254F0
              (0) r:1363 0 SQLFetch:- hst=14254F0
              (0) r:1363 0 SQLFetch:- hst=14254F0
              (0) r:1363 0 SQLFetch:- hst=14254F0
              (0) r:1363 0 SQLFetch:- hst=14254F0
              (0) r:1363 0 SQLFetch:- hst=14254F0
              (0) r:1363 0 SQLFetch:- hst=14254F0
              (0) r:1363 0 SQLFetch:- hst=14254F0
              (0) r:1363 0 SQLFetch:- hst=14254F0
              (0) r:1363 0 SQLFetch:- hst=14254F0
              (0) r:1363 0 SQLFetch:- hst=14254F0
              (0) r:1363 0 SQLFetch:- hst=14254F0
              (0) r:1363 0 SQLFetch:- hst=14254F0
              (0) r:1363 0 SQLFetch:- hst=14254F0
              (0) r:1363 0 SQLFetch:- hst=14254F0
              (0) r:1363 0 SQLFetch:- hst=14254F0
              (0) r:1363 0 SQLFetch:- hst=14254F0
              (0) r:1363 0 SQLFetch:- hst=14254F0
              (0) r:1363 0 SQLFetch:- hst=14254F0
              (0) r:1363 0 SQLFetch:- hst=14254F0
              (0) r:1363100 SQLFetch:- hst=14254F0
              (0) r:1394 0 SQLFreeStmt:- hst=14254F0, fop=1
              (0) hoalgon (7): ; hoalgon Exited with retcode = 0.
              (0) hoaulcp (4): ; hoaulcp Entered.
              (0) hoaulcp (4): ; hoaulcp Exited with retcode = 0.
              (0) hoauldt (5): ; hoauldt Entered.
              (0) hoauldt (5): ; hoauldt Exited with retcode = 0.
              (0) hoabegn (9): ; hoabegn Entered. formatID = 306206, hoagttln = 55, hoagttid =
              (0) ORCL.REGRESS.RDBMS.DEV.US.ORACLE.COM.f04eafd4.29.17.259, hoagtbln = 10,
              (0) hoagtbid = , tflag = 0, initial = 1
              (0) e:1005 0 SQLGetConnectOption:- hdbc=14247C0, fop=102 , pvprm=12EA80
              (0) e:1007 0 SQLSetConnectOption:- hdbc=14247C0, fop=108 , vprm=1
              (0) e:1012 0 SQLSetConnectOption:- hdbc=14247C0, fop=102 , vprm=0
              (0) hoabegn (9): ; hoabegn Exited with retcode = 0.
              (0) hoadtab (26): ; hoadtab Entered. count = 1
              (0) hoadtab (26): ; schema_name = , table_name = T_FLT_VERSION
              (0) mssqlodbc_rec: Select TOP 0 * FROM "T_FLT_VERSION"
              (0) r: 74 0 SQLAllocStmt:- hdbc=14247C0,pst=12E0C4
              (0) r: 113 0 SQLPrepare:- hst=14254F0, css=1237272
              (0) 13 0 Ssss = Select TOP 0 * FROM "T_FLT_VERSION"
              (0) r: 863 0 SQLNumResultCols:- hst=14254F0,pcol=6
              (0) r: 886 0 SQLDescribeCol:- hst=14254F0,icol=1,scn=vid,cnm=64,pcn=12DFE2,ps
              t=12DFF8,pcd=12DFF0,psc=12DFF4,pnul=12DFEC
              (0) r: 903 0 SQLColAttributes:- hst=14254F0,icol=1,fdt=10,rgbd=0,cbdm=0,pcbd=
              0,pfd=12DFE4
              (0) r: 909 0 SQLColAttributes:- hst=14254F0,icol=1,fdt=11,rgbd=0,cbdm=0,pcbd=
              0,pfd=12DFE8
              (0) r: 886 0 SQLDescribeCol:- hst=14254F0,icol=2,scn=fltyear,cnm=64,pcn=12DFE
              2,pst=12DFF8,pcd=12DFF0,psc=12DFF4,pnul=12DFEC
              (0) r: 903 0 SQLColAttributes:- hst=14254F0,icol=2,fdt=10,rgbd=0,cbdm=0,pcbd=
              0,pfd=12DFE4
              (0) r: 909 0 SQLColAttributes:- hst=14254F0,icol=2,fdt=11,rgbd=0,cbdm=0,pcbd=
              0,pfd=12DFE8
              (0) r: 886 0 SQLDescribeCol:- hst=14254F0,icol=3,scn=season,cnm=64,pcn=12DFE2
              ,pst=12DFF8,pcd=12DFF0,psc=12DFF4,pnul=12DFEC
              (0) r: 903 0 SQLColAttributes:- hst=14254F0,icol=3,fdt=10,rgbd=0,cbdm=0,pcbd=
              0,pfd=12DFE4
              (0) r: 909 0 SQLColAttributes:- hst=14254F0,icol=3,fdt=11,rgbd=0,cbdm=0,pcbd=
              0,pfd=12DFE8
              (0) r: 886 0 SQLDescribeCol:- hst=14254F0,icol=4,scn=startdate,cnm=64,pcn=12D
              FE2,pst=12DFF8,pcd=12DFF0,psc=12DFF4,pnul=12DFEC
              (0) r: 903 0 SQLColAttributes:- hst=14254F0,icol=4,fdt=10,rgbd=0,cbdm=0,pcbd=
              0,pfd=12DFE4
              (0) r: 909 0 SQLColAttributes:- hst=14254F0,icol=4,fdt=11,rgbd=0,cbdm=0,pcbd=
              0,pfd=12DFE8
              (0) r: 886 0 SQLDescribeCol:- hst=14254F0,icol=5,scn=enddate,cnm=64,pcn=12DFE
              2,pst=12DFF8,pcd=12DFF0,psc=12DFF4,pnul=12DFEC
              (0) r: 903 0 SQLColAttributes:- hst=14254F0,icol=5,fdt=10,rgbd=0,cbdm=0,pcbd=
              0,pfd=12DFE4
              (0) r: 909 0 SQLColAttributes:- hst=14254F0,icol=5,fdt=11,rgbd=0,cbdm=0,pcbd=
              0,pfd=12DFE8
              (0) r: 886 0 SQLDescribeCol:- hst=14254F0,icol=6,scn=statue,cnm=64,pcn=12DFE2
              ,pst=12DFF8,pcd=12DFF0,psc=12DFF4,pnul=12DFEC
              (0) r: 903 0 SQLColAttributes:- hst=14254F0,icol=6,fdt=10,rgbd=0,cbdm=0,pcbd=
              0,pfd=12DFE4
              (0) r: 909 0 SQLColAttributes:- hst=14254F0,icol=6,fdt=11,rgbd=0,cbdm=0,pcbd=
              0,pfd=12DFE8
              (0) r: 147 0 SQLFreeStmt:- hst=14254F0, fop=1
              (0) r:1215 0 SQLAllocStmt:- hdbc=14247C0,pst=12DDB4
              (0) r:1222 0 SQLStatistics:- hst=14254F0,scn=0,ccn=0,ssn=0,csn=0,stn=12E00C,c
              tn=-3,funq=1,fcc=0
              (0) cs:- hscn=, ssn=, stn=T_FLT_VERSION
              (0) r:1231 0 SQLBindCol:- hst=14254F0,icl=2,fct=1,rgv=12DF04,cbvm=129,pcv=123
              6448
              (0) r:1232 0 SQLBindCol:- hst=14254F0,icl=4,fct=5,rgv=12DDD4,cbvm=0,pcv=12364
              40
              (0) r:1233 0 SQLBindCol:- hst=14254F0,icl=6,fct=1,rgv=12DF88,cbvm=129,pcv=123
              6468
              (0) r:1234 0 SQLBindCol:- hst=14254F0,icl=7,fct=5,rgv=12DDC4,cbvm=0,pcv=12364
              72
              (0) r:1235 0 SQLBindCol:- hst=14254F0,icl=9,fct=1,rgv=12E090,cbvm=129,pcv=123
              6464
              (0) r:1236 0 SQLBindCol:- hst=14254F0,icl=10,fct=1,rgv=12DDCA,cbvm=2,pcv=1236
              456
              (0) r:1237 0 SQLBindCol:- hst=14254F0,icl=11,fct=4,rgv=12DDD0,cbvm=0,pcv=1236
              428
              (0) r:1238 0 SQLBindCol:- hst=14254F0,icl=12,fct=4,rgv=12DDE4,cbvm=0,pcv=1236
              444
              (0) r:1245 0 SQLFetch:- hst=14254F0
              (0) r:1267 0 SQLFetch:- hst=14254F0
              (0) r:1298100 SQLFetch:- hst=14254F0
              (0) r:1311 0 SQLFreeStmt:- hst=14254F0, fop=1
              (0) nvOUT (F:\Work\Connect_4_6_3\src\qp\QP_SQTXT.C 55): select NON_UNIQUE,
              (0) INDEX_NAME, TYPE, SEQ_IN_INDEX, COLLATION, CARDINALITY, COLUMN_NAME from
              (0) NAV_PROC:SP_STATISTICS('OKFOC', '%', 'T_FLT_VERSION', 1, 0, 0) order by 3, 1,
              (0) 2, 4
              (0) <PROC> < OK>: GDB version 400
              (0) <PROC> GDB_DB_FUNCTION INFO:
              (0) Attributes: No GST.
              (0) Bookmark Size = 0
              (0) Datasource Fns: io_get_last_error; io_connect; io_disconnect;
              (0) io_set_connect.
              (0) Metadata Fns: io_get_item_list; io_describe_table; io_describe_sp.
              (0) Data Retrieval Fns: io_open; io_set_buffer; io_set_index; io_set_params;
              (0) io_fetch; io_close; io_rewind.
              (0) Update Fns: <None>.
              (0) Transaction Fns: <None>.
              (0) Data Definition Fns: <None>.
              (0) Blob Fns: <None>.
              (0) SQL Fns: <None>.
              (0) Chapter Fns: <None>.
              (0) Foreign keys Fns: <None>.
              (0) <PROC> : -->>>> CONNECT
              (0) <PROC> < OK>: CONNECT NAV_PROC ''
              (0) nvRETURN (F:\Work\Connect_4_6_3\src\qp\qpsynon.c 1140): -1
              (0) <PROC> : -->>>> DESCRIBE_SP
              (0) <PROC> < OK>: DESCRIBE_SP @SP_STATISTICS
              (0) <<<<<<<<<<<<<<<<<<< Execution Strategy Begin <<<<<<<<<<<<<<<<<<<<<<<<<<<<
              (0) Original SQL:
              (0) select NON_UNIQUE , INDEX_NAME , TYPE , SEQ_IN_INDEX , COLLATION , CARDINALITY , COLUMN_NAME from NAV_PROC : SP_STATISTICS ( 'OKFOC' , '%' , 'T_FLT_VERSION' , 1 , 0 , 0 ) order by 3 , 1 , 2 , 4
              (0)


              (0)
              (0) Accessing saved query spec SP_STATISTICS()
              (0) from NAV_PROC DB
              (0)
              Execution Strategy End >>>>>>>>>>>>>>>>>>>>>>>>>>>>
              (0) <PROC> : -->>>> OPEN
              (0) <PROC> < OK>: OPEN SP_STATISTICS(0)
              (0) <PROC> : -->>>> SET_BUFFER
              (0) <PROC> < OK>: SET_BUFFER SP_STATISTICS(0)
              (0) <PROC> : -->>>> SET_PARAMS
              (0) <PROC> < OK>: SET_PARAMS SP_STATISTICS(0)
              (0) <PROC> : -->>>> FETCH
              (0) <PROC> < OK>: FETCH SP_STATISTICS(0)
              (0) <PROC> : -->>>> FETCH
              (0) <PROC> < OK>: FETCH SP_STATISTICS(0)
              (0) <PROC> : -->>>> FETCH
              (0) <PROC> < EOS>: FETCH SP_STATISTICS(0)
              (0) <PROC> : -->>>> CLOSE
              (0) <PROC> < OK>: CLOSE SP_STATISTICS(0)
              (0) HOAUTIL.C (1259): ; ------ hoadtab (hoat) -------:
              (0) HOAUTIL.C (1262): ; hoatnam: T_FLT_VERSION, hoatnml: 13, hoatnrw: 4, hoatarl:
              (0) 47
              (0) HOAUTIL.C (1273): ; ------ hoadtab (hoai) -------:
              (0) HOAUTIL.C (1274): ; n_index_stat: 1
              (0) HOAUTIL.C (1276): ; index 0 - hoaiuni: 1, hoainci: 1, hoaiasc: 0
              (0) HOAUTIL.C (1279): ; index col 0 - hoaicid: 1
              (0) HOAUTIL.C (1224): ; -------- hoadtab for table T_FLT_VERSION---------:
              (0) HOAUTIL.C (1225): ; hoadamsz: 6, hoadasiz: 6, hoadambr: 1, hoadabrc: 0
              (0) HOAUTIL.C (1228): ; row 0 - hoadambl: 4, hoadadty: 8, hoadaprc: 10, hoadacst: 0
              (0) HOAUTIL.C (1232): ; row 0 - hoadascl: 0, hoadanul: 0, hoadanml: 3, hoadanam:
              (0) vid, hoadabfl: 4, hoadamod: 0
              (0) HOAUTIL.C (1228): ; row 1 - hoadambl: 10, hoadadty: 108, hoadaprc: 10,
              (0) hoadacst: 0
              (0) HOAUTIL.C (1232): ; row 1 - hoadascl: 0, hoadanul: 1, hoadanml: 7, hoadanam:
              (0) fltyear, hoadabfl: 10, hoadamod: 0
              (0) HOAUTIL.C (1228): ; row 2 - hoadambl: 10, hoadadty: 108, hoadaprc: 10,
              (0) hoadacst: 0
              (0) HOAUTIL.C (1232): ; row 2 - hoadascl: 0, hoadanul: 1, hoadanml: 6, hoadanam:
              (0) season, hoadabfl: 10, hoadamod: 0
              (0) HOAUTIL.C (1228): ; row 3 - hoadambl: 7, hoadadty: 167, hoadaprc: 0, hoadacst:
              (0) 0
              (0) HOAUTIL.C (1232): ; row 3 - hoadascl: 0, hoadanul: 1, hoadanml: 9, hoadanam:
              (0) startdate, hoadabfl: 7, hoadamod: 0
              (0) HOAUTIL.C (1228): ; row 4 - hoadambl: 7, hoadadty: 167, hoadaprc: 0, hoadacst:
              (0) 0
              (0) HOAUTIL.C (1232): ; row 4 - hoadascl: 0, hoadanul: 1, hoadanml: 7, hoadanam:
              (0) enddate, hoadabfl: 7, hoadamod: 0
              (0) HOAUTIL.C (1228): ; row 5 - hoadambl: 1, hoadadty: 108, hoadaprc: 1, hoadacst:
              (0) 0
              (0) HOAUTIL.C (1232): ; row 5 - hoadascl: 0, hoadanul: 1, hoadanml: 6, hoadanam:
              (0) statue, hoadabfl: 1, hoadamod: 0
              (0) hoadtab (26): ; hoadtab Exited with retcode = 0.
              (0) hoadafr (23): ; hoadafr Entered. id = 0.
              (0) hoadafr (23): ; hoadafr Exited with retcode = 0.
              (0) hoapars (15): ; hoapars Entered. stmtType = 0, id = 1.
              (0) nvOUT (F:\Work\Connect_4_6_3\src\qp\QP_SQTXT.C 55): SELECT
              (0) A1."vid",A1."fltyear",A1."season",A1."startdate",A1."enddate",A1."statue" FROM
              (0) "T_FLT_VERSION" A1
              (0) nvRETURN (F:\Work\Connect_4_6_3\src\qp\qpsynon.c 1140): -1
              (0) SELECT "A1"."vid" AS c000, "A1"."fltyear" AS c001, "A1"."season" AS c002, "A1"."startdate" AS c003, "A1"."enddate" AS c004, "A1"."statue" AS c005 FROM "T_FLT_VERSION" "A1"
              (0)

              (0) r: 74 0 SQLAllocStmt:- hdbc=14247C0,pst=12E7C0
              (0) r: 113 0 SQLPrepare:- hst=14254F0, css=31234964
              (0) Ssss = SELECT "A1"."vid" AS c000, "A1"."fltyear" AS c001, "A1"
              ."season" AS c002, "A1"."startdate" AS c003, "A1"."enddate" AS
              c004, "A1"."statue" AS c005 FROM "T_FLT_VERSION" "A1"
              (0) r: 863 0 SQLNumResultCols:- hst=14254F0,pcol=6
              (0) r: 886 0 SQLDescribeCol:- hst=14254F0,icol=1,scn=c000,cnm=64,pcn=12E6DE,p
              st=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
              (0) r: 903 0 SQLColAttributes:- hst=14254F0,icol=1,fdt=10,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E0
              (0) r: 909 0 SQLColAttributes:- hst=14254F0,icol=1,fdt=11,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E4
              (0) r: 886 0 SQLDescribeCol:- hst=14254F0,icol=2,scn=c001,cnm=64,pcn=12E6DE,p
              st=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
              (0) r: 903 0 SQLColAttributes:- hst=14254F0,icol=2,fdt=10,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E0
              (0) r: 909 0 SQLColAttributes:- hst=14254F0,icol=2,fdt=11,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E4
              (0) r: 886 0 SQLDescribeCol:- hst=14254F0,icol=3,scn=c002,cnm=64,pcn=12E6DE,p
              st=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
              (0) r: 903 0 SQLColAttributes:- hst=14254F0,icol=3,fdt=10,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E0
              (0) r: 909 0 SQLColAttributes:- hst=14254F0,icol=3,fdt=11,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E4
              (0) r: 886 0 SQLDescribeCol:- hst=14254F0,icol=4,scn=c003,cnm=64,pcn=12E6DE,p
              st=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
              (0) r: 903 0 SQLColAttributes:- hst=14254F0,icol=4,fdt=10,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E0
              (0) r: 909 0 SQLColAttributes:- hst=14254F0,icol=4,fdt=11,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E4
              (0) r: 886 0 SQLDescribeCol:- hst=14254F0,icol=5,scn=c004,cnm=64,pcn=12E6DE,p
              st=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
              (0) r: 903 0 SQLColAttributes:- hst=14254F0,icol=5,fdt=10,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E0
              (0) r: 909 0 SQLColAttributes:- hst=14254F0,icol=5,fdt=11,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E4
              (0) r: 886 0 SQLDescribeCol:- hst=14254F0,icol=6,scn=c005,cnm=64,pcn=12E6DE,p
              st=12E6F4,pcd=12E6EC,psc=12E6F0,pnul=12E6E8
              (0) r: 903 0 SQLColAttributes:- hst=14254F0,icol=6,fdt=10,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E0
              (0) r: 909 0 SQLColAttributes:- hst=14254F0,icol=6,fdt=11,rgbd=0,cbdm=0,pcbd=
              0,pfd=12E6E4
              (0) r: 147 0 SQLFreeStmt:- hst=14254F0, fop=1
              (0) <<<<<<<<<<<<<<<<<<< Execution Strategy Begin <<<<<<<<<<<<<<<<<<<<<<<<<<<<
              (0) Original SQL:
              (0) SELECT A1 . "vid" , A1 . "fltyear" , A1 . "season" , A1 . "startdate" , A1 . "enddate" , A1 . "statue" FROM "T_FLT_VERSION" A1
              (0)


              (0)
              (0) Accessing Database 'OKFOC' with SQL:
              (0) SELECT "A1"."vid" AS c000, "A1"."fltyear" AS c001, "A1"."season" AS c002, "A1"."startdate" AS c003, "A1"."enddate" AS c004, "A1"."statue" AS c005 FROM "T_FLT_VERSION" "A1"
              (0)

              (0)
              Execution Strategy End >>>>>>>>>>>>>>>>>>>>>>>>>>>>
              (0) hoapars (15): ; hoapars Exited with retcode = 0.
              (0) hoaopen (19): ; hoaopen Entered. id = 1.
              (0) hoaopen (19): ; hoaopen Exited with retcode = 0.
              (0) hoadscr (16): ; hoadscr Entered. id = 1.
              (0) hoastmt.c (304): ; Array fetch size is: 1.
              (0) HOAUTIL.C (1224): ; ------ hoadscr() -------:
              (0) HOAUTIL.C (1225): ; hoadamsz: 6, hoadasiz: 6, hoadambr: 1, hoadabrc: 1
              (0) HOAUTIL.C (1228): ; row 0 - hoadambl: 4, hoadadty: 8, hoadaprc: 10, hoadacst: 0
              (0) HOAUTIL.C (1232): ; row 0 - hoadascl: 0, hoadanul: 0, hoadanml: 6, hoadanam:
              (0) A1.vid, hoadabfl: 4, hoadamod: 0
              (0) HOAUTIL.C (1228): ; row 1 - hoadambl: 10, hoadadty: 108, hoadaprc: 10,
              (0) hoadacst: 0
              (0) HOAUTIL.C (1232): ; row 1 - hoadascl: 0, hoadanul: 1, hoadanml: 10, hoadanam:
              (0) A1.fltyear, hoadabfl: 10, hoadamod: 0
              (0) HOAUTIL.C (1228): ; row 2 - hoadambl: 10, hoadadty: 108, hoadaprc: 10,
              (0) hoadacst: 0
              (0) HOAUTIL.C (1232): ; row 2 - hoadascl: 0, hoadanul: 1, hoadanml: 9, hoadanam:
              (0) A1.season, hoadabfl: 10, hoadamod: 0
              (0) HOAUTIL.C (1228): ; row 3 - hoadambl: 7, hoadadty: 167, hoadaprc: 0, hoadacst:
              (0) 0
              (0) HOAUTIL.C (1232): ; row 3 - hoadascl: 0, hoadanul: 1, hoadanml: 12, hoadanam:
              (0) A1.startdate, hoadabfl: 7, hoadamod: 0
              (0) HOAUTIL.C (1228): ; row 4 - hoadambl: 7, hoadadty: 167, hoadaprc: 0, hoadacst:
              (0) 0
              (0) HOAUTIL.C (1232): ; row 4 - hoadascl: 0, hoadanul: 1, hoadanml: 10, hoadanam:
              (0) A1.enddate, hoadabfl: 7, hoadamod: 0
              (0) HOAUTIL.C (1228): ; row 5 - hoadambl: 1, hoadadty: 108, hoadaprc: 1, hoadacst:
              (0) 0
              (0) HOAUTIL.C (1232): ; row 5 - hoadascl: 0, hoadanul: 1, hoadanml: 9, hoadanam:
              (0) A1.statue, hoadabfl: 1, hoadamod: 0
              (0) hoadscr (16): ; hoadscr Exited with retcode = 0.
              (0) hoaftch (21): ; hoaftch Entered. id = 1.
              (0) apiutil.c (0): ; hoaftch()::
              (0) apiutil.c (0): ; Column 0 - pszName: A1.vid, size: 4, id: 8, width: 0, scale:
              (0) 0, flags: 0.
              (0) apiutil.c (0): ; Column 1 - pszName: A1.fltyear, size: 11, id: 108, width: 10,
              (0) scale: 0, flags: 4.
              (0) apiutil.c (0): ; Column 2 - pszName: A1.season, size: 11, id: 108, width: 10,
              (0) scale: 0, flags: 4.
              (0) apiutil.c (0): ; Column 3 - pszName: A1.startdate, size: 16, id: 125, width:
              (0) 0, scale: -3, flags: 4.
              (0) apiutil.c (0): ; Column 4 - pszName: A1.enddate, size: 16, id: 125, width: 0,
              (0) scale: -3, flags: 4.
              (0) apiutil.c (0): ; Column 5 - pszName: A1.statue, size: 2, id: 108, width: 1,
              (0) scale: 0, flags: 4.
              (0) SELECT "A1"."vid" AS c000, "A1"."fltyear" AS c001, "A1"."season" AS c002, "A1"."startdate" AS c003, "A1"."enddate" AS c004, "A1"."statue" AS c005 FROM "T_FLT_VERSION" "A1"
              (0)
              • 4. Re: tg4msql.exe hung!!!
                978005
                (0) r: 74 0 SQLAllocStmt:- hdbc=14247C0,pst=12EB98
                (0) r: 113 0 SQLPrepare:- hst=14254F0, css=14777052
                (0) Ssss = SELECT "A1"."vid" AS c000, "A1"."fltyear" AS c001, "A1"
                ."season" AS c002, "A1"."startdate" AS c003, "A1"."enddate" AS
                c004, "A1"."statue" AS c005 FROM "T_FLT_VERSION" "A1"
                (0) r: 863 0 SQLNumResultCols:- hst=14254F0,pcol=6
                (0) r: 886 0 SQLDescribeCol:- hst=14254F0,icol=1,scn=c000,cnm=64,pcn=12EAB6,p
                st=12EACC,pcd=12EAC4,psc=12EAC8,pnul=12EAC0
                (0) r: 903 0 SQLColAttributes:- hst=14254F0,icol=1,fdt=10,rgbd=0,cbdm=0,pcbd=
                0,pfd=12EAB8
                (0) r: 909 0 SQLColAttributes:- hst=14254F0,icol=1,fdt=11,rgbd=0,cbdm=0,pcbd=
                0,pfd=12EABC
                (0) r: 886 0 SQLDescribeCol:- hst=14254F0,icol=2,scn=c001,cnm=64,pcn=12EAB6,p
                st=12EACC,pcd=12EAC4,psc=12EAC8,pnul=12EAC0
                (0) r: 903 0 SQLColAttributes:- hst=14254F0,icol=2,fdt=10,rgbd=0,cbdm=0,pcbd=
                0,pfd=12EAB8
                (0) r: 909 0 SQLColAttributes:- hst=14254F0,icol=2,fdt=11,rgbd=0,cbdm=0,pcbd=
                0,pfd=12EABC
                (0) r: 886 0 SQLDescribeCol:- hst=14254F0,icol=3,scn=c002,cnm=64,pcn=12EAB6,p
                st=12EACC,pcd=12EAC4,psc=12EAC8,pnul=12EAC0
                (0) r: 903 0 SQLColAttributes:- hst=14254F0,icol=3,fdt=10,rgbd=0,cbdm=0,pcbd=
                0,pfd=12EAB8
                (0) r: 909 0 SQLColAttributes:- hst=14254F0,icol=3,fdt=11,rgbd=0,cbdm=0,pcbd=
                0,pfd=12EABC
                (0) r: 886 0 SQLDescribeCol:- hst=14254F0,icol=4,scn=c003,cnm=64,pcn=12EAB6,p
                st=12EACC,pcd=12EAC4,psc=12EAC8,pnul=12EAC0
                (0) r: 903 0 SQLColAttributes:- hst=14254F0,icol=4,fdt=10,rgbd=0,cbdm=0,pcbd=
                0,pfd=12EAB8
                (0) r: 909 0 SQLColAttributes:- hst=14254F0,icol=4,fdt=11,rgbd=0,cbdm=0,pcbd=
                0,pfd=12EABC
                (0) r: 886 0 SQLDescribeCol:- hst=14254F0,icol=5,scn=c004,cnm=64,pcn=12EAB6,p
                st=12EACC,pcd=12EAC4,psc=12EAC8,pnul=12EAC0
                (0) r: 903 0 SQLColAttributes:- hst=14254F0,icol=5,fdt=10,rgbd=0,cbdm=0,pcbd=
                0,pfd=12EAB8
                (0) r: 909 0 SQLColAttributes:- hst=14254F0,icol=5,fdt=11,rgbd=0,cbdm=0,pcbd=
                0,pfd=12EABC
                (0) r: 886 0 SQLDescribeCol:- hst=14254F0,icol=6,scn=c005,cnm=64,pcn=12EAB6,p
                st=12EACC,pcd=12EAC4,psc=12EAC8,pnul=12EAC0
                (0) r: 903 0 SQLColAttributes:- hst=14254F0,icol=6,fdt=10,rgbd=0,cbdm=0,pcbd=
                0,pfd=12EAB8
                (0) r: 909 0 SQLColAttributes:- hst=14254F0,icol=6,fdt=11,rgbd=0,cbdm=0,pcbd=
                0,pfd=12EABC
                (0) r: 147 0 SQLFreeStmt:- hst=14254F0, fop=1
                (0) e: 744 0 SQLAllocStmt:- hdbc=14247C0,pst=E3F5A8
                (0) e: 760 0 SQLPrepare:- hst=14254F0, css=14960832
                (0) Ssss = SELECT "A1"."vid" AS c000, "A1"."fltyear" AS c001, "A1"
                ."season" AS c002, "A1"."startdate" AS c003, "A1"."enddate" AS
                c004, "A1"."statue" AS c005 FROM "T_FLT_VERSION" "A1"
                (0) e: 765 0 SQLNumResultCols:- hst=14254F0,pcol=6
                (0) e: 782 0 SQLDescribeCol:- hst=14254F0,icol=1,scn=c000,cnm=128,pcn=E44B2A,
                pst=E44B2C,pcd=E44B30,psc=E44B34,pnul=E44B36
                (0) e: 782 0 SQLDescribeCol:- hst=14254F0,icol=2,scn=c001,cnm=128,pcn=E44BDA,
                pst=E44BDC,pcd=E44BE0,psc=E44BE4,pnul=E44BE6
                (0) e: 782 0 SQLDescribeCol:- hst=14254F0,icol=3,scn=c002,cnm=128,pcn=E44C8A,
                pst=E44C8C,pcd=E44C90,psc=E44C94,pnul=E44C96
                (0) e: 782 0 SQLDescribeCol:- hst=14254F0,icol=4,scn=c003,cnm=128,pcn=E44D3A,
                pst=E44D3C,pcd=E44D40,psc=E44D44,pnul=E44D46
                (0) e: 782 0 SQLDescribeCol:- hst=14254F0,icol=5,scn=c004,cnm=128,pcn=E44DEA,
                pst=E44DEC,pcd=E44DF0,psc=E44DF4,pnul=E44DF6
                (0) e: 782 0 SQLDescribeCol:- hst=14254F0,icol=6,scn=c005,cnm=128,pcn=E44EDA,
                pst=E44EDC,pcd=E44EE0,psc=E44EE4,pnul=E44EE6
                (0) e: 502 0 SQLBindCol:- hst=14254F0,icl=1,fct=99,rgv=E44FC4,cbvm=4,pcv=1496
                3028
                (0) e: 502 0 SQLBindCol:- hst=14254F0,icl=2,fct=99,rgv=E452E4,cbvm=11,pcv=149
                64948
                (0) e: 502 0 SQLBindCol:- hst=14254F0,icl=3,fct=99,rgv=E45A64,cbvm=11,pcv=149
                66452
                (0) e: 502 0 SQLBindCol:- hst=14254F0,icl=4,fct=99,rgv=E46044,cbvm=16,pcv=149
                68452
                (0) e: 502 0 SQLBindCol:- hst=14254F0,icl=5,fct=99,rgv=E468FC,cbvm=16,pcv=149
                70684
                (0) e: 502 0 SQLBindCol:- hst=14254F0,icl=6,fct=99,rgv=E470CC,cbvm=2,pcv=1497
                1284
                (0) e: 359 0 SQLSetStmtOption:- hst=14254F0, fop=0 , vprm=0
                (0) e: 365 0 SQLExecute:- hst=14254F0
                (0) e: 396 0 SQLSetStmtOption:- hst=14254F0, fop=9 , vprm=100
                (0) e: 400 0 SQLExtendedFetch:- hstm=14254F0, fft=1, irow=0, pcrw=E3F5D8, rgr
                s=E44EFC
                (0) hoaftch (21): ; hoaftch Exited with retcode = 0, hoadabrc = 1.
                (0) hoaftch (21): ; hoaftch Entered. id = 1.
                (0) hoaftch (21): ; hoaftch Exited with retcode = 0, hoadabrc = 1.
                (0) hoaftch (21): ; hoaftch Entered. id = 1.
                (0) hoaftch (21): ; hoaftch Exited with retcode = 0, hoadabrc = 1.
                (0) hoaftch (21): ; hoaftch Entered. id = 1.
                (0) hoaftch (21): ; hoaftch Exited with retcode = 0, hoadabrc = 1.
                (0) hoaftch (21): ; hoaftch Entered. id = 1.
                (0) e: 396 0 SQLSetStmtOption:- hst=14254F0, fop=9 , vprm=100
                (0) e: 400100 SQLExtendedFetch:- hstm=14254F0, fft=1, irow=0, pcrw=E3F5D8, rg
                rs=E44EFC
                (0) hoaftch (21): ; hoaftch Exited with retcode = 1403, hoadabrc = 0.
                (0) hoapars (15): ; hoapars Entered. stmtType = 0, id = 2.
                (0) nvOUT (F:\Work\Connect_4_6_3\src\qp\QP_SQTXT.C 55): SELECT
                (0) A1."vid",A1."fltyear",A1."season",A1."startdate",A1."enddate",A1."statue" FROM
                (0) "T_FLT_VERSION" A1
                (0) nvOUT (F:\Work\Connect_4_6_3\src\qp\qpsqlcsh.c 140):
                (0) ---------------------------> Using Cached QSpec
                (0) hoapars (15): ; hoapars Exited with retcode = 0.
                (0) hoaopen (19): ; hoaopen Entered. id = 2.
                (0) hoaopen (19): ; hoaopen Exited with retcode = 0.
                (0) hoadscr (16): ; hoadscr Entered. id = 2.
                (0) hoastmt.c (304): ; Array fetch size is: 1.
                (0) HOAUTIL.C (1224): ; ------ hoadscr() -------:
                (0) HOAUTIL.C (1225): ; hoadamsz: 6, hoadasiz: 6, hoadambr: 1, hoadabrc: 1
                (0) HOAUTIL.C (1228): ; row 0 - hoadambl: 4, hoadadty: 8, hoadaprc: 10, hoadacst: 0
                (0) HOAUTIL.C (1232): ; row 0 - hoadascl: 0, hoadanul: 0, hoadanml: 6, hoadanam:
                (0) A1.vid, hoadabfl: 4, hoadamod: 0
                (0) HOAUTIL.C (1228): ; row 1 - hoadambl: 10, hoadadty: 108, hoadaprc: 10,
                (0) hoadacst: 0
                (0) HOAUTIL.C (1232): ; row 1 - hoadascl: 0, hoadanul: 1, hoadanml: 10, hoadanam:
                (0) A1.fltyear, hoadabfl: 10, hoadamod: 0
                (0) HOAUTIL.C (1228): ; row 2 - hoadambl: 10, hoadadty: 108, hoadaprc: 10,
                (0) hoadacst: 0
                (0) HOAUTIL.C (1232): ; row 2 - hoadascl: 0, hoadanul: 1, hoadanml: 9, hoadanam:
                (0) A1.season, hoadabfl: 10, hoadamod: 0
                (0) HOAUTIL.C (1228): ; row 3 - hoadambl: 7, hoadadty: 167, hoadaprc: 0, hoadacst:
                (0) 0
                (0) HOAUTIL.C (1232): ; row 3 - hoadascl: 0, hoadanul: 1, hoadanml: 12, hoadanam:
                (0) A1.startdate, hoadabfl: 7, hoadamod: 0
                (0) HOAUTIL.C (1228): ; row 4 - hoadambl: 7, hoadadty: 167, hoadaprc: 0, hoadacst:
                (0) 0
                (0) HOAUTIL.C (1232): ; row 4 - hoadascl: 0, hoadanul: 1, hoadanml: 10, hoadanam:
                (0) A1.enddate, hoadabfl: 7, hoadamod: 0
                (0) HOAUTIL.C (1228): ; row 5 - hoadambl: 1, hoadadty: 108, hoadaprc: 1, hoadacst:
                (0) 0
                (0) HOAUTIL.C (1232): ; row 5 - hoadascl: 0, hoadanul: 1, hoadanml: 9, hoadanam:
                (0) A1.statue, hoadabfl: 1, hoadamod: 0
                (0) hoadscr (16): ; hoadscr Exited with retcode = 0.
                (0) hoaclse (22): ; hoaclse Entered. id = 2.
                (0) hoaclse (22): ; hoaclse Exited with retcode = 0.
                (0) hoadafr (23): ; hoadafr Entered. id = 2.
                (0) hoadafr (23): ; hoadafr Exited with retcode = 0.
                (0) hoaclse (22): ; hoaclse Entered. id = 1.
                (0) e: 442 0 SQLFreeStmt:- hst=14254F0, fop=1
                (0) hoaclse (22): ; hoaclse Exited with retcode = 0.
                (0) hoadafr (23): ; hoadafr Entered. id = 1.
                (0) hoadafr (23): ; hoadafr Exited with retcode = 0.
                (0) hoaroll (12): ; hoaroll Entered. tflag = 1.
                (0) e:1353 0 SQLTransact:- henv=0,hdbc=14247C0, ftp=1
                (0) e:1359 0 SQLSetConnectOption:- hdbc=14247C0, fop=102 , vprm=1
                (0) hoaroll (12): ; hoaroll Exited with retcode = 0.
                (0) hoalgof (8): ; hoalgof Entered. tflag = 1.
                (0) nvRETURN (F:\Work\Connect_4_6_3\src\drv\DRVIUNWN.C 779): -1210
                (0) i: 676 0 SQLDisconnect:- hdbc=14247C0
                (0) i: 683 0 SQLFreeConnect:- hdbc=14247C0
                (0) (Last message occurred 2 times)
                (0) hoalgof (8): ; hoalgof Exited with retcode = 0.
                (0) hoaexit (6): ; hoaexit Entered.
                (0) hoaexit (6): ; hoaexit Exited with retcode = 0.
                (0) (0): ; Closing log file at TUE JAN 08 15:10:36 2013.

                Regards
                • 5. Re: tg4msql.exe hung!!!
                  Kgronau-Oracle
                  Just from the trace it does not indicate that the gateway session hangs. The trace shows a fetch of the data and a normal disconnect:
                  (0) hoalgof (8): ; hoalgof Exited with retcode = 0.
                  (0) hoaexit (6): ; hoaexit Entered.
                  (0) hoaexit (6): ; hoaexit Exited with retcode = 0.
                  (0) (0): ; Closing log file at TUE JAN 08 15:10:36 2013.

                  Do you have more details what is causing the hanging session? Are you executing a certain piece of code in a PL/SQL routine?
                  • 6. Re: tg4msql.exe hung!!!
                    978005
                    Hi



                    The Task Manager just shows that there are more than one tg4msql.exe processes exist, and it can be more than 20. I don't know whether it is just because the process was hung or a executing query that keeps it. This may keep the CPU run in 100%, the solution I can find is just kill the process by hand or restart my application. My superior just order me to get over it by giving no advice, I am just a rookie, and I am just losing my confidence now. Hope you or somebody else can give me some advice.



                    Regards

                    Edited by: BK_Ferdinand on 2013-1-8 下午5:56
                    • 7. Re: tg4msql.exe hung!!!
                      978005
                      My question is similar to this: All queries using database link to Sql Server hang!
                      But it didn't work following the solution
                      • 8. Re: tg4msql.exe hung!!!
                        Kgronau-Oracle
                        From the description and the trace file I might think about an issue using the gateway. In general when you open the database link by using the gateway you need also make sure to close the database link.
                        Closing a database link is done automatically when closing the session that uses the gateway, for example when you close SQL*Plus. BUT there's an issue when you use PL/SQL and the Oracle job system as the job system is always active the database link won't be closed at all and depending on the executions of the job a couple of tg4msql processes will remain in the memory. So you need to make sure that you close the database link when you don't need it anymore.

                        Example:
                        - Count the amount of tg4msql processes.
                        - select from the SQL Server using the gateway
                        - you see an additional gateway process.
                        - you can now get rid of it when you close SQL*Plus or when you execute for example a "commit"/"rollback" and "alter session close database link <db link name>";

                        => So please verify that you're closing your database links.
                        • 9. Re: tg4msql.exe hung!!!
                          978005
                          It works with "alter session close database link <db link name>" following a query, I am now trying it in the Java code, hope it can work.
                          Thank you for your patient!