Archives of the TeradataForum

Message Posted: Sat, 08 Mar 2014 @ 19:23:07 GMT

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

Roopalini,

Regarding your login error:

     WRT_8001 Error connecting to database...
     WRT_8001 [Session s_m_STG_O_Rate_Header_ins Username yyc302tdatetnl DB Error -1
     [Teradata][ODBC Teradata Driver] Login timeout expired[Teradata]
     [ODBC Teradata Driver] Not enough information to log on
     Database driver error... Function Name : Connect
     Database driver error...  Function Name : Connect
     Database Error: Failed to connect to data base using user [yyc302tdatetnl]
     and connection string [C302_PRD_TD].]

Please review the ODBC "Login Timeout" setting for your ODBC DSN. By default, the login will time-out after 20 seconds. If there is a network issue or the Teradata server is extremely busy, you may exceed this threshold. You can increase this value up to an acceptable value (say 5 minutes). To see if this is causing the issue, you can examine the DBC.Software_Event_Logv and look for "Logon Timed Out" events (340807400).

     Event number 34-08074-00 (severity 0, category 13), occurred on
     Sat Mar  8 07:54:11 2014 at 002-09 (Vproc 8206, partition 10,
     task 25252) in system xxxxxx in Module gtwgateway, version
     PDE:14.00.04.12,TDBMS:14.00.04.11,PDEGPL:14.00.04.12,TGTW:14.00.04.05,
     TDGSS: 14.00.04.07 Logon Timed Out
     Session: 0 Remote IP Address: xxx.xxx.xxx.xxx Port: 49080 exceeded 20 seconds

Jim

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