Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 26 May 2003 @ 18:38:01 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


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



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023