Ask Your Question

Batch is empty, Where is the issue?

asked 2020-01-12 04:29:01 -0500

SoftDesire gravatar image

updated 2020-01-13 13:22:21 -0500

metadaddy gravatar image

I'm new to StreamSets, I'm using JDBC producer for Ignite and getting below error. Anyone can explain what it means and how to get rid of this issue? If I just change the destination to Kudu and the same configuration runs fine with it.

com.streamsets.pipeline.api.StageException: JDBC_14 - Error processing batch: [SQLState:null][ErrorCode:0] Batch is empty.
SQLState: null
Error Code: 0
Message: Batch is empty.
edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2020-01-13 13:21:50 -0500

metadaddy gravatar image

That Batch is empty message comes from the database - Ignite. It evidently doesn't like you submitting empty batches for processing. We should not submit empty batches, so this is a bug.

Please create an issue at with as much information as possible, including the full stack trace from sdc.log. If you are a StreamSets customer, please open a support ticket.

As a workaround, try disabling Use Multi-Row Operation in the JDBC Producer - this will avoid the use of batches, but will likely impact performance.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-01-12 04:29:01 -0500

Seen: 38 times

Last updated: Jan 13