@Vas  The straight out of the box generated keystore and truststore will not have "nifi.local" as a SAN entry.   You could generate your own keystore and truststore with needed SAN entry(s). 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

Its a script processor to run a groovy script. If a functional error is detected, I need to send original input file over FTP. ... View more

Sorry for my late post, Yes like you said @SAMSAL  I miss the parameter from connection string : this is my previous connection string jdbc:sqlserver://#{db_cmk_colo_host};port=#{db_cmk_colo_port};database=#{db_cmk_colo_name} And this is after (its working now) jdbc:sqlserver://#{db_cmk_colo_host};port=#{db_cmk_colo_port};database=#{db_cmk_colo_name};authentication=NotSpecified;encrypt=true;trustServerCertificate=true  Thank you again for your help. 😊 ... View more

@SAMSAL , After i added escaping to $ with double slash it got worked in shift too. "#\\${netval}": "&3[&2].&1"   thanks a lot again   ... View more

Hi @SAMSAL , I have thought to write a stored procedure to compare field values and then log value changes to solve problem 2, but one thing is that Records in a Flow File cannot be passed to a stored procedure and interact with the database data in a stored procedure directly. Maybe I didn't know the correct processor or script to use. Do you have any insight on this? ... View more

@SAMSAL are you still on M1 or M2...I'm on M1 and took what you shared and just made those minor tweaks. I'll test it out more tomorrow...maybe I'll restart NiFi just to clear memory and any funny stuff that might there.  ... View more

@coelacanth, My pleasure! Im glad it worked . If you find a better way than having to manually create the bin folder then copy the files from the script folder to it and restarting nifi every time you add new python processor or create the bin folder, please let us know and share. Right now for every python processor I create I have to restart my nifi instance 2 times: 1- Deploy the processor to the canvas so that the venv is created. 2- After the venv is created to copy the files to the bin folder. I know  its possible to create vevn manually under the work folder and get it setup without relying much on Nifi to do it but Im afraid that might interfere with the process and cause other problems. @pvillard, @MattWho , @cotopaul  please if you know better workaround for this let us know.     ... View more