question Re: NiFi connection in Support Questions

NiFi connection

grb — Tue, 29 Nov 2022 17:35:39 GMT

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?

Re: NiFi connection

grb — Tue, 29 Nov 2022 17:42:46 GMT

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

Re: NiFi connection

MattWho — Mon, 05 Dec 2022 19:09:52 GMT

@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

Re: NiFi connection

DianaTorres — Tue, 06 Dec 2022 22:35:50 GMT

@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