search

OHDSI / WebAPI

OHDSI WebAPI contains all OHDSI services that can be called from OHDSI applications
Apache License 2.0
126 stars 156 forks source link

Databricks: vocabulary search triggers SQLNonTransientConnectionException about missing PWD #2261

Open xitology opened 1 year ago

xitology commented 1 year ago

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.
chrisknoll commented 1 year ago

@anton-abushkevich or @wivern, would you know why there is special dialect specific code for spark?

chrisknoll commented 1 year ago

@alondhe , I think you defined this class: https://github.com/OHDSI/SqlRender/blob/95028be117f3625d4d52c53835f7a21d03a5f983/java/org/ohdsi/sql/BigQuerySparkTranslate.java

Could you let us know if this is working outside the typical sqlrender function of translate/render SQL?

@anton-abushkevich , it looks like this code was added as part of PR #2004. Can you tell us what the thinking was?