What I understand : As soon as you start the processor ExecuteSQL  to load the data from oracle to NiFI , after few min NiFi UI became unviable but when you check on host , NiFi process id shows running. if this the case then  This is a behaviour of resource constraints in NiFi with respect to memory and not the right way to read/load data from database. Two things needs to be considered here . 1. Need to make sure NiFi os configured with right heap settings 2. Load the data in incremental manner.   NiFi can run various Sql loads with 8-16 GB of heap, so this much heap is required  Use GenerateTableFetch before ExecuteSQL and limit number of records in each flow file with settings "Max Rows Per Flow File"  & "Output Batch Size" & Fetch Size. With some test run iterations you need to determine what would be right value for above setting which does not create high heap usage.    Thank You.        ... View more

To answer your question "is there a way to read a parameter from environment inside a parameter context?" No.   The way you want to manage password at runtime is not possible.  ... View more

 I have used CSV file withCountText and it worked fine for me,  Upon success it will writes an attribute name "text.line.count" with number of lines as value, attaching sample csv file which I used to test and it has 6 lines.    ... View more