[NIFI-1570] "org.apache.avro.SchemaParseException: empty name"

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 0.5.0
• Component/s: Core Framework
• External issue URL: https://www.mail-archive.com/search?l=[e-mail]&q=subject:%22executesql%22&o=newest&f=1
• Assignee: Unassigned
• Reporter: RAHUL CHATURVEDI
• Created: 26/Feb/16 03:47
• Updated: 07/Jun/16 14:17
• Resolved: 13/Mar/16 17:11

Description

With Nifi version 0.5.0 and following all the steps pointed here
https://www.mail-archive.com/search?l=[e-mail]&q=subject:%22executesql%22&o=newest&f=1

I am still getting the same error.

My flow is
Generate Flow File > Fetch File -> Extract Text (here the value for the WHERE clause is exposed as a property "property1")> ExecuteSQL (Oracle DB) -> PutFile (results of the query)

The query executes fine in the Oracle DB
SELECT field1
FROM table
WHERE field1= '${property1}'

I am hitting dead ends, any help will be appreciated

Issue Links

• duplicates: NIFI-1596 ExecuteSQL Error Creating Schema