TPT19003 !ERROR! Delimited Data Parsing error: First character not open quote mark in row 1, col 0

Teradata Applications
New Member

TPT19003 !ERROR! Delimited Data Parsing error: First character not open quote mark in row 1, col 0

Hi,

I'm unable to load the teradata table using TPT load.

Please find the log added below.

 

DEFINE JOB INSERT_SRC_SAMPLE_DATA (
DEFINE SCHEMA SRC_SAMPLE_DATA_SCHEMA
(
SID VARCHAR(11)
,SNAME VARCHAR(8)
,DEPT_ID VARCHAR(11)
,JOINING_DATE VARCHAR(10)
,JOINING_TIME VARCHAR(26)
,TOTAL_EXP VARCHAR(58)
,SALARY VARCHAR(11)
,LOCATION VARCHAR(3)
,EMP_COMMENTS VARCHAR(6)
,GENDER VARCHAR(1)
,EMP_LEVEL VARCHAR(1)
);

DEFINE OPERATOR SRC_SAMPLE_DATA_LOAD
TYPE LOAD
SCHEMA *
ATTRIBUTES
(
VARCHAR UserName = 'devuser',
VARCHAR UserPassword = *****,
VARCHAR LogTable = 'LT_41998_34384_34388',
VARCHAR WorkingDatabase = 'db_dev',
VARCHAR TargetTable = 'E1_SAMPLE_41998'
);

DEFINE OPERATOR SRC_SAMPLE_DATA_SOURCE
TYPE DATACONNECTOR PRODUCER
SCHEMA SRC_SAMPLE_DATA_SCHEMA
ATTRIBUTES
(
VARCHAR FileName = '/app/source/SAMPLE_DATA.csv',
VARCHAR OpenMode = 'Read',
VARCHAR Format = 'DELIMITED',
VARCHAR NullColumns = 'N',
INTEGER ErrorLimit = 1,
VARCHAR TextDelimiter = ','
,INTEGER SkipRows = 1 ,
VARCHAR QuotedData = 'Yes',
VARCHAR OpenQuoteMark = '"',
VARCHAR CloseQuoteMark = '"'
);

APPLY
('
INSERT INTO db_dev.E1_SAMPLE_41998 ( SID,SNAME,DEPT_ID,JOINING_DATE,JOINING_TIME,TOTAL_EXP,SALARY,LOCATION,EMP_COMMENTS,GENDER,EMP_LEVEL ) VALUES ( :SID,:SNAME,:DEPT_ID,:JOINING_DATE (DATE,FORMAT ''YYYY-MM-DD''),:JOINING_TIME (TIMESTAMP(6),FORMAT ''YYYY-MM-DDBHH:MI:SS.S (6)''),:TOTAL_EXP,:SALARY,:LOCATION,:EMP_COMMENTS,:GENDER,:EMP_LEVEL)
')
TO OPERATOR (SRC_SAMPLE_DATA_LOAD )
SELECT case when SID = 'NULL' then NULL else SID end as SID,case when SNAME = 'NULL' then NULL else SNAME end as SNAME,case when DEPT_ID = 'NULL' then NULL else DEPT_ID end as DEPT_ID,case when JOINING_DATE = 'NULL' then NULL else JOINING_DATE end as JOINING_DATE,case when JOINING_TIME = 'NULL' then NULL else JOINING_TIME end as JOINING_TIME,case when TOTAL_EXP = 'NULL' then NULL else TOTAL_EXP end as TOTAL_EXP,case when SALARY = 'NULL' then NULL else SALARY end as SALARY,case when LOCATION = 'NULL' then NULL else LOCATION end as LOCATION,case when EMP_COMMENTS = 'NULL' then NULL else EMP_COMMENTS end as EMP_COMMENTS,case when GENDER = 'NULL' then NULL else GENDER end as GENDER,case when EMP_LEVEL = 'NULL' then NULL else EMP_LEVEL end as EMP_LEVEL FROM OPERATOR (SRC_SAMPLE_DATA_SOURCE );
);

Control script is created successfully.[scriptNm : /app/control/SRC_SAMPLE_DATA419998__LOAD.ctl ]

Command -
tbuild -f /app/control/SRC_SAMPLE_DATA419998__LOAD.ctl -u "
DI_PWD = '*****' ,DI_2PWD = '*****' " -r /app/source/SAMPLE_DATA_419998

Execution terminated while processing command.[Status: Failed][ReturnMsg:Output:
Teradata Parallel Transporter Version 14.00.00.00
Teradata Parallel Transporter DataConnector Version 14.00.00.00
SRC_SAMPLE_DATA_SOURCE: TPT19008 DataConnector Producer operator Instances: 1
SRC_SAMPLE_DATA_SOURCE: TPT19003 ECI operator ID: SRC_SAMPLE_DATA_SOURCE-5353
SRC_SAMPLE_DATA_SOURCE: TPT19222 Operator instance 1 processing file '/app/source/SAMPLE_DATA.csv'.
Teradata Parallel Transporter Load Operator Version 14.00.00.00
SRC_SAMPLE_DATA_LOAD: private log not specified
SRC_SAMPLE_DATA_LOAD: connecting sessions
SRC_SAMPLE_DATA_LOAD: preparing target table
SRC_SAMPLE_DATA_LOAD: entering Acquisition Phase
SRC_SAMPLE_DATA_SOURCE: TPT19350 I/O error on file '/app/source/SAMPLE_DATA.csv'.
SRC_SAMPLE_DATA_SOURCE: TPT19003 !ERROR! Delimited Data Parsing error: First character not open quote mark in row 1, col 0
SRC_SAMPLE_DATA_SOURCE: TPT19221 Total files processed: 0.
SRC_SAMPLE_DATA_LOAD: disconnecting sessions
SRC_SAMPLE_DATA_LOAD: Total processor time used = '0.68 Second(s)'
SRC_SAMPLE_DATA_LOAD: Start : Fri Mar 3 18:59:30 2017
SRC_SAMPLE_DATA_LOAD: End : Fri Mar 3 18:59:41 2017
Job step MAIN_STEP terminated (status 12)
ExitCode:12
]

 

My source data is 

 

ID,NAME,DEPT_ID,JOINING_DATE,JOINING_TIME,TOTAL_EXP,SALARY,LOCATION,COMMENTS,GENDER,LEVEL
1,MANI,20,3/11/2001,9:00:00,,18500,HYD,,M,
2,TONY ,10,1/1/2009,8:30:00,,18000,BLR,,M,
3,KARUNA ,30,7/15/2010,11:00:00,,19000,CHE,,F,
4,RAJ ,10,8/22/2010,14:00:00,,20000,KOL,,M,
5,SURYA,30,6/6/2001,13:30:00,,14000,GUR,,M,
6,PRI YA,40,12/8/2006,14:00:00,,15500,DEL,,M,
7,SNEHA,40,11/1/2007,15:00:00,,25000,HYD,,F,
8,SAI,20,5/7/2016,9:30:00,,17500,MUM,,M,
9,TEJA,20,9/15/2014,13:00:00,,18000,PUN,,F,
10,MANI,40,2/20/2010,14:30:00,,19000,BLR,,M,
11,NI**bleep**H,10,1/2/2010,10:00:00,,16000,MUM,,M,
12,TARUN,20,4/19/2015,8:00:00,,17000,PUN,,M,
13,DI NESH,20,9/3/2013,9:00:00,,22000,KOL,,M,
14,RAKESH,40,6/24/2010,10:00:00,,18000,HYD,,M,
15,SITARA,10,12/25/2014,11:30:00,,17500,KOL,,F,
16,RAMA,30,5/7/2008,9:00:00,,19500,GUR,,F,
17,KARTHIK,40,4/26/2006,9:00:00,,16500,DEL,,M,
18,JAYANTH,40,9/20/2005,10:00:00,,22500,MUM,,M,
19,RAMYA,20,8/7/2003,9:30:00,,21500,HYD,,F,
20,MANVITHA,10,6/12/2002,9:30:00,,20500,BLR,,F,

 

I'm new to teradata and i have tried to find out the issue but couldnot find the issue.

 

Kindly please provide solution to above issue.

 

Thanks in Advance.

 

Regards,

Naveen

1 REPLY
Teradata Employee

Re: TPT19003 !ERROR! Delimited Data Parsing error: First character not open quote mark in row 1, col

QuotedData = 'Yes' means quotes around each field in the input are mandatory. Your data has no quotes, so you need QuotedData='No' (the default) or at least QuotedDate='Optional'.