Created 03-13-2022 09:22 PM
2022-03-14 04:03:03,899 INFO [main] o.a.n.b.NotificationServiceManager Successfully loaded the following 0 services: []
2022-03-14 04:03:03,902 INFO [main] org.apache.nifi.bootstrap.RunNiFi Registered no Notification Services for Notification Type NIFI_STARTED
2022-03-14 04:03:03,902 INFO [main] org.apache.nifi.bootstrap.RunNiFi Registered no Notification Services for Notification Type NIFI_STOPPED
2022-03-14 04:03:03,903 INFO [main] org.apache.nifi.bootstrap.RunNiFi Registered no Notification Services for Notification Type NIFI_DIED
2022-03-14 04:03:03,931 INFO [main] org.apache.nifi.bootstrap.RunNiFi Runtime Java version: 1.8.0_312
2022-03-14 04:03:03,941 INFO [main] org.apache.nifi.bootstrap.Command Starting Apache NiFi...
2022-03-14 04:03:03,942 INFO [main] org.apache.nifi.bootstrap.Command Working Directory: /root/nifi-1.15.2
2022-03-14 04:03:03,942 INFO [main] org.apache.nifi.bootstrap.Command Command: /usr/lib/jvm/java-8-openjdk-amd64/bin/java -classpath /root/nifi-1.15.2/./conf:/root/nifi-1.15.2/./lib/postgresql-42.2.23.jar:/root/nifi-1.15.2/./lib/nifi-stateless-api-1.15.2.jar:/root/nifi-1.15.2/./lib/orai18n.jar:/root/nifi-1.15.2/./lib/xdb.jar:/root/nifi-1.15.2/./lib/osdt_core.jar:/root/nifi-1.15.2/./lib/simplefan.jar:/root/nifi-1.15.2/./lib/nifi-server-api-1.15.2.jar:/root/nifi-1.15.2/./lib/slf4j-api-1.7.32.jar:/root/nifi-1.15.2/./lib/nifi-stateless-bootstrap-1.15.2.jar:/root/nifi-1.15.2/./lib/nifi-properties-1.15.2.jar:/root/nifi-1.15.2/./lib/nifi-api-1.15.2.jar:/root/nifi-1.15.2/./lib/ojdbc8.jar:/root/nifi-1.15.2/./lib/nifi-property-utils-1.15.2.jar:/root/nifi-1.15.2/./lib/logback-core-1.2.9.jar:/root/nifi-1.15.2/./lib/xmlparserv2_sans_jaxp_services.jar:/root/nifi-1.15.2/./lib/jcl-over-slf4j-1.7.32.jar:/root/nifi-1.15.2/./lib/jul-to-slf4j-1.7.32.jar:/root/nifi-1.15.2/./lib/logback-classic-1.2.9.jar:/root/nifi-1.15.2/./lib/oraclepki.jar:/root/nifi-1.15.2/./lib/rsi.jar:/root/nifi-1.15.2/./lib/jetty-schemas-3.1.jar:/root/nifi-1.15.2/./lib/nifi-framework-api-1.15.2.jar:/root/nifi-1.15.2/./lib/ucp.jar:/root/nifi-1.15.2/./lib/xmlparserv2.jar:/root/nifi-1.15.2/./lib/osdt_cert.jar:/root/nifi-1.15.2/./lib/javax.servlet-api-3.1.0.jar:/root/nifi-1.15.2/./lib/nifi-runtime-1.15.2.jar:/root/nifi-1.15.2/./lib/log4j-over-slf4j-1.7.32.jar:/root/nifi-1.15.2/./lib/ons.jar:/root/nifi-1.15.2/./lib/nifi-nar-utils-1.15.2.jar -Dorg.apache.jasper.compiler.disablejsr199=true -Xmx2g -Xms512m -Dcurator-log-only-first-connection-issue-as-error-level=true -Djavax.security.auth.useSubjectCredsOnly=true -Djava.security.egd=file:/dev/urandom -Dzookeeper.admin.enableServer=false -Dsun.net.http.allowRestrictedHeaders=true -Djava.net.preferIPv4Stack=true -Djava.awt.headless=true -Djava.protocol.handler.pkgs=sun.net.www.protocol -Dnifi.properties.file.path=/root/nifi-1.15.2/./conf/nifi.properties -Dnifi.bootstrap.listen.port=45093 -Dapp=NiFi -Dorg.apache.nifi.bootstrap.config.log.dir=/root/nifi-1.15.2/logs org.apache.nifi.NiFi
2022-03-14 04:03:03,961 INFO [main] org.apache.nifi.bootstrap.Command Launched Apache NiFi with Process ID 25688
2022-03-14 04:03:04,202 ERROR [NiFi logging handler] org.apache.nifi.StdErr Failed to auto configure default logger context
2022-03-14 04:03:04,202 ERROR [NiFi logging handler] org.apache.nifi.StdErr Reported exception:
2022-03-14 04:03:04,202 ERROR [NiFi logging handler] org.apache.nifi.StdErr ch.qos.logback.core.joran.spi.JoranException: Parser configuration error occurred
2022-03-14 04:03:04,202 ERROR [NiFi logging handler] org.apache.nifi.StdErr at ch.qos.logback.core.joran.event.SaxEventRecorder.buildSaxParser(SaxEventRecorder.java:89)
2022-03-14 04:03:04,202 ERROR [NiFi logging handler] org.apache.nifi.StdErr at ch.qos.logback.core.joran.event.SaxEventRecorder.recordEvents(SaxEventRecorder.java:57)
2022-03-14 04:03:04,203 ERROR [NiFi logging handler] org.apache.nifi.StdErr at ch.qos.logback.core.joran.GenericConfigurator.doConfigure(GenericConfigurator.java:151)
2022-03-14 04:03:04,203 ERROR [NiFi logging handler] org.apache.nifi.StdErr at ch.qos.logback.core.joran.GenericConfigurator.doConfigure(GenericConfigurator.java:110)
2022-03-14 04:03:04,203 ERROR [NiFi logging handler] org.apache.nifi.StdErr at ch.qos.logback.core.joran.GenericConfigurator.doConfigure(GenericConfigurator.java:53)
2022-03-14 04:03:04,203 ERROR [NiFi logging handler] org.apache.nifi.StdErr at ch.qos.logback.classic.util.ContextInitializer.configureByResource(ContextInitializer.java:65)
2022-03-14 04:03:04,203 ERROR [NiFi logging handler] org.apache.nifi.StdErr at ch.qos.logback.classic.util.ContextInitializer.autoConfig(ContextInitializer.java:140)
2022-03-14 04:03:04,203 ERROR [NiFi logging handler] org.apache.nifi.StdErr at org.slf4j.impl.StaticLoggerBinder.init(StaticLoggerBinder.java:84)
2022-03-14 04:03:04,203 ERROR [NiFi logging handler] org.apache.nifi.StdErr at org.slf4j.impl.StaticLoggerBinder.<clinit>(StaticLoggerBinder.java:55)
2022-03-14 04:03:04,203 ERROR [NiFi logging handler] org.apache.nifi.StdErr at org.slf4j.LoggerFactory.bind(LoggerFactory.java:150)
2022-03-14 04:03:04,203 ERROR [NiFi logging handler] org.apache.nifi.StdErr at org.slf4j.LoggerFactory.performInitialization(LoggerFactory.java:124)
2022-03-14 04:03:04,203 ERROR [NiFi logging handler] org.apache.nifi.StdErr at org.slf4j.LoggerFactory.getILoggerFactory(LoggerFactory.java:417)
2022-03-14 04:03:04,203 ERROR [NiFi logging handler] org.apache.nifi.StdErr at org.slf4j.LoggerFactory.getLogger(LoggerFactory.java:362)
2022-03-14 04:03:04,203 ERROR [NiFi logging handler] org.apache.nifi.StdErr at org.slf4j.LoggerFactory.getLogger(LoggerFactory.java:388)
2022-03-14 04:03:04,203 ERROR [NiFi logging handler] org.apache.nifi.StdErr at org.apache.nifi.NiFi.<clinit>(NiFi.java:71)
2022-03-14 04:03:04,203 ERROR [NiFi logging handler] org.apache.nifi.StdErr Caused by: javax.xml.parsers.ParserConfigurationException: SAX feature 'http://xml.org/sax/features/external-general-entities' not supported.
2022-03-14 04:03:04,203 ERROR [NiFi logging handler] org.apache.nifi.StdErr at oracle.xml.jaxp.JXSAXParserFactory.setFeature(JXSAXParserFactory.java:272)
2022-03-14 04:03:04,203 ERROR [NiFi logging handler] org.apache.nifi.StdErr at ch.qos.logback.core.joran.event.SaxEventRecorder.buildSaxParser(SaxEventRecorder.java:82)
2022-03-14 04:03:04,203 ERROR [NiFi logging handler] org.apache.nifi.StdErr ... 14 more
2022-03-14 04:03:04,222 INFO [NiFi logging handler] org.apache.nifi.StdOut 04:03:04,119 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could NOT find resource [logback-test.xml]
2022-03-14 04:03:04,222 INFO [NiFi logging handler] org.apache.nifi.StdOut 04:03:04,119 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could NOT find resource [logback.groovy]
2022-03-14 04:03:04,222 INFO [NiFi logging handler] org.apache.nifi.StdOut 04:03:04,119 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Found resource [logback.xml] at [file:/root/nifi-1.15.2/conf/logback.xml]
2022-03-14 04:03:04,222 INFO [NiFi logging handler] org.apache.nifi.StdOut 04:03:04,202 |-ERROR in ch.qos.logback.core.joran.event.SaxEventRecorder@2471cca7 - Parser configuration error occurred javax.xml.parsers.ParserConfigurationException: SAX feature 'http://xml.org/sax/features/external-general-entities' not supported.
2022-03-14 04:03:04,222 INFO [NiFi logging handler] org.apache.nifi.StdOut at javax.xml.parsers.ParserConfigurationException: SAX feature 'http://xml.org/sax/features/external-general-entities' not supported.
2022-03-14 04:03:04,222 INFO [NiFi logging handler] org.apache.nifi.StdOut at at oracle.xml.jaxp.JXSAXParserFactory.setFeature(JXSAXParserFactory.java:272)
2022-03-14 04:03:04,222 INFO [NiFi logging handler] org.apache.nifi.StdOut at at ch.qos.logback.core.joran.event.SaxEventRecorder.buildSaxParser(SaxEventRecorder.java:82)
2022-03-14 04:03:04,222 INFO [NiFi logging handler] org.apache.nifi.StdOut at at ch.qos.logback.core.joran.event.SaxEventRecorder.recordEvents(SaxEventRecorder.java:57)
2022-03-14 04:03:04,222 INFO [NiFi logging handler] org.apache.nifi.StdOut at at ch.qos.logback.core.joran.GenericConfigurator.doConfigure(GenericConfigurator.java:151)
2022-03-14 04:03:04,222 INFO [NiFi logging handler] org.apache.nifi.StdOut at at ch.qos.logback.core.joran.GenericConfigurator.doConfigure(GenericConfigurator.java:110)
2022-03-14 04:03:04,222 INFO [NiFi logging handler] org.apache.nifi.StdOut at at ch.qos.logback.core.joran.GenericConfigurator.doConfigure(GenericConfigurator.java:53)
2022-03-14 04:03:04,222 INFO [NiFi logging handler] org.apache.nifi.StdOut at at ch.qos.logback.classic.util.ContextInitializer.configureByResource(ContextInitializer.java:65)
2022-03-14 04:03:04,222 INFO [NiFi logging handler] org.apache.nifi.StdOut at at ch.qos.logback.classic.util.ContextInitializer.autoConfig(ContextInitializer.java:140)
2022-03-14 04:03:04,222 INFO [NiFi logging handler] org.apache.nifi.StdOut at at org.slf4j.impl.StaticLoggerBinder.init(StaticLoggerBinder.java:84)
2022-03-14 04:03:04,222 INFO [NiFi logging handler] org.apache.nifi.StdOut at at org.slf4j.impl.StaticLoggerBinder.<clinit>(StaticLoggerBinder.java:55)
2022-03-14 04:03:04,222 INFO [NiFi logging handler] org.apache.nifi.StdOut at at org.slf4j.LoggerFactory.bind(LoggerFactory.java:150)
2022-03-14 04:03:04,222 INFO [NiFi logging handler] org.apache.nifi.StdOut at at org.slf4j.LoggerFactory.performInitialization(LoggerFactory.java:124)
2022-03-14 04:03:04,222 INFO [NiFi logging handler] org.apache.nifi.StdOut at at org.slf4j.LoggerFactory.getILoggerFactory(LoggerFactory.java:417)
2022-03-14 04:03:04,222 INFO [NiFi logging handler] org.apache.nifi.StdOut at at org.slf4j.LoggerFactory.getLogger(LoggerFactory.java:362)
2022-03-14 04:03:04,222 INFO [NiFi logging handler] org.apache.nifi.StdOut at at org.slf4j.LoggerFactory.getLogger(LoggerFactory.java:388)
2022-03-14 04:03:04,222 INFO [NiFi logging handler] org.apache.nifi.StdOut at at org.apache.nifi.NiFi.<clinit>(NiFi.java:71)
2022-03-14 04:03:04,222 INFO [NiFi logging handler] org.apache.nifi.StdOut
2022-03-14 04:03:04,521 INFO [NiFi Bootstrap Command Listener] org.apache.nifi.bootstrap.RunNiFi Apache NiFi now running and listening for Bootstrap requests on port 33541
2022-03-14 04:03:20,704 ERROR [NiFi logging handler] org.apache.nifi.StdErr Failed to start web server: oracle/i18n/util/LocaleMapper
2022-03-14 04:03:20,704 ERROR [NiFi logging handler] org.apache.nifi.StdErr Shutting down...
2022-03-14 04:03:20,964 INFO [main] org.apache.nifi.bootstrap.RunNiFi NiFi never started. Will not restart NiFi
after adding the jdbc driver into the lib floder, i can not use the `nifi.sh start` command to start the nifi server , and the above is the error log
Created 03-14-2022 03:11 AM
The error seems to be provided from nifi-boostrap.log , please check corresponding nifi-app.log and share for any warning or error leading to stop of nifi service so we can check further and help.
Thank You.
Created 03-14-2022 03:48 PM
What's the exact JDBC driver and version that you added to the lib folder?
André
Created 03-14-2022 10:08 PM
Hi @gaofzhan,
For what reason are you copying the JDBC driver to the NiFi's lib folder?
When you need to JDBC driver for connecting to the remote sources, you typically only need to copy the ojdbc8.jar file. If you copy all the files that come in the tarball downloaded from Oracle it can cause errors like the one you describe.
Please remove the copied files from the lib folder, copy only the ojdbc8.jar one and try again.
Cheers,
André