All Forums General
NewbieTD 25 posts Joined 05/13
23 Mar 2015
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,

NewbieTD 25 posts Joined 05/13
26 Mar 2015

Hi experts,
can anyone please give some advise for the above error??

Rmsranjith 4 posts Joined 03/09
26 Mar 2015

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

NewbieTD 25 posts Joined 05/13
26 Mar 2015

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

You must sign in to leave a comment.