TPT logtable

Tools & Utilities
Enthusiast

TPT logtable

In program, we have define clause as like this, but while  execution, it is giving error saying that log table is not there.

Do we need to log table as parameter.?

DEFINE OPERATOR INPUTLAYOUT

TYPE DATACONNECTOR PRODUCER

SCHEMA INPUTLAYOUT

ATTRIBUTES

(

VARCHAR TdpId = @TargetTdpId

,VARCHAR UserName = @TargetUserName

,VARCHAR UserPassword = @TargetUserPassword

,VARCHAR LogTable = 'TPT_TABLES.PUBLIC_AUTOSYS_TPTLOG'

,VARCHAR  FileName = 'cex_shared.dat'

,VARCHAR DirectoryPath = '/home/gssa0/data'

,VARCHAR ErrorTable1       = 'TPT_TABLES.PUBLIC_ERR1'

,VARCHAR ErrorTable2       = 'TPT_TABLES.PUBLIC_ERR2'

,VARCHAR TargetWorkingDatabase = 'TPT_TABLES'

,VARCHAR TargetDatabase        = 'TPT_TABLES'

,VARCHAR TargetTable ='TPT_TABLES.PUBLIC_AUTOSYS_TEMP'

,VARCHAR Format = 'Text'

,VARCHAR OpenMode = 'Read'

,VARCHAR IndicatorMode = 'N'

,VARCHAR PrivateLogName = 'Read'

);

This is the output error messageTeradata Parallel Transporter Version 14.00.00.07

Job log: /opt/teradata/client/14.00/tbuild/logs/cel1_shared-579.out

Job id is cel1_shared-579, running on teraqds4.ca.xxxxxcom

Found CheckPoint file: /opt/teradata/client/14.00/tbuild/checkpoint/cel1_sharedLVCP

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

Teradata Parallel Transporter Load Operator Version 14.00.00.07

$LOAD: private log not specified

Teradata Parallel Transporter INPUTLAYOUT: TPT19006 Version 14.00.00.07

INPUTLAYOUT Instance 1 directing private log report to 'Read-1'.

INPUTLAYOUT: TPT19008 DataConnector Producer operator Instances: 1

INPUTLAYOUT: TPT19003 ECI operator ID: INPUTLAYOUT-11498

INPUTLAYOUT: TPT19222 Operator instance 1 processing file '/home/ptersa0/data/cex_shared.dat'.

$LOAD: TPT10306: Error 5 retrieving attribute 'LogTable'

INPUTLAYOUT: TPT19221 Total files processed: 0.

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

$LOAD: Start : Fri Jul 19 12:40:58 2013

$LOAD: End   : Fri Jul 19 12:40:58 2013

Job step MAIN_STEP terminated (status 12)

Job cel1_shared terminated (status 12)

pls advice.