Dataset cannot be Deleted due to SSLHandshakeException (Doc ID 2979154.1)

Last updated on OCTOBER 11, 2023

Applies to:

Symptoms

Datasets cannot be deleted via DV after configuring SSL.

bi_server1-diagnostic.log has the following ERROR:

[timestamp] [bi_server1] [ERROR] [] [oracle.apps.bi.datarefresh.dssext.api.core.DataRefreshNotifyAPICore] [tid [ACTIVE].ExecuteThread '37' for queue 'weblogic.kernel.Default (self-tuning)'] [userId anonymous] [ecid ECID] [APP bidatasetsvc] [partition-name DOMAIN] [tenant-name GLOBAL] [SI-Key ssi] Failed to submit DSS Request to Data Refresh Service. Tried all nodes.
[timestamp] [bi_server1] [ERROR] [] [oracle.apps.bi.datarefresh.dssext.api.core.DataRefreshNotifyAPICore] [tid [ACTIVE].ExecuteThread '37' for queue 'weblogic.kernel.Default (self-tuning)'] [userId anonymous] [ecid ECID] [APP bidatasetsvc] [partition-name DOMAIN] [tenant-name GLOBAL] [SI-Key ssi] Not able to create delete request for the event id fe72629f-7065-4674-9e00-40a207407001[[
javax.ws.rs.ProcessingException javax.net.ssl.SSLHandshakeException sun.security.validator.ValidatorException PKIX path building failed sun.security.provider.certpath.SunCertPathBuilderException unable to find valid certification path to requested target
at org.glassfish.jersey.client.internal.HttpUrlConnector.apply(HttpUrlConnector.java287)
at org.glassfish.jersey.client.ClientRuntime.invoke(ClientRuntime.java255)
at org.glassfish.jersey.client.JerseyInvocation$1.call(JerseyInvocation.java684)
at org.glassfish.jersey.client.JerseyInvocation$1.call(JerseyInvocation.java681)
at org.glassfish.jersey.internal.Errors.process(Errors.java315)
at org.glassfish.jersey.internal.Errors.process(Errors.java297)
at org.glassfish.jersey.internal.Errors.process(Errors.java228)
at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java444)
at org.glassfish.jersey.client.JerseyInvocation.invoke(JerseyInvocation.java681)
at org.glassfish.jersey.client.JerseyInvocation$Builder.method(JerseyInvocation.java437)
at org.glassfish.jersey.client.JerseyInvocation$Builder.post(JerseyInvocation.java343)
at oracle.apps.bi.datarefresh.dssext.api.core.DataRefreshNotifyAPICore.submitHttpRequest(DataRefreshNotifyAPICore.java665)
at oracle.apps.bi.datarefresh.dssext.api.core.DataRefreshNotifyAPICore.processRequest(DataRefreshNotifyAPICore.java612)
at oracle.apps.bi.datarefresh.dssext.api.core.DataRefreshNotifyAPICore.addDSSRequest(DataRefreshNotifyAPICore.java542)
at oracle.apps.bi.datarefresh.dssext.api.core.DataRefreshNotifyAPICore.performDSSDeleteEvent(DataRefreshNotifyAPICore.java427)
at oracle.apps.bi.datarefresh.dssext.api.core.DataRefreshNotifyAPICore.entityDeleted(DataRefreshNotifyAPICore.java50)
at oracle.apps.bi.datarefresh.dssext.listeners.DataRefreshDSSEntityLifecycleListener.entityDeleted(DataRefreshDSSEntityLifecycleListener.java25)
at oracle.bi.web.datasetsvc.extension.services.notification.NotificationServiceImpl.broadcast(NotificationServiceImpl.java234)
at oracle.bi.web.datasetsvc.extension.services.notification.NotificationServiceImpl.broadcastLifecycleEventBatchPreCommit(NotificationServiceImpl.java181)
at oracle.bi.web.datasetsvc.api.core.NotificationUtils.broadcastLifecycleEventBatchPreCommit(NotificationUtils.java331)
at oracle.bi.web.datasetsvc.api.core.v5.DatamodelsCore.deleteDatamodel(DatamodelsCore.java393)
at oracle.bi.web.datasetsvc.api.core.v5.DatamodelsCore.deleteDatamodel(DatamodelsCore.java368)
at oracle.bi.web.datasetsvc.api.rest.v5.DatamodelsREST.deleteDataset(DatamodelsREST.java562)
at oracle.bi.web.datasetsvc.api.rest.v6.DatamodelsREST.deleteDataset(DatamodelsREST.java751)
at sun.reflect.GeneratedMethodAccessor1799.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java43)
at java.lang.reflect.Method.invoke(Method.java498)
at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java81)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java144)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java161)
at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$ResponseOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java160)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java99)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java389)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java347)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java102)
at org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java326)
at org.glassfish.jersey.internal.Errors$1.call(Errors.java271)
at org.glassfish.jersey.internal.Errors$1.call(Errors.java267)
at org.glassfish.jersey.internal.Errors.process(Errors.java315)
at org.glassfish.jersey.internal.Errors.process(Errors.java297)
at org.glassfish.jersey.internal.Errors.process(Errors.java267)
at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java317)
at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java305)
at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java1154)
at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java473)
at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java427)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java388)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java341)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java228)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java295)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java260)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java137)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java353)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java25)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java78)
at oracle.bi.web.datasetsvc.api.rest.filter.throttle.ThrottleServletFilter.doFilter(ThrottleServletFilter.java39)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java78)
at oracle.bi.web.datasetsvc.security.DSSSecurityFilter.doFilter(DSSSecurityFilter.java112)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java78)
at oracle.bi.security.filter.BISecurityRESTFilter.lambda$chainToNext$1(BISecurityRESTFilter.java698)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java422)
at oracle.bi.security.filter.BISecurityRESTFilter.chainToNext(BISecurityRESTFilter.java708)
at oracle.bi.security.filter.BISecurityRESTFilter.handleSystemUserSubject(BISecurityRESTFilter.java568)
at oracle.bi.security.filter.BISecurityRESTFilter.doFilter(BISecurityRESTFilter.java185)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java78)
at oracle.security.jps.ee.http.JpsAbsFilter$3.run(JpsAbsFilter.java175)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java314)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java650)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java112)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilterInternal(JpsAbsFilter.java293)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java150)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java94)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java78)
at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java248)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java78)
at oracle.jrf.servlet.ExtensibleGlobalFilter.doFilter(ExtensibleGlobalFilter.java92)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java78)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java3800)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java3766)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java344)
at weblogic.security.service.SecurityManager.runAsForUserCode(SecurityManager.java197)
at weblogic.servlet.provider.WlsSecurityProvider.runAsForUserCode(WlsSecurityProvider.java203)
at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java71)
at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java2454)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java2302)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java2280)
at weblogic.servlet.internal.ServletRequestImpl.runInternal(ServletRequestImpl.java1739)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java1699)
at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java272)
at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java352)
at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java337)
at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java57)
at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java41)
at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java655)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java420)
at weblogic.work.ExecuteThread.run(ExecuteThread.java360)
Caused by javax.net.ssl.SSLHandshakeException sun.security.validator.ValidatorException PKIX path building failed sun.security.provider.certpath.SunCertPathBuilderException unable to find valid certification path to requested target
at sun.security.ssl.Alert.createSSLException(Alert.java131)
at sun.security.ssl.TransportContext.fatal(TransportContext.java377)
at sun.security.ssl.TransportContext.fatal(TransportContext.java320)
at sun.security.ssl.TransportContext.fatal(TransportContext.java315)
at sun.security.ssl.CertificateMessage$T13CertificateConsumer.checkServerCerts(CertificateMessage.java1355)
at sun.security.ssl.CertificateMessage$T13CertificateConsumer.onConsumeCertificate(CertificateMessage.java1230)
at sun.security.ssl.CertificateMessage$T13CertificateConsumer.consume(CertificateMessage.java1173)
at sun.security.ssl.SSLHandshake.consume(SSLHandshake.java376)
at sun.security.ssl.HandshakeContext.dispatch(HandshakeContext.java479)
at sun.security.ssl.SSLEngineImpl$DelegatedTask$DelegatedAction.run(SSLEngineImpl.java991)
at sun.security.ssl.SSLEngineImpl$DelegatedTask$DelegatedAction.run(SSLEngineImpl.java978)
at java.security.AccessController.doPrivileged(Native Method)
at sun.security.ssl.SSLEngineImpl$DelegatedTask.run(SSLEngineImpl.java925)
at weblogic.socket.JSSEFilterImpl.doTasks(JSSEFilterImpl.java223)
at weblogic.socket.JSSEFilterImpl.doHandshake(JSSEFilterImpl.java123)
at weblogic.socket.JSSEFilterImpl.doHandshake(JSSEFilterImpl.java87)
at weblogic.socket.JSSESocket.startHandshake(JSSESocket.java250)
at weblogic.net.http.HttpsClient.New(HttpsClient.java582)
at weblogic.net.http.HttpsClient.New(HttpsClient.java562)
at weblogic.net.http.HttpsURLConnection.connect(HttpsURLConnection.java265)
at weblogic.net.http.HttpURLConnection.getInputStream(HttpURLConnection.java754)
at weblogic.net.http.SOAPHttpsURLConnection.getInputStream(SOAPHttpsURLConnection.java42)
at weblogic.net.http.HttpURLConnection.getResponseCode(HttpURLConnection.java1616)
at org.glassfish.jersey.client.internal.HttpUrlConnector._apply(HttpUrlConnector.java394)
at org.glassfish.jersey.client.internal.HttpUrlConnector.apply(HttpUrlConnector.java285)
... 97 more
Caused by sun.security.validator.ValidatorException PKIX path building failed sun.security.provider.certpath.SunCertPathBuilderException unable to find valid certification path to requested target
at sun.security.validator.PKIXValidator.doBuild(PKIXValidator.java439)
at sun.security.validator.PKIXValidator.engineValidate(PKIXValidator.java306)
at sun.security.validator.Validator.validate(Validator.java271)
at sun.security.ssl.X509TrustManagerImpl.validate(X509TrustManagerImpl.java312)
at sun.security.ssl.X509TrustManagerImpl.checkTrusted(X509TrustManagerImpl.java232)
at sun.security.ssl.X509TrustManagerImpl.checkServerTrusted(X509TrustManagerImpl.java109)
at weblogic.security.SSL.jsseadapter.JaTrustManager.checkServerTrusted(JaTrustManager.java128)
at sun.security.ssl.AbstractTrustManagerWrapper.checkServerTrusted(SSLContextImpl.java1262)
at sun.security.ssl.CertificateMessage$T13CertificateConsumer.checkServerCerts(CertificateMessage.java1333)
... 117 more
Caused by sun.security.provider.certpath.SunCertPathBuilderException unable to find valid certification path to requested target
at sun.security.provider.certpath.SunCertPathBuilder.build(SunCertPathBuilder.java146)
at sun.security.provider.certpath.SunCertPathBuilder.engineBuild(SunCertPathBuilder.java127)
at java.security.cert.CertPathBuilder.build(CertPathBuilder.java280)
at sun.security.validator.PKIXValidator.doBuild(PKIXValidator.java434)
... 125 more

]]
[timestamp] [bi_server1] [ERROR] [] [oracle.bi.web.datasetsvc.rest] [tid [ACTIVE].ExecuteThread '37' for queue 'weblogic.kernel.Default (self-tuning)'] [userId anonymous] [ecid ECID] [APP bidatasetsvc] [partition-name DOMAIN] [tenant-name GLOBAL] [SI-Key ssi] OutboundJaxrsResponse{status=500, reason=Internal Server Error, hasEntity=true, closed=false, buffered=false} {prefixDSS,code50000,messageDSS understood the request, but was unable to perform the operation due to an internal error,subMessagejavax.ws.rs.ProcessingException javax.net.ssl.SSLHandshakeException sun.security.validator.ValidatorException PKIX path building failed sun.security.provider.certpath.SunCertPathBuilderException unable to find valid certification path to requested target}

Changes

SSL configured.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.