Error in fastload.

Database

Error in fastload.

Hello,

 

I have this problem and I can't solve it. Can anyone help me?

 

===================================================================
= =
= FASTLOAD UTILITY VERSION 16.20.00.01 =
= PLATFORM WIN32 =
= PID 7696 =
= =
===================================================================

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

**** 18:22:33 Processing starting at: Sat Jul 28 18:22:33 2018

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

 

**** 18:22:33 Number of AMPs available: 2
**** 18:22:33 Current CLI or RDBMS allows maximum row size: 64K
**** 18:22:33 Character set for this job: ASCII


0002 DATABASE d_dwh_table;

**** 18:22:33 Command completed successfully


0003 CREATE MULTISET TABLE mo_orders10

(
Canal varchar(200),
Subcanal varchar(200),
Tienda varchar(200)
);

**** 18:22:33 Command completed successfully


0004 BEGIN LOADING d_dwh_table.mo_orders10
ERRORFILES d_dwh_table.mo_orders10_ET, d_dwh_table.mo_orde
rs10_UV
CHECKPOINT 2;

**** 18:22:33 Session count 2 returned by the DBS overrides
user-requested session count
**** 18:22:33 Number of FastLoad sessions connected = 2
**** 18:22:33 FDL4808 LOGON successful
**** 18:22:33 RDBMS error 2634: Existing ERROR table(s) or Incorrect
use of mo_orders10 in Fast Load operation.
**** 18:22:33 Delete the Error Tables or fix the BEGIN LOADING statement
===================================================================
= =
= Logoff/Disconnect =
= =
===================================================================

**** 18:22:33 Logging off all sessions
**** 18:22:33 Total processor time used = '0.203125 Seconds'
. Start : Sat Jul 28 18:22:33 2018
. End : Sat Jul 28 18:22:33 2018
. Highest return code encountered = '12'.
**** 18:22:33 FDL4818 FastLoad Terminated

 

Thank you so much.

 

 

1 REPLY
Teradata Employee

Re: Error in fastload.

You can get the Messages manual from info.teradata.com and it tells you what to do:

2634 Existing ERROR table(s) or Incorrect use of %TVMID in Fast Load operation.
Explanation: This error occurs if the table/error table(s) specified either;
(a) existed before the start of the Fast Load, or
(b) did not indicate that it was involved in this specific Fast Load.
... Notes: This error means either that the user has referenced existing tables for the ERRORFILES in a Fast Load that is not restarting, or that incorrect tables were referenced in a restart of a Fast Load.
Remedy: If this is not a restart of a previous Fast Load, delete the referenced error files. If this is a restart, correct the Begin Loading Statement so that the error files are those specified for the original Fast Load.

So, is this a restart of a fast load?  If you think it is not, then try dropping mo_orders10 and the -_ET and -_UV tables also, and try the script again.