Fatal Error: While loading data using Teradata Mltiload

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
fridge
Premium Member
Premium Member
Posts: 136
Joined: Sat Jan 10, 2004 8:51 am

Post by fridge »

Hullo,

I suspect the final error (3807) is down to the previous error concerning the error tables

03:56:17 UTY1008 RDBMS failure: 3807, Object 'EDW_STAGE.STATUS_S_WE411_ET' does not
exist.

Basically when the multiload starts it attempts to drop any error tables first, though these will only get left if you either
a) Had some bad data
or / and
b) You attempted to insert duplicates

on a previous run

as the tables dont exist - it cant drop them , however will continue to do the load proper

However not sure why it is picking up the error at the end - as dropping of non-existant tables shouldlt cause the job to fail

How is the script produced - is it custom load type in the Multiload stage - I work on AIX so cant seem to replicate the script
hamzaqk
Participant
Posts: 249
Joined: Tue Apr 17, 2007 5:50 am
Location: islamabad

Post by hamzaqk »

it gives 3807 error when the target table does not exist.... the one you are trying to insert into...
Teradata Certified Master V2R5
ManojRawat
Participant
Posts: 2
Joined: Wed Oct 21, 2009 7:17 am

Re: Fatal Error: While loading data using Teradata Mltiload

Post by ManojRawat »

========================================================================
= =
= Processing Control Statements =
= =
========================================================================
0018 .if &SYSRC then;
**** 03:56:34 UTY2402 Previous statement modified to:
0019 .if 3807 then;
0020 .logoff &SYSRC;
**** 03:56:34 UTY2402 Previous statement modified to:
0021 .logoff 3807;

Load script outputting the return code "3807" due to the "highlited code" mentioned above.Multiloade will not prompt for failure if this portion removed from the code.
aaron102
Participant
Posts: 17
Joined: Mon Nov 09, 2009 12:23 am

Post by aaron102 »

In after section of the script in the multiload script did you miss to tick mark "Treat SQL Errors as non fatal error"
Good comes to those who seldom wish for it.
Post Reply