Talend Connect
Virtual Summit
JOIN US!
And visit the Customer
& Community Lounge.
May 27-28, wherever you are.

error with tredshiftoutput using dynamic schema

Highlighted
Six Stars

error with tredshiftoutput using dynamic schema

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]

Highlighted
Moderator

Re: error with tredshiftoutput using dynamic schema

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Talend Cloud Available on Microsoft Azure

An integration platform-as-a-serviceto help enterprises collect, govern, transform, and share data from any data sources

Watch Now

Self-service Talend Migration: Moving from On-Premises to the Cloud

Move from On-Premises to the Cloud by following the advice of experts

Read Now

How to deploy Talend Jobs as Docker images to Amazon, Azure and Google Cloud reg...

Learn how to deploy Talend Jobs as Docker images to Amazon, Azure and Google Cloud registries

Blog