Teradata Parallel Transporter (TPT) wizard error TPT19003, TPT19008, TPT19119,TPT19003

Tools
Enthusiast

Teradata Parallel Transporter (TPT) wizard error TPT19003, TPT19008, TPT19119,TPT19003

Dear All,

its my first time using TPT and i want to use it to import flat tab delimited text files to a teradata DB. But i get errors (see below). Im using windows server 2003 and installed the latest JAVA SE. I threw away all the error/log tables and released mload but it keep complaining it cant access the file. I tried giving java.exe administrator rights which didnt work either. I'm out of ideas. Anyone? Otherwise isnt there a helpdesk i can call?

Teradata Parallel Transporter Version 14.10.00.01

Job log: C:\Program Files (x86)\Teradata\client\14.10\Teradata Parallel Transporter/logs/test_tpt-14.out

Job id is test_tpt-14, running on SVOV06303

Found CheckPoint file: C:\Program Files (x86)\Teradata\client\14.10\Teradata Parallel Transporter/checkpoint\test_tptLVCP

This is a restart job; it restarts at step MAIN_STEP.

Teradata Parallel Transporter Update Operator Version 14.10.00.01

W_1_o_import_fc_mcr_hypotheken_tab_delimited_file: private log not specified

Teradata Parallel Transporter W_0_o_import_fc_mcr_hypotheken_tab_delimited_file: TPT19006 Version 14.10.00.01

W_0_o_import_fc_mcr_hypotheken_tab_delimited_file Instance 1 directing private log report to 'dtacop-9311365-5592-1'.

W_0_o_import_fc_mcr_hypotheken_tab_delimited_file: TPT19003 NotifyMethod: 'None (default)'

W_0_o_import_fc_mcr_hypotheken_tab_delimited_file: TPT19008 DataConnector Producer operator Instances: 1

W_0_o_import_fc_mcr_hypotheken_tab_delimited_file: TPT19119 Unable to examine directory 'C:\'

W_0_o_import_fc_mcr_hypotheken_tab_delimited_file: TPT19003 TPT Exit code set to 12.

W_0_o_import_fc_mcr_hypotheken_tab_delimited_file: TPT19221 Total files processed: 0.

W_1_o_import_fc_mcr_hypotheken_tab_delimited_file: connecting sessions

W_1_o_import_fc_mcr_hypotheken_tab_delimited_file: The RDBMS retryable error code list was not found

W_1_o_import_fc_mcr_hypotheken_tab_delimited_file: The job will use its internal retryable error codes

W_1_o_import_fc_mcr_hypotheken_tab_delimited_file: preparing target table(s)

W_1_o_import_fc_mcr_hypotheken_tab_delimited_file: entering DML Phase

W_1_o_import_fc_mcr_hypotheken_tab_delimited_file: entering Acquisition Phase

W_1_o_import_fc_mcr_hypotheken_tab_delimited_file: disconnecting sessions

W_1_o_import_fc_mcr_hypotheken_tab_delimited_file: Total processor time used = '4.04688 Second(s)'

W_1_o_import_fc_mcr_hypotheken_tab_delimited_file: Start : Thu Sep 12 17:59:58 2013

W_1_o_import_fc_mcr_hypotheken_tab_delimited_file: End   : Thu Sep 12 18:01:04 2013

Job step MAIN_STEP terminated (status 12)

 Following is the script which is generated by the wizard:

/* 1 */ 

/* 2 */ 

/* 3 */  USING CHARACTER SET ASCII

/* 4 */  DEFINE JOB import_fc_mcr_hypotheken_tab_delimited_file

/* 5 */  (

/* 6 */   DEFINE OPERATOR W_1_o_import_fc_mcr_hypotheken_tab_delimited_file

/* 7 */   TYPE UPDATE

/* 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 AmpCheck,

/* 23 */    VARCHAR DeleteTask,

/* 24 */    VARCHAR ErrorTable1,

/* 25 */    VARCHAR ErrorTable2,

/* 26 */    VARCHAR NotifyExit,

/* 27 */    VARCHAR NotifyExitIsDLL,

/* 28 */    VARCHAR NotifyLevel,

/* 29 */    VARCHAR NotifyMethod,

/* 30 */    VARCHAR NotifyString,

/* 31 */    VARCHAR PauseAcq,

/* 32 */    VARCHAR PrivateLogName,

/* 33 */    VARCHAR TdpId,

/* 34 */    VARCHAR TraceLevel,

/* 35 */    VARCHAR WorkingDatabase,

/* 36 */    VARCHAR WorkTable

/* 37 */   );

/* 38 */ 

/* 39 */   DEFINE SCHEMA W_0_s_import_fc_mcr_hypotheken_tab_delimited_file

/* 40 */   (

/* 41 */    dt_rapport VARCHAR(150),

/* 42 */    Verwerking VARCHAR(150),

/* 43 */    rek_nr VARCHAR(150),

/* 44 */    hoofdsom_nr VARCHAR(150),

/* 45 */    klant_nr VARCHAR(150),

/* 46 */    bank_nr VARCHAR(150),

/* 47 */    cbk_nr VARCHAR(150),

/* 48 */    vkk_nr VARCHAR(150),

/* 49 */    makelaar_nr VARCHAR(150),

/* 50 */    segment VARCHAR(150),

/* 51 */    status VARCHAR(150),

/* 52 */    bln_eerste_termijn VARCHAR(150),

/* 53 */    rentevariant VARCHAR(150),

/* 54 */    vorige_rentevariant VARCHAR(150),

/* 55 */    aflossingsvorm VARCHAR(150),

/* 56 */    risicoklasse VARCHAR(150),

/* 57 */    tariefvorm VARCHAR(150),

/* 58 */    productievorm VARCHAR(150),

/* 59 */    securitisatiestatus VARCHAR(150),

/* 60 */    probleem_code VARCHAR(150),

/* 61 */    bg_oorspr_hoofdsom VARCHAR(150),

/* 62 */    bg_vorig_saldo_kas VARCHAR(150),

/* 63 */    bg_saldo_kas VARCHAR(150),

/* 64 */    bg_saldo_spaardeel VARCHAR(150),

/* 65 */    bg_saldo_rentedagen VARCHAR(150),

/* 66 */    bg_saldo_bij_renteherz VARCHAR(150),

/* 67 */    bg_ev VARCHAR(150),

/* 68 */    bg_hybride_tier1 VARCHAR(150),

/* 69 */    bg_utier2 VARCHAR(150),

/* 70 */    bg_ltier2 VARCHAR(150),

/* 71 */    bg_reguliere_aflossing VARCHAR(150),

/* 72 */    bg_vervr_aflossing VARCHAR(150),

/* 73 */    bg_theo_afl_boete VARCHAR(150),

/* 74 */    dt_offerte VARCHAR(150),

/* 75 */    dt_begin VARCHAR(150),

/* 76 */    dt_eind VARCHAR(150),

/* 77 */    dt_vorige_renteherz VARCHAR(150),

/* 78 */    dt_volgende_renteherz VARCHAR(150),

/* 79 */    dt_vorige_margeherz VARCHAR(150),

/* 80 */    dt_volgende_margeherz VARCHAR(150),

/* 81 */    dt_klantrente VARCHAR(150),

/* 82 */    pct_klantrente VARCHAR(150),

/* 83 */    pct_rente_spaardeel VARCHAR(150),

/* 84 */    pct_geoffreerde_rente VARCHAR(150),

/* 85 */    pct_swap_rente VARCHAR(150),

/* 86 */    pct_sns_spread VARCHAR(150),

/* 87 */    pct_offerte_opslag VARCHAR(150),

/* 88 */    pct_aflos_opslag VARCHAR(150),

/* 89 */    pct_product_opslag VARCHAR(150),

/* 90 */    pct_payoff_offerte VARCHAR(150),

/* 91 */    pct_payoff_product VARCHAR(150),

/* 92 */    pct_utier2_opslag VARCHAR(150),

/* 93 */    pct_ltier2_opslag VARCHAR(150),

/* 94 */    pct_schaduw VARCHAR(150),

/* 95 */    pct_kosten_opslag VARCHAR(150),

/* 96 */    pct_kredietrisico_opslag VARCHAR(150),

/* 97 */    pct_rev_opslag VARCHAR(150),

/* 98 */    pct_hybride_opslag VARCHAR(150),

/* 99 */    pct_opslag_rentetype VARCHAR(150),

/* 100 */    pct_opslag_extra_winst VARCHAR(150),

/* 101 */    pct_free_fund VARCHAR(150),

/* 102 */    pct_vorige_marge VARCHAR(150),

/* 103 */    pct_marge VARCHAR(150),

/* 104 */    pct_toets VARCHAR(150),

/* 105 */    pct_renteplafond VARCHAR(150),

/* 106 */    pct_bandbreedte_onder VARCHAR(150),

/* 107 */    pct_bandbreedte_boven VARCHAR(150),

/* 108 */    oorspr_LTF VARCHAR(150),

/* 109 */    renteperiode VARCHAR(150),

/* 110 */    prijsserver_code VARCHAR(250)

/* 111 */   );

/* 112 */ 

/* 113 */   DEFINE OPERATOR W_0_o_import_fc_mcr_hypotheken_tab_delimited_file

/* 114 */   TYPE DATACONNECTOR PRODUCER

/* 115 */   SCHEMA W_0_s_import_fc_mcr_hypotheken_tab_delimited_file

/* 116 */   ATTRIBUTES

/* 117 */   (

/* 118 */    VARCHAR FileName,

/* 119 */    VARCHAR Format,

/* 120 */    VARCHAR OpenMode,

/* 121 */    INTEGER BlockSize,

/* 122 */    INTEGER BufferSize,

/* 123 */    INTEGER RetentionPeriod,

/* 124 */    INTEGER RowsPerInstance,

/* 125 */    INTEGER SecondarySpace,

/* 126 */    INTEGER UnitCount,

/* 127 */    INTEGER VigilElapsedTime,

/* 128 */    INTEGER VigilWaitTime,

/* 129 */    INTEGER VolumeCount,

/* 130 */    VARCHAR AccessModuleName,

/* 131 */    VARCHAR AccessModuleInitStr,

/* 132 */    VARCHAR DirectoryPath,

/* 133 */    VARCHAR ExpirationDate,

/* 134 */    VARCHAR IndicatorMode,

/* 135 */    VARCHAR PrimarySpace,

/* 136 */    VARCHAR PrivateLogName,

/* 137 */    VARCHAR RecordFormat,

/* 138 */    VARCHAR RecordLength,

/* 139 */    VARCHAR SpaceUnit,

/* 140 */    VARCHAR TextDelimiter,

/* 141 */    VARCHAR VigilNoticeFileName,

/* 142 */    VARCHAR VigilStartTime,

/* 143 */    VARCHAR VigilStopTime,

/* 144 */    VARCHAR VolSerNumber,

/* 145 */    VARCHAR UnitType

/* 146 */   );

/* 147 */ 

/* 148 */   APPLY

/* 149 */    (

/* 150 */     'INSERT INTO FC.mcr_hypotheken (dt_rapport,rek_nr,hoofdsom_nr,bank_nr,cbk_nr,segment,status,bln_eerste_termijn,rentevariant,vorige_rentevariant,aflossingsvorm,risicoklasse,tariefvorm,productievorm,bg_oorspr_hoofdsom,bg_saldo_kas,bg_vorig_saldo_kas,bg_saldo_spaardeel,bg_saldo_rentedagen,bg_saldo_bij_renteherz,bg_ev,bg_hybride_tier1,bg_utier2,bg_ltier2,bg_reguliere_aflossing,bg_vervr_aflossing,bg_theo_afl_boete,dt_offerte,dt_klantrente,dt_begin,dt_vorige_margeherz,dt_vorige_renteherz,dt_volgende_renteherz,dt_volgende_margeherz,dt_eind,pct_geoffreerde_rente,pct_marge,pct_vorige_marge,pct_klantrente,pct_schaduw,pct_swap_rente,pct_SNS_spread,pct_offerte_opslag,pct_aflos_opslag,pct_product_opslag,pct_payoff_offerte,pct_payoff_product,pct_utier2_opslag,pct_ltier2_opslag,pct_hybride_opslag,pct_kosten_opslag,pct_kredietrisico_opslag,pct_opslag_rentetype,pct_opslag_extra_winst,pct_free_fund,pct_rev_opslag,pct_toets,pct_renteplafond,pct_bandbreedte_onder,pct_bandbreedte_boven,pct_rente_spaardeel,oorspr_LTF,renteperiode,prijsserver_code,probleem_code,verwerking,securitisatiestatus,vkk_nr,klant_nr,makelaar_nr) VALUES (:dt_rapport,:rek_nr,:hoofdsom_nr,:bank_nr,:cbk_nr,:segment,:status,:bln_eerste_termijn,:rentevariant,:vorige_rentevariant,:aflossingsvorm,:risicoklasse,:tariefvorm,:productievorm,:bg_oorspr_hoofdsom,:bg_saldo_kas,:bg_vorig_saldo_kas,:bg_saldo_spaardeel,:bg_saldo_rentedagen,:bg_saldo_bij_renteherz,:bg_ev,:bg_hybride_tier1,:bg_utier2,:bg_ltier2,:bg_reguliere_aflossing,:bg_vervr_aflossing,:bg_theo_afl_boete,:dt_offerte,:dt_klantrente,:dt_begin,:dt_vorige_margeherz,:dt_vorige_renteherz,:dt_volgende_renteherz,:dt_volgende_margeherz,:dt_eind,:pct_geoffreerde_rente,:pct_marge,:pct_vorige_marge,:pct_klantrente,:pct_schaduw,:pct_swap_rente,:pct_sns_spread,:pct_offerte_opslag,:pct_aflos_opslag,:pct_product_opslag,:pct_payoff_offerte,:pct_payoff_product,:pct_utier2_opslag,:pct_ltier2_opslag,:pct_hybride_opslag,:pct_kosten_opslag,:pct_kredietrisico_opslag,:pct_opslag_rentetype,:pct_opslag_extra_winst,:pct_free_fund,:pct_rev_opslag,:pct_toets,:pct_renteplafond,:pct_bandbreedte_onder,:pct_bandbreedte_boven,:pct_rente_spaardeel,:oorspr_LTF,:renteperiode,:prijsserver_code,:probleem_code,:Verwerking,:securitisatiestatus,:vkk_nr,:klant_nr,:makelaar_nr);'

/* 151 */    )

/* 152 */   TO OPERATOR

/* 153 */   (

/* 154 */    W_1_o_import_fc_mcr_hypotheken_tab_delimited_file[1]

/* 155 */ 

/* 156 */    ATTRIBUTES

/* 157 */    (

/* 158 */     UserName = 'p9311365',

/* 159 */     UserPassword = 'teradata1234',

/* 160 */     LogTable = 'FC.mcr_hypotheken_log',

/* 161 */     TargetTable = 'FC.mcr_hypotheken',

/* 162 */     TdpId = '10.210.139.144'

/* 163 */    )

/* 164 */   )

/* 165 */   SELECT * FROM OPERATOR

/* 166 */   (

/* 167 */    W_0_o_import_fc_mcr_hypotheken_tab_delimited_file[1]

/* 168 */ 

/* 169 */    ATTRIBUTES

/* 170 */    (

/* 171 */     FileName = 'mlinfile_ansi.txt',

/* 172 */     Format = 'DELIMITED',

/* 173 */     OpenMode = 'Read',

/* 174 */     DirectoryPath = 'C:\',

/* 175 */     IndicatorMode = 'N',

/* 176 */     TextDelimiter = 'TAB'

/* 177 */    )

/* 178 */   );

/* 179 */  );

Tags (2)
7 REPLIES
Teradata Employee

Re: Teradata Parallel Transporter (TPT) wizard error TPT19003, TPT19008, TPT19119,TPT19003

Is the file really in the C:\ directory?

Do you have read access to that file and directory (have to ask that question)?

Please add a screenshot or something.

Do not worry about the message numbers. The only relevant one is TPT19119. For some reason the file reader is unable to access the file in that directory.

-- SteveF
N/A

Re: Teradata Parallel Transporter (TPT) wizard error TPT19003, TPT19008, TPT19119,TPT19003

I'm having the same error in Windows 7 environment. And after changing the permissions in that directory to allow Everyone full control, the error still persists.

Also I have tried putting the data file in the default log folder which tpt is able to write a log file to but this does not work either. Is it really a security issue?

Here is the output...

Teradata Parallel Transporter $DATACONNECTOR_PRODUCER: TPT19006 Version 14.10.00.01

$DATACONNECTOR_PRODUCER Instance 1 directing private log report to 'dataconnector_log-1'.

Teradata Parallel Transporter Load Operator Version 14.10.00.01

$LOAD: private log specified: ddl_log

$DATACONNECTOR_PRODUCER: TPT19003 NotifyMethod: 'None (default)'

$DATACONNECTOR_PRODUCER: TPT19008 DataConnector Producer operator Instances: 1

$DATACONNECTOR_PRODUCER: TPT19119 Unable to examine directory 'C:\Work\TPT\01b\'

$DATACONNECTOR_PRODUCER: TPT19003 TPT Exit code set to 12.

$DATACONNECTOR_PRODUCER: TPT19221 Total files processed: 0.

$LOAD: connecting sessions

$LOAD: The RDBMS retryable error code list was not found

$LOAD: The job will use its internal retryable error codes

$LOAD: preparing target table

$LOAD: entering Acquisition Phase

$LOAD: disconnecting sessions

$LOAD: Total processor time used = '0.280802 Second(s)'

$LOAD: Start : Fri Sep 13 11:08:51 2013

$LOAD: End   : Fri Sep 13 11:08:53 2013

Job step MAIN_STEP terminated (status 12)

Job uguide01b terminated (status 12)

Job start: Fri Sep 13 11:08:51 2013

Job end:   Fri Sep 13 11:08:53 2013

Enthusiast

Re: Teradata Parallel Transporter (TPT) wizard error TPT19003, TPT19008, TPT19119,TPT19003

I confirmed that the file is on the c:\ . I put it there so to check it wasnt a foldername issue. I also put it in de the folder where the tptwizard was located. Keep getting the same error.

Enthusiast

Re: Teradata Parallel Transporter (TPT) wizard error TPT19003, TPT19008, TPT19119,TPT19003

Heres a screeshot. Didnt know how to add it to this forum otherwise so here is a flickr link:

http://www.flickr.com/photos/59494638@N08/9772782513/lightbox/

Enthusiast

Re: Teradata Parallel Transporter (TPT) wizard error TPT19003, TPT19008, TPT19119,TPT19003

Hello all,

Has anyone got an answer to this please ?...

I am having the same problem, but importing from MSSQL. The Fastload wizard script works perfectly, but the TPT load script gives the following error, although it is exactly the same connections being used !.. Can TPT import from MSSQL ?... or only flat files ?...

DataConnOper: TPT19003 ECI operator ID: DataConnOper-4740

DataConnOper: TPT19127 WARNING file 'Untitled' not processed.

DataConnOper: TPT19003 The system cannot find the file specified.

This is the script:

SET MyTdpId='xxx.xx.xx.x';

SET MyUserName='xxxxxxxxxxxxx';

SET MyPassword='xxxxxxxxxxxx';

SET MyDatabase='Dev_DB_LAND';

USING CHAR SET UTF8

DEFINE JOB MyJob

(

  DEFINE SCHEMA MySchema

  (

    WorkflowId              INTEGER,

    "Name"                  VARCHAR(150),

    WorkflowTypeId          INTEGER,

    WorkflowTypeServiceName VARCHAR(3000),

    IsCurrent               BYTEINT

  );

  DEFINE OPERATOR DDLOperator()

  TYPE DDL

  ATTRIBUTES

  (

    VARCHAR PrivateLogName = 'ddl_log',

    VARCHAR TdpId = @MyTdpId,

    VARCHAR UserName = @MyUserName,

    VARCHAR UserPassword = @MyPassword,

    VARCHAR WorkingDatabase = @MyDatabase

  );

  DEFINE OPERATOR DataConnOper()

  TYPE DATACONNECTOR PRODUCER

  SCHEMA MySchema

  ATTRIBUTES

  (

    VARCHAR AccessModuleName = 'Oledb_Axsmod',

    VARCHAR AccessModuleInitStr = 'noprompt jobid=1',

    VARCHAR FileName = 'Untitled',

    VARCHAR Format = 'Formatted',

    VARCHAR EnableScan = 'No',

    VARCHAR IndicatorMode = 'Yes',

    VARCHAR PrivateLogName = 'producer_log'

  );

  DEFINE OPERATOR MyConsumer()

  TYPE LOAD

  SCHEMA MySchema

  ATTRIBUTES

  (

    VARCHAR DateForm = 'IntegerDate',

    VARCHAR ErrorTable1 = 'Workflow_errors1',

    VARCHAR ErrorTable2 = 'Workflow_errors2',

    VARCHAR LogTable = '"Dev_DB_LAND"."Workflow_Log"',

    VARCHAR PrivateLogName = 'consumer_log',

    VARCHAR TargetTable = '"Workflow"',

    VARCHAR TdpId = @MyTdpId,

    VARCHAR UserName = @MyUserName,

    VARCHAR UserPassword = @MyPassword,

    VARCHAR WorkingDatabase = @MyDatabase

  );

  STEP create_the_table

  (

    APPLY

    ('CREATE MULTISET TABLE "Workflow" ( WorkflowId              INTEGER NOT NULL ,

                                         "Name"                  VARCHAR(50) CHARACTER SET UNICODE NOT NULL CASESPECIFIC  ,

                                         WorkflowTypeId          INTEGER NOT NULL ,

                                         WorkflowTypeServiceName VARCHAR(1000) CHARACTER SET UNICODE NOT NULL CASESPECIFIC  ,

                                         IsCurrent               BYTEINT NOT NULL );')

      TO OPERATOR (DDLOperator);

  );

  STEP load_the_data

  (

    APPLY

    ('INSERT INTO "Workflow" ( :WorkflowId, :"Name", :WorkflowTypeId, 

                               :WorkflowTypeServiceName, :IsCurrent );')

      TO OPERATOR (MyConsumer)

      SELECT * FROM OPERATOR (DataConnOper);

  );

);


Thank you for your feedback !...

Boris.

Re: Teradata Parallel Transporter (TPT) wizard error TPT19003, TPT19008, TPT19119,TPT19003

Hi Boris,

CLI error is different than the others. This issue depends your connection limit at teradata.

Teradata Employee

Re: Teradata Parallel Transporter (TPT) wizard error TPT19003, TPT19008, TPT19119,TPT19003

I see that you specified this:

VARCHAR FileName = 'Untitled',

That FileName attribute must contain the name of the .amj file created for the access module to use for the job.

-- SteveF