TPT 14.10 problems loading data from SQL Server using TPT Wizard

Tools
Teradata Employee

TPT 14.10 problems loading data from SQL Server using TPT Wizard

Hi.

Recently I made an version upgrade to TTU 14.10 but I'm having some problems that I didn't have in 13.10.

I tried to use the TPT Wizard to create a load Job to retrieve data from "SQL Server", but the Log File says that no rows are exported. That is weird because If I submit the SQL in the source, It returns data.

Do you know if there are some bugs in this version about that?

I copy the TPT JOB and the log, If for some case you need them

Script

======

/* 1 */ 

/* 2 */ 

/* 3 */  USING CHARACTER SET UTF8

/* 4 */  DEFINE JOB "Carga_tablas_Paradata"

/* 5 */  (

/* 6 */   DEFINE OPERATOR "W_1_o_Carga_tablas_Paradata"

/* 7 */   TYPE LOAD

/* 8 */   SCHEMA *

/* 9 */   ATTRIBUTES

/* 10 */   (

/* 11 */    VARCHAR "UserName",

/* 12 */    VARCHAR "UserPassword",

/* 13 */    VARCHAR "LogTable",

/* 14 */    VARCHAR "TargetTable",

/* 15 */    INTEGER "BufferSize",

/* 16 */    INTEGER "ErrorLimit",

/* 17 */    INTEGER "MaxSessions",

/* 18 */    INTEGER "MinSessions",

/* 19 */    INTEGER "TenacityHours",

/* 20 */    INTEGER "TenacitySleep",

/* 21 */    VARCHAR "AccountID",

/* 22 */    VARCHAR "DateForm",

/* 23 */    VARCHAR "ErrorTable1",

/* 24 */    VARCHAR "ErrorTable2",

/* 25 */    VARCHAR "NotifyExit",

/* 26 */    VARCHAR "NotifyExitIsDLL",

/* 27 */    VARCHAR "NotifyLevel",

/* 28 */    VARCHAR "NotifyMethod",

/* 29 */    VARCHAR "NotifyString",

/* 30 */    VARCHAR "PauseAcq",

/* 31 */    VARCHAR "PrivateLogName",

/* 32 */    VARCHAR "TdpId",

/* 33 */    VARCHAR "TraceLevel",

/* 34 */    VARCHAR "WorkingDatabase"

/* 35 */   );

/* 36 */ 

/* 37 */   DEFINE SCHEMA "W_0_s_Carga_tablas_Paradata"

/* 38 */   (

/* 39 */    "Lote_id" INTEGER,

/* 40 */    "Lote_descripcion" VARCHAR(100),

/* 41 */    "Lote_Cliente" VARCHAR(20),

/* 42 */    "dedu_fecha_proceso" CHARACTER(23),

/* 43 */    "dedu_cantidad_registros" BIGINT,

/* 44 */    "dedu_veto_total" BIGINT,

/* 45 */    "dedu_cliente_vigente_tot" BIGINT

/* 46 */   );

/* 47 */ 

/* 48 */   DEFINE OPERATOR "W_0_o_Carga_tablas_Paradata"

/* 49 */   TYPE ODBC

/* 50 */   SCHEMA "W_0_s_Carga_tablas_Paradata"

/* 51 */   ATTRIBUTES

/* 52 */   (

/* 53 */    VARCHAR "UserName",

/* 54 */    VARCHAR "UserPassword",

/* 55 */    VARCHAR "SelectStmt",

/* 56 */    VARCHAR "PrivateLogName",

/* 57 */    VARCHAR "DSNName",

/* 58 */    VARCHAR "ConnectString",

/* 59 */    VARCHAR "TruncateData"

/* 60 */   );

/* 61 */ 

/* 62 */   APPLY

/* 63 */    (

/* 64 */     'INSERT INTO P_DW_PROSPECTOS_TEMP_TABLES.mktd_lotes_v1 (Lote_id,Lote_descripcion,Lote_Cliente,dedu_fecha_proceso,dedu_cantidad_registros,dedu_veto_total,dedu_cliente_vigente_tot) VALUES (:Lote_id,:Lote_descripcion,:Lote_Cliente,:dedu_fecha_proceso,:dedu_cantidad_registros,:dedu_veto_total,:dedu_cliente_vigente_tot);'

/* 65 */    )

/* 66 */   TO OPERATOR

/* 67 */   (

/* 68 */    "W_1_o_Carga_tablas_Paradata"[1]

/* 69 */ 

/* 70 */    ATTRIBUTES

/* 71 */    (

/* 72 */     "UserName" = 'L0607460',

/* 73 */     "UserPassword" = 'XXXXXXXXXX',

/* 74 */     "LogTable" = 'P_DW_PROSPECTOS_TEMP_TABLES.mktd_lotes_v1_log',

/* 75 */     "TargetTable" = 'P_DW_PROSPECTOS_TEMP_TABLES.mktd_lotes_v1',

/* 76 */     "TdpId" = '10.0.xx.xx'

/* 77 */    )

/* 78 */   )

/* 79 */   SELECT * FROM OPERATOR

/* 80 */   (

/* 81 */    "W_0_o_Carga_tablas_Paradata"[1]

/* 82 */ 

/* 83 */    ATTRIBUTES

/* 84 */    (

/* 85 */     "UserName" = 'XXXXXXXXXXXXXX',

/* 86 */     "UserPassword" = 'XXXXXXXXXXXXXX',

/* 87 */     "SelectStmt" = 'SELECT Lote_id,Lote_descripcion,Lote_Cliente,dedu_fecha_proceso,dedu_cantidad_registros,dedu_veto_total,dedu_cliente_vigente_tot FROM MKTD_DEDUPLICACION.dbo.Lotes;',

/* 88 */     "DSNName" = 'paradata'

/* 89 */    )

/* 90 */   );

/* 91 */  ); 

LOG FILE:

===========

Teradata Parallel Transporter Version 14.10.00.04

Job log: C:\Archivos de programa\Teradata\client\14.10\Teradata Parallel Transporter/logs/LOTE_V1_2-31.out

Job id is LOTE_V1_2-31, running on GAL082262

Teradata Parallel Transporter Load Operator Version 14.10.00.04

W_1_o_Carga_tablas_Paradata: private log not specified

Teradata Parallel Transporter ODBC Operator Version 14.10.00.04

W_0_o_Carga_tablas_Paradata: private log not specified

W_0_o_Carga_tablas_Paradata: connecting sessions

W_0_o_Carga_tablas_Paradata: TPT17176: Info: Message received from ODBC driver:

STATE=01000, CODE=5701,

MSG='[Microsoft][ODBC SQL Server Driver][SQL Server]Changed database context to 'MKTD_DEDUPLICACION'.'

W_0_o_Carga_tablas_Paradata: TPT17176: Info: Message received from ODBC driver:

STATE=01000, CODE=5703,

MSG='[Microsoft][ODBC SQL Server Driver][SQL Server]Changed language setting to us_english.'

W_0_o_Carga_tablas_Paradata: TPT17175: Warning: Message received from ODBC driver:

STATE=S1092, CODE=0,

MSG='[Microsoft][ODBC SQL Server Driver]Identificador de opción o atributo no válido'

W_1_o_Carga_tablas_Paradata: connecting sessions

W_1_o_Carga_tablas_Paradata: preparing target table

W_1_o_Carga_tablas_Paradata: entering Acquisition Phase

W_0_o_Carga_tablas_Paradata: sending SELECT request

W_0_o_Carga_tablas_Paradata: data retrieval complete

W_0_o_Carga_tablas_Paradata: Total Rows Exported:  0

W_1_o_Carga_tablas_Paradata: entering Application Phase

W_1_o_Carga_tablas_Paradata: Statistics for Target Table:  'P_DW_PROSPECTOS_TEMP_TABLES.mktd_lotes_v1'

W_1_o_Carga_tablas_Paradata: Total Rows Sent To RDBMS:      0

W_1_o_Carga_tablas_Paradata: Total Rows Applied:            0

W_1_o_Carga_tablas_Paradata: Total Rows in Error Table 1:   0

W_1_o_Carga_tablas_Paradata: Total Rows in Error Table 2:   0

W_1_o_Carga_tablas_Paradata: Total Duplicate Rows:          0

W_0_o_Carga_tablas_Paradata: disconnecting sessions

W_1_o_Carga_tablas_Paradata: disconnecting sessions

W_0_o_Carga_tablas_Paradata: Total processor time used = '0.859375 Second(s)'

W_0_o_Carga_tablas_Paradata: Start : Tue Jul 22 18:28:37 2014

W_0_o_Carga_tablas_Paradata: End   : Tue Jul 22 18:29:00 2014

W_1_o_Carga_tablas_Paradata: Total processor time used = '4.57813 Second(s)'

W_1_o_Carga_tablas_Paradata: Start : Tue Jul 22 18:28:37 2014

W_1_o_Carga_tablas_Paradata: End   : Tue Jul 22 18:29:06 2014

Job step MAIN_STEP terminated (status 4)

Job LOTE_V1_2 completed successfully, but with warning(s).

Job start: Tue Jul 22 18:28:34 2014

Job end:   Tue Jul 22 18:29:06 2014

Thanks

Tags (1)
1 REPLY
Teradata Employee

Re: TPT 14.10 problems loading data from SQL Server using TPT Wizard

This was a known issue with 64-bit TPT and the Microsoft ODBC driver.

It was fixed in 14.10.00.03.

However, I see that you are using 14.10.00.04, so this is baffling.

I would need you to try the same job with the drivers from DataDirect (TPT is only certified with the drivers from DataDirect).

-- SteveF