You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@nifi.apache.org by VEERANJI G <gv...@gmail.com> on 2020/08/08 19:58:02 UTC

DBCP connection pool Issue in Windows nifi-1.11.4-bin

Hi Team,
can you help me on below issue

01:24:20 IST
ERROR
cf6cf1cb-0173-1000-1496-523d316e3cff

ExecuteSQL[id=cf6cf1cb-0173-1000-1496-523d316e3cff]
ExecuteSQL[id=cf6cf1cb-0173-1000-1496-523d316e3cff] failed to process
session due to Cannot invoke method public default java.sql.Connection
org.apache.nifi.dbcp.DBCPService.getConnection(java.util.Map) throws
org.apache.nifi.processor.exception.ProcessException on Controller
Service with identifier cf674d7f-0173-1000-ce58-0312a249a0df because
the Controller Service's State is currently ENABLING; Processor
Administratively Yielded for 1 sec:
org.apache.nifi.controller.service.ControllerServiceDisabledException:
Cannot invoke method public default java.sql.Connection
org.apache.nifi.dbcp.DBCPService.getConnection(java.util.Map) throws
org.apache.nifi.processor.exception.ProcessException on Controller
Service with identifier cf674d7f-0173-1000-ce58-0312a249a0df because
the Controller Service's State is currently ENABLING






Controller Service Details
Database Connection URL
jdbc:sqlserver://localhost;databaseName=Anji;integratedSecurity=true;
Database Driver Class Name com.microsoft.sqlserver.jdbc.SQLServerDriver
Database Driver Location(s) * file:///C:/mssql-jdbc-8.4.0.jre8.jar*

-- 
*Thank & Regards*
*Veeranjaneyulu,*
Hello : +91 9042729425,
Email : gvn5810@gmail.com

Re: DBCP connection pool Issue in Windows nifi-1.11.4-bin

Posted by Mike Thomsen <mi...@gmail.com>.
Most likely issue is that it's hanging trying to connect to SQL
Server. Try independently verifying that you can make a connection
from that server.

On Sat, Aug 8, 2020 at 4:15 PM VEERANJI G <gv...@gmail.com> wrote:
>
> Hi Team,
> can you help me on below issue
>
> 01:24:20 IST
> ERROR
> cf6cf1cb-0173-1000-1496-523d316e3cff
>
> ExecuteSQL[id=cf6cf1cb-0173-1000-1496-523d316e3cff]
> ExecuteSQL[id=cf6cf1cb-0173-1000-1496-523d316e3cff] failed to process
> session due to Cannot invoke method public default java.sql.Connection
> org.apache.nifi.dbcp.DBCPService.getConnection(java.util.Map) throws
> org.apache.nifi.processor.exception.ProcessException on Controller
> Service with identifier cf674d7f-0173-1000-ce58-0312a249a0df because
> the Controller Service's State is currently ENABLING; Processor
> Administratively Yielded for 1 sec:
> org.apache.nifi.controller.service.ControllerServiceDisabledException:
> Cannot invoke method public default java.sql.Connection
> org.apache.nifi.dbcp.DBCPService.getConnection(java.util.Map) throws
> org.apache.nifi.processor.exception.ProcessException on Controller
> Service with identifier cf674d7f-0173-1000-ce58-0312a249a0df because
> the Controller Service's State is currently ENABLING
>
>
>
>
>
>
> Controller Service Details
> Database Connection URL
> jdbc:sqlserver://localhost;databaseName=Anji;integratedSecurity=true;
> Database Driver Class Name com.microsoft.sqlserver.jdbc.SQLServerDriver
> Database Driver Location(s) * file:///C:/mssql-jdbc-8.4.0.jre8.jar*
>
> --
> *Thank & Regards*
> *Veeranjaneyulu,*
> Hello : +91 9042729425,
> Email : gvn5810@gmail.com