This discussion is archived
9 Replies Latest reply: Jan 8, 2013 10:40 PM by 978005 RSS

tg4msql.exe hung!!!

978005 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    (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 Newbie
    Currently Being Moderated
    (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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points