Teradata connector error

[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

[ramesh9394]

my job looks like

sequential file---->transformer---->TDconnector

can any one help me out
Thanks

[pandeesh]

What you are doing in TD connector?
Inserting or updating?
Please post your sql.

Thanks

[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

[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

[ramesh9394]

my bad

problem is resolved

[pandeesh]

Please explain how the problem is resolved.

Thanks

[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.