question ExecuteSQL Unsupported field: YearOfEra in Support Questions

ExecuteSQL Unsupported field: YearOfEra

blackboks — Wed, 10 Dec 2025 16:09:29 GMT

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

Re: ExecuteSQL Unsupported field: YearOfEra

vafs — Thu, 11 Dec 2025 15:33:37 GMT

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-instant-to-string

Re: ExecuteSQL Unsupported field: YearOfEra

blackboks — Thu, 25 Dec 2025 06:07:16 GMT

@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