ExecuteSQL Unsupported field: YearOfEra

[#1]

Hello!

NiFi version - 2.5.0

Java - 21

When trying to run ExecuteSQL processor i'm getting error:

What does it mean and where is this unsupported field located? 

Log:

It's something wrong with java or nifi or whole system?

Please, help me to figure it out

[#2]

Hello @blackboks, 

Thanks for being part of our community. 

That error you're facing looks like it's from Java side, not from NiFi. 
This appears when no timezone information is provided during the request. 

Maybe these two forums can help you find where in your query is missing that: 
https://java2blog.com/format-instant-to-string-java/
https://stackoverflow.com/questions/25229124/unsupportedtemporaltypeexception-when-formatting-instan... 

[#3 · Accepted solution]

@vafs thank you for the reply, in fact the problem was in logback.xml file, not sure in what part of it exactly, but when i'm replaced is from another worked server, make changes in paths and restart Nifi the ExecuteSQL processor start to work as expected