All Forums Tools
msshishodia 2 posts Joined 02/13
21 Feb 2013
Error: Error table already exists - Eventhough it was not present in the warehouse.

Hi ,
I am facing an issue with Mload. We are loading in a table through Mload in Informatica. For the first time when I submitted the informtica job. It has given me the following error
Error1 - Message: [ERROR] Type:(Teradata DBS Error), Error: (Table 'I1103_EXT_R2_PRES_MT_PREV_ER1' already exists.)
I checked for this error table in the warehouse but didnt find one. Then I stopped the suspended Informatica job and deleted the related logtable in the warehouse and then resubmitted the job.
and this time I get the following error:
Error2 - Mload error: bad internal_status -Delete Mload Started while Import Mload suspended
This time, I released the Mload and again resubmitted the job..... But again I was getting Error1 .. I have also tried dropping the base table but that even didnt work.

Any help will be appreciated.
Thanks

Manoj Singh
Ivyuan 63 posts Joined 01/10
22 Feb 2013

Hi,
Which version of MLOAD are you using? And, if possible, can you share your MLOAD script?
Thanks!
--Ivy.

You must sign in to leave a comment.