Teradata FLOAD error table 1 creates unwanted newlines in Dataparcel data.

Tools

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|2002-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|2002-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??

3 REPLIES
Teradata Employee

Re: Teradata FLOAD error table 1 creates unwanted newlines in Dataparcel data.

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

Re: Teradata FLOAD error table 1 creates unwanted newlines in Dataparcel data.

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!!

Teradata Employee

Re: Teradata FLOAD error table 1 creates unwanted newlines in Dataparcel data.

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