Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 20 Sep 2007 @ 12:37:22 GMT

  <Prev Next>  
Next> Last>>  

Subj:   MultiLoad Delete Failure 2554
From:   Albarran Ordas, Jesus

Hi All,

I am trying to run a MultiLoad delete, but I get the following error message:

     UTY0805 RDBMS failure, 2554: Inconsistent situation occurs
             in restart MLoad - Suspended Delete MLoad on same
             Target table, different Work/Error table(s)

The code that I am running is:

     .Logtable PROD_U.FT_EVENT_LOG;

     .Begin Delete Mload Tables PROD_T.FT_EVENT
                  ErrorTables PROD_U.FT_EVENT_E2
                  WorkTables PROD_U.FT_EVENT_W;

     delete from PROD_T.FT_EVENT_00 where Date <
          upper(cast(cast((current_date - 60) as FORMAT 'YYYY-MM-DD') as
     char(10))) ;

     End Mload;

It has been working fine until yesterday, when I changed to delete the rows older than 60 instead of 32 days. I have 2 different environment and only in one of them is failing, when both should have exactly the same configuration.

Does anybody knows what can be the reason and how can I solve it?



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