Archives of the TeradataForum

Message Posted: Fri, 06 Jul 2012 @ 15:22:47 GMT

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

Hi Sughesh,

For Mload

Below are the things u need to do if it fails.

1) Resolve the error because of which it has failed mainly it will be data type or field mismatch issue.

2) Drop the log table and error tables if created.

3) Release the mload on table(in apply, forcefully), if its acquisition phase.

4) restart the job of mload or submit the mload again

For Fload

Below u have to do if it fails,

1) Find the issue of failure and correct it by seeing in the type of ET table

2) Drop the table and recreate it, as we can't release the FLOAD locks on table.

3) drop the ET table.

ET 1 stores data if format is not correct

ET2 if the data voilates the UPI

4) Make sure u have dropped all the RI constraints on the loading table and loading table is empty.

5) Restart the Fload job or submit the Fload again.

Thanks,

Pawan Kumar Verma

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