All Forums Tools
MukhtarMohammed 2 posts Joined 05/15
18 May 2015
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] );
   );

);

 

feinholz 1234 posts Joined 05/08
19 May 2015

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

MukhtarMohammed 2 posts Joined 05/15
19 May 2015

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?

feinholz 1234 posts Joined 05/08
20 May 2015

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

You must sign in to leave a comment.