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

General

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

Hi Experts,

I am facing an issue with Mload and I am new to teradata. Actually 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.

I released the lock and resubmitted the job..... BUT this time again I recieved Error1. I also tried dropping the base table but that too didn't work out.

Can someone share some insights on this. Any help will be appreciated.

Thanks.