Page 1 of 1
Error while loading in Teradata table
Posted: Tue Dec 04, 2007 2:36 am
by shaonli
Hi,
In my job data is getting loaded from dataset to teradata table with load utility Multiload.
The job is getting aborted due to this error "Fatal Error: Fatal: Unable to start MultiLoad process : MultiLoad failed:"
I am not able to get anything from this message.
If anyone from you have faced this error please suggest.
Thanks
shaonli
Re: Error while loading in Teradata table
Posted: Tue Dec 04, 2007 3:15 am
by Govindarajan
Try to drop the teradata error tables and log table and restart the job. The error table has not been dropped due to previous abort.
Posted: Tue Dec 04, 2007 3:57 am
by shaonli
I looked into the MultiLoad report.There I found this statement
=========================
0003 drop table ABC.ET_ABC;
**** 23:13:58 UTY1008 RDBMS failure: 3807, Object ABC.ET_ABCdoes not exist.
0004 drop table ABC.UV_ABC
**** 23:13:58 UTY1008 RDBMS failure: 3807, Object ABC.UV_ABC' does not
==========================
These error tables are not present in the database also.I have already checked.
Please suggest.
Thanks
Shaonli
Posted: Tue Dec 04, 2007 8:15 am
by DS_FocusGroup
try to check you report file, it will contain all the details why it not working, it maybe that you use some envirnoment variables for DB names etc but forgot to reference it in the job. check the report file and if you don't understand the problem try to paste the error message from teradata report file here and i will help you out on this
Posted: Tue Dec 04, 2007 3:26 pm
by richdhan
Hi,
In the Teradata Multiload stage you would have mentioned all the temporary tables that Multiload uses during various phases of loading data into the table.
1. Drop all the tables (UV, ERR, LOG, WRK)
2. Issue this command from Teradata SQL Assistant (RELEASE MLOAD <Table_Name>)
This should resolve the issue.
HTH
--Rich
Posted: Tue Dec 04, 2007 6:41 pm
by siddesai
[quote="shaonli"]I looked into the MultiLoad report.There I found this statement
=========================
0003 drop table ABC.ET_ABC;
**** 23:13:58 UTY1008 RDBMS failure: 3807, Object ABC.ET_ABCdoes not exist.
0004 drop table ABC.UV_ABC
**** 23:13:58 UTY1008 RDBMS failure: 3807, Object ABC.UV_ABC' does not
==========================
What are ET_ABC and UV_ABC? I guess they are the tables that you are trying to load and it fails because they are not present?
Within the multi-load stage there is grid settings where you can use the option 'drop before loading' or something similar that will drop your tables and re-create it.
Posted: Wed Dec 05, 2007 8:18 am
by landaghaar
RELEASE MLOAD Table_Name
is the answer
