You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@nifi.apache.org by "younes (JIRA)" <ji...@apache.org> on 2016/03/10 13:09:40 UTC
[jira] [Closed] (NIFI-1585) SQLExecute with Oracle DB fails into
org.apache.avro.SchemaParseException: Empty name
[ https://issues.apache.org/jira/browse/NIFI-1585?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
younes closed NIFI-1585.
------------------------
Duplicate of the resolved issue : https://issues.apache.org/jira/browse/NIFI-1596
> SQLExecute with Oracle DB fails into org.apache.avro.SchemaParseException: Empty name
> --------------------------------------------------------------------------------------
>
> Key: NIFI-1585
> URL: https://issues.apache.org/jira/browse/NIFI-1585
> Project: Apache NiFi
> Issue Type: Bug
> Reporter: younes
> Priority: Critical
>
> Hello,
> Could not select the right version from the menu, *Affects Version : 0.5.1*
> While trying to launch an SQLExecute Processor to import data from Oracle database, I recieve the following error :
> {code:none}
> 2016-03-03 15:38:12,883 ERROR [Timer-Driven Process Thread-1] o.a.nifi.processors.standard.ExecuteSQL ExecuteSQL[id=570c183b-6298-4010-8fe2-82bc6e9a3564] ExecuteSQL[id=570c183b-6298-4010-8fe2-82bc6e9a3564] failed to process due to org.apache.avro.SchemaParseException: Empty name; rolling back session: org.apache.avro.SchemaParseException: Empty name
> 2016-03-03 15:38:12,893 INFO [Flow Service Tasks Thread-1] o.a.nifi.controller.StandardFlowService Saved flow controller org.apache.nifi.controller.FlowController@4d37e860 // Another save pending = false
> 2016-03-03 15:38:12,893 ERROR [Timer-Driven Process Thread-1] o.a.nifi.processors.standard.ExecuteSQL
> org.apache.avro.SchemaParseException: Empty name
> {code}
> For information this processor used to work with HDF 1.1.1.0-12 (which implements nifi 0.4.1)
> More details about the error :
> {code:none}
> 2016-03-03 15:38:12,883 ERROR [Timer-Driven Process Thread-1] o.a.nifi.processors.standard.ExecuteSQL ExecuteSQL[id=570c183b-6
> 298-4010-8fe2-82bc6e9a3564] ExecuteSQL[id=570c183b-6298-4010-8fe2-82bc6e9a3564] failed to process due to org.apache.avro.SchemaParseException: Empty name; rolling back session: org.apache.avro.SchemaParseException: Empty name
> 2016-03-03 15:38:12,893 INFO [Flow Service Tasks Thread-1] o.a.nifi.controller.StandardFlowService Saved flow controller org.apache.nifi.controller.FlowController@4d37e860 // Another save pending = false
> 2016-03-03 15:38:12,893 ERROR [Timer-Driven Process Thread-1] 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_45]
> at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:304) [na:1.7.0_45]
> at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:178) [na:1.7.0_45]
> at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) [na:1.7.0_45]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_45]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [na:1.7.0_45]
> at java.lang.Thread.run(Thread.java:744) [na:1.7.0_45]
> {code}
> The Processor configuration is:
> {code:none}
> Database Driver Class Name : oracle.jdbc.OracleDriver
> Database Driver Jar Url : file:///path/to/ojdbc7.jar
> {code}
> Th other elements (Database Connection URL, Database User and Password) are tested successfully using a database client
> After enabling Debug mode, I see :
> {code:none}
> nifi-app_2016-03-02_20.0.log:2016-03-02 20:43:27,845 DEBUG [Timer-Driven Process Thread-4] o.a.nifi.processors.standard.ExecuteSQL ExecuteSQL[id=570c123b-6598-4990-8ff2-82bc63aa3564] Executing query SELECT HOSTNAME, USER FROM DESKTOPS
> {code}
> which let me think that the problem happens at one of the lines 157 or 158 of https://github.com/apache/nifi/blob/aa6bc5d505dde3078505199b8aae5eb2c399086a/nifi-nar-bundles/nifi-standard-bundle/nifi-standard-processors/src/main/java/org/apache/nifi/processors/standard/ExecuteSQL.java
> Thanks in advance
> Best Regards
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)