英文:
Connect NiFi to MS SQL server windows 10
问题
无法连接到SQL Server使用nifi,你能否帮助我解决以下错误?
错误信息:
00:52:36 ISTERRORcf6cf1cb-0173-1000-1496-523d316e3cff
ExecuteSQL[id=cf6cf1cb-0173-1000-1496-523d316e3cff]执行失败,因为无法调用方法public default java.sql.Connection org.apache.nifi.dbcp.DBCPService.getConnection(java.util.Map) throws org.apache.nifi.processor.exception.ProcessException,原因是控制器服务的状态当前为ENABLING;处理器在1秒内被管理员暂停:org.apache.nifi.controller.service.ControllerServiceDisabledException: 无法调用方法public default java.sql.Connection org.apache.nifi.dbcp.DBCPService.getConnection(java.util.Map) throws org.apache.nifi.processor.exception.ProcessException,原因是控制器服务的状态当前为ENABLING
数据库连接URL: jdbc:sqlserver://localhost;databaseName=DB_NAME;integratedSecurity=true;
数据库驱动程序类名 com.microsoft.sqlserver.jdbc.SQLServerDriver
数据库驱动程序位置 file:///C:/Users/user_name/sqljdbc_8.4/enu/mssql-jdbc-8.4.0.jre8.jar
英文:
I am not able to connect nifi using sql server can you please help me getting below error
Error
00:52:36 ISTERRORcf6cf1cb-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
Database Connection URL: jdbc:sqlserver://localhost;databaseName=DB_NAME;integratedSecurity=true;
Database Driver Class Name com.microsoft.sqlserver.jdbc.SQLServerDriver
Database Driver Location(s) file:///C:/Users/user_name/sqljdbc_8.4/enu/mssql-jdbc-8.4.0.jre8.jar
答案1
得分: 1
控制器服务的状态为"ENABLING",这意味着该服务尚不可用。刷新界面,当该服务可用时,您可以启动依赖于它的处理器。
英文:
The controller service's state is "ENABLING" which means the service is not available yet. Refresh the UI and when that service is available, you can start the processor that relies on it.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论