Thank you Isha, I was able to resolve the controller issue. Regards, Urmila Pal
From: Isha Lamboo<mailto:[email protected]> Sent: Wednesday, May 3, 2023 6:19 PM To: [email protected]<mailto:[email protected]> Subject: [EXTERNAL] RE: error in connecting to MSSQL DB Hi Urmila, I see in your screenshot that the listed scope is “Controller”. That means this controller exists not on the Main NiFi Flow canvas, but in some Process Group, where it’s only visible to any processors in that group and its child groups. If you create the controller while on the main canvas, it should have “NiFi Flow” as its scope and be visible to all processors. If that is too broad, create the controller in the main process group of the flow you are making. Regards, Isha Van: Urmila Pal <[email protected]> Verzonden: woensdag 3 mei 2023 14:23 Aan: [email protected] Onderwerp: error in connecting to MSSQL DB Hi Team, I have recently started working on Apache NiFi and was trying to configure ExecuteSQL Processor. I have created a DBCPConnectionPool controller in global menu and is enabled. [cid:[email protected]] But I could not use that controller into the Processor, every time it creates a new controller and I couldn’t see a way to enable it as I am not seeing it in the global menu. Could you please guide me through this. Thank you, Urmila Pal
