tbuild fails to proceed after "$LOAD: Warning: The job will use its internal retryable error"

Teradata Applications
Highlighted

tbuild fails to proceed after "$LOAD: Warning: The job will use its internal retryable error"

Hi, 

I'm trying to upload pipe delimited files to TD tables using tdload and, in this case, tbuild. On my other post I detail the issues surrounding tdload. I'm now experiencing those same issues with tbuild and scripts.

I'm using TD's sample files here, modified with my own data, and I'm still getting the error. The goal is to run two jobs, qsetup and qstart which will drop/create tables and upload the contents of a dummy flat file (flatfile.dat) to the newly created table. What's odd about this is that creating and deleting the tables works perfectly, but when I try to load the data into the table, nothing happens at all. Below is the output from running (after the qsetup file) C:\MyDir> tbuild -f qstart.txt -v jobvars.txt -j qstart 

C:\MyDir>tbuild -f qstart.txt -v jobvars.txt -j qstart
Teradata Parallel Transporter Version 15.10.01.05 64-Bit
Job log: C:\Program Files\Teradata\client\15.10\Teradata Parallel Transporter/logs/qstart-54.out
Job id is qstart-54, running on W00409574
Found CheckPoint file: C:\Program Files\Teradata\client\15.10\Teradata Parallel Transporter/checkpoint\qstartLVCP
This is a restart job; it restarts at step MAIN_STEP.
Teradata Parallel Transporter Load Operator Version 15.10.01.05
Teradata Parallel Transporter DataConnector Operator Version 15.10.01.05
$LOAD: private log specified: loadprivate.log
$FILE_READER[1]: Instance 1 directing private log report to 'dtacop-username-10136-1'.
$FILE_READER[1]: DataConnector Producer operator Instances: 1
$FILE_READER[1]: ECI operator ID: '$FILE_READER-10136'
$FILE_READER[1]: Operator instance 1 processing file 'flatfile.dat'.
$LOAD: connecting sessions
$LOAD: Warning: The job will use its internal retryable error

And here, nothing happens. CMD just gives me a flashing cursor.  

Here are the contents of the files relating to the job I'm trying to do:

jobvars.txt 

TargetTdpId = 'TPID'
,TargetUserName = 'USER'
,TargetUserPassword = 'PASS'
,TargetLogonMech = 'LDAP'
,TargetWorkingDatabase = 'DB'
,DDLPrivateLogName = 'ddlprivate.log'
,LoadPrivateLogName = 'loadprivate.log'
,TargetErrorList = ['3807']
,TargetTable = 'DB.TABLE'
,LogTable = 'DB.TABLE_LOG'
,ErrorTable1 = 'DB.TABLE_E1'
,ErrorTable2 = 'DB.TABLE_E2'
,SourceFileName = 'flatfile.dat'
,SourceFormat = 'delimited'
,SourceTextDelimiter = '|'
,OpenMode = 'read'

 

qsetup.txt (this one works):

 

/**************************************************************/
/* Script Name: qsetup.txt */
/* Description: This Teradata Parallel Transporter sample */
/* script creates an empty target table. */
/**************************************************************/
/* Required customizations before running this script: */
/* */
/* Inside the file "jobvars.txt", modify the values: */
/* TargetTdpId: Name of target Teradata system */
/* TargetUserName: Username on target Teradata system */
/* TargetUserPassword: Password on target Teradata system */
/**************************************************************/
/* Execution: */
/* tbuild -f qsetup.txt -v jobvars.txt -j qsetup */
/**************************************************************/

DEFINE JOB qsetup
(
APPLY
('DROP TABLE DB.TABLE;')
,('DROP TABLE DB.TABLE_LOG;')
,('DROP TABLE DB.TABLE_E1;')
,('DROP TABLE DB.TABLE_E2;')
,('CREATE TABLE DB.TABLE(EMP_ID VARCHAR(10), EMP_NAME VARCHAR(10));')
TO OPERATOR ($DDL);
);


qstart (the job that won't finish processing):

 

/**************************************************************/
/* Script Name: qstart.txt */
/* Description: This Teradata Parallel Transporter (TPT) */
/* script reads data from a delimited file and */
/* loads into an empty Teradata target table. */
/**************************************************************/
/* Required customizations before running this script: */
/* */
/* Inside the file "jobvars.txt", modify the values: */
/* TargetTdpId: Name of target Teradata system */
/* TargetUserName: Username on target Teradata system */
/* TargetUserPassword: Password on target Teradata system */
/**************************************************************/
/* Execution: */
/* tbuild -f qstart.txt -v jobvars.txt -j qstart */
/**************************************************************/

DEFINE JOB qstart
(
APPLY $INSERT TO OPERATOR ($LOAD)
SELECT * FROM OPERATOR($FILE_READER);
);



So after running qsetup (sucessfully), when I run qstart I can't get any further than the $LOAD warning. 

What I've tried so far:
- Placed and run files in different directories (network and local) - same result

- Removed restart/checkpoint files - same result

- Removed fully qualified DB paths from jobvars.txt - upload then FAILS and I get a message that says "no more room in database MYUSERNAME" (my username and an underscore proceedes all of my tables in the DB) - this will end the job 
- Various combinations of the above - none end with the desired result.

Any thoughts on this?