Trying to run a ExecuteSQL on MiniFi on a remote mysql DB server.
I'm hitting the error. The config.yml does not have the connection pool instead pointing to the connection pool UUID. Do we need to export the connection pool while creating a template for minifi. If now, how does minifi know what DB connection information to use.
2017-03-07 05:27:28,911 ERROR [main] o.apache.nifi.controller.FlowController Unable to start ExecuteSQL[id=3e913fc1-a6ed-196e-0000-000000000000] due to java.lang.IllegalStateException: Processor ExecuteSQL_Hive is not in a valid state due to ['Database Connection Pooling Service' validated against 'ed333d3f-0c93-1f69-ffff-ffffd097f976' is invalidbecauseInvalidControllerService: ed333d3f-0c93-1f69-ffff-ffffd097f976 is not a valid ControllerService Identifier or does not reference the correct type of ControllerService]