[jira] [Created] (NIFI-4174) GenerateTableFetch does not work with oracle on Nifi 1.2

["Jorge Machado (JIRA)" <ji...@apache.org>]

Jorge Machado created NIFI-4174:
-----------------------------------

             Summary: GenerateTableFetch does not work with oracle on Nifi 1.2
                 Key: NIFI-4174
                 URL: https://issues.apache.org/jira/browse/NIFI-4174
             Project: Apache NiFi
          Issue Type: Bug
    Affects Versions: 1.2.0
            Reporter: Jorge Machado
            Priority: Minor


I'm trying to extract some data from a oracle DB.  
I'm getting : 


{code:java}
2017-07-11 16:19:29,612 WARN [StandardProcessScheduler Thread-7] o.a.n.controller.StandardProcessorNode Timed out while waiting for OnScheduled of 'GenerateTableFetch' processor to finish. An attempt is made to cancel the task via Thread.interrupt(). However it does not guarantee that the task will be canceled since the code inside current OnScheduled operation may have been written to ignore interrupts which may result in a runaway thread. This could lead to more issues, eventually requiring NiFi to be restarted. This is usually a bug in the target Processor 'GenerateTableFetch[id=f08a3acd-ac7e-17d7-598b-8f9720fd92d4]' that needs to be documented, reported and eventually fixed.
2017-07-11 16:19:29,612 ERROR [StandardProcessScheduler Thread-7] o.a.n.p.standard.GenerateTableFetch GenerateTableFetch[id=f08a3acd-ac7e-17d7-598b-8f9720fd92d4] GenerateTableFetch[id=f08a3acd-ac7e-17d7-598b-8f9720fd92d4] failed to invoke @OnScheduled method due to java.lang.RuntimeException: Timed out while executing one of processor's OnScheduled task.; processor will not be scheduled to run for 30 seconds: java.lang.RuntimeException: Timed out while executing one of processor's OnScheduled task.
java.lang.RuntimeException: Timed out while executing one of processor's OnScheduled task.
	at org.apache.nifi.controller.StandardProcessorNode.invokeTaskAsCancelableFuture(StandardProcessorNode.java:1480)
	at org.apache.nifi.controller.StandardProcessorNode.access$000(StandardProcessorNode.java:102)
	at org.apache.nifi.controller.StandardProcessorNode$1.run(StandardProcessorNode.java:1303)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
	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)
Caused by: java.util.concurrent.TimeoutException: null
	at java.util.concurrent.FutureTask.get(FutureTask.java:205)
	at org.apache.nifi.controller.StandardProcessorNode.invokeTaskAsCancelableFuture(StandardProcessorNode.java:1465)
	... 9 common frames omitted
2017-07-11 16:19:29,613 ERROR [StandardProcessScheduler Thread-7] o.a.n.controller.StandardProcessorNode Failed to invoke @OnScheduled method due to java.lang.RuntimeException: Timed out while executing one of processor's OnScheduled task.
java.lang.RuntimeException: Timed out while executing one of processor's OnScheduled task.
	at org.apache.nifi.controller.StandardProcessorNode.invokeTaskAsCancelableFuture(StandardProcessorNode.java:1480)
	at org.apache.nifi.controller.StandardProcessorNode.access$000(StandardProcessorNode.java:102)
	at org.apache.nifi.controller.StandardProcessorNode$1.run(StandardProcessorNode.java:1303)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
	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)
Caused by: java.util.concurrent.TimeoutException: null
	at java.util.concurrent.FutureTask.get(FutureTask.java:205)
	at org.apache.nifi.controller.StandardProcessorNode.invokeTaskAsCancelableFuture(StandardProcessorNode.java:1465)
	... 9 common frames omitted
{code}

Database Connection Pooling Service:
jdbc:oracle:thin:@somehost:6779:someSID
oracle.jdbc.OracleDriver
/pathTo/ojdbc7.jar
max wait time 500mil


On the processor I have:

Max Wait Time 10 seconds
Partition Size 100

i tryed schedule 0s and 10 000s result is the same




--
This message was sent by Atlassian JIRA
(v6.4.14#64029)