Uploaded image for project: 'Apache NiFi'
  1. Apache NiFi
  2. NIFI-1596

ExecuteSQL Error Creating Schema

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.6.0
    • Component/s: None
    • Labels:
      None

      Description

      It was reported that after upgrading to 0.5.1, ExecuteSQL was no longer working against Oracle and MS SQL, in the same scenario that had previously worked against 0.4.1.

      ERROR [Timer-Driven Process Thread-8] o.a.nifi.processors.standard.ExecuteSQL
      org.apache.avro.SchemaParseException: Empty name
      at org.apache.avro.Schema.validateName(Schema.java:1076) ~[na:na]
      at org.apache.avro.Schema.access$200(Schema.java:79) ~[na:na]
      at org.apache.avro.Schema$Name.<init>(Schema.java:436) ~[na:na]
      at org.apache.avro.Schema.createRecord(Schema.java:145) ~[na:na]
      at org.apache.avro.SchemaBuilder$RecordBuilder.fields(SchemaBuilder.java:1732) ~[na:na]
      at org.apache.nifi.processors.standard.util.JdbcCommon.createSchema(JdbcCommon.java:138) ~[na:na]
      at org.apache.nifi.processors.standard.util.JdbcCommon.convertToAvroStream(JdbcCommon.java:72) ~[na:na]
      at org.apache.nifi.processors.standard.ExecuteSQL$1.process(ExecuteSQL.java:158) ~[na:na]
      at org.apache.nifi.controller.repository.StandardProcessSession.write(StandardProcessSession.java:1953) ~[nifi-framework-core-0.5.1.jar:0.5.1]
      at org.apache.nifi.processors.standard.ExecuteSQL.onTrigger(ExecuteSQL.java:152) ~[na:na]
      at org.apache.nifi.processor.AbstractProcessor.onTrigger(AbstractProcessor.java:27) ~[nifi-api-0.5.1.jar:0.5.1]
      at org.apache.nifi.controller.StandardProcessorNode.onTrigger(StandardProcessorNode.java:1139) [nifi-framework-core-0.5.1.jar:0.5.1]
      at org.apache.nifi.controller.tasks.ContinuallyRunProcessorTask.call(ContinuallyRunProcessorTask.java:139) [nifi-framework-core-0.5.1.jar:0.5.1]
      at org.apache.nifi.controller.tasks.ContinuallyRunProcessorTask.call(ContinuallyRunProcessorTask.java:49) [nifi-framework-core-0.5.1.jar:0.5.1]
      at org.apache.nifi.controller.scheduling.TimerDrivenSchedulingAgent$1.run(TimerDrivenSchedulingAgent.java:124) [nifi-framework-core-0.5.1.jar:0.5.1]
      at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) [na:1.7.0_79]
      at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:304) [na:1.7.0_79]
      at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:178) [na:1.7.0_79]
      at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) [na:1.7.0_79]
      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_79]
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [na:1.7.0_79]

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                mattyb149 Matt Burgess
                Reporter:
                bbende Bryan Bende
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: