Archives of the TeradataForum

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

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

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?

Thanks,

Jesus

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