Table is moved to another Map

Database
Enthusiast

Table is moved to another Map

Hi,

 

I have MLOAD failure as below

     CHECK WORKLOAD FOR BEGIN MLOAD PM_EDW_MSTR_D.d_SERV_INTRCTN;

**** 06:00:44 UTY0817 MultiLoad submitting the following request:

     CHECK WORKLOAD END;

**** 06:00:45 UTY0812 MLOAD session(s) requested: 12.

**** 06:00:45 UTY0815 MLOAD session(s) connected: 12.

**** 06:00:45 UTY0817 MultiLoad submitting the following request:

     BEGIN MLOAD PM_EDW_MSTR_D.d_SERV_INTRCTN WITH INTERVAL;

**** 06:00:45 UTY0805 RDBMS failure, 2635: Error tables are invalid OR

     d_SERV_INTRCTN is in an invalid state for Load - Target Table is not

     fallback and an AMP is down.

 

By analysing I found that there is an error related to MLOAD log file table. Now when I am trying to select the table showing table is moved to another MAP. When I tried to Drop the table its showing data corruption detected  in DBC.TVFIELDS table.

On the same note: we had couple of Node failure last week. We are facing the issue after the DIMMs replacement.

 

Can you please suggest how can I drop this Table?

1 REPLY
Teradata Employee

Re: Table is moved to another Map

Please engage Teradata support to look into this problem.