Fastload - Error on piom GET ROW: 64

Tools
Teradata Employee

Fastload - Error on piom GET ROW: 64

Hello, I hope some one can help me with the following problem.

I have a .txt file on my windows computer I need to import into Teradata. The file is 18 MB in size. It is delimited with comma and every kolom is in between quotes ("). Every record is ended with CR LF.

When I try to import the file I get this error:

**** 16:37:41 Error on piom GET ROW: 64, Text: Quoted data- Column

              missing close quote !ERROR! No corresponding close quote

              for open quote was found. OpenQuoteOffset=65650

              BufferSize=65536 BufferPosition=65518

**** 16:37:41 Error at record number 132052

However, the quotes are correct for this line. If I delete the last line of the file the import goes correct. If I delete some of the first lines (leaving the last line in the file), the import goes correct. Does fastload have an issue with loading files on windows with a certain size?

I have no idea where to look, this error is no where to be found in any documentation.

We are using the Teradata 15, Fastload version 15.0.0.1

Here is my Fastload script:

/***** Login section *****/
.LOGON xxxxx/xxxxx,xxxxx;

/***** Clean-up temporary import tables from last run if they exist *****/
DROP TABLE d0_wrk.IN_wbdata;
DROP TABLE d0_wrk.IN_wbdata_err1;
DROP TABLE d0_wrk.IN_wbdata_err2;

/***** Create temporary import table, fields are imported as VARCHAR *****/
CREATE MULTISET TABLE d0_wrk.IN_wbdata
(
DatumTijd VARCHAR(50),
IPAdres VARCHAR(250),
LAND VARCHAR(250),
BSN VARCHAR(250),
Url VARCHAR(1000),
Host VARCHAR(1000),
BSN_Per_IP VARCHAR(250),
IP_Per_BSN VARCHAR(250)
) NO PRIMARY INDEX;

/***** Prepare Load *****/
BEGIN LOADING
d0_wrk.IN_wbdata
ERRORFILES
d0_wrk.IN_wbdata_err1, d0_wrk.IN_wbdata_err2
CHECKPOINT 10000;

/***** Define which records to load *****/
/* Rem line if all records need to be loaded */
/* RECORD 2 THRU 1000; */

/***** Define file layout *****/
SET RECORD VARTEXT DELIMITER ',' QUOTE OPTIONAL '"';

DEFINE
DatumTijd (VARCHAR(50))
IPAdres (VARCHAR(250))
LAND (VARCHAR(250))
BSN (VARCHAR(250))
Url (VARCHAR(1000))
Host (VARCHAR(1000))
BSN_Per_IP (VARCHAR(250))
IP_Per_BSN (VARCHAR(250))
FILE = C:\Data\data_max.txt;

/***** Insert file into import table *****/
INSERT INTO d0_wrk.IN_wbdata
(
:DatumTijd ,
:IPAdres ,
:LAND ,
:BSN ,
:Url ,
:Host ,
:BSN_Per_IP ,
:IP_Per_BSN
);

/***** End loading *****/
END LOADING;

.LOGOFF;

And this is my logfile with the error:

     ===================================================================
= =
= FASTLOAD UTILITY VERSION 15.00.00.01 =
= PLATFORM WIN32 =
= PID 8996 =
= =
===================================================================

===================================================================
= =
= Copyright 1984-2014, Teradata Corporation. =
= ALL RIGHTS RESERVED. =
= =
===================================================================

**** 16:37:18 Processing starting at: Tue Jul 12 16:37:18 2016

/***** Login section *****/
===================================================================
= =
= Logon/Connection =
= =
===================================================================

0001 .LOGON xxxxxxx/xxxxxxxx,

**** 16:37:19 Teradata Database Release: 15.00.04.04
**** 16:37:19 Teradata Database Version: 15.00.04.04
**** 16:37:19 Number of AMPs available: 144
**** 16:37:19 Current CLI or RDBMS allows maximum row size: 64K
**** 16:37:19 Character set for this job: ASCII

/***** Clean-up temporary import tables from last run if they exist *****/
0002 DROP TABLE d0_wrk.IN_wbdata;

**** 16:37:21 Command completed successfully

0003 DROP TABLE d0_wrk.IN_wbdata_err1;

**** 16:37:21 RDBMS error 3807: Object
'd0_wrk.IN_wbdata_err1' does not exist.

0004 DROP TABLE d0_wrk.IN_wbdata_err2;

**** 16:37:21 RDBMS error 3807: Object
'd0_wrk.IN_wbdata_err2' does not exist.

/***** Create temporary import table, fields are imported as VARCHAR *****/
0005 CREATE MULTISET TABLE d0_wrk.IN_wbdata
(
DatumTijd VARCHAR(50),
IPAdres VARCHAR(250),
LAND VARCHAR(250),
BSN VARCHAR(250),
Url VARCHAR(1000),
Host VARCHAR(1000),
BSN_Per_IP VARCHAR(250),
IP_Per_BSN VARCHAR(250)
) NO PRIMARY INDEX;

**** 16:37:22 Command completed successfully

/***** Prepare Load *****/
0006 BEGIN LOADING
d0_wrk.IN_wbdata
ERRORFILES
d0_wrk.IN_wbdata_err1, d0_wrk.IN_wbdata_err2
CHECKPOINT 10000;

**** 16:37:22 Session count 27 returned by the DBS overrides
user-requested session count
**** 16:37:32 Number of FastLoad sessions connected = 27
**** 16:37:32 FDL4808 LOGON successful
**** 16:37:33 Number of AMPs available: 144
**** 16:37:33 BEGIN LOADING COMPLETE

/***** Define which records to load *****/
/* Rem line if all records need to be loaded */
/* RECORD 2 THRU 1000; */

/***** Define file layout *****/
0007 SET RECORD VARTEXT DELIMITER ',' QUOTE OPTIONAL '"';

**** 16:37:33 Now set to read 'Variable-Length Text' records
**** 16:37:33 Delimiter character(s) is set to ','
**** 16:37:33 Field values are optionally quoted with '"'
**** 16:37:33 Command completed successfully

0008 DEFINE
DatumTijd (VARCHAR(50))
IPAdres (VARCHAR(250))
LAND (VARCHAR(250))
BSN (VARCHAR(250))
Url (VARCHAR(1000))
Host (VARCHAR(1000))
BSN_Per_IP (VARCHAR(250))
IP_Per_BSN (VARCHAR(250))
FILE = C:\Data\data_max.txt;

**** 16:37:33 FDL4803 DEFINE statement processed

/***** Insert file into import table *****/
===================================================================
= =
= Insert Phase =
= =
===================================================================

0009 INSERT INTO d0_wrk.IN_wbdata
(
:DatumTijd ,
:IPAdres ,
:LAND ,
:BSN ,
:Url ,
:Host ,
:BSN_Per_IP ,
:IP_Per_BSN
);

**** 16:37:34 Number of recs/msg: 19
**** 16:37:34 Starting to send to RDBMS with record 1
**** 16:37:34 Sending row 10000
**** 16:37:35 Sending row 20000
**** 16:37:36 Sending row 30000
**** 16:37:36 Sending row 40000
**** 16:37:37 Sending row 50000
**** 16:37:37 Sending row 60000
**** 16:37:38 Sending row 70000
**** 16:37:38 Sending row 80000
**** 16:37:38 Sending row 90000
**** 16:37:39 Sending row 100000
**** 16:37:39 Sending row 110000
**** 16:37:40 Sending row 120000
**** 16:37:40 Sending row 130000
**** 16:37:41 Error on piom GET ROW: 64, Text: Quoted data- Column
missing close quote !ERROR! No corresponding close quote
for open quote was found. OpenQuoteOffset=65650
BufferSize=65536 BufferPosition=65518
**** 16:37:41 Error at record number 132052
===================================================================
= =
= Logoff/Disconnect =
= =
===================================================================

**** 16:37:41 Logging off all sessions
**** 16:37:47 Total processor time used = '2.58962 Seconds'
. Start : Tue Jul 12 16:37:18 2016
. End : Tue Jul 12 16:37:47 2016
. Highest return code encountered = '12'.
**** 16:37:47 FastLoad Paused

4 REPLIES
Teradata Employee

Re: Fastload - Error on piom GET ROW: 64

Hi,

1. Can you let us know the Teradata Data Connector version? This could be obtained by issuing a ".show version;" command using FastLoad.

The version will be followed "Teradata Data Connector  :"

2. Can you send us the data row which caused this error?

**** 16:37:41 Error on piom GET ROW: 64, Text: Quoted data- Column

missing close quote !ERROR! No corresponding close quote

for open quote was found. OpenQuoteOffset=65650

BufferSize=65536 BufferPosition=65518

Thanks!

Teradata Employee

Re: Fastload - Error on piom GET ROW: 64

Hi,

There was a similar issue and it is fixed in Dataconnector 15.00.00.003 and above. Please try to use 15.00.00.003 and above versions of Dataconnector and let us know if there is still issues.

Thanks!

Teradata Employee

Re: Fastload - Error on piom GET ROW: 64

Hi,

Thanks for the quick response!

The version of the Teradata Data Connector is 15.00.00.01. I will get the latest version and retry. Thanks!

Enthusiast

Re: Fastload - Error on piom GET ROW: 64

I believe I encounted this bug even in fastload 15.10, but since upgrading to fastload 16 I have not faced this at all.