https://community.cloudera.com/t5/Archives-of-Support-Questions/NiFi-1-2-QueryTable-on-Phoenix-Not-retrieving-even-with-data/m-p/180495#M61495 <P>only in phoenix sometimes on Zeppelin</P> Tue, 12 Sep 2017 09:03:05 GMT TimothySpann 2017-09-12T09:03:05Z https://community.cloudera.com/t5/Archives-of-Support-Questions/NiFi-1-2-QueryTable-on-Phoenix-Not-retrieving-even-with-data/m-p/180494#M61494 <P>I am going to try a reboot and see if I get a different message.</P><P>2017-05-20 10:37:53,174 ERROR [Timer-Driven Process Thread-3] o.a.n.p.standard.QueryDatabaseTable QueryDatabaseTable[id=65501581-100f-1159-01e0-ac486442f2d0] Unable to execute SQL select query SELECT * FROM TRIALS due to org.apache.nifi.processor.exception.ProcessException: Error during database query or conversion of records to Avro.: {} org.apache.nifi.processor.exception.ProcessException: Error during database query or conversion of records to Avro. at org.apache.nifi.processors.standard.QueryDatabaseTable.lambda$onTrigger$0(QueryDatabaseTable.java:289) at org.apache.nifi.controller.repository.StandardProcessSession.write(StandardProcessSession.java:2377) at org.apache.nifi.processors.standard.QueryDatabaseTable.onTrigger(QueryDatabaseTable.java:283) at org.apache.nifi.controller.StandardProcessorNode.onTrigger(StandardProcessorNode.java:1118) at org.apache.nifi.controller.tasks.ContinuallyRunProcessorTask.call(ContinuallyRunProcessorTask.java:144) at org.apache.nifi.controller.tasks.ContinuallyRunProcessorTask.call(ContinuallyRunProcessorTask.java:47) at org.apache.nifi.controller.scheduling.TimerDrivenSchedulingAgent$1.run(TimerDrivenSchedulingAgent.java:132) 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:745) Caused by: java.sql.SQLException: ERROR 1101 (XCL01): ResultSet is closed. at org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:441) at org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:145) at org.apache.phoenix.jdbc.PhoenixResultSet.checkOpen(PhoenixResultSet.java:215) at org.apache.phoenix.jdbc.PhoenixResultSet.next(PhoenixResultSet.java:772) at org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:207) at org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:207) at org.apache.nifi.processors.standard.util.JdbcCommon.convertToAvroStream(JdbcCommon.java:103) at org.apache.nifi.processors.standard.QueryDatabaseTable.lambda$onTrigger$0(QueryDatabaseTable.java:287) ... 13 common frames omitted</P> Sat, 20 May 2017 21:46:25 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/NiFi-1-2-QueryTable-on-Phoenix-Not-retrieving-even-with-data/m-p/180494#M61494 TimothySpann 2017-05-20T21:46:25Z https://community.cloudera.com/t5/Archives-of-Support-Questions/NiFi-1-2-QueryTable-on-Phoenix-Not-retrieving-even-with-data/m-p/180495#M61495 <P>only in phoenix sometimes on Zeppelin</P> Tue, 12 Sep 2017 09:03:05 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/NiFi-1-2-QueryTable-on-Phoenix-Not-retrieving-even-with-data/m-p/180495#M61495 TimothySpann 2017-09-12T09:03:05Z https://community.cloudera.com/t5/Archives-of-Support-Questions/NiFi-1-2-QueryTable-on-Phoenix-Not-retrieving-even-with-data/m-p/180496#M61496 <P>Make sure Phoenix is enabled. PQS can be running with HBase not enabled for phoenix.</P> Tue, 12 Sep 2017 09:03:49 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/NiFi-1-2-QueryTable-on-Phoenix-Not-retrieving-even-with-data/m-p/180496#M61496 TimothySpann 2017-09-12T09:03:49Z