Did you update ignite-core-2.16.0.jar file location path under the Database driver location?  ... View more

Do you see any exceptions in the logs before you see the Initiating shutdown of Jetty web server?  ... View more

Load the data into NiFi in an iterative manner, for this you can evaluate GenerateTableFetch -->ExecuteSQL. Loading a large table in one go with ExecuteSQL could result in high heap usage. on the other side, CPU usage is high due to running too many parallelism by increasing the processor concurrent task from default 1 to 8 which is not required.  Thank you ... View more

Since NiFi runs on Linux, you have to use Kerberos as a security Auth when connecting from Nifi to MSSQL:  Please refer https://learn.microsoft.com/en-us/sql/connect/jdbc/using-kerberos-integrated-authentication-to-connect-to-sql-server?view=sql-server-ver16&source=recommendations DBCPconnectionpool has to use the following  jdbc:sqlserver://URL:port;domain=<Domianame >;databasename=<DBNAME >;authenticationScheme=JavaKerberos;TrustServerCertificate=True;integratedSecurity=true with KerberosPasswordUserService controller  to set the Kerberos username Principal and password Hope this helps. Thank you  ... View more

If you can post the exact error you were facing? it would help much to understand.  Also, was the error part of the stdout/stderr file or nifi service initially started by Bootstrap but later went down due to exceptions? What have you added as a group in Ranger?   ... View more

Can you please try these two  NIFI_JVM_HEAP_INIT NIFI_JVM_HEAP_MAX   Thank you  ... View more

I suspect one more NiFi service is running on the same host with the same port, It can be checked easily by running "ps -ef | grep nifi"   ... View more

I would further interested check nifi-user.log to see the forbidden events when you see  403 error  ... View more

403 : Client is not authorized to make this request.  This means you are Authenticated and since you have a valid token but you are not authorized to do this action. to double-check if your user is Authorized, check if you can do the same action directly from NiFi UI ?   Thank you  ... View more