Archives of the TeradataForum

Message Posted: Tue, 24 Feb 2015 @ 16:04:05 GMT

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

Hi Chiran,

We are using TPT 13.10. Yes I did check the schema for both the tables, In fact I recreated the Dev table by taking the DDL from PROD but it is still showing the same error. I am attaching the log file and script files below, if that helps.

TPT Script File

     /* 1 */
     /* 2 */
     /* 3 */  DEFINE JOB SAMPLE
     /* 4 */  (
     /* 5 */    DEFINE OPERATOR W_1_o_SAMPLE
     /* 6 */    TYPE LOAD
     /* 7 */    SCHEMA *
     /* 8 */    ATTRIBUTES
     /* 9 */    (
     /* 10 */     VARCHAR UserName,
     /* 11 */     VARCHAR UserPassword,
     /* 12 */     VARCHAR LogTable,
     /* 13 */     VARCHAR TargetTable,
     /* 14 */     INTEGER BufferSize,
     /* 15 */     INTEGER ErrorLimit,
     /* 16 */     INTEGER MaxSessions,
     /* 17 */     INTEGER MinSessions,
     /* 18 */     INTEGER TenacityHours,
     /* 19 */     INTEGER TenacitySleep,
     /* 20 */     VARCHAR AccountID,
     /* 21 */     VARCHAR DateForm,
     /* 22 */     VARCHAR ErrorTable1,
     /* 23 */     VARCHAR ErrorTable2,
     /* 24 */     VARCHAR NotifyExit,
     /* 25 */     VARCHAR NotifyExitIsDLL,
     /* 26 */     VARCHAR NotifyLevel,
     /* 27 */     VARCHAR NotifyMethod,
     /* 28 */     VARCHAR NotifyString,
     /* 29 */     VARCHAR PauseAcq,
     /* 30 */     VARCHAR PrivateLogName,
     /* 31 */     VARCHAR TdpId,
     /* 32 */     VARCHAR TraceLevel,
     /* 33 */     VARCHAR WorkingDatabase
     /* 34 */    );
     /* 35 */
     /* 36 */   DEFINE SCHEMA W_0_s_SAMPLE
     /* 37 */   (
     /* 38 */     MEMBER_NUM VARCHAR(8),
     /* 39 */     POLICY_NUM VARCHAR(25),
     /* 40 */     POLICY_TYPE VARCHAR(8),
     /* 41 */     DOL VARCHAR(10),
     /* 42 */     LINECODE_VIN VARCHAR(250),
     /* 43 */     CAUSE_CODE VARCHAR(156),
     /* 44 */     CLM_AMOUNT DECIMAL(14, 2),
     /* 45 */     POLICY_STATUS VARCHAR(1),
     /* 46 */     POLICYSTATUS_GROUPNM VARCHAR(150),
     /* 47 */     CLAIM_NBR VARCHAR(40),
     /* 48 */     CSR_CLAIM_NBR CHARACTER(40),
     /* 49 */     CLAIM_STATUS_CD CHARACTER(12)
     /* 50 */   );
     /* 51 */
     /* 52 */   DEFINE OPERATOR W_0_o_SAMPLE
     /* 53 */   TYPE EXPORT
     /* 54 */   SCHEMA W_0_s_SAMPLE
     /* 55 */   ATTRIBUTES
     /* 56 */   (
     /* 57 */     VARCHAR UserName,
     /* 58 */     VARCHAR UserPassword,
     /* 59 */     VARCHAR SelectStmt,
     /* 60 */     INTEGER BlockSize,
     /* 61 */     INTEGER MaxSessions,
     /* 62 */     INTEGER MinSessions,
     /* 63 */     INTEGER TenacityHours,
     /* 64 */     INTEGER TenacitySleep,
     /* 65 */     INTEGER MaxDecimalDigits,
     /* 66 */     VARCHAR AccountID,
     /* 67 */     VARCHAR DateForm,
     /* 68 */     VARCHAR NotifyExit,
     /* 69 */     VARCHAR NotifyExitIsDLL,
     /* 70 */     VARCHAR NotifyLevel,
     /* 71 */     VARCHAR NotifyMethod,
     /* 72 */     VARCHAR NotifyString,
     /* 73 */     VARCHAR PrivateLogName,
     /* 74 */     VARCHAR TdpId,
     /* 75 */     VARCHAR TraceLevel,
     /* 76 */     VARCHAR WorkingDatabase
     /* 77 */   );
     /* 78 */
     /* 79 */   APPLY
     /* 80 */      (
     /* 81 */        'INSERT INTO DB_T_STAG_MEMBXREF_DEV.CLAIM_DETAILS (MEMBER_NUM, POLICY_NUM, POLICY_TYPE, DOL,
                      LINECODE_VIN, CAUSE_CODE, CLM_AMOUNT, POLICY_STATUS, POLICYSTATUS_GROUPNM, CLAIM_NBR, CSR_CLAIM_NBR,
                      CLAIM_STATUS_CD)
                      VALUES (:MEMBER_NUM,:POLICY_NUM, :POLICY_TYPE, :DOL,:LINECODE_VIN, :CAUSE_CODE, :CLM_AMOUNT,
                     :POLICY_STATUS, :POLICYSTATUS_GROUPNM, :CLAIM_NBR, :CSR_CLAIM_NBR, :CLAIM_STATUS_CD);'
     /* 82 */      )
     /* 83 */   TO OPERATOR
     /* 84 */   (
     /* 85 */     W_1_o_SAMPLE[1]
     /* 86 */
     /* 87 */     ATTRIBUTES
     /* 88 */     (
     /* 89 */        UserName = @TeradataDestinationUser,
     /* 90 */        UserPassword = @TeradataDestinationPassword,
     /* 91 */        LogTable = 'DB_T_STAG_MEMBXREF_DEV.CLAIM_DETAILS_log',
     /* 92 */        TargetTable = 'DB_T_STAG_MEMBXREF_DEV.CLAIM_DETAILS',
     /* 93 */        TdpId = 'dsTD-D'
     /* 94 */     )
     /* 95 */   )
     /* 96 */   SELECT * FROM OPERATOR
     /* 97 */   (
     /* 98 */     W_0_o_SAMPLE[1]
     /* 99 */
     /* 100 */    ATTRIBUTES
     /* 101 */    (
     /* 102 */      UserName = @TeradataSourceUser,
     /* 103 */      UserPassword = @TeradataSourcePassword,
     /* 104 */      SelectStmt = 'SELECT MEMBER_NUM, POLICY_NUM,POLICY_TYPE,DOL, LINECODE_VIN, CAUSE_CODE,
                    CLM_AMOUNT, POLICY_STATUS, POLICYSTATUS_GROUPNM, CLAIM_NBR, CSR_CLAIM_NBR, CLAIM_STATUS_CD
                    FROM DB_T_STAG_MEMBXREF_PROD.CLAIM_DETAILS;',
     /* 105 */      TdpId = 'Alfa2'
     /* 106 */    )
     /* 107 */  );
     /* 108 */  );

TPT Log File

     Teradata Parallel Transporter Version 13.10.00.13 Job log: C:\Program Files
     (x86)\Teradata\client\13.10\Teradata Parallel Transporter/logs/sample4-40.out Job id is
     sample4-40, running on ho-sqlmgt Teradata Parallel Transporter Load Operator Version
     13.10.00.04 Teradata Parallel Transporter Export Operator Version 13.10.00.06
     W_1_o_SAMPLE: private log not specified
     W_0_o_SAMPLE: private log not specified
     W_0_o_SAMPLE: connecting sessions
     W_1_o_SAMPLE: connecting sessions
     W_0_o_SAMPLE: TPT12108: Output Schema does not match data from SELECT statement
     W_0_o_SAMPLE: disconnecting sessions
     W_0_o_SAMPLE: Total processor time used = '0.280802 Second(s)'
     W_0_o_SAMPLE: Start : Mon Feb 23 15:18:18 2015
     W_0_o_SAMPLE: End   : Mon Feb 23 15:18:24 2015
     W_1_o_SAMPLE: preparing target table
     W_1_o_SAMPLE: entering Acquisition Phase
     W_1_o_SAMPLE: disconnecting sessions
     W_1_o_SAMPLE: Total processor time used = '0.764405 Second(s)'
     W_1_o_SAMPLE: Start : Mon Feb 23 15:18:18 2015
     W_1_o_SAMPLE: End   : Mon Feb 23 15:18:27 2015
     Job step MAIN_STEP terminated (status 12) Job sample4 terminated (status 12)

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