Problem with Reconnect using .NET and ODBC drivers

Connectivity

Problem with Reconnect using .NET and ODBC drivers

Hi All,

I am facing an issue with reconnect in .NET and ODBC connectors from SQLA when i do a DBS restart. I am seeing this in TD Expres 15.0 SLES 10 40GB  VM.

Teradata .NET Data Provider :

Issue here is that after a successful DBS restart, SQLA is not maintaining the current session context.

'sel session' query returns different session number and it keeps on incrementing with each retry of the query from there on.

To confirm this, I tried to reproduce this issue with GTT which should sustain a typical DBS restart.

Steps I used to reproduce this issue:

1) Created a GTT and inserted a row in it.

create GLOBAL TEMPORARY TABLE gtt_restart(i int,j char(10)) 
unique primary index(i) on commit preserve rows;

ins gtt_restart(1,'a');

2) Issued a select query 'sel * from gtt_restart' and was able to succesfully fetch the data. 'Sel Session' query and sessioninfo view display the sesion number as '1010' 

3) Performed a DBS restart using tpareset and waited till TD is up.

4) Re executed the query 'sel * from gtt_restart' . It failed with "SELECT Failed [10001] Cannot close an Active Request. Please Abort the Request" . Re executed the query again and see that the sesion gets reconnected but there is no data in the GTT. I have tried to verify the session number and this time 'Sel Session' query  displays the sesion number as '1012' and sessioninfo table has two rows with old sesion number '1010' and new sesion number '1012'. 

If i try to reissue the 'sel session' query or fetch session info from 'sessioninfo' view, The session number gets incremented. 

ODBC Driver: (Have configured the DSN with Enable Reconnect)

Using ODBC driver in SQLA, After a DBS restart, When i tried to re-run any query in SQLA window, It throws an error msg box '10054 WSA E ConnReset: Connection reset by peer' and the status bar displays executing query and remained like that forever.

This is working fine through BTEQ and GTT is able to retain data(With 2825 error) after a DBS restart.

OS :

Windows 8.1 Pro

DBS package versions used:

TDExpress15.0.0.8_Sles10:~ # pdepath -i

PDE: 15.00.00.08

TDGSS: 15.00.00.07

TDBMS: 15.00.00.07

TGTW: 15.00.00.00

RSG: 15.00.00.00

PDEGPL: 15.00.00.08

Client versions used:(TTU 15.00 for windows)

.NET Data Provider for Teradata 14.11.0.1  (This is the version from TTU 15.00 client setup package)

ODBC Driver for Teradata 15.00.0.1

ODBC Driver for Teradata nt-x8664 15.00.0.1


Teradata SQL Assistant 15.00

2 REPLIES
Teradata Employee

Re: Problem with Reconnect using .NET and ODBC drivers

.NET Data Provider version 14.11.0.1 does not support Reconnect.

Enthusiast

Re: Problem with Reconnect using .NET and ODBC drivers

Once aborted a .NET session (via viewpoint or DBS restart), SQLA does not ask for connection information again when I try to execute another qurey from same window. It just reconnect another session and executes the query without asking me connection information again.

Why this is so ?