fatal Error

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
ds_dwh
Participant
Posts: 39
Joined: Fri May 14, 2010 6:06 am

fatal Error

Post by ds_dwh »

Hi all,

when i am running Job i am getting below Fatal error, how to reslove this one my target is teradata

TRG_L0053_ADJUSTMENT_H: [IIS-CONN-TERA-005004] RDBMS code 3807: Object 'DL0053_In_SDD_Adjustment_H' does not exist. SQL statement: DELETE FROM DL0053_In_SDD_Adjustment_H ALL (CC_TeraConnection::execute, file CC_TeraConnection.cpp, line 2,640)

any idea plz..........

Thanks,
ANJI
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Do you need to qualify the table name?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
suresh.angadi
Participant
Posts: 17
Joined: Tue Jun 23, 2009 6:44 pm

Re: fatal Error

Post by suresh.angadi »

Hi,

Please check in the database for the object 'DL0053_In_SDD_Adjustment_H', table is not present in the databse.

Regards
Suresh
Suresh Angadi
Top
saikir
Participant
Posts: 92
Joined: Wed Nov 08, 2006 12:25 am
Location: Minneapolis
Contact:
Contact saikir

Post by saikir »

Hi,

Change the "Write Mode" to "User-Defined SQL". This is a work around, that should work fine.

Regards
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”