This has been resolved, thanks to this post:
https://community.hortonworks.com/questions/66883/nifi-cannot-handle-db2-blob-data-sends-wrong-resul.html
On 2016-11-16 11:56 (-0600), "Kaggal, Vinod C." <k...@mayo.edu> wrote:
> Hello!>
>
> We have been using nifi successfully for a few things and can attest
that this is a great tool to have in our tool box!>
>
> Recently, we were trying to query a blob field from db2 which
resulted in an exception.>
>
> Any recommendation on how to address this would be appreciated!>
>
> Query:>
> SELECT BLOBTBL.BLOB_CONTENTS FROM CE_BLOB_DECOMP BLOBTBL fetch first
10 rows only with UR>
>
>
> Exception:>
>
> ExecuteSQL[id=93bdd730-65ba-4deb-b6a4-78a551916d1d] Unable to execute
SQL select query SELECT BLOBTBL.BLOB_CONTENTS FROM CE_BLOB_DECOMP
BLOBTBL fetch first 10 rows only with UR due to
org.apache.nifi.processor.exception.ProcessException:
com.ibm.db2.jcc.am.jo: [jcc][t4][1092][11638][3.57.110] Invalid data
conversion: Wrong result column type for requested conversion.
ERRORCODE=-4461, SQLSTATE=42815; routing to failure:
org.apache.nifi.processor.exception.ProcessException:
com.ibm.db2.jcc.am.jo: [jcc][t4][1092][11638][3.57.110] Invalid data
conversion: Wrong result column type for requested conversion.
ERRORCODE=-4461, SQLSTATE=42815>
>
>
> Thank you!>
> Vinod>
>
>