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
Error while loading in Teradata table
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 24
- Joined: Mon Jul 12, 2004 10:16 am
Re: Error while loading in Teradata table
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.
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
=========================
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
-
- Premium Member
- Posts: 197
- Joined: Sun Jul 15, 2007 11:45 pm
- Location: Prague
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
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
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
[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.
=========================
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.
-
- Participant
- Posts: 38
- Joined: Wed Sep 19, 2007 10:11 am
- Location: Canada