Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Tue, 16 Jul 2013 @ 17:53:11 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: ERROR [HYT00][ODBC TERADATA DRIVER] Query time out expired
 
From:   Dempsey, Mike

When you execute a query or Import in SQL Assistant the app always sets the Command Timeout to zero.

This tells ODBC to continue waiting rather than stop after some predefined time.

When we fetch meta-data for the Database Tree however we use a function provided by the Microsoft ODBCConnection object. That function has no way to specify a timeout, so if network or locking problems cause the default timeout to be exceeded then the function will abort. (Times may also be much longer if you use the 'X' [restricted] views)

One alternative might be to use the Teradata.Net connection instead of ODBC.

Another option is to use the "Save Database Tree information ..." option together with the "Load only column names for views" sub-option. This will be much faster so it should avoid the problem. (it uses a 2 minute timeout) [The options are on the DB Tree tab] However these options only affect retrieval of Column information - not the Tables and Views.


Mike Dempsey



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 24 Jul 2020