question Re: ExecuteSQLRecord - org.apache.avro.SchemaParseException: in Support Questions

ExecuteSQLRecord - org.apache.avro.SchemaParseException:

swanifi — Tue, 28 Mar 2023 10:32:26 GMT

Hi ,

Am using MSSQL version 12+ , I have connected to DB successfully . I could able to fetch the data eg : Select * from dbname.sys.tables

But If i try to query fetch the table records using below processor

Getting below error :

Re: ExecuteSQLRecord - org.apache.avro.SchemaParseException:

ckumar — Tue, 28 Mar 2023 11:19:41 GMT

This error has to do with the schema used in Record Writer controllers used by ExecuteSQLRecord.

I would validate the provided schema and check if it is in the correct Avro format as it Avro schema parser is complaining about an illegal character in the provided schema.

If you found this response assisted with your issue, please take a moment and click on "Accept as Solution" below this post.

Thank you

Re: ExecuteSQLRecord - org.apache.avro.SchemaParseException:

VidyaSargur — Tue, 28 Mar 2023 11:34:59 GMT

@swanifi, Welcome to our community! To help you get the best possible answer, I have tagged in our NiFi experts @ckumar @MattWho @SAMSAL @cotopaul may be able to assist you further.

Please feel free to provide any additional information or details about your query, and we hope that you will find a satisfactory solution to your question.