You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@nifi.apache.org by "Ravi Pratap Singh (JIRA)" <ji...@apache.org> on 2018/05/24 20:20:00 UTC
[jira] [Created] (NIFI-5235) SQLExecute with MS SQL Server fails
with org.apache.avro.SchemaParseException: Empty name
Ravi Pratap Singh created NIFI-5235:
---------------------------------------
Summary: SQLExecute with MS SQL Server fails with org.apache.avro.SchemaParseException: Empty name
Key: NIFI-5235
URL: https://issues.apache.org/jira/browse/NIFI-5235
Project: Apache NiFi
Issue Type: Bug
Components: Core Framework
Affects Versions: 1.5.0
Environment: Redhat (64 bit), HP
Reporter: Ravi Pratap Singh
This issue started happening when we upgraded from nifi-1.2.0.3.0.2.0-76 to nifi-1.5.0.3.1.1.0-35. While trying to launch SQLExecute Processor against MS SQL server, I received the following error :
2018-05-24 15:52:06,625 ERROR [Timer-Driven Process Thread-58] o.a.nifi.processors.standard.ExecuteSQL ExecuteSQL[id=9eda8a6b-21c0-31b8-b665-56464223632e] ExecuteSQL[id=9eda8a6b-21c0-31b8-b665-56464223632e] failed to process due to org.apache.avro.SchemaParseException: Empty name; rolling back session: {}
org.apache.avro.SchemaParseException: Empty name
at org.apache.avro.Schema.validateName(Schema.java:1144)
at org.apache.avro.Schema.access$200(Schema.java:81)
at org.apache.avro.Schema$Field.<init>(Schema.java:403)
at org.apache.avro.SchemaBuilder$FieldBuilder.completeField(SchemaBuilder.java:2124)
at org.apache.avro.SchemaBuilder$FieldBuilder.completeField(SchemaBuilder.java:2120)
at org.apache.avro.SchemaBuilder$FieldBuilder.access$5200(SchemaBuilder.java:2034)
at org.apache.avro.SchemaBuilder$FieldDefault.noDefault(SchemaBuilder.java:2146)
at org.apache.nifi.processors.standard.util.JdbcCommon.createSchema(JdbcCommon.java:488)
at org.apache.nifi.processors.standard.util.JdbcCommon.convertToAvroStream(JdbcCommon.java:256)
at org.apache.nifi.processors.standard.ExecuteSQL$2.process(ExecuteSQL.java:230)
at org.apache.nifi.controller.repository.StandardProcessSession.write(StandardProcessSession.java:2571)
at org.apache.nifi.processors.standard.ExecuteSQL.onTrigger(ExecuteSQL.java:218)
at org.apache.nifi.processor.AbstractProcessor.onTrigger(AbstractProcessor.java:27)
at org.apache.nifi.controller.StandardProcessorNode.onTrigger(StandardProcessorNode.java:1122)
at org.apache.nifi.controller.tasks.ContinuallyRunProcessorTask.call(ContinuallyRunProcessorTask.java:147)
at org.apache.nifi.controller.tasks.ContinuallyRunProcessorTask.call(ContinuallyRunProcessorTask.java:47)
at org.apache.nifi.controller.scheduling.TimerDrivenSchedulingAgent$1.run(TimerDrivenSchedulingAgent.java:128)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:748)
{code}
Here is the processor configuration
Database Driver Class Name : com.microsoft.sqlserver.jdbc.SQLServerDriver
Database Driver Jar Url : file:///path/to/sqljdbc4.jar
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)