Support Questions
Find answers, ask questions, and share your expertise

Error Could not determine the Avro Schema to use for writing the content

Error Could not determine the Avro Schema to use for writing the content

New Contributor

Hi, 

I've suddenly an error on an AvroRecordSet Writer processor.

The processor is in charge to query a postgresql database.

Everything was okay since 5 months.

 

Now i have the following error 

 

Unable to execute SQL select query SELECT s.name as society_name , ...
WHERE ... due to java.io.IOException: org.apache.nifi.processor.exception.ProcessException: Could not determine the Avro Schema to use for writing the content. No FlowFile to route to failure: org.apache.nifi.processor.exception.ProcessException: java.io.IOException: org.apache.nifi.processor.exception.ProcessException: Could not determine the Avro Schema to use for writing the content
The processor settings : 
Record Writer : AvroRecordSetWriter
Normalize Table/Column Names : false
Use Avro Logical Types : true
 
The AvorRecordSetWriter controller setting : 
Schema Write Strategy Embed Avro Schema
Schema Cache No value set
Schema Protocol Version 1
Schema Access Strategy Inherit Record Schema
Schema Registry No value set
Schema Name ${schema.name}
Schema Version No value set
Schema Branch No value set
Schema Text ${avro.schema}
Compression Format NONE
Cache Size 1000
Encoder Pool Size 32
 
I'm running Nifi 1.12.0
 
Any idea of the problem ?
 
Thanks.