All Forums Tools
WB255000 11 posts Joined 11/09
22 Jul 2014
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_proc eso,dedu_cantidad_registros,dedu_veto_total,dedu_clien te_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_proce so,dedu_cantidad_registros,dedu_veto_total,dedu_client e_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:
feinholz 1234 posts Joined 05/08
23 Jul 2014

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

You must sign in to leave a comment.