error with tredshiftoutput using dynamic schema

ravi999 — Sat, 16 Nov 2024 07:31:23 GMT

Hi ,

We are trying to load data to redshift using tredshiftoutput component using dynamic schema and have below error. Has anyone solved this issue earlier ?

Starting job oracle_redshift_dynamic at 13:25 04/10/2018.

[statistics] connecting to socket on port 3869
[statistics] connected
[FATAL]: talend_etl_project.oracle_redshift_dynamic_0_1.oracle_redshift_dynamic - tRedshiftOutput_1 [Amazon](500310) Invalid operation: DECIMAL precision 0 must be between 1 and 38;
java.sql.SQLException: [Amazon](500310) Invalid operation: DECIMAL precision 0 must be between 1 and 38;
at com.amazon.redshift.client.messages.inbound.ErrorResponse.toErrorException(ErrorResponse.java:1830)
at com.amazon.redshift.client.PGMessagingContext.handleErrorResponse(PGMessagingContext.java:822)
at com.amazon.redshift.client.PGMessagingContext.handleMessage(PGMessagingContext.java:647)
at com.amazon.jdbc.communications.InboundMessagesPipeline.getNextMessageOfClass(InboundMessagesPipeline.java:312)
at com.amazon.redshift.client.PGMessagingContext.doMoveToNextClass(PGMessagingContext.java:1080)
at com.amazon.redshift.client.PGMessagingContext.getBindComplete(PGMessagingContext.java:977)
at com.amazon.redshift.client.PGClient.handleErrorsScenario1(PGClient.java:2484)
at com.amazon.redshift.client.PGClient.handleErrors(PGClient.java:2451)
at com.amazon.redshift.client.PGClient.directExecuteExtraMetadata(PGClient.java:1222)
at com.amazon.redshift.dataengine.PGQueryExecutor.execute(PGQueryExecutor.java:210)
at com.amazon.jdbc.common.SStatement.executeNoParams(Unknown Source)
at com.amazon.jdbc.common.SStatement.execute(Unknown Source)
at talend_etl_project.oracle_redshift_dynamic_0_1.oracle_redshift_dynamic.tOracleInput_1Process(oracle_redshift_dynamic.java:1474)
at talend_etl_project.oracle_redshift_dynamic_0_1.oracle_redshift_dynamic.runJobInTOS(oracle_redshift_dynamic.java:5494)
Caused by: com.amazon.support.exceptions.ErrorException: [Amazon](500310) Invalid operation: DECIMAL precision 0 must be between 1 and 38;
... 14 more
Exception in component tRedshiftOutput_1 (oracle_redshift_dynamic)
java.sql.SQLException: [Amazon](500310) Invalid operation: DECIMAL precision 0 must be between 1 and 38;
at com.amazon.redshift.client.messages.inbound.ErrorResponse.toErrorException(ErrorResponse.java:1830)
at com.amazon.redshift.client.PGMessagingContext.handleErrorResponse(PGMessagingContext.java:822)
at com.amazon.redshift.client.PGMessagingContext.handleMessage(PGMessagingContext.java:647)
at com.amazon.jdbc.communications.InboundMessagesPipeline.getNextMessageOfClass(InboundMessagesPipeline.java:312)
at com.amazon.redshift.client.PGMessagingContext.doMoveToNextClass(PGMessagingContext.java:1080)
at com.amazon.redshift.client.PGMessagingContext.getBindComplete(PGMessagingContext.java:977)
at com.amazon.redshift.client.PGClient.handleErrorsScenario1(PGClient.java:2484)
at com.amazon.redshift.client.PGClient.handleErrors(PGClient.java:2451)
at com.amazon.redshift.client.PGClient.directExecuteExtraMetadata(PGClient.java:1222)
at com.amazon.redshift.dataengine.PGQueryExecutor.execute(PGQueryExecutor.java:210)
at com.amazon.jdbc.common.SStatement.executeNoParams(Unknown Source)
at com.amazon.jdbc.common.SStatement.execute(Unknown Source)
at talend_etl_project.oracle_redshift_dynamic_0_1.oracle_redshift_dynamic.tOracleInput_1Process(oracle_redshift_dynamic.java:1474)
at talend_etl_project.oracle_redshift_dynamic_0_1.oracle_redshift_dynamic.runJobInTOS(oracle_redshift_dynamic.java:5494)
Caused by: com.amazon.support.exceptions.ErrorException: [Amazon](500310) Invalid operation: DECIMAL precision 0 must be between 1 and 38;
... 14 more
[statistics] disconnected
Job oracle_redshift_dynamic ended at 13:25 04/10/2018. [exit code=1]

Re: error with tredshiftoutput using dynamic schema

Anonymous — Tue, 16 Oct 2018 09:08:20 GMT

Hello,

Did you specify the DECIMAL precision?

From the error message, it seems the precision specified for a number column in a CREATE/ALTER TABLE statement must be a digit between 1 and 38.

On which talend build version you got this issue?

Could you please post your job setting screenshots on forum? Which will be helpful for us to address your issue.

Best regards

Sabrina

topic Re: error with tredshiftoutput using dynamic schema in Talend Studio

error with tredshiftoutput using dynamic schema

Re: error with tredshiftoutput using dynamic schema