Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

NiFi connection

avatar
New Contributor

When  trying to connect to a dblink to user the QueryDatabaseTable, NiFi is returning this error:

• 14:24:36 BRT ERROR
QueryDatabase Table[id=c3576641-0184-1000-ad73-c81ab57c11bb]
QueryDatabase Table[id=c3576641-0184-1000-ad73-c81ab57c11bb] 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. Process Exception on Controller Service with
because the Controller
identifier bf90fd3d-0184-1000-4a92-d8b25677a705
Service's State is currently ENABLING; Processor Administratively Yielded for 1
sec: org.apache.nifi.controller.service.Controller Service DisabledException: Cannot
invoke method public default java.sql.Connection
org.apache.nifi.dbcp.DBCPService.getConnection(java.util.Map)
throws
org.apache.nifi.processor.exception. Process Exception on Controller Service with
identifier bf90fd3d-0184-1000-4a92-d8b25677a705 because the Controller
Service's State is currently ENABLING

Can anyone help me?

1 ACCEPTED SOLUTION

avatar
Super Mentor

@grb 

Your QueryDatabaseTable processor is failing because the dependent controller service is not yet enabled. It appears that controller services is still trying to enable (enabling) because the SQLServerDriver you have configured in that controller service is not compatible with the Java JDK version you are using to run NiFi.

What version of NiFi are you using?
What version Java is your NiFi using?


 I recommend updating your Java version to the most recent version of Java JDK 8 or Java JDK 11 (Version 11 only supported in NiFi versions 1.10+).  Otherwise, you'll need to find an older version of your SQ driver.


If you found that the provided solution(s) assisted you with your query, please take a moment to login and click Accept as Solution below each response that helped.

Thank you,

Matt

View solution in original post

3 REPLIES 3

avatar
New Contributor

Theres also that error in my NiFi Flow Configuration:

14:36:05 BRT ERROR
StandardControllerServiceNode[service-DBCPConnectionPool[id=bf90fd3d-
0184-1000-4a92-d8b25677a705], versionedComponentid=null,
processGroup=Standard ProcessGroup[identifier-bf056a65-0184-1000-cb2e-
35c3c5842085,name=NiFi Flow], active=true] Failed to invoke @OnEnabled
method due to java.lang.UnsupportedClass VersionError:
com/microsoft/sqlserver/jdbc/SQLServerDriver has been compiled by a more
recent version of the Java Runtime (class file version 55.0), this version of the
Java Runtime only recognizes class file versions up to 52.0:
com/microsoft/sqlserver/jdbc/SQLServerDriver has been compiled by a more
recent version of the Java Runtime (class file version 55.0), this version of the
Java Runtime only recognizes class file versions up to 52.0

avatar
Super Mentor

@grb 

Your QueryDatabaseTable processor is failing because the dependent controller service is not yet enabled. It appears that controller services is still trying to enable (enabling) because the SQLServerDriver you have configured in that controller service is not compatible with the Java JDK version you are using to run NiFi.

What version of NiFi are you using?
What version Java is your NiFi using?


 I recommend updating your Java version to the most recent version of Java JDK 8 or Java JDK 11 (Version 11 only supported in NiFi versions 1.10+).  Otherwise, you'll need to find an older version of your SQ driver.


If you found that the provided solution(s) assisted you with your query, please take a moment to login and click Accept as Solution below each response that helped.

Thank you,

Matt

avatar
Community Manager

@grb Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future. Thanks


Regards,

Diana Torres,
Community Moderator


Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.
Learn more about the Cloudera Community: