 |
 |
Archives of the TeradataForum
Message Posted: Mon, 26 May 2003 @ 18:38:01 GMT
| Subj: | | Core dump using Multiload |
| |
| From: | | Adriano Ferreira |
While loading data into some very small tables, we are finding an error that terminates in a core dump. The layout is the simplest
(codes and description), the file seems to be allright. Would someone have a clue of what's going on?
Thanks very much,
Adriano.
**** 16:14:35 UTY2414 BRIEF option is enabled.
---------------------------------------------------------------
- MultiLoad Utility Release MLOD.07.03.00 -
---------------------------------------------------------------
**** 16:14:35 UTY2411 Processing start date: MON MAY 26, 2003
---------------------------------------------------------------
- Logon/Connection -
---------------------------------------------------------------
0001 /* ----------------------------------------------------------
Datawarehouse Project
SCRIPT ID :dw0033020
JOB ID :dw0033
FUNCTION :Multiload Script
FINAL TABLE(S) :Secao_Produto
ASSUMPTIONS :
VER DATE WHO COMMENTS
---------------------------------------------------------- */
.RUN FILE /work/pxtdw/logon/root;
0002 .LOGON SysDBA,;
**** 16:14:35 UTY6214 Reminder: A .Logtable statement must be entered
for a successful logon.
0003 .LOGTABLE TempDB.dw0033_mllog;
**** 16:14:35 UTY8400 Maximum supported buffer size: 64K
**** 16:14:35 UTY8400 Default character set: ASCII
**** 16:14:35 UTY6211 A successful connect was made to the RDBMS.
**** 16:14:35 UTY6210 Logtable 'TempDB.dw0033_mllog' indicates that a
restart is in progress.
0004 .BEGIN IMPORT MLOAD
TABLES
Peixoto_Data.Secao_Produto
WORKTABLES
TempDB.dw0033_mlwt
ERRORTABLES
TempDB.dw0033_mlet
TempDB.dw0033_mluv
ERRLIMIT 50
SESSIONS 30
TENACITY 2;
---------------------------------------------------------------
- Processing MultiLoad Statements -
---------------------------------------------------------------
0005 .LAYOUT INPUTLAYOUT;
0006 .FIELD IN_Cod_Departamento * CHAR( 2 );
0007 .FIELD IN_Cod_Secao * CHAR( 3 );
0008 .FIELD IN_Des_Secao * CHAR( 50 );
0009 .FIELD IN_EOL * CHAR( 1 );
0010 .DML LABEL INSERTS DO INSERT FOR MISSING UPDATE ROWS;
0011 UPDATE Peixoto_Data.Secao_Produto
SET Des_Secao = :IN_Des_Secao
WHERE Cod_Secao = :IN_Cod_Secao
AND Cod_Departamento = :IN_Cod_Departamento
;
0012 INSERT INTO Peixoto_Data.Secao_Produto
(
Cod_Secao
,Cod_Departamento
,Des_Secao
) VALUES (
:IN_Cod_Secao
,:IN_Cod_Departamento
,:IN_Des_Secao
);
0013 .IMPORT INFILE /work/pxtdw/dev/data/temp/DW/dw0033.dat
FORMAT UNFORMAT
LAYOUT INPUTLAYOUT
APPLY INSERTS;
0014 .END MLOAD;
---------------------------------------------------------------
- MultiLoad Initial Phase -
---------------------------------------------------------------
**** 16:14:35 UTY0829 Options in effect for this MultiLoad import task:=
. Sessions: 30 session(s).
. Checkpoint: 15 minute(s).
. Tenacity: 2 hour limit to successfully connect load sessions.
. Errlimit: 50 rejected record(s).
. AmpCheck: In effect for apply phase transitions.
**** 16:14:35 UTY0823 Restart in progress, processing for this MultiLoad
task has already been completed.
**** 16:14:35 UTY0684 Invalid size from memory address 135045888.
UTY667 *** Size detected 0 bytes ***
**** 16:14:35 UTY0676 Invalid Data Entry Block =E1=01.
Abort - core dumped
Adriano Rodrigues Ferreira
Analista de Sistemas
Metodologia e Controle de Processos/Tecnologia da Informa��o
Peixoto Ind. Com. Trans. e Serv. Ltda
| |
