Skip to main content

We are using offset,  where clause initial value is from job parameters. 20 pipelines following the same structure, 1 was done, and we copied to develop all others 19.
On DEV and SIT they are working fine,  only in prod has this error for 16 pipelines, others 4 are working fine. 
Giving up, after 1 error as per stage configuration. First error: SQLState: HY000 error code:640 message: aTeradata JSBC Driver]
bTeraJDBC 16.20.00.10]0Error 640] SQÇstare HY000]ResultSet: findColumn — column-- not found
We got an SQL statement run by Teradata and it works fine.

 

@giulliana_souza ,

From the above error i believe you are using JDBC producer as destination to insert data into the table.

If you are using JDBC producer , please make sure that the column names and data type are exactly same in both source and destination tables. it also case sensitive in nature. 

In case of any mismatch , the JDBC producer will throw the error like above.

kindly check if the column names and data types are same or not in your case . 

please let me know if it helps.

 

Thanks & Regards,

Bikram_

Reply


Terms & Conditions