Archives of the TeradataForum

Message Posted: Fri, 11 Oct 2002 @ 08:09:22 GMT

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

Hi all,

below is a part of the teradata.log file generated when search is fired on the db...it seems a query time out has occurred, i want to know from the forum whether i can deal with this problem without touching the source code and only by manipulating the server/application settings (or anything else for that matter).

BSE:Wed Oct 09 13:42:34 Starting Asynchronous reconciliation thread...
BSE:Wed Oct 09 13:42:34 Intializing objects for instance database...
BSE:Wed Oct 09 13:42:34 Starting configuration Thread...
BSE:Wed Oct 09 13:42:34 Beginning transaction processing loop...
BSE:Wed Oct 09 13:42:34 Configured Protocols = 'DAML'
BSE:Wed Oct 09 13:42:34 Loading protocol modules from C:\WINNT\System32
BSE:Wed Oct 09 13:42:34 Successfully bound to port 44970
BSE:Wed Oct 09 13:42:34 Starting DAML Protocol Server (ver 4.23)

DTL:Wed Oct 09 14:08:23 Search Table= select * from dbc.AccountInfo where UserName='p548ev'
DTL:Wed Oct 09 14:08:24 Search Table= select * from abc.JournalName where UserName='p548ev'
DTL:Wed Oct 09 14:08:27 Search Table= select * from abc.JournalType where UserName='p548ev'
DTL:Wed Oct 09 14:08:40 Search Table= select * from abc.SysPrivs where UserName='p548ev'

DBG:Wed Oct 09 14:09:10 Error:
DBG:Wed Oct 09 14:09:10 Code = 80040e31
DBG:Wed Oct 09 14:09:10 Code meaning = IDispatch error #3121
DBG:Wed Oct 09 14:09:10 Source = Microsoft OLE DB Provider for ODBC Drivers
DBG:Wed Oct 09 14:09:10 Description = [NCR][ODBC Teradata Driver] Query timeout expired
DBG:Wed Oct 09 14:09:11 DoSearchProc failed: [NCR][ODBC Teradata Driver] Query timeout expired

BSE:Wed Oct 09 14:09:11 Done Processing requests
BSE:Wed Oct 09 14:09:11 Shutting down SSL server...
BSE:Wed Oct 09 14:09:11 Cleaning up SSL connection...
BSE:Wed Oct 09 14:09:11 SSL cleanup complete
BSE:Wed Oct 09 14:09:11 Destroying protocol context
BSE:Wed Oct 09 14:09:11 Destroyed protocol context
BSE:Wed Oct 09 14:09:11 Closing SSL protocol service...
BSE:Wed Oct 09 15:09:43 Setting priority Level to 4
BSE:Wed Oct 09 15:09:43 Socket connection lost...

please help

Javed

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