Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Pipeline Status: RUN_ERROR: com.streamsets.pipeline.api.StageException: JDBC_14 - Error processing batch. SQLState: 50000 Error Code: 1 Message: Failed to map key to node.

while storing the data into a database using Jdbc producer, We are getting below error

Pipeline Status: RUN_ERROR: com.streamsets.pipeline.api.StageException: JDBC_14 - Error processing batch. SQLState: 50000 Error Code: 1 Message: Failed to map key to node.

ERROR An exception occurred while running the pipeline, com.streamsets.pipeline.api.StageException: JDBC_14 - Error processing batch. ProductionPipelineRunnable *admin ProductionPipelineRunnable- SQLState: 50000 Error Code: 1 Message: Failed to map key to node.

com.streamsets.pipeline.api.StageException: JDBC_14 - Error processing batch. SQLState: 50000 Error Code: 1 Message: Failed to map key to node.

at com.streamsets.pipeline.lib.jdbc.JdbcBaseRecordWriter.handleSqlException(JdbcBaseRecordWriter.java:635)
at com.streamsets.pipeline.lib.jdbc.JdbcGenericRecordWriter.handleBatchUpdateException(JdbcGenericRecordWriter.java:306)
at com.streamsets.pipeline.lib.jdbc.JdbcGenericRecordWriter.write(JdbcGenericRecordWriter.java:214)
at com.streamsets.pipeline.lib.jdbc.JdbcGenericRecordWriter.writeBatch(JdbcGenericRecordWriter.java:123)
at com.streamsets.pipeline.lib.jdbc.JdbcUtil.write(JdbcUtil.java:824)
at com.streamsets.pipeline.stage.destination.jdbc.JdbcTarget.write(JdbcTarget.java:208)
at com.streamsets.pipeline.api.base.configurablestage.DTarget.write(DTarget.java:34)
at com.streamsets.datacollector.runner.StageRuntime.lambda$execute$2(StageRuntime.java:290)
at com.streamsets.datacollector.runner.StageRuntime.execute(StageRuntime.java:235)
at com.streamsets.datacollector.runner.StageRuntime.execute(StageRuntime.java:298)

Can any one help to get out of this issue please.

Thanks in advance.