After updating to openjdk 1.8.0_60 I am unable to run jobs using the AWS S3 component. I get the following error.
AWS authentication requires a valid Date or x-amz-date header (Service: Amazon S3; Status Code: 403; Error Code: AccessDenied;
I understand this should be updated in the newest version of the aws adk, but Talend looks for a specific version. Is there a way to point it to a newer one?
Hi, I am using Talend for Big Data 6.3.1 desktop. I am loading data from postgresql db to aws redshift db. I have a problem 'Error converting Timestamp' Exception in component tPostgresqlInput_1 java.sql.SQLDataException: (10140) Error converting value to Timestamp. I tried adding joda-time-2.8.2.jar in java classpath and path of jar file in jvm instructions and ran the job. But still, problem not resolved. Can anyone help me to resolve the issue. Thanks in Advance. Regards Satya
Think it other problem, not related to joda version and AWS as mentioned by Sabrina - it good to add some screenshots
Hi, I am using Talend for Big Data 6.3.1 desktop. I am loading data from postgresql db to aws redshift db. I have a problem 'Error converting Timestamp' Exception in component tPostgresqlInput_1 java.sql.SQLDataException: (10140) Error converting value to Timestamp. I tried adding joda-time-2.8.2.jar in java classpath and path of jar file in jvm instructions and ran the job. But still, problem not resolved. Can anyone help me to resolve the issue. Thanks in Advance. Regards Satya
Think it other problem, not related to joda version and AWS
as mentioned by Sabrina - it good to add some screenshots
HI, its not allowing me to upload screen shorts .
Job is just to load data from postgresql db table to redshift db table, pretty straight forward.
Here is the error message:
Exception in component tPostgresqlInput_1
java.sql.SQLDataException: (10140) Error converting value to Timestamp.
at com.amazon.exceptions.ExceptionConverter.toSQLException(Unknown Source)
at com.amazon.utilities.conversion.TypeConverter.convertToTimestamp(Unknown Source)
at com.amazon.utilities.conversion.TypeConverter.toTimestamp(Unknown Source)
at com.amazon.jdbc.common.SForwardResultSet.getTimestamp(Unknown Source)
at routines.system.JDBCUtil.getDate(JDBCUtil.java:61)
at local_project.college_appl_dl_fl_0_1.college_appl_dl_fl.tPostgresqlInput_1Process(college_appl_dl_fl.java:2169)
at local_project.college_appl_dl_fl_0_1.college_appl_dl_fl.runJobInTOS(college_appl_dl_fl.java:5975)
at local_project.college_appl_dl_fl_0_1.college_appl_dl_fl.main(college_appl_dl_fl.java:5580)
This is the actual error message.
Regards
exactly! 😉
tPostgresqlInput_1 - it is NOT AWS component
You are read from Postgres and write to Redshift (it will be tRedshift
Output)
so - please attache more Job screenshots
I have some issues in uploading pictures or screenshots. I'm sorry. I am loading data using the below workflow: tPostgresqlConnection-->on component ok-->tRedshiftConnection-->onsubjobok-->tPostgresqlinput -->row1(Main)-->tRedshiftOutput The same workflow is working in talend 6.1.2 and the same job is giving problems with version talend 6.2, 6.3 also. why the error is not in talend 6.1.2 and why in talend 6.2 and 6.3? any guess on the error? Thanks
