Page 1 of 1
Teradata connector error
Posted: Sat Nov 12, 2011 8:56 pm
by ramesh9394
hi
i am loading teradata table using Teradata connector
i am getting following fatel error
table_TGT: [IIS-CONN-TERA-005004] RDBMS code 3810: SP_STAGE:Column/Parameter 'col' does not exist. SQL statement: call (CC_TeraConnection::execute, file CC_TeraConnection.cpp, line 2,640)
can any one help me out
Thanks
Re: Teradata connector error
Posted: Sat Nov 12, 2011 9:00 pm
by ramesh9394
my job looks like
sequential file---->transformer---->TDconnector
can any one help me out
Thanks
Posted: Sat Nov 12, 2011 9:49 pm
by pandeesh
What you are doing in TD connector?
Inserting or updating?
Please post your sql.
Thanks
Posted: Sat Nov 12, 2011 10:04 pm
by ramesh9394
Thanks for reply pandeesh
i am inerting in bulk mode
this is after sql
Code: Select all
call #DBNAME#.SP_STAGE
(
'#DBNAME#','#STGTBL#','STARTDATE' , 'STARTUTCDTTM', 'ENDDATE', 'ENDUTCDTTM'
)
thanks
Posted: Sat Nov 12, 2011 10:34 pm
by pandeesh
The error is pretty obvious that the column/parameter 'START_UTC_DTTM' does not exist.
How you are manipulating the parameter 'START_UTC_DTTM' inside your Stored Procedure code?
Are you able to call the same Stored Procedure successfuly inTeradata Sql Assistant.
Thanks
Posted: Thu Nov 17, 2011 1:46 pm
by ramesh9394
my bad
problem is resolved
Posted: Thu Nov 17, 2011 3:24 pm
by pandeesh
Please explain how the problem is resolved.
Thanks
Posted: Fri Nov 18, 2011 12:51 pm
by ramesh9394
initially we don't have start_utc_dttm and End_utc_dttm in database table . after they changed table definition my job running good.