Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

DB Connection Pooling Services Minifi

DB Connection Pooling Services Minifi

Rising Star

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]
1 REPLY 1
Highlighted

Re: DB Connection Pooling Services Minifi

Contributor

Hi, i am also facing same issue..did you get solution for this?

Don't have an account?
Coming from Hortonworks? Activate your account here