NiFi executesql invalid character exception

mrdavidsheard — Mon, 19 Sep 2016 13:33:58 GMT

Any advice, please. I get an error doing any sort of select statement.

E.G.

select max(nextval) from <schema>.<table_name>

But I get an error below (schema and table name withheld:

Unable to execute SQL select query select max(nextval) from <schema>.<table_name>; due to org.apache.nifi.processor.exception.ProcessException: java.sql.SQLSyntaxErrorException: ORA-00911: invalid character
; routing to failure: org.apache.nifi.processor.exception.ProcessException: java.sql.SQLSyntaxErrorException: ORA-00911: invalid character

Re: NiFi executesql invalid character exception

mrdavidsheard — Mon, 19 Sep 2016 14:06:44 GMT

It seems it isn't happy with using a function such as max 😞

Work around (schema and table name withheld):

select * from (select nextval from <schema>.<table_name> order by nextval desc) where rownum=1

question Re: NiFi executesql invalid character exception in Support Questions

NiFi executesql invalid character exception

Re: NiFi executesql invalid character exception