TPT19003 Number of characters in column 20 (65537) exceeds maximum allowed (65536)

Tools & Utilities

TPT19003 Number of characters in column 20 (65537) exceeds maximum allowed (65536)

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

 Error:

FILE_WRITER: TPT19003 Number of characters in column 20 (65537) exceeds maximum allowed (65536)

Tbuild command:

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'
   (
INCLUDE @inschema;
   );

   DEFINE OPERATOR FILE_WRITER()
   DESCRIPTION 'TERADATA PARALLEL TRANSPORTER DATA CONNECTOR OPERATOR'
   TYPE DATACONNECTOR CONSUMER
   SCHEMA TABLE_SCHEMA
   ATTRIBUTES
   (
      VARCHAR PrivateLogName    = @Filewriterlog,
      VARCHAR FileName          = @FileName,
      VARCHAR OpenMode          = 'Write',
      VARCHAR Format            = 'Delimited',
      VARCHAR TextDelimiter     = '|'
   );

   DEFINE OPERATOR EXPORT_OPERATOR()
   DESCRIPTION 'TERADATA PARALLEL TRANSPORTER EXPORT OPERATOR'
   TYPE EXPORT
   SCHEMA TABLE_SCHEMA
   ATTRIBUTES
   (
      VARCHAR PrivateLogName    = @exportop,
      INTEGER MaxSessions       =  32,
      INTEGER MinSessions       =  1,
      VARCHAR UserName          = 'user',
      VARCHAR UserPassword      = 'pwd',
      VARCHAR AccountId,
                        INCLUDE @selschema;
   );

   STEP EXPORT_2_FILE
   (
      APPLY TO OPERATOR (FILE_WRITER() [1] )
      SELECT * FROM OPERATOR (EXPORT_OPERATOR() [1] );
   );

);
3 REPLIES
Teradata Employee

Re: TPT19003 Number of characters in column 20 (65537) exceeds maximum allowed (65536)

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

-- SteveF

Re: TPT19003 Number of characters in column 20 (65537) exceeds maximum allowed (65536)

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?

Teradata Employee

Re: TPT19003 Number of characters in column 20 (65537) exceeds maximum allowed (65536)

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.

-- SteveF