Ask Your Question
1

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

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

pederpansen gravatar image

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

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 -0500

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 34 times

Last updated: Jul 04