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 <[email protected]> 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 : [email protected]
