RDBMS Code 25000 - error occurred during data acquisition

General
Enthusiast

RDBMS Code 25000 - error occurred during data acquisition

Hi All,

I am new to Teradata. I am using mload to load data to target table. When i am loading dat i got RDBSM code 25000 error occurred during data acquisition.

I dropped error/work/log tables and released mload lock on target table and tried to reload the dat. But still i am facing same error.

When i was rerunning without dropping err/wrk/log tables i got "Work table is missing during mload restart".  

Can anyone help here??

tool used: Datastage - teradata connector

Thanks,

3 REPLIES
Enthusiast

Re: RDBMS Code 25000 - error occurred during data acquisition

Hi experts,

can anyone please give some advise for the above error??

Re: RDBMS Code 25000 - error occurred during data acquisition

Does the ET_ table has any records loaded into it or empty?

Enthusiast

Re: RDBMS Code 25000 - error occurred during data acquisition

Hi,

no, i am loading into empty staging table. From staging table, load into target table using insert/select.

Thanks,