Failed To Refresh External Dataset: Odbc Driver Returned An Error (SQLDriverConnectW)
(Doc ID 2866354.1)
Last updated on OCTOBER 16, 2023
Applies to:
Oracle Analytics Server - Version 5.9.0 and laterInformation in this document applies to any platform.
Symptoms
In an two node clustered Oracle Analytics Server (OAS) instance on Windows environment, while refreshing any data visualization (DV) dataset from the DV application running on node 2, it fails with below error:
Error: Failed to refresh external data set
bi_server log shows below error:
<Error> <oracle.bi.tech.services.dataset.StandaloneDatasetService> <BEA-000000> <Failed to refresh external dataset: Odbc driver returned an error (SQLDriverConnectW).
oracle.bi.tech.bips.svs.exception.BISvsRPDException: Odbc driver returned an error (SQLDriverConnectW).
at oracle.bi.tech.bips.svs.saw.SAWServicesHelper.getSOAPException(SAWServicesHelper.java:687)
at oracle.bi.tech.bips.svs.saw.SAWServicesHelper.getException(SAWServicesHelper.java:627)
at oracle.bi.tech.bips.svs.metadata.rpd.RPDMetadataSvsImpl.getPresentationTable(RPDMetadataSvsImpl.java:266)
at oracle.bi.tech.services.metadata.model.ModelMetadataService.handleGetSubjectAreaTable(ModelMetadataService.java:995)
at oracle.bi.tech.services.metadata.model.ModelMetadataService.getSubjectAreaTable(ModelMetadataService.java:982)
at oracle.bi.tech.services.dataset.DatasetService.getColumnInfos(DatasetService.java:401)
at oracle.bi.tech.services.dataset.DatasetService.getColumnInfos(DatasetService.java:391)
at oracle.bi.tech.services.dataset.StandaloneDatasetService.handleRefreshedDatasetJsonRetrieval(StandaloneDatasetService.java:4176)
at oracle.bi.tech.services.dataset.StandaloneDatasetService.refreshExternalDataset(StandaloneDatasetService.java:4135)
at oracle.bi.tech.services.dataset.DatasetResource.refreshExternalDataset(DatasetResource.java:768)
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$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161)
at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$ResponseOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:160)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)
at org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:326)
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
at org.glassfish.jersey.internal.Errors.process(Errors.java:267)
at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317)
at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:305)
at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154)
at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:473)
at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:427)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:388)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:341)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:228)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:295)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:260)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:137)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:353)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.bi.tech.model.servlet.ModelFilter.doFilter(ModelFilter.java:315)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.bi.security.filter.BISecurityFilter.lambda$chainToNext$0(BISecurityFilter.java:530)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAsPrivileged(Subject.java:549)
at oracle.bi.security.filter.BISecurityFilter.chainToNext(BISecurityFilter.java:534)
at oracle.bi.security.filter.BISecurityFilter.handleLogin(BISecurityFilter.java:398)
at oracle.bi.security.filter.BISecurityFilter.doFilter(BISecurityFilter.java:169)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.bi.tech.model.servlet.VAStatelessFilter.doFilter(VAStatelessFilter.java:125)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.bi.tech.model.servlet.VARedirectFilter.doFilter(VARedirectFilter.java:180)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.security.jps.ee.http.JpsAbsFilter$3.run(JpsAbsFilter.java:175)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:650)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:112)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilterInternal(JpsAbsFilter.java:293)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:150)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:94)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:248)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.jrf.servlet.ExtensibleGlobalFilter.doFilter(ExtensibleGlobalFilter.java:92)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3797)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3763)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:344)
at weblogic.security.service.SecurityManager.runAsForUserCode(SecurityManager.java:197)
at weblogic.servlet.provider.WlsSecurityProvider.runAsForUserCode(WlsSecurityProvider.java:203)
at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:71)
at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2451)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2299)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2277)
at weblogic.servlet.internal.ServletRequestImpl.runInternal(ServletRequestImpl.java:1710)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1670)
at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:272)
at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:352)
at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:337)
at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:57)
at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)
at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:655)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:420)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:360)
>
[Fatal Error] :1:55: Premature end of file.
<Warning> <oracle.bi.web.datasetsvc> <BEA-000000> <Error performing task
java.lang.NullPointerException
at oracle.bi.web.datasetsvc.typeoptions.ImportoptionsXML.getDataAccessModeFromXML(ImportoptionsXML.java:1056)
at oracle.bi.web.datasetsvc.api.core.v1.DatasetsCore.getDatasetMetadataObject(DatasetsCore.java:382)
at oracle.bi.web.datasetsvc.api.core.v1.DatasetsCore.getDatasetMetadataObject(DatasetsCore.java:324)
at oracle.bi.web.datasetsvc.api.core.v5.DatamodelsCore.deleteDatamodel(DatamodelsCore.java:318)
at oracle.bi.web.datasetsvc.api.core.v5.DatamodelsCore.deleteDatamodel(DatamodelsCore.java:286)
at oracle.bi.web.datasetsvc.api.direct.v5.DirectApiImpl.deleteDatamodel(DirectApiImpl.java:337)
at oracle.bi.web.datasetsvc.rest.maintenance.EmbryonicDatasetDeletionTask.deleteTarget(EmbryonicDatasetDeletionTask.java:45)
at oracle.bi.web.datasetsvc.rest.maintenance.EmbryonicDeletionTask.performTask(EmbryonicDeletionTask.java:193)
at oracle.bi.web.datasetsvc.rest.maintenance.EmbryonicDeletionTask.run(EmbryonicDeletionTask.java:112)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
oracle.bi.tech.bips.svs.exception.BISvsRPDException: Odbc driver returned an error (SQLDriverConnectW).
at oracle.bi.tech.bips.svs.saw.SAWServicesHelper.getSOAPException(SAWServicesHelper.java:687)
at oracle.bi.tech.bips.svs.saw.SAWServicesHelper.getException(SAWServicesHelper.java:627)
at oracle.bi.tech.bips.svs.metadata.rpd.RPDMetadataSvsImpl.getPresentationTable(RPDMetadataSvsImpl.java:266)
at oracle.bi.tech.services.metadata.model.ModelMetadataService.handleGetSubjectAreaTable(ModelMetadataService.java:995)
at oracle.bi.tech.services.metadata.model.ModelMetadataService.getSubjectAreaTable(ModelMetadataService.java:982)
at oracle.bi.tech.services.dataset.DatasetService.getColumnInfos(DatasetService.java:401)
at oracle.bi.tech.services.dataset.DatasetService.getColumnInfos(DatasetService.java:391)
at oracle.bi.tech.services.dataset.StandaloneDatasetService.handleRefreshedDatasetJsonRetrieval(StandaloneDatasetService.java:4176)
at oracle.bi.tech.services.dataset.StandaloneDatasetService.refreshExternalDataset(StandaloneDatasetService.java:4135)
at oracle.bi.tech.services.dataset.DatasetResource.refreshExternalDataset(DatasetResource.java:768)
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$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161)
at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$ResponseOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:160)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)
at org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:326)
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
at org.glassfish.jersey.internal.Errors.process(Errors.java:267)
at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317)
at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:305)
at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154)
at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:473)
at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:427)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:388)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:341)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:228)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:295)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:260)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:137)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:353)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.bi.tech.model.servlet.ModelFilter.doFilter(ModelFilter.java:315)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.bi.security.filter.BISecurityFilter.lambda$chainToNext$0(BISecurityFilter.java:530)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAsPrivileged(Subject.java:549)
at oracle.bi.security.filter.BISecurityFilter.chainToNext(BISecurityFilter.java:534)
at oracle.bi.security.filter.BISecurityFilter.handleLogin(BISecurityFilter.java:398)
at oracle.bi.security.filter.BISecurityFilter.doFilter(BISecurityFilter.java:169)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.bi.tech.model.servlet.VAStatelessFilter.doFilter(VAStatelessFilter.java:125)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.bi.tech.model.servlet.VARedirectFilter.doFilter(VARedirectFilter.java:180)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.security.jps.ee.http.JpsAbsFilter$3.run(JpsAbsFilter.java:175)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:650)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:112)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilterInternal(JpsAbsFilter.java:293)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:150)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:94)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:248)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.jrf.servlet.ExtensibleGlobalFilter.doFilter(ExtensibleGlobalFilter.java:92)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3797)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3763)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:344)
at weblogic.security.service.SecurityManager.runAsForUserCode(SecurityManager.java:197)
at weblogic.servlet.provider.WlsSecurityProvider.runAsForUserCode(WlsSecurityProvider.java:203)
at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:71)
at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2451)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2299)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2277)
at weblogic.servlet.internal.ServletRequestImpl.runInternal(ServletRequestImpl.java:1710)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1670)
at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:272)
at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:352)
at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:337)
at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:57)
at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)
at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:655)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:420)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:360)
>
[Fatal Error] :1:55: Premature end of file.
<Warning> <oracle.bi.web.datasetsvc> <BEA-000000> <Error performing task
java.lang.NullPointerException
at oracle.bi.web.datasetsvc.typeoptions.ImportoptionsXML.getDataAccessModeFromXML(ImportoptionsXML.java:1056)
at oracle.bi.web.datasetsvc.api.core.v1.DatasetsCore.getDatasetMetadataObject(DatasetsCore.java:382)
at oracle.bi.web.datasetsvc.api.core.v1.DatasetsCore.getDatasetMetadataObject(DatasetsCore.java:324)
at oracle.bi.web.datasetsvc.api.core.v5.DatamodelsCore.deleteDatamodel(DatamodelsCore.java:318)
at oracle.bi.web.datasetsvc.api.core.v5.DatamodelsCore.deleteDatamodel(DatamodelsCore.java:286)
at oracle.bi.web.datasetsvc.api.direct.v5.DirectApiImpl.deleteDatamodel(DirectApiImpl.java:337)
at oracle.bi.web.datasetsvc.rest.maintenance.EmbryonicDatasetDeletionTask.deleteTarget(EmbryonicDatasetDeletionTask.java:45)
at oracle.bi.web.datasetsvc.rest.maintenance.EmbryonicDeletionTask.performTask(EmbryonicDeletionTask.java:193)
at oracle.bi.web.datasetsvc.rest.maintenance.EmbryonicDeletionTask.run(EmbryonicDeletionTask.java:112)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |