question Re: 'Database Connection Pooling Service' validated against '' is invalid because invalid controller service in Archives of Support Questions (Read Only)

'Database Connection Pooling Service' validated against '' is invalid because invalid controller service

ankit_garg0489 — Sun, 18 Aug 2019 11:49:58 GMT

Hi,

I have implemented custom processor in nifi and used DBService connection pool in the processor. I have built it and put .nar file into lib folder of nifi.

When I am creating new DB connection pool then its working fine but when I am using another built in processor or another custom processor along with this where DB connection is required then it gives some errors. It doesn't fetch the connection. For example I have created 1 processor 'ThreatRawProcessor' and using DB connection for the operation and I am using 1 build in processor 'ExecuteSQL' along with custom processor for select the record from table. But the issue is that only cutom processor is able to fetch & use the DB connection but another processors are not able to fetch the connection. Please find the screenshot for the same :

CutomProcessor's Configuration :

Execute SQL Configuration :

Error Message :

Code where connection pool is used : Kindly check the below link for screenshot.

https://postimg.org/image/8l6vb3xhl/

Kindly help me how to resolve this error & I can get the connection in other processor's also.

Thanks in Advance.

Regards,

Ankit

Re: 'Database Connection Pooling Service' validated against '' is invalid because invalid controller service

aishwarya020793 — Fri, 10 Mar 2017 18:53:54 GMT

Hi, I have the same issue. Did you find any solution to it? @Ankit Garg @Matt Burgess

Re: 'Database Connection Pooling Service' validated against '' is invalid because invalid controller service

ankit_garg0489 — Fri, 10 Mar 2017 19:20:23 GMT

@aishwarya srivastava

Hi, Yes I resolved the issue. Could you please show me your pom.xml file of your processor and nar project ?

Re: 'Database Connection Pooling Service' validated against '' is invalid because invalid controller service

aishwarya020793 — Fri, 10 Mar 2017 20:41:11 GMT

hi, I have attached my pom file and java code. If you need any more details let me know. @Ankit Garg

myprocessor.txt pom.xml

Re: 'Database Connection Pooling Service' validated against '' is invalid because invalid controller service

ankit_garg0489 — Sat, 11 Mar 2017 00:24:19 GMT

Hi, You didn't share nar project's pom.xml file. Please share nar project's pom file.

Re: 'Database Connection Pooling Service' validated against '' is invalid because invalid controller service

ankit_garg0489 — Sat, 11 Mar 2017 00:35:16 GMT

I resolved this issue. This issue occurs when nifi custom processor uses any inbuilt controller service so that custom processor should contain the service API in the custom nar file and for that we have to add dependency in the nar project's pom.xml file. Add the following dependency in the pom.xml file of nar project :

<dependency>

<groupId>org.apache.nifi</groupId>

<artifactId>nifi-standard-services-api-nar</artifactId>

<version>1.1.1</version>

<type>nar</type>

</dependency>

Note : change version according to your nifi version.

Add these lines and the issue will be resolved.

Re: 'Database Connection Pooling Service' validated against '' is invalid because invalid controller service

ankit_garg0489 — Sat, 11 Mar 2017 10:33:18 GMT

Hi, please check the answer I posted.

Re: 'Database Connection Pooling Service' validated against '' is invalid because invalid controller service

aishwarya020793 — Sun, 18 Aug 2019 11:49:28 GMT

Hi Ankit,

I added the dependency as you had instructed but now I am getting error in the same line of pom file

which says "Project build error: 'dependencies.dependency.groupId' for null:nifi-standard-services-api-nar:nar is missing."

I have added a screenshot of the same. Kindly Help me out. @Ankit Garg

Re: 'Database Connection Pooling Service' validated against '' is invalid because invalid controller service

ankit_garg0489 — Tue, 14 Mar 2017 18:39:32 GMT

@aishwarya srivastava

Please add below line :

<groupId>org.apache.nifi</groupId>

Re: 'Database Connection Pooling Service' validated against '' is invalid because invalid controller service

aishwarya020793 — Tue, 14 Mar 2017 19:56:59 GMT

Thanks a lot. It worked for me. Thanks for your help. 🙂