Member since
01-15-2019
11
Posts
0
Kudos Received
0
Solutions
12-01-2023
10:45 AM
@Fanxxx Do you have a load balancer in front of your NiFi Cluster? If so, the load balancer needs to be configured to use session persistence (also known as sticky sessions). That is because when you access node 1 for example and authenticate your user that token is only valid for that specific node (there is a client token and a matching server side key). If subsequent request/redirect is sent to a different node by the load balancer the node is going to be missing the matching server side key and reject the client token. Sharing more details about your NiFi security setup and Apache NiFi version is also valuable to those who may provide suggestion in the community. If you found any of the suggestions/solutions provided helped you with your issue, please take a moment to login and click "Accept as Solution" on one or more of them that helped. Thank you, Matt
... View more
02-12-2021
12:10 AM
This solution will not work. The failure flow does not go to next putDatabaseRecord processor because the error is exception. Failure flow files will go nowhere
... View more
10-22-2020
04:18 PM
@mburgess Helpful information shared. I am using Nifi 1.7.1 For my case, the incremental fetching does not seem to work correctly. All records gets ingested from the database but do not make it all the way to the destination. Processor used is GenerateTableFetch then Execute SQL and the other corresponding processors down the data processing flow. Record id is captured correctly on the GenerateTableFetch property state and its up to date as the record id from the source (db). However, it will still miss some records when processing the files making the number of records on the destination out of sync with the source from the db. Am i missing something, Would scheduling times for fetching help and how can I do that?
... View more
02-20-2019
10:44 PM
1 Kudo
I left an answer to your SO post, basically there is a bug or two preventing BLOB transfer from source to target DBs, but I presented a possible workaround.
... View more
02-15-2019
07:55 PM
@Matt Burgess Thank you.
... View more