Archives of the TeradataForum
Message Posted: Thu, 20 Sep 2007 @ 12:37:22 GMT
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|