ExecuteSQLRecord - org.apache.avro.SchemaParseException:

[#1]

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  :

[#2 · Accepted solution]

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

[#3]

@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.