Ask Your Question
1

Oracle JDBC Producer: Can't coerce '35' of type 'INTEGER' to column

asked 2018-07-04 03:44:29 -0600

pederpansen gravatar image

updated 2018-07-04 15:41:04 -0600

metadaddy gravatar image

After upgrading from Streamset 3.0.2.0 to 3.3.0, we see a lot of the following errors in our pipelines:

com.streamsets.pipeline.api.base.OnRecordErrorException: JDBC_23 - Can't coerce '35' of type 'INTEGER' to column 'p.mycol'

The destination table contains only VARCHARcolumns, so an (implicit) conversion should always be possible. Is this error somehow related to https://issues.streamsets.com/browse/... and what are suggestions to fix it?

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
1

answered 2018-07-04 15:44:09 -0600

metadaddy gravatar image

That may well be a manifestation of SDC-9132. It will be fixed in 3.3.1 and 3.4.0. In the meantime, you should be able to work around it by using a Field Type Converter to convert the field to a string.

edit flag offensive delete link more

Comments

thank you vary much,the Field Type Converter have already solved my question before data enters JDBC Producer,But another problem is my streamsets version is 3.4.1,it seams that the manifestation haven`t been fixed.

harley gravatar imageharley ( 2018-10-19 04:45:23 -0600 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-07-04 03:44:29 -0600

Seen: 204 times

Last updated: Jul 04