All Forums Database
john9 30 posts Joined 05/14
05 Nov 2014
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:
05 Nov 2014

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

Satyanarayana

john9 30 posts Joined 05/14
05 Nov 2014

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

john9 30 posts Joined 05/14
06 Nov 2014

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

newtera7 2 posts Joined 01/14
09 May 2015

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.

cfalez 1 post Joined 03/14
18 Sep 2015

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 ...
 

You must sign in to leave a comment.