[ https://issues.apache.org/jira/browse/NIFI-5235?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16490461#comment-16490461 ]
Pierre Villard edited comment on NIFI-5235 at 5/25/18 9:24 AM: --------------------------------------------------------------- Hi, What's the definition of the table you're querying? What's the executed query? was (Author: pvillard): Hi, What's the definition of the table you're querying? What's the execute query? > 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: Extensions > Affects Versions: 1.5.0 > Environment: Redhat (64 bit), HP > Reporter: Ravi Pratap Singh > Priority: Major > Original Estimate: 168h > Remaining Estimate: 168h > > 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 : > > {code:java} > 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 > {code:java} > Database Driver Class Name : com.microsoft.sqlserver.jdbc.SQLServerDriver > Database Driver Jar Url : file:///path/to/sqljdbc4.jar{code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)