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.

asked 2018-09-20 06:51:45 -0500

Kumar gravatar image

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.

edit retag flag offensive close merge delete

Comments

What database are you trying to write to?

metadaddy gravatar imagemetadaddy ( 2018-09-21 21:44:17 -0500 )edit

I am using Ignite(https://ignite.apache.org/).

Kumar gravatar imageKumar ( 2018-09-24 00:42:40 -0500 )edit