Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sun, 03 Feb 2008 @ 09:28:55 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: MultiLoad - an unexplainable 'configuration
From:   Christopher Stephens

I've never seen this error before, but I thought the fourth possibility provided by the Messages manual was interesting:

This error occurs when an internal consistency check fails. The possible inconsistency are:

1) Session status not in order

2) MLoad phase status not in order

3) MLoad state status not in order

4) _Target table is in MLoad state but WorkTable is missing_

That scenario happens all the time at our site - people dropping work tables but not the log table and trying to restart after an error. Maybe the error tables must exist for this error to be thrown?

I'm with Victor - RELEASE MLOAD using BTEQ; drop the log, error, and work tables; run your script again.

- Chris

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