Teradata Fastload has stopped working

Tools

Teradata Fastload has stopped working

Hi,

I'm testing the Fastload utility. But I received a pop-up message at the end of the process,

"Teradata Fastload has stopped working.  A problem caused the program to stop wroking correctly. Windows will close the program and notify you if a solution is available."

The scipt I used is:

SESSIONS 5; 
TENACITY 5;
SLEEP 5;
ERRLIMIT 50;
.logon xxxxx/yyyyy,zzzzzz;
DROP TABLE p_kocac_t.fastload_test;

create table p_kocac_t.fastload_test
(
Year_Week_Number char(15),
Relative_Week char(15),
Hierarchy_Code char(15),
Daily_Target char(15))
unique primary index(Year_Week_Number ,Relative_Week, Hierarchy_Code);

DROP TABLE p_kocac_t.fastload_test_ET;
DROP TABLE p_kocac_t.fastload_test_UV;

.SET RECORD VARTEXT "|";

DEFINE
Year_Week_Number (VARCHAR(15)),
Relative_Week (VARCHAR(15)),
Hierarchy_Code (VARCHAR(15)),
Daily_Target (VARCHAR(15))

FILE=data.csv;

SHOW;
BEGIN LOADING p_kocac_t.fastload_test ERRORFILES p_kocac_t.fastload_test_ET , p_kocac_t.fastload_test_UV
CHECKPOINT 1000;
INSERT INTO p_kocac_t.fastload_test VALUES(
:Year_Week_Number,
:Relative_Week,
:Hierarchy_Code,
:Daily_Target);

END LOADING;
.LOGOFF;
.QUIT;

In file "data.csv", there is only one record for testing purpose:

Year_Week_Number|Relative_Week|Hierarchy_Code|Daily_Target

 And here is the log:

     ===================================================================
     =                                                                 =
     =          FASTLOAD UTILITY     VERSION 13.10.00.003              =
     =          PLATFORM WIN32                                         =
     =                                                                 =
     ===================================================================

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

**** 09:19:19 Processing starting at: Wed Aug 21 09:19:19 2013

0001 SESSIONS 5;

**** 09:19:19 FDL4866 SESSIONS command accepted

0002 TENACITY 5;

**** 09:19:19 Tenacity Enabled:  5 hour(s)

0003 SLEEP 5;

**** 09:19:19 Sleep Minutes Set: 5 minute(s)

0004 ERRLIMIT 50;

**** 09:19:19 Error limit set to: 50

     ===================================================================
     =                                                                 =
     =          Logon/Connection                                       =
     =                                                                 =
     ===================================================================

0005 .logon xxxxx/yyyyy,

**** 09:19:25 Teradata Database Release: 14.00.03.503
**** 09:19:25 Teradata Database Version: 14.00.03.502
**** 09:19:25 Current CLI or RDBMS allows maximum row size: 64K
**** 09:19:25 Character set for this job: ASCII

0006 DROP TABLE p_kocac_t.fastload_test;

**** 09:19:38 Command completed successfully

0007 create table p_kocac_t.fastload_test
     (
     Year_Week_Number char(15),
     Relative_Week char(15),
     Hierarchy_Code char(15),
     Daily_Target char(15))
     unique primary index(Year_Week_Number ,Relative_Week, Hierarchy_Code);

**** 09:19:44 Command completed successfully

0008 DROP TABLE p_kocac_t.fastload_test_ET;

**** 09:19:50 Command completed successfully

0009 DROP TABLE p_kocac_t.fastload_test_UV;

**** 09:20:03 Command completed successfully

0010 .SET RECORD VARTEXT "|";

**** 09:20:03 Now set to read 'Variable-Length Text' records
**** 09:20:03 Delimiter character(s) is set to '|'
**** 09:20:03 Command completed successfully

0011 DEFINE
     Year_Week_Number (VARCHAR(15)),
     Relative_Week (VARCHAR(15)),
     Hierarchy_Code (VARCHAR(15)),
     Daily_Target (VARCHAR(15))
    
     FILE=data.csv;

**** 09:20:03 FDL4803 DEFINE statement processed

 And then a error message box pop up, "Teradata Fastload has stopped working....."

And if I want to select table p_kocac_t.fastload_test, I get the feedback "operation not allowed, p_kocac_t.fastload_test is being loaded".

Is there anyone who met the similar issue? 

Any advice?

Regards,

Eminent

5 REPLIES
Teradata Employee

Re: Teradata Fastload has stopped working

Increase the size of your VARCHAR fields.

The first field was defined as VARCHAR(15) but has 16 bytes.

(There may be a coredump issue we are unaware of?)

-- SteveF
Teradata Employee

Re: Teradata Fastload has stopped working

Eminent,

Make sure that the dependencies (tdcli, cliv2, piom) are installed correctly on your machine and run your script again.

If it still does not work, run fastload with "show versions;" command, then post what it displays.

Thomas

Re: Teradata Fastload has stopped working

Thanks Feinholz.  I've changed the data.csv to make each column <= 15 bytes and run the tool again, but received same error message.

Thanks Thomas.  I went to the download center, but didn't find the same version as my current tools, then I pick clv2: 13.10.00.14

when installing, it said it would upgrade current setting and I clicked continue.  So it seems old version cliv2 existed previously.

and here is the log with show versions command:

0006 show versions;

     FastLoad Version 13.10.00.003 for Win 32 running Windows Sockets
     FastLoad  : 13.10.00.16
     FastCmds  : 13.10.00.12
     FastIO    : 13.10.00.04
     FastMBCS  : 13.00.00.02
     FastNtfy  : 13.01.00.00
     FastPars  : 13.10.00.00
     FastSQL   : 13.10.00.16
     FastUtil  : 13.10.00.04
     Fdlosdep  : 13.01.00.00
     Teradata Data Connector  : 13.10.00.002
     PMPROCS   : 13.10.00.07
     PMRWFMT   : 13.10.00.06
     PMTRCE    : 13.10.00.02
     PMMM      : 13.00.00.01
     PMHEXDMP  : 13.10.00.01
     PMUNXDSK  : 13.10.00.08
     ICUVER    : TDICU, 13.10.00.01
     CLIV2     : 13.10.00.33
     MTDP      : 13.10.00.26
     MOSIos    : 13.10.00.16
     MOSIDEP   : 13.10.00.13
     OSENCRYPT : N/A
     OSERR     : 13.10.00.01

     FastLoad linking date: Jul 13 2010

And saddly it ends up with error as well.  Just one more question, what's piom?

Regards,

Eminent

Teradata Employee

Re: Teradata Fastload has stopped working

Eminent,

PIOM is Data Connector.

I suspect the problem is related to the environment and/or your Windows system, sometimes it's due drivers or other applications on your machine.

If you google search "has stopped working.  A problem caused the program to stop wroking correctly" you see discussions about it.

I tried your script on my Windows machine, It works fine.

I suggest you install FastLoad and its dependencies on another Windows machine and see if it it works for you.

Good luck!

Thomas

Re: Teradata Fastload has stopped working

Thanks Thomas!

And here comes the good news. I finally loaded the data into database after I ungraded the utility to version 14.

0006 show versions;

     FastLoad Version 14.10.00.03 for Win 32 running Windows Sockets
     FastLoad  : 14.10.00.10
     FastCmds  : 14.10.00.15
     FastIO    : 14.10.00.00
     FastMBCS  : 14.10.00.00
     FastNtfy  : 14.10.00.01
     FastPars  : 14.10.00.06
     FastSQL   : 14.10.00.30
     FastUtil  : 14.10.00.03
     Fdlosdep  : 13.01.00.00
     Teradata Data Connector  : 14.10.00.00
     PMPROCS   : 14.10.00.10
     PMRWFMT   : 14.10.00.01
     PMTRCE    : 13.10.00.02
     PMMM      : 13.00.00.01
     PMUDDI    : 14.10.00.06
     DCUDDI    : 14.10.00.12
     PMHEXDMP  : 14.10.00.00
     PMUNXDSK  : 14.10.00.07
     ICUVER    : TDICU, 14.10.00.00
     CLIV2     : 14.10.00.33
     MTDP      : 14.10.00.27
     MOSIos    : 14.10.00.08
     MOSIDEP   : 14.10.00.06
     OSENCRYPT : N/A
     OSERR     : 14.00.00.00

     FastLoad linking date: Mar 13 2013

 Regards,

Eminent