[
https://issues.apache.org/jira/browse/NIFI-1596?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15183036#comment-15183036
]
ASF GitHub Bot commented on NIFI-1596:
--------------------------------------
GitHub user mattyb149 opened a pull request:
https://github.com/apache/nifi/pull/258
NIFI-1596: ExecuteSQL Error Creating Schema
I ran the unit test before making the change, verified it fails, then made
the fix and the test passes. Also tried in a full NiFi build against Oracle
(where the problem was first noticed).
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/mattyb149/nifi NIFI-1596
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/nifi/pull/258.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #258
----
commit 808074cb077e88c5227a914f97f8b6a55a3c7f01
Author: Matt Burgess <[email protected]>
Date: 2016-03-07T14:10:05Z
NIFI-1596: ExecuteSQL Error Creating Schema
----
> ExecuteSQL Error Creating Schema
> --------------------------------
>
> Key: NIFI-1596
> URL: https://issues.apache.org/jira/browse/NIFI-1596
> Project: Apache NiFi
> Issue Type: Bug
> Reporter: Bryan Bende
> Assignee: Matt Burgess
> Fix For: 0.6.0
>
>
> 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]
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
