Archives of the TeradataForum

Message Posted: Fri, 04 Sep 2009 @ 19:12:28 GMT


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

Subj:		Re: mload issues with variable length records

From:		Millar, Timothy

Timothy Millar wrote:

I'm using Multiload Release MLOD.07.08.00.000. and I'm attempting to load a file with variable length single field into a single column in Teradata and having no success. The file was exported from Excel which led me to use FORMAT TEXT

Thanks everyone. The mload finally succeeded when I space-filled the end of each record to make them the same length, then use FORMAT TEXT.

Now I have another issue I'm getting when attempting to mload a pipe-delimited file with approx 5.3 rows:

     UTY0806 RDBMS error, 2825: NO RECORD OF THE LAST REQUEST WAS FOUND AFTER DBC RESTART
     UTY1804 Re-starting this MultiLoad task because The RDBMS crashed.

This error will show up in the Acquisition phase, then Teradata will repeat the Initial phase, then the Acquisition phase then repeat the error, then repeat the Initial phase, and so on, indefinitely. What is causing this error?

Of course the database has not crashed, but the message is generated anyway.

Thanks,

Tim