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]
