Question

[TeraJDBC 16.20.00.10][Error 640][SQÇstare HY000]ResultSet: findColumn - column -- not found

  • 11 January 2022
  • 1 reply
  • 166 views
G
Rank

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: [Teradata JSBC Driver]
[TeraJDBC 16.20.00.10][Error 640][SQÇstare HY000]ResultSet: findColumn — column-- not found
We got an SQL statement run by Teradata and it works fine.

 

1 reply

Bikram
Rank
Userlevel 5
Badge +1

@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