Posted: Wed Feb 09, 2011 1:42 am
Hi,
Where did you find this error? In the Director or in the report file. Always check the report file for Multiload errors.
Also when you re-start the job you have to drop all the temp tables that would be created for each multiload session like log, UV, err and work tables. Then issue the command RELEASE MLOAD <table_name>
I always load the data using Teradata API stage and if the load is successful then replace with the Teradata Multiload stage.
Also do a search, I think this was discussed earlier.
HTH
--Rich
Where did you find this error? In the Director or in the report file. Always check the report file for Multiload errors.
Also when you re-start the job you have to drop all the temp tables that would be created for each multiload session like log, UV, err and work tables. Then issue the command RELEASE MLOAD <table_name>
I always load the data using Teradata API stage and if the load is successful then replace with the Teradata Multiload stage.
Also do a search, I think this was discussed earlier.
HTH
--Rich