For reference, I tried solution #1 where I added an UpdateAttribute processor and deleted any references to SQL attributes. That did it. Thanks! ... View more

Thank you @SAMSAL ,  we used Execute Process with a curl script file, when writing the script into the Execute Process itself, the body still did not go away. Your message helped solve the problem, 👏but unfortunately I don't have a button to mark it as a solution.😪 ... View more

Thankyou for reffering to experts, Moreover, i am keep going adding the jar files in lib folder but everytime i add and restart the nifi it again give invliad error on another jar file dependency error, do i alos need to add these jar files as dependecy in anyother .xml configuration as well.? ... View more

@Mikkkk Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.  Thanks. ... View more

@HenriqueAX Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.  Thanks. ... View more

Forgot to mention, is there something I said that rendered no responses? My apologies if that's the case, didn't think I ofended anybody. ... View more

From the below , it does looks like tez session itself not initialized.  Validate configuration from set -v , make sure everything fine and try re-running the query.    org.apache.tez.dag.api.SessionNotRunning: TezSession has already shutdown. Application application_1726980746968_0077 failed 1 times (global limit =2; local limit is =1) due to AM Container for appattempt_1726980746968_0077_000001 exited with exitCode: -1000 Failing this attempt.Diagnostics: [2024-10-13 10:30:27.706]Application application_1726980746968_0077 initialization failed (exitCode=255) with output: main : command provided 0    If you can't able to identify the incorrect configuration , raise a support case for the same.  ... View more

Hi @drewski7 ,  Now I have another minor problem.. how do I send you a six pack to thank you for the help??? 😉 Been banging my head on this for days, still going through the logic to learn from it.  Really appreciate the detailed explanation. 👍 🙂 Cheers! :clinking_beer_mugs: ... View more