After TTU upgrade from 13 to 14 on unix, same tpt script is failing with below error which was running fine with earlier version
Script exports data from table to a pipe delimited file
Note: script runs fine if table has less records , say lesser than 500 records , but if same sript runs with 1000 records it fails
FILE_WRITER: TPT19003 Number of characters in column 20 (65537) exceeds maximum allowed (65536)
tbuild -f tptscript -v exportjobvar.txt jobname
Below is the tpt script:
DEFINE JOB EXPORT_FROM_TABLE_TO_FILE
DESCRIPTION 'EXPORT DATA FROM A TABLE TO FILE'
DEFINE SCHEMA TABLE_SCHEMA
DESCRIPTION 'TABLE SCHEMA'
DEFINE OPERATOR FILE_WRITER()
DESCRIPTION 'TERADATA PARALLEL TRANSPORTER DATA CONNECTOR OPERATOR'
TYPE DATACONNECTOR CONSUMER
VARCHAR PrivateLogName = @Filewriterlog,
VARCHAR FileName = @FileName,
VARCHAR OpenMode = 'Write',
VARCHAR Format = 'Delimited',
VARCHAR TextDelimiter = '|'
DEFINE OPERATOR EXPORT_OPERATOR()
DESCRIPTION 'TERADATA PARALLEL TRANSPORTER EXPORT OPERATOR'
VARCHAR PrivateLogName = @exportop,
INTEGER MaxSessions = 32,
INTEGER MinSessions = 1,
VARCHAR UserName = 'user',
VARCHAR UserPassword = 'pwd',
APPLY TO OPERATOR (FILE_WRITER()  )
SELECT * FROM OPERATOR (EXPORT_OPERATOR()  );
What is the exact version number of TPT you are running (I need the patch number)?
(And while I research this, if you could upgrade to the latest and greatest patch for TPT 14.00, and retry your job, that would help.)
Thanks, Yes looks like i need to upgrade to latest verion of TPT , Currently we are at 14.00.00.03 ,Which version do you recomend and from where can i get it?
Always download and install the latest patches for all packages of TPT.
They are located on the patch server, probably accessing through Teradata At Your Service.