Ask Your Question

Jdbc Producer does not write data

asked 2020-07-30 12:42:52 -0500

Drystan gravatar image

Hi i have a Jdbc producer from SDC 3.17 targeting a SQL server table and it just spins and does nothing. It has 10,000 records backlog from the processor before it and set for batch insert of 1000 records but the input record count is always zero. I let it run for over 30 minutes to see if ever changed with no effect. There is no errors in the pipeline log or any indication what is at fault. Thanks

edit retag flag offensive close merge delete


Did you try resetting offset and restarting the pipeline?

iamontheinet gravatar imageiamontheinet ( 2020-07-30 17:12:51 -0500 )edit

1 Answer

Sort by ยป oldest newest most voted

answered 2020-07-31 14:03:50 -0500

Drystan gravatar image

Ok found an issue via setting debug tracing UPDATE are running it seems but not taking any records spliting pipeline to dump UPDATE's allows the inserts to run

edit flag offensive delete link more


Thanks for the update.

iamontheinet gravatar imageiamontheinet ( 2020-07-31 14:56:22 -0500 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-07-30 12:42:52 -0500

Seen: 78 times

Last updated: Jul 30