Nifi processor runs recursively

Question

I am exploring nifi, as of I have created processor group with number of processor which basically select data from Oracle DB and insert in to mongoDB. the the flow works as expected.

The flow is QueryDatabaseTable -> SplitAvro -> ConvertAvorToJson -> PutMongoRecord

In QueryDatabaseTable I have custom query select * from employee, which gives me 100 records and these 100 records inserted into mongoDB. But here issue is QueryDatabaseTable is called again and again, so in result same 100 records are get added in mongoDB again and again. Is there any way to stop this repeated execution? Thanks in advance.

Update: I am using Nifi 1.9.2

PFB QueryDatabaseTable setting tab below

Scheduling

Properties

Update 2: Configuration

Set the timer not to be zero where it is default value or change the scheduling with cron. — Lamanus, Oct 09 '19 at 11:59
@daggett I have attached the configuration for QueryDatabaseTable — Hitesh Ghuge, Oct 09 '19 at 12:40
@Lamanus Yes I have changed `Run Schedule` to non-zore value and its works — Hitesh Ghuge, Oct 09 '19 at 13:07

score 0 · Answer 1 · answered Jan 20 '21 at 20:18

0

Use maximum-value columns if you want to prevent duplicates selection.

answered Jan 20 '21 at 20:18

Bera

673
2
12
31

Nifi processor runs recursively

1 Answers1