Archives of the TeradataForum

Message Posted: Tue, 09 Dec 2008 @ 23:09:09 GMT

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

No disrespect intended, but you should probably seek some onsite tutelage. These are rather basic errors and you are not providing much information - as such the best you will get is generic answers. Is there someone at your site that can review your load script, data file and table definition? If not, perhaps post them here and it is possible that someone may be willing to review them for you.

In simple terms, the message you supplied below means that all of the records in your input file don't match the layout of the table you are trying to load into. This could be for any number of reasons (hence my suggestion to get someone to review your script, data file and table definition).

For example if you told multiload that the fields are a date, integer and a character, but your input file contains a character, date and an integer you will get this error.

Having said that it is likely that the error is more subtle than that, for example do you have the right record type (text, fastload etc?). If using a text format are you taking into consideration end of line characters? If a binary format (e.g. fastload) how did you generate it? Did you specify fixed length fields, but supply variable (e.g. comma delimited)?

Have you correctly aligned the values in the file with variables in the load and aligned them correctly with the columns in the table/insert statement?

Are your date formats correct (e.g. dd-mm-yyyy, but the table is defined as yyyy/mm/dd)?

The list goes on.

You should look at the contents of the error tables. These will give you an indication of the problem and an error code which you can look up in the messages reference manual.

Hope this helps.

Glenn Mc

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