Multiload Error : 2554: Inconsistent situation occurs in restart...

[radhabalan]

RDBMS failure, 2554: Inconsistent situation occurs in restart MLoad??

I got the above error while running MLOAD utility. I dropped all the worktables, error tables, application tables and restarted the MLOAD to run Mload as a new process , but its still giving the same.
Can anyone give an idea about this?.

 

[DaveW16]

Hi, Did you issue the "release mload" command as well ? Regards, Dave

 

[radhabalan]

Hi dave,
Yeah, after dropping the above mentioned tables I issued release MLOAD command too.Actually MLOAD was not active on the target tables.The error number and description is not helping me out to locate where the problem would be.
Thanks,
Raj.

 

[TheTeradataKid]

Multi load has restart capabilities and you have to go to bteq and issue the command
release mload dbase.tablename;
This should do it.

 

[TheTeradataKid]

CALL GLOBAL SUPPORT!

 

[radhabalan]

Hi,
Yeah I found later that's the solution is NCR SUPPORT.....I had to DROP and recreate the target tables again to get rid of the error...

Thanks for the suggestion.

Raj.