TPT DSN Error

Tools

TPT DSN Error

Our enterprise teradata version is 13.10.07.12. I have installed TTU 15 on our 64bit windows server. While trying to use TPT wizard to connect to SQL Server using odbc DSN I am getting Driver Error: There was an error initializing the driver for usage.

I am using Microsoft sql server native client 10.0 odbc driver. I know that this driver is not recommended but that is all I can afford to use as it is free. 

I can connect to sql server using tpt wizard with out any issues on my local 32 bit xp machine. I have generated a tpt script on my local machine and ran it on our windows server. Script ran sucessfully but exported zero rows...

Below is my TPT script:

/* 1 */  

/* 2 */  

/* 3 */  DEFINE JOB DSN_Test_51V

/* 4 */  (

/* 5 */   DEFINE OPERATOR W_1_o_DSN_Test_51V

/* 6 */   TYPE DATACONNECTOR CONSUMER

/* 7 */   SCHEMA *

/* 8 */   ATTRIBUTES

/* 9 */   (

/* 10 */   VARCHAR FileName, 

/* 11 */   VARCHAR Format, 

/* 12 */   VARCHAR OpenMode, 

/* 13 */   INTEGER BlockSize, 

/* 14 */   INTEGER BufferSize, 

/* 15 */   INTEGER RetentionPeriod, 

/* 16 */   INTEGER RowsPerInstance, 

/* 17 */   INTEGER SecondarySpace, 

/* 18 */   INTEGER UnitCount, 

/* 19 */   INTEGER VigilElapsedTime, 

/* 20 */   INTEGER VigilWaitTime, 

/* 21 */   INTEGER VolumeCount, 

/* 22 */   VARCHAR AccessModuleName, 

/* 23 */   VARCHAR AccessModuleInitStr, 

/* 24 */   VARCHAR DirectoryPath, 

/* 25 */   VARCHAR ExpirationDate, 

/* 26 */   VARCHAR IndicatorMode, 

/* 27 */   VARCHAR PrimarySpace, 

/* 28 */   VARCHAR PrivateLogName, 

/* 29 */   VARCHAR RecordFormat, 

/* 30 */   VARCHAR RecordLength, 

/* 31 */   VARCHAR SpaceUnit, 

/* 32 */   VARCHAR TextDelimiter, 

/* 33 */   VARCHAR VigilNoticeFileName, 

/* 34 */   VARCHAR VigilStartTime, 

/* 35 */   VARCHAR VigilStopTime, 

/* 36 */   VARCHAR VolSerNumber, 

/* 37 */   VARCHAR UnitType

/* 38 */   );

/* 39 */  

/* 40 */   DEFINE SCHEMA W_0_s_DSN_Test_51V

/* 41 */   (

/* 42 */   CLNT_CD VARCHAR(21),

/* 43 */   CUST_NM VARCHAR(100),

/* 44 */   RPT_OPT1_CD VARCHAR(22),

/* 45 */   CARRIER VARCHAR(20),

/* 46 */   ACCOUNT_0 VARCHAR(20)

/* 47 */   );

/* 48 */  

/* 49 */   DEFINE OPERATOR W_0_o_DSN_Test_51V

/* 50 */   TYPE ODBC

/* 51 */   SCHEMA W_0_s_DSN_Test_51V

/* 52 */   ATTRIBUTES

/* 53 */   (

/* 54 */   VARCHAR UserName, 

/* 55 */   VARCHAR UserPassword, 

/* 56 */   VARCHAR SelectStmt, 

/* 57 */   VARCHAR PrivateLogName, 

/* 58 */   VARCHAR DSNName, 

/* 59 */   VARCHAR ConnectString, 

/* 60 */   VARCHAR TruncateData

/* 61 */   );

/* 62 */  

/* 63 */   APPLY

/* 64 */   TO OPERATOR

/* 65 */   (

/* 66 */   W_1_o_DSN_Test_51V[1]

/* 67 */  

/* 68 */   ATTRIBUTES

/* 69 */   (

/* 70 */   FileName = 'C:\Users\svcitools\Desktop\New Folder\New Text Document.txt', 

/* 71 */   Format = 'DELIMITED', 

/* 72 */   OpenMode = 'WriteAppend', 

/* 73 */   IndicatorMode = 'N', 

/* 74 */   TextDelimiter = '|'

/* 75 */   )

/* 76 */   )

/* 77 */   SELECT * FROM OPERATOR

/* 78 */   (

/* 79 */   W_0_o_DSN_Test_51V[1]

/* 80 */  

/* 81 */   ATTRIBUTES

/* 82 */   (

/* 83 */   UserName = 'XXXX', 

/* 84 */   UserPassword = 'XXXX', 

/* 85 */   SelectStmt = 'SELECT CLNT_CD,CUST_NM,RPT_OPT1_CD,CARRIER,ACCOUNT FROM Dimensions.dbo.PEER_Carrier;', 

/* 86 */   DSNName = 'XXX'

/* 87 */   )

/* 88 */   );

/* 89 */  );
Tags (1)
6 REPLIES

Re: TPT DSN Error

Update:

I have tested the TPT wizard and I am able to export rows into text document with out any issues from a teradata table. It is only exporting zero rows if my source is sql server.

Teradata Employee

Re: TPT DSN Error

This is a known issue and has been fixed in 15.00.00.02 (you are running 15.00.00.00).

Please download the latest 15.00 patch/efix.

Thanks!

-- SteveF
Teradata Employee

Re: TPT DSN Error

Actually, 15.00.00.02 may not have been released yet.

Looks like it is schedule for mid-July.

-- SteveF
Teradata Employee

Re: TPT DSN Error

In the meantime, you can always download a free 15-day evaluation copy of the DataDirect drivers.

-- SteveF

Re: TPT DSN Error

Thank you for your response Steve.

What is the reason for this issue? is it because of 64bit OS?

One more question I have is.... Is it a good approach/legal to update tools to latest version even though enterprise database is an older version? 

Teradata Employee

Re: TPT DSN Error

Yes, it was related to 64-bit TPT.

The Microsoft driver needed something set explicitly whereas the DataDirect driver did not (accepted our default setting).

We always recommend that you keep current with the latest efixes/patches of our client software. By that, I mean if you have version 14.10, then keep up-to-date with the patches. If there is an issue, we cannot assist unless you are at the latest version.

If you have, say, a 14.10 version of the DBS, it does not necessarily mean you should upgrade your client to 15.0 or 15.10. Most people try to keep the client and database versions at the same level.

However, our client software supports 3-4 releases of Teradata, so you will not run into issues if you have an older database release than client.

-- SteveF