[
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)
