Hi all,
While trying to open search screen I am seeing the below error message.
'Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Cannot open connection'
I checked for AppianBusinessDS connection and it looks fine.
Can someone please let me know how to move forward with this issue.
Thanks in Advance.
Discussion posts and replies are publicly visible
Hi ,
Yes the same datasource is used in datastore..... On Premises.... Below are the logs <Aug 8, 2017 8:00:12 PM GMT> <Warning> <org.hibernate.util.JDBCExceptionReporter> <BEA-000000> <SQL Error: 0, SQLState: null> Aug 08, 2017 8:00:12 PM org.hibernate.util.JDBCExceptionReporter logExceptions SEVERE: Cannot obtain connection: driverURL = jdbc:weblogic:pool:AppianBusinessDS, props = {EmulateTwoPhaseCommit=false, connectionPoolID=AppianBusinessDS, jdbcTxDataSource=true, LoggingLastResource=false, dataSourceName=AppianBusinessDS} <Aug 8, 2017 8:00:12 PM GMT> <Error> <org.hibernate.util.JDBCExceptionReporter> <BEA-000000> <Cannot obtain connection: driverURL = jdbc:weblogic:pool:AppianBusinessDS, props = {EmulateTwoPhaseCommit=false, connectionPoolID=AppianBusinessDS, jdbcTxDataSource=true, LoggingLastResource=false, dataSourceName=AppianBusinessDS}> 2017-08-08 20:00:13,554 [[ACTIVE] ExecuteThread: '30' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR com.appiancorp.rest.shared.AppianExceptionMapper - Internal Server Error on REST API invocation. com.appiancorp.process.expression.ExpressionRuntimeException$AppianExceptionProvider: Expression evaluation error in rule '___ getrevieworganizationdata' (called by rule '_____ viewmainscreen') at function a!queryEntity [line 26]: An error occurred while retrieving the data. (APNX-1-4198-000) at com.appiancorp.process.expression.ExpressionRuntimeException.<init>(ExpressionRuntimeException.java:70) at com.appiancorp.core.expr.exceptions.AppianScriptException.<init>(AppianScriptException.java:25) at com.appiancorp.core.expr.exceptions.ParseException.<init>(ParseException.java:20) at com.appiancorp.core.expr.exceptions.FunctionException.<init>(FunctionException.java:13) at com.appiancorp.core.expr.tree.FunctionCall.evalEvaluable(FunctionCall.java:329) at com.appiancorp.core.expr.tree.FunctionCall.eval(FunctionCall.java:392) at com.appiancorp.core.expr.Tree.eval0(Tree.java:213) at com.appiancorp.core.expr.Tree.eval(Tree.java:209) at com.appiancorp.core.expr.rule.Rule.evalBody(Rule.java:674) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:336) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:245) at com.appiancorp.core.expr.rule.Rule.evalWithMetrics(Rule.java:233) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:222) at com.appiancorp.core.expr.tree.FreeformRule.eval(FreeformRule.java:68) at com.appiancorp.core.expr.tree.FreeformRule.eval0(FreeformRule.java:45) at com.appiancorp.core.expr.Tree.eval(Tree.java:209) at com.appiancorp.core.expr.tree.If.evalInner(If.java:134) at com.appiancorp.core.expr.tree.If.eval0(If.java:59) at com.appiancorp.core.expr.tree.TreeEvaluable.eval(TreeEvaluable.java:63) at com.appiancorp.core.expr.tree.SpecialFunction.eval0(SpecialFunction.java:60) at com.appiancorp.core.expr.Tree.eval(Tree.java:199) at com.appiancorp.core.expr.tree.With.evalBinding(With.java:71) at com.appiancorp.core.expr.tree.AbstractLetFunction.eval00(AbstractLetFunction.java:99) at com.appiancorp.core.expr.tree.With.eval0(With.java:50) at com.appiancorp.core.expr.tree.TreeEvaluable.eval(TreeEvaluable.java:63) at com.appiancorp.core.expr.tree.SpecialFunction.eval0(SpecialFunction.java:60) at com.appiancorp.core.expr.Tree.eval(Tree.java:209) at com.appiancorp.core.expr.rule.Rule.evalBody(Rule.java:674) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:336) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:245) at com.appiancorp.core.expr.rule.Rule.evalWithMetrics(Rule.java:233) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:222) at com.appiancorp.core.expr.tree.FreeformRule.eval(FreeformRule.java:68) at com.appiancorp.core.expr.tree.FreeformRule.eval0(FreeformRule.java:45) at com.appiancorp.core.expr.Tree.eval(Tree.java:209) at com.appiancorp.core.expr.Tree.evalAndAllowBind(Tree.java:242) at com.appiancorp.core.expr.tree.Load.evalBinding(Load.java:203) at com.appiancorp.core.expr.tree.AbstractLetFunction.eval00(AbstractLetFunction.java:99) at com.appiancorp.core.expr.tree.Load.eval0(Load.java:106) at com.appiancorp.core.expr.tree.TreeEvaluable.eval(TreeEvaluable.java:63) at com.appiancorp.core.expr.tree.SpecialFunction.eval0(SpecialFunction.java:60) at com.appiancorp.core.expr.Tree.eval(Tree.java:209) at com.appiancorp.core.expr.tree.ListAtIndices.eval(ListAtIndices.java:132) at com.appiancorp.core.expr.Tree.eval0(Tree.java:213) at com.appiancorp.core.expr.Tree.eval(Tree.java:209) at com.appiancorp.core.expr.rule.Rule.evalBody(Rule.java:674) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:336) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:245) at com.appiancorp.core.expr.rule.Rule.evalWithMetrics(Rule.java:233) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:222) at com.appiancorp.core.expr.tree.FreeformRule.eval(FreeformRule.java:68) at com.appiancorp.core.expr.tree.FreeformRule.eval0(FreeformRule.java:45) at com.appiancorp.core.expr.Tree.eval(Tree.java:209) at com.appiancorp.core.expr.rule.Rule.evalTreeOrValue(Rule.java:260) at com.appiancorp.core.expr.rule.Rule.cast(Rule.java:274) at com.appiancorp.core.expr.rule.Rule.prepareBindingsKeywords(Rule.java:382) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:325) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:245) at com.appiancorp.core.expr.rule.Rule.evalWithMetrics(Rule.java:233) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:222) at com.appiancorp.core.expr.tree.FreeformRule.eval(FreeformRule.java:68) at com.appiancorp.core.expr.tree.FreeformRule.eval0(FreeformRule.java:45) at com.appiancorp.core.expr.Tree.eval(Tree.java:209) at com.appiancorp.core.expr.rule.Rule.evalTreeOrValue(Rule.java:260) at com.appiancorp.core.expr.rule.Rule.cast(Rule.java:274) at com.appiancorp.core.expr.rule.Rule.prepareBindingsPositionalInternal(Rule.java:435) at com.appiancorp.core.expr.rule.Rule.prepareBindingsPositional(Rule.java:400) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:327) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:245) at com.appiancorp.core.expr.rule.Rule.evalWithMetrics(Rule.java:233) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:222) at com.appiancorp.core.expr.tree.FreeformRule.eval(FreeformRule.java:68) at com.appiancorp.core.expr.tree.FreeformRule.eval0(FreeformRule.java:45) at com.appiancorp.core.expr.Tree.eval(Tree.java:199) at com.appiancorp.core.expr.tree.With.evalBinding(With.java:71) at com.appiancorp.core.expr.tree.AbstractLetFunction.eval00(AbstractLetFunction.java:99) at com.appiancorp.core.expr.tree.With.eval0(With.java:50) at com.appiancorp.core.expr.tree.TreeEvaluable.eval(TreeEvaluable.java:63) at com.appiancorp.core.expr.tree.SpecialFunction.eval0(SpecialFunction.java:60) at com.appiancorp.core.expr.Tree.eval(Tree.java:209) at com.appiancorp.core.expr.Parse.evalInner(Parse.java:296) at com.appiancorp.core.expr.Parse.eval(Parse.java:254) at com.appiancorp.sail.UserInterfaceGenerator.doEvaluation(UserInterfaceGenerator.java:445) at com.appiancorp.sail.UserInterfaceGenerator.evaluateUiExpression(UserInterfaceGenerator.java:196) at com.appiancorp.sail.UserInterfaceGenerator.generateUserInterface(UserInterfaceGenerator.java:177) at com.appiancorp.sail.FullEvaluator.doFirstEvaluation(FullEvaluator.java:47) at com.appiancorp.sail.ValueUiEvaluator.eval(ValueUiEvaluator.java:86) at com.appiancorp.sail.TvUiEvaluator.eval(TvUiEvaluator.java:31) at com.appiancorp.sail.TvUiEvaluator.eval(TvUiEvaluator.java:20) at com.appiancorp.sail.UiEvaluator.eval(UiEvaluator.java:69) at com.appiancorp.sail.UiServiceImpl.reevaluateUi(UiServiceImpl.java:47) at com.appiancorp.uidesigner.TaskFormActionRequest.getUIFrameworkForm(TaskFormActionRequest.java:199) at com.appiancorp.uidesigner.TaskFormActionRequest.call0(TaskFormActionRequest.java:102) at com.appiancorp.uidesigner.TaskFormActionRequest.call0(TaskFormActionRequest.java:58) at com.appiancorp.uidesigner.AbstractActionRequest.call(AbstractActionRequest.java:24) at com.appiancorp.uidesigner.TaskFormSubmissionActionRequest.call0(TaskFormSubmissionActionRequest.java:173) at com.appiancorp.uidesigner.TaskFormSubmissionActionRequest.call0(TaskFormSubmissionActionRequest.java:54) at com.appiancorp.uidesigner.AbstractActionRequest.call(AbstractActionRequest.java:24) at com.appiancorp.rest.shared.WebSubmissionRequest.call0(WebSubmissionRequest.java:83) at com.appiancorp.rest.shared.WebSubmissionRequest.call0(WebSubmissionRequest.java:51) at com.appiancorp.uidesigner.AbstractActionRequest.call(AbstractActionRequest.java:24) at com.appiancorp.rest.task.TaskRestService.reevaluateFormExpectingNormal(TaskRestService.java:540) 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:497) at com.atlassian.plugins.rest.common.interceptor.impl.DispatchProviderHelper$ResponseOutInvoker$1.invoke(DispatchProviderHelper.java:234) at com.atlassian.plugins.rest.common.interceptor.impl.DispatchProviderHelper$1.intercept(DispatchProviderHelper.java:100) at com.atlassian.plugins.rest.common.interceptor.impl.DefaultMethodInvocation.invoke(DefaultMethodInvocation.java:61) at com.atlassian.plugins.rest.common.expand.interceptor.ExpandInterceptor.intercept(ExpandInterceptor.java:38) at com.atlassian.plugins.rest.common.interceptor.impl.DefaultMethodInvocation.invoke(DefaultMethodInvocation.java:61) at com.atlassian.plugins.rest.common.interceptor.impl.DispatchProviderHelper.invokeMethodWithInterceptors(DispatchProviderHelper.java:132) at com.atlassian.plugins.rest.common.interceptor.impl.DispatchProviderHelper$ResponseOutInvoker._dispatch(DispatchProviderHelper.java:230) at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75) at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:288) at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108) at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1469) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1400) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1349) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1339) at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:537) at com.atlassian.plugins.rest.module.RestDelegatingServletFilter$JerseyOsgiServletContainer.doFilter(RestDelegatingServletFilter.java:178) at com.sun.jersey.spi.container.servlet.ServletContainer.doFilter(ServletContainer.java:795) at com.atlassian.plugins.rest.module.RestDelegatingServletFilter.doFilter(RestDelegatingServletFilter.java:73) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66) at com.atlassian.plugins.rest.module.servlet.RestServletUtilsUpdaterFilter.doFilterInternal(RestServletUtilsUpdaterFilter.java:26) at com.atlassian.plugins.rest.module.servlet.RestServletUtilsUpdaterFilter.doFilter(RestServletUtilsUpdaterFilter.java:40) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79) at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176) at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145) at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92) at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:381) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79) at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176) at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145) at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92) at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:381) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79) at com.appiancorp.tempo.util.PerformanceLogFilter.doFilter(PerformanceLogFilter.java:57) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79) at com.appiancorp.common.web.PathMatchExclusionFilter.doFilter(PathMatchExclusionFilter.java:68) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79) at com.appiancorp.security.web.FrameOptionsFilter.doFilter(FrameOptionsFilter.java:25) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79) at com.appiancorp.security.auth.ForceSetPasswordFilter.doFilter(ForceSetPasswordFilter.java:47) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at com.appiancorp.security.auth.activity.UserActivityFilter.doFilter(UserActivityFilter.java:46) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.appiancorp.security.auth.rememberme.CookieTheftRedirectFilter.doFilter(CookieTheftRedirectFilter.java:36) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter.doFilter(RememberMeAuthenticationFilter.java:146) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.access.channel.ChannelProcessingFilter.doFilter(ChannelProcessingFilter.java:144) at com.appiancorp.security.csrf.CsrfChannelProcessingFilter.doFilter(CsrfChannelProcessingFilter.java:93) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.appiancorp.security.auth.MobileClientValidationFilter.doFilter(MobileClientValidationFilter.java:47) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79) at com.appiancorp.common.web.HttpMethodOverrideFilter.doFilter(HttpMethodOverrideFilter.java:34) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79) at com.appiancorp.security.cors.CorsFilter.doFilter(CorsFilter.java:224) at com.appiancorp.security.cors.CorsFilter.doFilter(CorsFilter.java:199) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79) at com.appiancorp.security.auth.logging.AuthenticationLoggingFilter.doFilter(AuthenticationLoggingFilter.java:37) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79) at com.appiancorp.ap2.environment.EnvironmentFilter.doFilter(EnvironmentFilter.java:87) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79) at com.appiancorp.common.web.ThreadLocalRequestFilter.doFilter(ThreadLocalRequestFilter.java:34) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79) at com.appiancorp.common.web.WeblogicSessionAttributeClassLoaderRequestFilter.doFilter(WeblogicSessionAttributeClassLoaderRequestFilter.java:256) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79) at com.appiancorp.ap2.NullByteInjectionFilter.doFilter(NullByteInjectionFilter.java:32) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79) at com.appiancorp.ap2.EncodingFilter.doFilter(EncodingFilter.java:58) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3431) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3397) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120) at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57) at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2280) at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2196) at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2174) at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1621) at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:256) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:311) at weblogic.work.ExecuteThread.run(ExecuteThread.java:263) Caused by: com.appiancorp.suiteapi.common.exceptions.AppianRuntimeException: com.appiancorp.suiteapi.common.exceptions.AppianException: An error occurred while retrieving the data. (APNX-1-4261-002) at com.appiancorp.core.expr.fn.query.QueryEntity.queryDataStoreEntity(QueryEntity.java:147) at com.appiancorp.core.expr.fn.query.QueryEntity.queryentity_appian_internal(QueryEntity.java:98) at com.appiancorp.core.expr.fn.query.QueryEntity.executeQuery(QueryEntity.java:57) at com.appiancorp.core.expr.fn.query.AbstractQueryExecutor.op(AbstractQueryExecutor.java:67) at com.appiancorp.core.expr.fn.Signature.eval(Signature.java:181) at com.appiancorp.core.expr.fn.Function.eval0(Function.java:58) at com.appiancorp.core.expr.DefaultEvaluable.eval(DefaultEvaluable.java:175) at com.appiancorp.core.expr.tree.FunctionCall.evalImmediate(FunctionCall.java:353) at com.appiancorp.core.expr.tree.FunctionCall.evalEvaluable(FunctionCall.java:320) ... 218 more Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128) at com.appiancorp.rdbms.hb.HbSqlExceptionConverter.convert(HbSqlExceptionConverter.java:95) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52) at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449) at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167) at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:160) at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:81) at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1473) at sun.reflect.GeneratedMethodAccessor479.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:345) at com.sun.proxy.$Proxy183.beginTransaction(Unknown Source) at com.appiancorp.type.external.teneoimpl.TeneoDataStore.beginTransaction(TeneoDataStore.java:248) at com.appiancorp.core.expr.fn.query.QueryEntity.queryDataStoreEntity(QueryEntity.java:133) ... 226 more Caused by: java.sql.SQLException: Pool connect failed : java.lang.SecurityException: [Security:090398]Invalid Subject: principals=[pe_guest] at weblogic.jdbc.common.internal.JDBCUtil.wrapAndThrowResourceException(JDBCUtil.java:277) at weblogic.jdbc.pool.Driver.connect(Driver.java:153) at weblogic.jdbc.jts.Driver.getNonTxConnection(Driver.java:662) at weblogic.jdbc.jts.Driver.connect(Driver.java:128) at weblogic.jdbc.common.internal.RmiDataSource.getConnectionInternal(RmiDataSource.java:589) at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:545) at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:538) at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:92) at com.appiancorp.rdbms.hb.LoggingDatasourceConnectionProvider.getConnection(LoggingDatasourceConnectionProvider.java:28) at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446) ... 237 more Caused by: java.lang.SecurityException: [Security:090398]Invalid Subject: principals=[pe_guest] at weblogic.security.service.SecurityServiceManager.seal(SecurityServiceManager.java:855) at weblogic.security.service.IdentityUtility.authenticatedSubjectToIdentity(IdentityUtility.java:30) at weblogic.security.service.RoleManager.getRoles(RoleManager.java:183) at weblogic.security.service.AuthorizationManager.isAccessAllowed(AuthorizationManager.java:376) at weblogic.jdbc.common.internal.JDBCUtil.checkPermission(JDBCUtil.java:245) at weblogic.jdbc.common.internal.ConnectionPool.doAuthorizationCheck(ConnectionPool.java:712) at weblogic.jdbc.common.internal.ConnectionPool.reserve(ConnectionPool.java:450) at weblogic.jdbc.common.internal.ConnectionPool.reserve(ConnectionPool.java:425) at weblogic.jdbc.common.internal.ConnectionPoolManager.reserve(ConnectionPoolManager.java:133) at weblogic.jdbc.common.internal.ConnectionPoolManager.reserve(ConnectionPoolManager.java:166) at weblogic.jdbc.pool.Driver.connect(Driver.java:143) ... 245 more