Error: Error table already exists - Eventhough it was not present in the warehouse.

Tools & Utilities

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

1 REPLY
Teradata Employee

Re: Error: Error table already exists - Eventhough it was not present in the warehouse.

Hi,

Which version of MLOAD are you using? And, if possible, can you share your MLOAD script?

Thanks!

--Ivy.