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

failed to convert jsontosql

New Contributor

Hi,

I used jsontosql processor to convert json to sql. I am getting below error.

offset=10266, length=1129],offset=0,name=1963423193751,size=1129] to a SQL INSERT statement due to org.apache.nifi.processor.exception.ProcessException: None of the fields in the JSON map to the columns defined by the fta.reporter_status table; routing to failure: org.apache.nifi.processor.exception.ProcessException: None of the fields in the JSON map to the columns defined by the xxxxx table org.apache.nifi.processor.exception.ProcessException: None of the fields in the JSON map to the columns defined by the xxxxx table

properties-jsontosql.jpg

1 REPLY 1

Super Guru
@subbu p

This error occurs when processor not able find atleast one column name in the target table matching with your json message columns(keys).

Make sure you are having same column names(case sensitive) matching to your target table in your json message and re run the process again.