OHDSI / OHDSI/WebAPI

Databricks: vocabulary search triggers SQLNonTransientConnectionException about missing PWD

Open
#2,261 2 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
Java
Stars
151
Forks
183
Avg merge
14m
Merged PRs (30d)
2

Description

Vocabulary search on a Databricks source invokes sparkHandleInsert() (https://github.com/OHDSI/WebAPI/blob/master/src/main/java/org/ohdsi/webapi/util/PreparedStatementRenderer.java#L293), which tries to open a fresh connection to the database without supplying username and password, which triggers the exception.

Expected behavior
  1. Execute vocabulary search in Atlas, for example /atlas/#/search?query=hypertension
  2. Get a concept list back with no errors in the logs
Actual behavior

Using ohdsi/webapi:2.13.0, the query successfully returns a list of results, but it also leaves a stacktrace in the logs:

2023-04-28T15:47:07.698983614Z java.sql.SQLNonTransientConnectionException: [Databricks][JDBC](10100) Connection Refused: [Databricks][JDBC](11640) Required Connection Key(s): PWD; [Databricks][JDBC](11480) Optional Connection Key(s): AllowSelfSignedCerts, AsyncExecPollInterval, AutomaticColumnRename, CAIssuedCertNamesMismatch, CatalogSchemaSwitch, DecimalColumnScale, DefaultStringColumnLength, DelegationToken, DelegationUID, DnsResolver, DnsResolverArg, FastConnection, krbJAASFile, NonSSPs, PreparedMetaLimitZero, RowsFetchedPerBlock, ServerVersion, ServiceDiscoveryMode, SocketFactory, SocketFactoryArg, SocketTimeOut, SSLKeyStore, SSLKeyStorePwd, SSLTrustStore, SSLTrustStorePwd, StripCatalogName, UID, UseCustomTypeCoercionMap
2023-04-28T15:47:07.699139399Z 	at com.databricks.client.exceptions.ExceptionConverter.toSQLException(Unknown Source)
2023-04-28T15:47:07.699148733Z 	at com.databricks.client.jdbc.common.BaseConnectionFactory.checkResponseMap(Unknown Source)
2023-04-28T15:47:07.699154572Z 	at com.databricks.client.jdbc.common.BaseConnectionFactory.doConnect(Unknown Source)
2023-04-28T15:47:07.699159013Z 	at com.databricks.client.jdbc.common.AbstractDriver.connect(Unknown Source)
2023-04-28T15:47:07.699163230Z 	at java.sql.DriverManager.getConnection(DriverManager.java:664)
2023-04-28T15:47:07.699167703Z 	at java.sql.DriverManager.getConnection(DriverManager.java:270)
2023-04-28T15:47:07.699357349Z 	at org.ohdsi.sql.BigQuerySparkTranslate.sparkHandleInsert(BigQuerySparkTranslate.java:508)
2023-04-28T15:47:07.699366181Z 	at org.ohdsi.webapi.util.PreparedStatementRenderer.getSql(PreparedStatementRenderer.java:293)
2023-04-28T15:47:07.699371223Z 	at org.ohdsi.webapi.vocabulary.DatabaseSearchProvider.executeSearch(DatabaseSearchProvider.java:37)
2023-04-28T15:47:07.699376459Z 	at org.ohdsi.webapi.service.VocabularyService.executeSearch(VocabularyService.java:670)
2023-04-28T15:47:07.699380850Z 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2023-04-28T15:47:07.699397382Z 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
2023-04-28T15:47:07.699403263Z 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
2023-04-28T15:47:07.699540965Z 	at java.lang.reflect.Method.invoke(Method.java:498)
2023-04-28T15:47:07.699548258Z 	at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
2023-04-28T15:47:07.699553549Z 	at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144)
2023-04-28T15:47:07.699558026Z 	at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161)
2023-04-28T15:47:07.699562310Z 	at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:205)
2023-04-28T15:47:07.699609627Z 	at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99)
2023-04-28T15:47:07.699744233Z 	at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389)
2023-04-28T15:47:07.699914423Z 	at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347)
2023-04-28T15:47:07.700068088Z 	at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)
2023-04-28T15:47:07.700222846Z 	at org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:326)
2023-04-28T15:47:07.700378852Z 	at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
2023-04-28T15:47:07.700521132Z 	at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
2023-04-28T15:47:07.700674175Z 	at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
2023-04-28T15:47:07.700813847Z 	at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
2023-04-28T15:47:07.700955991Z 	at org.glassfish.jersey.internal.Errors.process(Errors.java:267)
2023-04-28T15:47:07.701095552Z 	at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317)
2023-04-28T15:47:07.701241586Z 	at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:305)
2023-04-28T15:47:07.701397951Z 	at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154)
2023-04-28T15:47:07.701561872Z 	at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:473)
2023-04-28T15:47:07.701728045Z 	at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:427)
2023-04-28T15:47:07.702704353Z 	at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:388)
2023-04-28T15:47:07.702922409Z 	at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:341)
2023-04-28T15:47:07.703108265Z 	at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:228)
2023-04-28T15:47:07.703273009Z 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
2023-04-28T15:47:07.705283399Z 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
2023-04-28T15:47:07.705475871Z 	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
2023-04-28T15:47:07.705651156Z 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
2023-04-28T15:47:07.705829187Z 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
2023-04-28T15:47:07.705998881Z 	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)
2023-04-28T15:47:07.706198934Z 	at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
2023-04-28T15:47:07.706373825Z 	at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
2023-04-28T15:47:07.706539054Z 	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:154)
2023-04-28T15:47:07.706711198Z 	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
2023-04-28T15:47:07.707578410Z 	at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
2023-04-28T15:47:07.707866840Z 	at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
2023-04-28T15:47:07.708092388Z 	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:154)
2023-04-28T15:47:07.709340696Z 	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
2023-04-28T15:47:07.709640131Z 	at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:458)
2023-04-28T15:47:07.709851936Z 	at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:373)
2023-04-28T15:47:07.710057871Z 	at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
2023-04-28T15:47:07.710253423Z 	at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
2023-04-28T15:47:07.710433163Z 	at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387)
2023-04-28T15:47:07.710611244Z 	at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:370)
2023-04-28T15:47:07.710777413Z 	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:154)
2023-04-28T15:47:07.710962916Z 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
2023-04-28T15:47:07.711546792Z 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
2023-04-28T15:47:07.711806069Z 	at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
2023-04-28T15:47:07.711979279Z 	at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
2023-04-28T15:47:07.712140243Z 	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:154)
2023-04-28T15:47:07.712478512Z 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
2023-04-28T15:47:07.712733551Z 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
2023-04-28T15:47:07.712951604Z 	at org.ohdsi.webapi.shiro.filters.CacheFilter.doFilter(CacheFilter.java:35)
2023-04-28T15:47:07.713401372Z 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
2023-04-28T15:47:07.713603969Z 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
2023-04-28T15:47:07.713786227Z 	at org.ohdsi.webapi.shiro.filters.ExceptionHandlerFilter.doFilter(ExceptionHandlerFilter.java:28)
2023-04-28T15:47:07.713964690Z 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
2023-04-28T15:47:07.714143285Z 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
2023-04-28T15:47:07.714696021Z 	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
2023-04-28T15:47:07.715032254Z 	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
2023-04-28T15:47:07.715287400Z 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
2023-04-28T15:47:07.716612638Z 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
2023-04-28T15:47:07.716839736Z 	at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:109)
2023-04-28T15:47:07.717029498Z 	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
2023-04-28T15:47:07.717623091Z 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
2023-04-28T15:47:07.717828223Z 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
2023-04-28T15:47:07.718007340Z 	at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93)
2023-04-28T15:47:07.718173483Z 	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
2023-04-28T15:47:07.718352634Z 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
2023-04-28T15:47:07.718527775Z 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
2023-04-28T15:47:07.718695697Z 	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
2023-04-28T15:47:07.718860626Z 	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
2023-04-28T15:47:07.719034502Z 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
2023-04-28T15:47:07.719211663Z 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
2023-04-28T15:47:07.719780046Z 	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
2023-04-28T15:47:07.720109075Z 	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
2023-04-28T15:47:07.720370915Z 	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
2023-04-28T15:47:07.720598890Z 	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
2023-04-28T15:47:07.720609448Z 	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
2023-04-28T15:47:07.720615715Z 	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
2023-04-28T15:47:07.720620607Z 	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
2023-04-28T15:47:07.720624855Z 	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:798)
2023-04-28T15:47:07.720628926Z 	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
2023-04-28T15:47:07.720903504Z 	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:808)
2023-04-28T15:47:07.720913383Z 	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)
2023-04-28T15:47:07.720918563Z 	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
2023-04-28T15:47:07.720923669Z 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
2023-04-28T15:47:07.720928711Z 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
2023-04-28T15:47:07.720933276Z 	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
2023-04-28T15:47:07.720937599Z 	at java.lang.Thread.run(Thread.java:750)
2023-04-28T15:47:08.840336492Z 2023-04-28 15:47:08.827 ERROR http-nio-8080-exec-4 org.glassfish.jersey.server.ServerRuntime$Responder - [] - An I/O error has occurred while writing a response message entity to the container output stream.
2023-04-28T15:47:08.840363328Z org.glassfish.jersey.server.internal.process.MappableException: org.apache.catalina.connector.ClientAbortException: java.io.IOException: Broken pipe
2023-04-28T15:47:08.840369420Z 	at org.glassfish.jersey.server.internal.MappableExceptionWrapperInterceptor.aroundWriteTo(MappableExceptionWrapperInterceptor.java:92) ~[jersey-server-2.25.1.jar!/:?]
2023-04-28T15:47:08.840374149Z 	at org.glassfish.jersey.message.internal.WriterInterceptorExecutor.proceed(WriterInterceptorExecutor.java:162) ~[jersey-common-2.25.1.jar!/:?]
2023-04-28T15:47:08.840378643Z 	at org.glassfish.jersey.message.internal.MessageBodyFactory.writeTo(MessageBodyFactory.java:1130) ~[jersey-common-2.25.1.jar!/:?]
2023-04-28T15:47:08.840382909Z 	at org.glassfish.jersey.server.ServerRuntime$Responder.writeResponse(ServerRuntime.java:711) [jersey-server-2.25.1.jar!/:?]
2023-04-28T15:47:08.840387245Z 	at org.glassfish.jersey.server.ServerRuntime$Responder.processResponse(ServerRuntime.java:444) [jersey-server-2.25.1.jar!/:?]
2023-04-28T15:47:08.840403502Z 	at org.glassfish.jersey.server.ServerRuntime$Responder.process(ServerRuntime.java:434) [jersey-server-2.25.1.jar!/:?]
2023-04-28T15:47:08.841372552Z 	at org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:329) [jersey-server-2.25.1.jar!/:?]
2023-04-28T15:47:08.841388840Z 	at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271) [jersey-common-2.25.1.jar!/:?]
2023-04-28T15:47:08.841394270Z 	at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267) [jersey-common-2.25.1.jar!/:?]
2023-04-28T15:47:08.841399147Z 	at org.glassfish.jersey.internal.Errors.process(Errors.java:315) [jersey-common-2.25.1.jar!/:?]
2023-04-28T15:47:08.841404090Z 	at org.glassfish.jersey.internal.Errors.process(Errors.java:297) [jersey-common-2.25.1.jar!/:?]
2023-04-28T15:47:08.841408795Z 	at org.glassfish.jersey.internal.Errors.process(Errors.java:267) [jersey-common-2.25.1.jar!/:?]
2023-04-28T15:47:08.841417416Z 	at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317) [jersey-common-2.25.1.jar!/:?]
2023-04-28T15:47:08.841422495Z 	at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:305) [jersey-server-2.25.1.jar!/:?]
2023-04-28T15:47:08.841429880Z 	at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154) [jersey-server-2.25.1.jar!/:?]
2023-04-28T15:47:08.841434854Z 	at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:473) [jersey-container-servlet-core-2.25.1.jar!/:?]
2023-04-28T15:47:08.841439601Z 	at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:427) [jersey-container-servlet-core-2.25.1.jar!/:?]
2023-04-28T15:47:08.841444366Z 	at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:388) [jersey-container-servlet-core-2.25.1.jar!/:?]
2023-04-28T15:47:08.841449021Z 	at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:341) [jersey-container-servlet-core-2.25.1.jar!/:?]
2023-04-28T15:47:08.841453764Z 	at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:228) [jersey-container-servlet-core-2.25.1.jar!/:?]
2023-04-28T15:47:08.841458499Z 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.841463227Z 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.841479953Z 	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat-embed-websocket-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.841484438Z 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.841488803Z 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.841493095Z 	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61) [shiro-web-1.10.1.jar!/:1.10.1]
2023-04-28T15:47:08.841506823Z 	at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) [shiro-web-1.10.1.jar!/:1.10.1]
2023-04-28T15:47:08.841511214Z 	at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) [shiro-web-1.10.1.jar!/:1.10.1]
2023-04-28T15:47:08.841515451Z 	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:154) [shiro-web-1.10.1.jar!/:1.10.1]
2023-04-28T15:47:08.841519681Z 	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66) [shiro-web-1.10.1.jar!/:1.10.1]
2023-04-28T15:47:08.841524474Z 	at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) [shiro-web-1.10.1.jar!/:1.10.1]
2023-04-28T15:47:08.841528799Z 	at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) [shiro-web-1.10.1.jar!/:1.10.1]
2023-04-28T15:47:08.841533114Z 	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:154) [shiro-web-1.10.1.jar!/:1.10.1]
2023-04-28T15:47:08.841537388Z 	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66) [shiro-web-1.10.1.jar!/:1.10.1]
2023-04-28T15:47:08.841541541Z 	at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:458) [shiro-web-1.10.1.jar!/:1.10.1]
2023-04-28T15:47:08.841545768Z 	at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:373) [shiro-web-1.10.1.jar!/:1.10.1]
2023-04-28T15:47:08.841550005Z 	at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) [shiro-core-1.10.1.jar!/:1.10.1]
2023-04-28T15:47:08.841554449Z 	at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) [shiro-core-1.10.1.jar!/:1.10.1]
2023-04-28T15:47:08.841558635Z 	at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387) [shiro-core-1.10.1.jar!/:1.10.1]
2023-04-28T15:47:08.841562841Z 	at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:370) [shiro-web-1.10.1.jar!/:1.10.1]
2023-04-28T15:47:08.841567051Z 	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:154) [shiro-web-1.10.1.jar!/:1.10.1]
2023-04-28T15:47:08.841571348Z 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.841575647Z 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.841579963Z 	at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) [shiro-web-1.10.1.jar!/:1.10.1]
2023-04-28T15:47:08.841584125Z 	at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) [shiro-web-1.10.1.jar!/:1.10.1]
2023-04-28T15:47:08.841588349Z 	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:154) [shiro-web-1.10.1.jar!/:1.10.1]
2023-04-28T15:47:08.841593410Z 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.841601585Z 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.841605984Z 	at org.ohdsi.webapi.shiro.filters.CacheFilter.doFilter(CacheFilter.java:35) [classes/:?]
2023-04-28T15:47:08.841610124Z 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.841614504Z 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.841618891Z 	at org.ohdsi.webapi.shiro.filters.ExceptionHandlerFilter.doFilter(ExceptionHandlerFilter.java:28) [classes/:?]
2023-04-28T15:47:08.841623110Z 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.841627376Z 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.841631579Z 	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) [spring-web-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-28T15:47:08.841635944Z 	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-28T15:47:08.841640215Z 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.841644639Z 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.841648932Z 	at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:109) [spring-web-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-28T15:47:08.841653230Z 	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-28T15:47:08.841657631Z 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.841662331Z 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.841758973Z 	at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93) [spring-web-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-28T15:47:08.841770842Z 	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-28T15:47:08.841776295Z 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.841780867Z 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.841792749Z 	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197) [spring-web-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-28T15:47:08.841797155Z 	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.25.RELEASE.jar!/:4.3.25.RELEASE]
2023-04-28T15:47:08.841800863Z 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.841804620Z 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.841808343Z 	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) [tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.841812208Z 	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.841816002Z 	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493) [tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.841819745Z 	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) [tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.841823507Z 	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) [tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.841827276Z 	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) [tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.841855483Z 	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.841860069Z 	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:798) [tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.841865054Z 	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.841869570Z 	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:808) [tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.841874093Z 	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498) [tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.841878487Z 	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.841883119Z 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_342]
2023-04-28T15:47:08.841887820Z 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_342]
2023-04-28T15:47:08.841892450Z 	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.841897036Z 	at java.lang.Thread.run(Thread.java:750) [?:1.8.0_342]
2023-04-28T15:47:08.841901717Z Caused by: org.apache.catalina.connector.ClientAbortException: java.io.IOException: Broken pipe
2023-04-28T15:47:08.841910997Z 	at org.apache.catalina.connector.OutputBuffer.realWriteBytes(OutputBuffer.java:364) ~[tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.841915100Z 	at org.apache.catalina.connector.OutputBuffer.flushByteBuffer(OutputBuffer.java:833) ~[tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.841919102Z 	at org.apache.catalina.connector.OutputBuffer.append(OutputBuffer.java:738) ~[tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.841924293Z 	at org.apache.catalina.connector.OutputBuffer.writeBytes(OutputBuffer.java:399) ~[tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.841928506Z 	at org.apache.catalina.connector.OutputBuffer.write(OutputBuffer.java:377) ~[tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.841932682Z 	at org.apache.catalina.connector.CoyoteOutputStream.write(CoyoteOutputStream.java:96) ~[tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.841937378Z 	at org.glassfish.jersey.servlet.internal.ResponseWriter$NonCloseableOutputStreamWrapper.write(ResponseWriter.java:325) ~[jersey-container-servlet-core-2.25.1.jar!/:?]
2023-04-28T15:47:08.841942407Z 	at org.glassfish.jersey.message.internal.CommittingOutputStream.write(CommittingOutputStream.java:229) ~[jersey-common-2.25.1.jar!/:?]
2023-04-28T15:47:08.841947706Z 	at java.util.zip.DeflaterOutputStream.deflate(DeflaterOutputStream.java:253) ~[?:1.8.0_342]
2023-04-28T15:47:08.841951804Z 	at java.util.zip.DeflaterOutputStream.write(DeflaterOutputStream.java:211) ~[?:1.8.0_342]
2023-04-28T15:47:08.841955499Z 	at java.util.zip.GZIPOutputStream.write(GZIPOutputStream.java:145) ~[?:1.8.0_342]
2023-04-28T15:47:08.841960033Z 	at org.glassfish.jersey.message.internal.WriterInterceptorExecutor$UnCloseableOutputStream.write(WriterInterceptorExecutor.java:299) ~[jersey-common-2.25.1.jar!/:?]
2023-04-28T15:47:08.841964678Z 	at com.fasterxml.jackson.core.json.UTF8JsonGenerator._flushBuffer(UTF8JsonGenerator.java:2177) ~[jackson-core-2.12.7.jar!/:2.12.7]
2023-04-28T15:47:08.841968581Z 	at com.fasterxml.jackson.core.json.UTF8JsonGenerator.flush(UTF8JsonGenerator.java:1190) ~[jackson-core-2.12.7.jar!/:2.12.7]
2023-04-28T15:47:08.841973214Z 	at com.fasterxml.jackson.databind.ObjectWriter.writeValue(ObjectWriter.java:1008) ~[jackson-databind-2.12.7.jar!/:2.12.7]
2023-04-28T15:47:08.841978026Z 	at com.fasterxml.jackson.jaxrs.base.ProviderBase.writeTo(ProviderBase.java:625) ~[jackson-jaxrs-base-2.8.11.jar!/:2.8.11]
2023-04-28T15:47:08.841981897Z 	at org.glassfish.jersey.message.internal.WriterInterceptorExecutor$TerminalWriterInterceptor.invokeWriteTo(WriterInterceptorExecutor.java:265) ~[jersey-common-2.25.1.jar!/:?]
2023-04-28T15:47:08.841986598Z 	at org.glassfish.jersey.message.internal.WriterInterceptorExecutor$TerminalWriterInterceptor.aroundWriteTo(WriterInterceptorExecutor.java:250) ~[jersey-common-2.25.1.jar!/:?]
2023-04-28T15:47:08.841991365Z 	at org.glassfish.jersey.message.internal.WriterInterceptorExecutor.proceed(WriterInterceptorExecutor.java:162) ~[jersey-common-2.25.1.jar!/:?]
2023-04-28T15:47:08.841995425Z 	at org.glassfish.jersey.server.internal.JsonWithPaddingInterceptor.aroundWriteTo(JsonWithPaddingInterceptor.java:106) ~[jersey-server-2.25.1.jar!/:?]
2023-04-28T15:47:08.842004837Z 	at org.glassfish.jersey.message.internal.WriterInterceptorExecutor.proceed(WriterInterceptorExecutor.java:162) ~[jersey-common-2.25.1.jar!/:?]
2023-04-28T15:47:08.842009774Z 	at org.glassfish.jersey.spi.ContentEncoder.aroundWriteTo(ContentEncoder.java:138) ~[jersey-common-2.25.1.jar!/:?]
2023-04-28T15:47:08.842015904Z 	at org.glassfish.jersey.message.internal.WriterInterceptorExecutor.proceed(WriterInterceptorExecutor.java:162) ~[jersey-common-2.25.1.jar!/:?]
2023-04-28T15:47:08.842020506Z 	at org.glassfish.jersey.server.internal.MappableExceptionWrapperInterceptor.aroundWriteTo(MappableExceptionWrapperInterceptor.java:86) ~[jersey-server-2.25.1.jar!/:?]
2023-04-28T15:47:08.842025153Z 	... 85 more
2023-04-28T15:47:08.842029523Z Caused by: java.io.IOException: Broken pipe
2023-04-28T15:47:08.842034515Z 	at sun.nio.ch.FileDispatcherImpl.write0(Native Method) ~[?:1.8.0_342]
2023-04-28T15:47:08.842039409Z 	at sun.nio.ch.SocketDispatcher.write(SocketDispatcher.java:47) ~[?:1.8.0_342]
2023-04-28T15:47:08.842044057Z 	at sun.nio.ch.IOUtil.writeFromNativeBuffer(IOUtil.java:93) ~[?:1.8.0_342]
2023-04-28T15:47:08.842049137Z 	at sun.nio.ch.IOUtil.write(IOUtil.java:65) ~[?:1.8.0_342]
2023-04-28T15:47:08.842054142Z 	at sun.nio.ch.SocketChannelImpl.write(SocketChannelImpl.java:470) ~[?:1.8.0_342]
2023-04-28T15:47:08.842059054Z 	at org.apache.tomcat.util.net.NioChannel.write(NioChannel.java:134) ~[tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.842063742Z 	at org.apache.tomcat.util.net.NioBlockingSelector.write(NioBlockingSelector.java:101) ~[tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.842068556Z 	at org.apache.tomcat.util.net.NioSelectorPool.write(NioSelectorPool.java:157) ~[tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.842073347Z 	at org.apache.tomcat.util.net.NioEndpoint$NioSocketWrapper.doWrite(NioEndpoint.java:1306) ~[tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.842077899Z 	at org.apache.tomcat.util.net.SocketWrapperBase.doWrite(SocketWrapperBase.java:731) ~[tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.842082252Z 	at org.apache.tomcat.util.net.SocketWrapperBase.writeBlocking(SocketWrapperBase.java:501) ~[tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.842086814Z 	at org.apache.tomcat.util.net.SocketWrapperBase.write(SocketWrapperBase.java:439) ~[tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.842091810Z 	at org.apache.coyote.http11.Http11OutputBuffer$SocketOutputBuffer.doWrite(Http11OutputBuffer.java:623) ~[tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.842096677Z 	at org.apache.coyote.http11.filters.ChunkedOutputFilter.doWrite(ChunkedOutputFilter.java:123) ~[tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.842100922Z 	at org.apache.coyote.http11.Http11OutputBuffer.doWrite(Http11OutputBuffer.java:225) ~[tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.842105602Z 	at org.apache.coyote.Response.doWrite(Response.java:602) ~[tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.842115270Z 	at org.apache.catalina.connector.OutputBuffer.realWriteBytes(OutputBuffer.java:352) ~[tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.842119905Z 	at org.apache.catalina.connector.OutputBuffer.flushByteBuffer(OutputBuffer.java:833) ~[tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.842124748Z 	at org.apache.catalina.connector.OutputBuffer.append(OutputBuffer.java:738) ~[tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.842129700Z 	at org.apache.catalina.connector.OutputBuffer.writeBytes(OutputBuffer.java:399) ~[tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.842134499Z 	at org.apache.catalina.connector.OutputBuffer.write(OutputBuffer.java:377) ~[tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.842138844Z 	at org.apache.catalina.connector.CoyoteOutputStream.write(CoyoteOutputStream.java:96) ~[tomcat-embed-core-8.5.43.jar!/:8.5.43]
2023-04-28T15:47:08.842143842Z 	at org.glassfish.jersey.servlet.internal.ResponseWriter$NonCloseableOutputStreamWrapper.write(ResponseWriter.java:325) ~[jersey-container-servlet-core-2.25.1.jar!/:?]
2023-04-28T15:47:08.842148831Z 	at org.glassfish.jersey.message.internal.CommittingOutputStream.write(CommittingOutputStream.java:229) ~[jersey-common-2.25.1.jar!/:?]
2023-04-28T15:47:08.842153599Z 	at java.util.zip.DeflaterOutputStream.deflate(DeflaterOutputStream.java:253) ~[?:1.8.0_342]
2023-04-28T15:47:08.842157840Z 	at java.util.zip.DeflaterOutputStream.write(DeflaterOutputStream.java:211) ~[?:1.8.0_342]
2023-04-28T15:47:08.842162171Z 	at java.util.zip.GZIPOutputStream.write(GZIPOutputStream.java:145) ~[?:1.8.0_342]
2023-04-28T15:47:08.842166865Z 	at org.glassfish.jersey.message.internal.WriterInterceptorExecutor$UnCloseableOutputStream.write(WriterInterceptorExecutor.java:299) ~[jersey-common-2.25.1.jar!/:?]
2023-04-28T15:47:08.842171810Z 	at com.fasterxml.jackson.core.json.UTF8JsonGenerator._flushBuffer(UTF8JsonGenerator.java:2177) ~[jackson-core-2.12.7.jar!/:2.12.7]
2023-04-28T15:47:08.842175940Z 	at com.fasterxml.jackson.core.json.UTF8JsonGenerator.flush(UTF8JsonGenerator.java:1190) ~[jackson-core-2.12.7.jar!/:2.12.7]
2023-04-28T15:47:08.842179753Z 	at com.fasterxml.jackson.databind.ObjectWriter.writeValue(ObjectWriter.java:1008) ~[jackson-databind-2.12.7.jar!/:2.12.7]
2023-04-28T15:47:08.842183774Z 	at com.fasterxml.jackson.jaxrs.base.ProviderBase.writeTo(ProviderBase.java:625) ~[jackson-jaxrs-base-2.8.11.jar!/:2.8.11]
2023-04-28T15:47:08.842188715Z 	at org.glassfish.jersey.message.internal.WriterInterceptorExecutor$TerminalWriterInterceptor.invokeWriteTo(WriterInterceptorExecutor.java:265) ~[jersey-common-2.25.1.jar!/:?]
2023-04-28T15:47:08.842193470Z 	at org.glassfish.jersey.message.internal.WriterInterceptorExecutor$TerminalWriterInterceptor.aroundWriteTo(WriterInterceptorExecutor.java:250) ~[jersey-common-2.25.1.jar!/:?]
2023-04-28T15:47:08.842197861Z 	at org.glassfish.jersey.message.internal.WriterInterceptorExecutor.proceed(WriterInterceptorExecutor.java:162) ~[jersey-common-2.25.1.jar!/:?]
2023-04-28T15:47:08.842202250Z 	at org.glassfish.jersey.server.internal.JsonWithPaddingInterceptor.aroundWriteTo(JsonWithPaddingInterceptor.java:106) ~[jersey-server-2.25.1.jar!/:?]
2023-04-28T15:47:08.842211509Z 	at org.glassfish.jersey.message.internal.WriterInterceptorExecutor.proceed(WriterInterceptorExecutor.java:162) ~[jersey-common-2.25.1.jar!/:?]
2023-04-28T15:47:08.842215926Z 	at org.glassfish.jersey.spi.ContentEncoder.aroundWriteTo(ContentEncoder.java:138) ~[jersey-common-2.25.1.jar!/:?]
2023-04-28T15:47:08.842220109Z 	at org.glassfish.jersey.message.internal.WriterInterceptorExecutor.proceed(WriterInterceptorExecutor.java:162) ~[jersey-common-2.25.1.jar!/:?]
2023-04-28T15:47:08.842224354Z 	at org.glassfish.jersey.server.internal.MappableExceptionWrapperInterceptor.aroundWriteTo(MappableExceptionWrapperInterceptor.java:86) ~[jersey-server-2.25.1.jar!/:?]
2023-04-28T15:47:08.842228954Z 	... 85 more
2023-04-28T15:47:25.921642338Z 172.25.0.1 - - [28/Apr/2023:15:47:25 +0000] "GET /webapi/vocabulary/trdw/search?query=hypertension HTTP/1.1" 200 26368 "-" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/112.0" "-"
Steps to reproduce behavior
  1. Add a Databricks source to the WebAPI database. The source should have username and password stored in the corresponding fields, and not bundled with the connection string.
  2. Execute a vocabulary search against the source.
  3. Observe a stacktrace in the logs.

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start with sparkHandleInsert() in BigQuerySparkTranslate.java and its call from src/main/java/org/ohdsi/webapi/util/PreparedStatementRenderer.java:293; trace how DatabaseSearchProvider.executeSearch() invokes it for Atlas vocabulary search. Reproduce the Databricks search and verify that results still return without a missing-PWD SQLNonTransientConnectionException or stacktrace in the logs.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, sql
Domain
backend, databases, search
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Clearly specified
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.