Page 1 of 1

fatal Error

Posted: Wed Apr 27, 2011 1:46 am
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,

Posted: Wed Apr 27, 2011 1:55 am
by ray.wurlod
Do you need to qualify the table name?

Re: fatal Error

Posted: Thu Apr 28, 2011 6:31 pm
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

Posted: Mon Aug 22, 2011 10:13 am
by saikir
Hi,

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

Regards