将NiFi连接到MS SQL Server Windows 10。

huangapple go评论83阅读模式
英文:

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

将NiFi连接到MS SQL Server Windows 10。

答案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.

huangapple
  • 本文由 发表于 2020年8月9日 03:24:04
  • 转载请务必保留本文链接:https://go.coder-hub.com/63319432.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定