TPT error

Database
Enthusiast

TPT error

Hi All -

I have worked on Mload,Fload and Fastexport utilities and i am bit new to TPT .I am trying to unload data from one server to another sever using TPT but i am getting some error as below

$ tbuild -f MOVE_DATA.txt -v jobvars.txt

Teradata Parallel Transporter Version 14.10.00.02

TPT_INFRA: Syntax error at or near line 7 of Job Script File 'MOVE_DATA.txt':

TPT_INFRA: At "ID" missing RPAREN_ in Rule: Explicit Schema Element List

TPT_INFRA: Syntax error at or near line 9 of Job Script File 'MOVE_DATA.txt':

TPT_INFRA: TPT03020: Rule: DEFINE SCHEMA

Compilation failed due to errors. Execution Plan was not generated.

Job script compilation failed.

Job terminated with status 8.

Not sure where i am going wrong ...could any one please help to resolve this...below is my script...

DEFINE JOB MOVE_DATA

DESCRIPTION 'MOVE DATA WITHOUT LANDING THE DATA TO DISK'

(

DEFINE SCHEMA DUMMY_SCHEMA

DESCRIPTION 'SAMPLE DUMMY SCHEMA'

(

ID INTEGER,

NAME CHAR(6)

);

DEFINE OPERATOR EXPORT_OPERATOR ()

DESCRIPTION 'TERADATA PARALLEL TRANSPORTER EXPORT OPERATOR'

TYPE EXPORT

SCHEMA DUMMY_SCHEMA

ATTRIBUTES (

VARCHAR PrivateLogName = 'exportoper_privatelog',

INTEGER MaxSessions = 8,

INTEGER MinSessions = 1,

VARCHAR TdpId = @SourceTdpId,

VARCHAR UserName = @SourceUserName,

VARCHAR UserPassword = @SourceUserPassword,

VARCHAR SelectStmt = 'SELECT * FROM DUMMY;'

);

DEFINE OPERATOR LOAD_OPERATOR ()

DESCRIPTION 'TERADATA PARALLEL TRANSPORTER LOAD OPERATOR'

TYPE LOAD

SCHEMA DUMMY_SCHEMA

ATTRIBUTES (

VARCHAR PrivateLogName = 'loadoper_privatelog',

INTEGER MaxSessions = 16,

INTEGER MinSessions = 1,

VARCHAR TargetTable = 'DUMMY_TPT',

VARCHAR TdpId = @TargetTdpId,

VARCHAR UserName = @TargetUserName,

VARCHAR UserPassword = @TargetUserPassword,

VARCHAR ErrorTable1 = 'LOADOPER_ERRTABLE1',

VARCHAR ErrorTable2 = 'LOADOPER_ERRTABLE2',

VARCHAR LogTable = 'LOADOPER_LOGTABLE'

);

APPLY ('INSERT INTO DUMMY_TPT (:ID, :NAME);')

TO OPERATOR (LOAD_OPERATOR [1]) SELECT * FROM OPERATOR (EXPORT_OPERATOR [2]);

);

Thank you all ....!!

Tags (1)
5 REPLIES
Enthusiast

Re: TPT error

Guessing ---  'ID' is being considered as keyword and so it is failing. Can you check by making it with different name if it works.

Enthusiast

Re: TPT error

Hi satya -

I Cahnged the column name to ACCT and i am getting below error...

Teradata Parallel Transporter Version 14.10.00.02

TPT_INFRA: Syntax error at or near line 7 of Job Script File 'MOVE_DATA.txt':

TPT_INFRA: At ","; "," not in { LPAREN_ SEMICOL_ ALLOW_ APPLY_ ATTR_ ATTRIBUTES_ DEBUG_ DISALLOW_ EXTERNAL_ INSERT_ INFO_ INTERFACE_ LIBRARY_ MSGCATALOG_ NOINFO_ NOT_ NODEBUG_ NOTRACE_ OUTPUT_ RESTARTABLE_ SELECT_ SOURCE_ TRACE_ REGULAR_IDENTIFIER_ EXTENDED_IDENTIFIER_ EXTENDED_IDENTIFIER_NO_N_ } in Rule: Column Definition

TPT_INFRA: Syntax error at or near line 8 of Job Script File 'MOVE_DATA.txt':

TPT_INFRA: At "NAME" missing { REGULAR_IDENTIFIER_ EXTENDED_IDENTIFIER_ EXTENDED_IDENTIFIER_NO_N_ } in Rule: Regular Identifier

TPT_INFRA: Syntax error at or near line 8 of Job Script File 'MOVE_DATA.txt':

TPT_INFRA: TPT03022: Rule: Column Definition

Compilation failed due to errors. Execution Plan was not generated.

Job script compilation failed.

Job terminated with status 8.

Any suggestions ...please

Thank you

Enthusiast

Re: TPT error

I am able to run the script successfully ...thank you all

Re: TPT error

How did u resolve this..i have the same error..

Teradata Parallel Transporter Version 14.10.00.05

TPT_INFRA: Syntax error at or near line 13 of Job Script File 'MERCHANT_BILLS.ctl':

TPT_INFRA: At ","; "," not in { LPAREN_ SEMICOL_ ALLOW_ APPLY_ ATTR_ ATTRIBUTES_ DEBUG_ DISALLOW_ EXTERNAL_ INSERT_ INFO_ INTERFACE_ LIBRARY_ MSGCATALOG_ NOINFO_ NOT_ NODEBUG_ NOTRACE_ OUTPUT_ RESTARTABLE_ SELECT_ SOURCE_ TRACE_ REGULAR_IDENTIFIER_ EXTENDED_IDENTIFIER_ EXTENDED_IDENTIFIER_NO_N_ } in Rule: Column Definition

TPT_INFRA: Syntax error at or near line 14 of Job Script File 'MERCHANT_BILLS.ctl':

TPT_INFRA: At "DESCRIPTION" missing { REGULAR_IDENTIFIER_ EXTENDED_IDENTIFIER_ EXTENDED_IDENTIFIER_NO_N_ } in Rule: Regular Identifier

TPT_INFRA: Syntax error at or near line 14 of Job Script File 'MERCHANT_BILLS.ctl':

TPT_INFRA: TPT03022: Rule: Column Definition

Compilation failed due to errors. Execution Plan was not generated.

Job script compilation failed.

Job terminated with status 8.

N/A

Re: TPT error

Hello,

i had the same error with a column named "DESCRIPTION".

I changed it in "DESCR" and it works ! So we could consider that it is a keyword and you can not use it in tpt ...