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
