topic Re: DB Connect Oracle Connection Null Pointer Exception in Getting Data In https://community.splunk.com/t5/Getting-Data-In/DB-Connect-Oracle-Connection-Null-Pointer-Exception/m-p/517001#M87497 <P>Hi <a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/129407">@thambisetty</a> , yes Java and JDBC Driver - both are installed. Thank you.</P> Mon, 31 Aug 2020 11:30:30 GMT madhav_dholakia 2020-08-31T11:30:30Z DB Connect Oracle Connection Null Pointer Exception https://community.splunk.com/t5/Getting-Data-In/DB-Connect-Oracle-Connection-Null-Pointer-Exception/m-p/516972#M87494 <P>Hello,</P><P>I am trying to create a connection to Oracle DB but on saving the connection, splunk_app_db_connect_server.log shows below error:</P><LI-CODE lang="markup">2020-08-31 09:20:34.764 +0100 [dw-56 - POST /api/connections/status] ERROR io.dropwizard.jersey.errors.LoggingExceptionMapper - Error handling a request: bd54ff303cdcc36b java.lang.NullPointerException: null at com.splunk.dbx.connector.logger.AuditLogger.replace(AuditLogger.java:50) at com.splunk.dbx.connector.logger.AuditLogger.error(AuditLogger.java:44) at com.splunk.dbx.server.api.service.database.impl.DatabaseMetadataServiceImpl.getStatus(DatabaseMetadataServiceImpl.java:159) at com.splunk.dbx.server.api.service.database.impl.DatabaseMetadataServiceImpl.getConnectionStatus(DatabaseMetadataServiceImpl.java:116) at com.splunk.dbx.server.api.resource.ConnectionResource.getConnectionStatusOfEntity(ConnectionResource.java:72) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java:52) at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:124) at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:167) at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:219) at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:79) at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:469) at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:391) at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:80) at org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:253) at org.glassfish.jersey.internal.Errors$1.call(Errors.java:248) at org.glassfish.jersey.internal.Errors$1.call(Errors.java:244) at org.glassfish.jersey.internal.Errors.process(Errors.java:292) at org.glassfish.jersey.internal.Errors.process(Errors.java:274) at org.glassfish.jersey.internal.Errors.process(Errors.java:244) at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:265) at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:232) at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:680) at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:392) at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:346) at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:365) at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:318) at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:205) at io.dropwizard.jetty.NonblockingServletHolder.handle(NonblockingServletHolder.java:50) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1617) at io.dropwizard.servlets.ThreadNameFilter.doFilter(ThreadNameFilter.java:35) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604) at io.dropwizard.jersey.filter.AllowedMethodsFilter.handle(AllowedMethodsFilter.java:47) at io.dropwizard.jersey.filter.AllowedMethodsFilter.doFilter(AllowedMethodsFilter.java:41) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604) at com.splunk.dbx.server.api.filter.ResponseHeaderFilter.doFilter(ResponseHeaderFilter.java:30) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:545) at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1297) at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:485) at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1212) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) at com.codahale.metrics.jetty9.InstrumentedHandler.handle(InstrumentedHandler.java:249) at io.dropwizard.jetty.RoutingHandler.handle(RoutingHandler.java:52) at org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:717) at org.eclipse.jetty.server.handler.RequestLogHandler.handle(RequestLogHandler.java:54) at org.eclipse.jetty.server.handler.StatisticsHandler.handle(StatisticsHandler.java:173) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) at org.eclipse.jetty.server.Server.handle(Server.java:500) at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:383) at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:547) at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:375) at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:270) at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103) at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:117) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129) at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:388) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:806) at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:938) at java.lang.Thread.run(Thread.java:748)</LI-CODE><P>&nbsp;Splunk 8.0.5</P><P>DB Connect 3.3.1</P><P>&nbsp;</P><P>Can someone please suggest how to resolve this? Thank you.</P><P>&nbsp;</P> Mon, 31 Aug 2020 08:40:51 GMT https://community.splunk.com/t5/Getting-Data-In/DB-Connect-Oracle-Connection-Null-Pointer-Exception/m-p/516972#M87494 madhav_dholakia 2020-08-31T08:40:51Z Re: DB Connect Oracle Connection Null Pointer Exception https://community.splunk.com/t5/Getting-Data-In/DB-Connect-Oracle-Connection-Null-Pointer-Exception/m-p/516980#M87496 <P>Did you install java on windows HF?</P><P>Did you install oracle-jdbc driver?</P> Mon, 31 Aug 2020 09:09:21 GMT https://community.splunk.com/t5/Getting-Data-In/DB-Connect-Oracle-Connection-Null-Pointer-Exception/m-p/516980#M87496 thambisetty 2020-08-31T09:09:21Z Re: DB Connect Oracle Connection Null Pointer Exception https://community.splunk.com/t5/Getting-Data-In/DB-Connect-Oracle-Connection-Null-Pointer-Exception/m-p/517001#M87497 <P>Hi <a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/129407">@thambisetty</a> , yes Java and JDBC Driver - both are installed. Thank you.</P> Mon, 31 Aug 2020 11:30:30 GMT https://community.splunk.com/t5/Getting-Data-In/DB-Connect-Oracle-Connection-Null-Pointer-Exception/m-p/517001#M87497 madhav_dholakia 2020-08-31T11:30:30Z Re: DB Connect Oracle Connection Null Pointer Exception https://community.splunk.com/t5/Getting-Data-In/DB-Connect-Oracle-Connection-Null-Pointer-Exception/m-p/517008#M87499 <P>do you any other oracle connections working?</P><P>what about authentication for the connection you are trying to create? is is oracle local authentication or domain account?</P> Mon, 31 Aug 2020 12:04:16 GMT https://community.splunk.com/t5/Getting-Data-In/DB-Connect-Oracle-Connection-Null-Pointer-Exception/m-p/517008#M87499 thambisetty 2020-08-31T12:04:16Z Re: DB Connect Oracle Connection Null Pointer Exception https://community.splunk.com/t5/Getting-Data-In/DB-Connect-Oracle-Connection-Null-Pointer-Exception/m-p/517010#M87501 <P>ok so this connection worked for a few mins last week, not sure but it has stopped working from this morning. The entity I have created here, I can connect to Oracle Instance through sqlplus using the same credentials.</P> Mon, 31 Aug 2020 12:14:54 GMT https://community.splunk.com/t5/Getting-Data-In/DB-Connect-Oracle-Connection-Null-Pointer-Exception/m-p/517010#M87501 madhav_dholakia 2020-08-31T12:14:54Z Re: DB Connect Oracle Connection Null Pointer Exception https://community.splunk.com/t5/Getting-Data-In/DB-Connect-Oracle-Connection-Null-Pointer-Exception/m-p/517017#M87502 <P>you are getting null pointer exception because when you are trying to save the connection db connect will validate the connection and it's getting nothing back from sql server.</P><P>It could be because of authentication or some other issue.&nbsp;</P><P>can you confirm, if you are using local sql credentials or domain credentials?</P> Mon, 31 Aug 2020 12:48:53 GMT https://community.splunk.com/t5/Getting-Data-In/DB-Connect-Oracle-Connection-Null-Pointer-Exception/m-p/517017#M87502 thambisetty 2020-08-31T12:48:53Z Re: DB Connect Oracle Connection Null Pointer Exception https://community.splunk.com/t5/Getting-Data-In/DB-Connect-Oracle-Connection-Null-Pointer-Exception/m-p/517019#M87504 <P>i am using local sql credentials.</P><P>Thank you.</P> Mon, 31 Aug 2020 12:50:01 GMT https://community.splunk.com/t5/Getting-Data-In/DB-Connect-Oracle-Connection-Null-Pointer-Exception/m-p/517019#M87504 madhav_dholakia 2020-08-31T12:50:01Z