All Forums Tools
yugeshshrestha 1 post Joined 09/14
11 Sep 2014
Teradata FLOAD error table 1 creates unwanted newlines in Dataparcel data.

I have a fastload utility to load data from txt file into Teradata table. I am trying to get the data from Teradata error table 1 into a structured format in a separate file. But Currently, the data generated from each Data Parcel for each row inserts a new line character after every date type data.
For eg: If my source file has following data
200239|Wk39|200209|October|20023|Quarter3|2002|2002|20 02-10-27|2002-11-02|2002-10-06|2002-11-02|2002-08- 04|2002-11-02||2003-02-01|||||||
The export data from error table generates it into following format.
200239|Wk39|200209|October|20023|Quarter3|2002|2002|20 02-10-27
|2002-11-02
|2002-10-06
|2002-11-02
|2002-08-04
|2002-11-02
||
2003-02-01|||||||
 
I added the delimiters manually using find/repace sed commands.
My query is, what is the way to obtain the data from Fload data parcel as it was in the original source file. Why are these extra new lines being added into the data??
 
 

feinholz 1234 posts Joined 05/08
12 Sep 2014

Please explain what you mean by: "Currently, the data generated from each Data Parcel"?
 
Who is generating the data?
If the source data was in delimited format, then FastLoad will convert that into a series of VARCHAR fields.
Thus, when interpreting the data in the DataParcel field, you need to parse down the data and extract out the 2-byte field length for each fields, followed by the character data. The data in the DataParcel is exactly what we send to Teradata. The data will not have newlines and/or carriage returns. The process extracting out the data will have to add that to the end of each record.
 

--SteveF

SANTOYO09 2 posts Joined 07/14
17 Sep 2014

Hi feinholz ... i have a trouble with TPT 14.10... yesterday i was upgrade the TTU's 13.10 to 14.10 in a linux server.. and when the users rus the comand tbuild they have the next error... :
Teradata Parallel Transporter Version 14.10.00.00
Teradata Parallel Transporter SQL DDL Operator Version 14.10.00.00
DDL_OPERATOR: private log specified: log_ins_LNDCRM_HOGCUP_M
DDL_OPERATOR: connecting sessions
DDL_OPERATOR: The RDBMS retryable error code list was not found
DDL_OPERATOR: The job will use its internal retryable error codes
DDL_OPERATOR: sending SQL requests
DDL_OPERATOR: TPT10508: RDBMS error 3807: Object 'TD_STGEDW.LNDCRM_HOGCUP_M_LOG' does not exist.
DDL_OPERATOR: TPT18046: Warning: error is ignored as requested in ErrorList
DDL_OPERATOR: TPT10508: RDBMS error 3807: Object 'TD_STGEDW.LNDCRM_HOGCUP_M_ERR1' does not exist.
DDL_OPERATOR: TPT18046: Warning: error is ignored as requested in ErrorList
DDL_OPERATOR: TPT10508: RDBMS error 3807: Object 'TD_STGEDW.LNDCRM_HOGCUP_M_ERR2' does not exist.
DDL_OPERATOR: TPT18046: Warning: error is ignored as requested in ErrorList
DDL_OPERATOR: disconnecting sessions
DDL_OPERATOR: Total processor time used = '0.04 Second(s)'
DDL_OPERATOR: Start : Mon Sep 15 13:32:37 2014
DDL_OPERATOR: End : Mon Sep 15 13:32:37 2014
Job step Setup_Tables completed successfully
Teradata Parallel Transporter Load Operator Version 14.10.00.00
LOAD_OPERATOR: private log not specified
Teradata Parallel Transporter FILE_READER: TPT19006 Version 14.10.00.00
FILE_READER: TPT19003 NotifyMethod: 'None (default)'
FILE_READER: TPT19008 DataConnector Producer operator Instances: 1
FILE_READER: TPT19003 ECI operator ID: FILE_READER-6458
FILE_READER: TPT19232 Multi-instance read feature requested via attribute 'MultipleReaders'. Disallowed because file count is > 1 or (#) instances is equal to 1
LOAD_OPERATOR: connecting sessions
LOAD_OPERATOR: The RDBMS retryable error code list was not found
LOAD_OPERATOR: The job will use its internal retryable error codes
LOAD_OPERATOR: preparing target table
LOAD_OPERATOR: entering Acquisition Phase
LOAD_OPERATOR: disconnecting sessions
LOAD_OPERATOR: Total processor time used = '0.16 Second(s)'
LOAD_OPERATOR: Start : Mon Sep 15 13:32:38 2014
LOAD_OPERATOR: End : Mon Sep 15 13:32:40 2014
Job step Load_Table terminated (status 12)
Job 6543 terminated (status 12)
Job start: Mon Sep 15 13:32:35 2014
Job end: Mon Sep 15 13:32:40 2014
[root@mxchkaloatlap01 scripts]# ls
 
Can you help me please to know what happend!!

feinholz 1234 posts Joined 05/08
22 Sep 2014

Whenever you upgrade to a new version of TTU, always go to the patch server and look for the latest patches (inevitably, by the time people get around to upgrading, new patches are available). In fact, usually by the time the release goes GCA, there is already at least one patch on the patch server.
 
In this case, I think we fixed this issue in a patch.
 
Thus, before I can offer suggestions or provide assistance, please upgrade to the latest and greatest patch for TPT 14.10 and re-run the job.
 

--SteveF

You must sign in to leave a comment.