About Kiranq

Kiranq · ‎10-08-2025

Thanks for replying @MattWho. Yes, Max Timer Driven Thread pool is set to 10 by default. At one time, around 10+ processors run in a single proccess group. Moreover, the Flowfile is indefinitely queued until I manually stop the next processor and then start it again. Once I start it, it smoothly migrates the data. I have not checked the logs, I will do so now.

Kiranq · ‎10-08-2025

Hi all, I have been seeing this problem increasingly now that the data gets stuck in between two different processors -- the data being as small as few KBs what could be the cause of it? The ExecuteSQL contains an SQL insert script. Moreover, this behavior is random -- occurs randomly on any processor. Does my machine specs count in this? I see my CPU usage and memory are not choking as well. Any comments on this will be appreciated. Thanks

Kiranq · ‎10-17-2024

" The only error from today seem to be repeating: 2024-10-17 08:35:19,764 ERROR [Timer-Driven Process Thread-5] o.a.n.c.s.StandardControllerServiceNode StandardControllerServiceNode[service=CSVRecordLookupService[id=a8b84b00-b0ee-31c8-dbda-7e7e9795ba4b], name=CSVRecordLookupService, active=true] Encountering difficulty enabling. (Validation State is INVALID: ['CSV File' is invalid because CSV File is required, 'Lookup Key Column' is invalid because Lookup Key Column is required]). Will continue trying to enable. 2024-10-17 08:35:19,764 ERROR [Timer-Driven Process Thread-13] o.a.n.c.s.StandardControllerServiceNode StandardControllerServiceNode[service=CSVRecordLookupService[id=10c1880b-0376-3223-c6b8-8d14780a8001], name=CSVRecordLookupService, active=true] Encountering difficulty enabling. (Validation State is INVALID: ['CSV File' is invalid because CSV File is required, 'Lookup Key Column' is invalid because Lookup Key Column is required]). Will continue trying to enable." I am also having these erros, if it helps you in any way.

Kiranq · ‎10-17-2024

The NiFi actually starts for the first time, if I close it and try to restart it, it never gets restarted again. No custom add ons. I dont know how to debug in logback.

Kiranq · ‎10-17-2024

@MattWho Hi Matt, I am having the same issue as: Here are my web properties: and java version as below: Please suggest any resolution.

Kiranq · ‎03-26-2024

Any feedback would be appreciated.

Kiranq · ‎03-26-2024

I have extracted below json from my executesql processor: { "Id" : "B2606868-F4BC-4230-9749-A083F6D222B2", "ReminderPlan" : "-5d, -1d'", "ModifiedOn" : "2024-01-03 19:56:59.0000000" } and I have several of these. The task at my hand is to extract the reminderplan value and pass it as an attribute to some sql processor and run a sql function on that reminderplan column value; for example: DECLARE @output varchar(255); SET @output = NewDemo.dbo.StandardizeReminderPlan('-5d, -1d') SELECT @output AS Result; After storing output value in Result, I want to insert the function value back in the same json. Could anyone suggest which processors I should use to accomplish this?

Kiranq · ‎02-02-2024

Any feedback would be appreciated.

Kiranq · ‎02-01-2024

I am trying to access a .py file present in one of the docker container and I am using execute stream command processor for it. However, I am receiving "Permission Denied" error on the .py file. Even though, the file has all the rights given but still facing this issue. Any feedback will be appreciate. Thanks.

Kiranq · ‎10-19-2023

I resolved the issue. I had DepartmentId in my avro schema however, I was getting DepartmentID in the input. Schemas are case sensitive. Now, that the string values are appended in the DepartmentID column, I am using RouteOnContent processors and using ${DepartmentID:equals('Undefined')} to match if the DepartmentID' values are of undefined or null type. It is not identifying the "Undefined" values. is the regex statement correct? Content of flow file is: [ { "TenantId" : "FF369226-0EDA-4D0D-B48C-6B27F404ECCB", "DepartmentID" : "Undefined", "Name": "xyz" } ]

Online	Offline
Last Visited	‎10-10-2025 12:38 AM

Member Since	‎05-30-2023 04:10 AM
Last Visited	‎10-10-2025 12:38 AM
Posts	43
Kudos received	4

Cloudera Community

Re: NiFi processor's data gets stuck between two p...

NiFi processor's data gets stuck between two proce...

Re: apache nifi 2.0.0 M2 JettyServer Failed

Re: apache nifi 2.0.0 M2 JettyServer Failed

Re: apache nifi 2.0.0 M2 JettyServer Failed

Re: Extract Json key, run Sql function and insert ...

Extract Json key, run Sql function and insert resu...

Re: Permission Denied in Execute Stream Command Ni...

Permission Denied in Execute Stream Command Nifi

Re: UpdateRecord processor changes the output of f...