Hi all,
we have a record based on a view, so no sync options is possible.
The view is quite complex, it takes 10 second from db side and 20 seconds on Appian side to be executed,
The record list works correctly, we have inserted the record in a site and we show only 50 rows per page, but when the user click on the record link in the list that should redirect him to the summary view the APNX appear
Substituting the record link with an a start process link where we call the same interface of the summary view it works, but for another reason we cannot use this strategy
We are in cloud, appian versione 24.1
2024-04-25 15:39:15,835 [ajp-nio-0.0.0.0-8009-exec-481] ERROR com.appiancorp.rest.record.data.RecordRestService - Unable to retrieve record summary for record w/ type RecordType [id=836, uuid=bdd54fd9-3928-41bc-876e-5bf67f3cf465, name=All Events Incidents, sourceTypeStr={http://www.appian.com/ae/types/2009}DataStoreEntity, sourceUuidStr=0d398e47-7f8b-45ee-9075-b62c963b4b72@_a-0000dfac-332a-8000-06a9-01ef9001ef90_12984] and id 118784com.appiancorp.suiteapi.common.exceptions.AppianException: An error occurred because the record types source is currently unavailable, or the query reached a timeout or memory limit. (APNX-1-4205-040) at com.appiancorp.suiteapi.common.exceptions.AppianRuntimeException.<init>(AppianRuntimeException.java:45) at com.appiancorp.record.data.sourcedataaccessors.RecordEntityDataAccessor.queryDataStoreEntity(RecordEntityDataAccessor.java:67) at com.appiancorp.record.data.sourcedataaccessors.RecordEntityDataAccessor.getRecordsInner(RecordEntityDataAccessor.java:47) at com.appiancorp.record.data.sourcedataaccessors.RecordDataAccessor.runQueryWithMetrics(RecordDataAccessor.java:153) at com.appiancorp.record.data.sourcedataaccessors.RecordDataAccessor.lambda$getRecordsData$0(RecordDataAccessor.java:119) at com.appiancorp.tracing.SafeTracerImpl.lambda$supplierWithTracing$3(SafeTracerImpl.java:55) at com.appiancorp.sail.WrapInMetricHelper.runSupplierWithScriptException(WrapInMetricHelper.java:85) at com.appiancorp.sail.WrapInMetricHelper.runSupplier(WrapInMetricHelper.java:49) at com.appiancorp.record.data.sourcedataaccessors.RecordDataAccessor.getRecordsData(RecordDataAccessor.java:122) at com.appiancorp.record.data.sourcedataaccessors.TypedValueRecordDataAccessor.getRecordsData(TypedValueRecordDataAccessor.java:59) at com.appiancorp.record.data.sourcedataaccessors.RecordDataAccessor.getRecordsData(RecordDataAccessor.java:98) at com.appiancorp.record.service.RecordDataReadServiceImpl.getRecordWithRequestedFields(RecordDataReadServiceImpl.java:118) at com.appiancorp.record.service.RecordDataReadServiceImpl.getRecord(RecordDataReadServiceImpl.java:80) at com.appiancorp.record.data.RecordBindingProvider.getInitialRvBindings(RecordBindingProvider.java:254) at com.appiancorp.record.data.RecordBindingProvider.generateBindings(RecordBindingProvider.java:210) at com.appiancorp.record.data.RecordBindingProvider.generateBindings(RecordBindingProvider.java:174) at com.appiancorp.record.data.RecordBindingProvider.getBindings(RecordBindingProvider.java:143) at com.appiancorp.record.ui.RecordUiSourceFactoryImpl.buildRecordUiBuilder(RecordUiSourceFactoryImpl.java:187) at com.appiancorp.record.ui.RecordUiSourceFactoryImpl.buildRecordUiBuilder(RecordUiSourceFactoryImpl.java:155) at com.appiancorp.record.ui.RecordUiBuilderFactoryImpl.build(RecordUiBuilderFactoryImpl.java:178) at com.appiancorp.record.ui.RecordUiBuilderFactoryImpl.buildAndCache(RecordUiBuilderFactoryImpl.java:148) at com.appiancorp.record.ui.RecordUiBuilderFactoryImpl.getBuilder(RecordUiBuilderFactoryImpl.java:228) at com.appiancorp.record.ui.RecordUiBuilderFactoryImpl.get(RecordUiBuilderFactoryImpl.java:191) at sun.reflect.GeneratedMethodAccessor2679.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.atlassian.plugin.util.ContextClassLoaderSettingInvocationHandler.invoke(ContextClassLoaderSettingInvocationHandler.java:26) at com.sun.proxy.$Proxy631.get(Unknown Source) at sun.reflect.GeneratedMethodAccessor2679.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344) at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:56) at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:60) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:137) at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:124) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:70) at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:53) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.eclipse.gemini.blueprint.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:57) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:137) at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:124) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215) at com.sun.proxy.$Proxy1072.get(Unknown Source) at com.appiancorp.rest.shared.RecordRestDelegate.getRecordView(RecordRestDelegate.java:119) at com.appiancorp.rest.shared.RecordRestDelegate.getRecordViewNormal(RecordRestDelegate.java:237) at com.appiancorp.rest.shared.RecordRestDelegate.addRecordView(RecordRestDelegate.java:380) at com.appiancorp.rest.shared.RecordRestDelegate.getTitleAndEvaluateRecordViewUi(RecordRestDelegate.java:217) at com.appiancorp.rest.shared.RecordRestDelegate.getRecordViewById(RecordRestDelegate.java:165) at com.appiancorp.rest.sites.SiteRestService.lambda$getRecordView$6(SiteRestService.java:936) at com.appiancorp.rest.urt.UserResponseTimeMetricsGathererWrapper.wrapGetRecordViewAsAbderaFeed(UserResponseTimeMetricsGathererWrapper.java:47) at com.appiancorp.rest.sites.SiteRestService.getRecordView(SiteRestService.java:942) at sun.reflect.GeneratedMethodAccessor2787.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.atlassian.plugins.rest.common.interceptor.impl.DispatchProviderHelper$TypeOutInvoker.lambda$_dispatch$0(DispatchProviderHelper.java:160) at com.atlassian.plugins.rest.common.interceptor.impl.DispatchProviderHelper.lambda$invokeMethodWithInterceptors$0(DispatchProviderHelper.java:81) at com.atlassian.plugins.rest.common.interceptor.impl.DefaultMethodInvocation.invoke(DefaultMethodInvocation.java:53) at com.atlassian.plugins.rest.common.expand.interceptor.ExpandInterceptor.intercept(ExpandInterceptor.java:42) at com.atlassian.plugins.rest.common.interceptor.impl.DefaultMethodInvocation.invoke(DefaultMethodInvocation.java:53) at com.atlassian.plugins.rest.common.interceptor.impl.DispatchProviderHelper.invokeMethodWithInterceptors(DispatchProviderHelper.java:106) at com.atlassian.plugins.rest.common.interceptor.impl.DispatchProviderHelper$TypeOutInvoker._dispatch(DispatchProviderHelper.java:159) 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:302) 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:1542) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1473) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1419) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1409) at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:409) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:558) at com.atlassian.plugins.rest.module.RestDelegatingServletFilter$JerseyOsgiServletContainer.doFilter(RestDelegatingServletFilter.java:171) at com.sun.jersey.spi.container.servlet.ServletContainer.doFilter(ServletContainer.java:829) at com.atlassian.plugins.rest.module.RestDelegatingServletFilter.doFilter(RestDelegatingServletFilter.java:75) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:62) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:37) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:43) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:62) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:37) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.lambda$doFilter$0(DelegatingPluginFilter.java:57) at com.atlassian.plugins.rest.module.servlet.RestServletUtilsUpdaterFilter.doFilterInternal(RestServletUtilsUpdaterFilter.java:23) at com.atlassian.plugins.rest.module.servlet.RestServletUtilsUpdaterFilter.doFilter(RestServletUtilsUpdaterFilter.java:35) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:62) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:37) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:179) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:154) at com.appiancorp.security.web.AppsPortalVisibilityFilter.doFilter(AppsPortalVisibilityFilter.java:87) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:179) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:154) 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:389) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:179) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:154) 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:389) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:179) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:154) at com.appiancorp.tempo.util.PerformanceLogFilter.doFilter(PerformanceLogFilter.java:124) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:179) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:154) at com.appiancorp.common.web.PathMatchExclusionFilter.doFilter(PathMatchExclusionFilter.java:68) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:179) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:154) at com.appiancorp.security.auth.ForceSetPasswordFilter.doFilter(ForceSetPasswordFilter.java:50) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:179) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:154) at com.appiancorp.security.auth.mfa.MfaVerificationCodeFilter.doFilter(MfaVerificationCodeFilter.java:61) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:179) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:154) at com.appiancorp.tracing.web.TracingUserUuidFilter.doFilter(TracingUserUuidFilter.java:47) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:354) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:179) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:154) at com.appiancorp.security.auth.AuthenticationStatusHeaderFilter.doFilter(AuthenticationStatusHeaderFilter.java:38) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:179) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:154) at com.appiancorp.security.xss.XssFilter.doFilter(XssFilter.java:30) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:179) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:154) at com.appiancorp.security.auth.session.SessionJvmRouteModificationFilter.doFilter(SessionJvmRouteModificationFilter.java:65) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:354) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:179) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:154) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:337) at com.appiancorp.security.auth.activity.UserActivityFilter.doFilter(UserActivityFilter.java:50) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:115) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:81) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:122) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:116) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:126) at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:81) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) at com.appiancorp.security.auth.rememberme.CookieTheftRedirectFilter.doFilter(CookieTheftRedirectFilter.java:44) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) at org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter.doFilter(RememberMeAuthenticationFilter.java:102) at org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter.doFilter(RememberMeAuthenticationFilter.java:93) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:149) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:150) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) at org.springframework.web.filter.CompositeFilter$VirtualFilterChain.doFilter(CompositeFilter.java:108) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:219) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:213) at org.springframework.web.filter.CompositeFilter$VirtualFilterChain.doFilter(CompositeFilter.java:113) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:219) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:213) at org.springframework.web.filter.CompositeFilter$VirtualFilterChain.doFilter(CompositeFilter.java:113) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:219) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:213) at org.springframework.web.filter.CompositeFilter$VirtualFilterChain.doFilter(CompositeFilter.java:113) at org.springframework.web.filter.CompositeFilter.doFilter(CompositeFilter.java:74) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) at org.springframework.security.web.access.channel.ChannelProcessingFilter.doFilter(ChannelProcessingFilter.java:133) at com.appiancorp.security.csrf.CsrfChannelProcessingFilter.callSuperDoFilter(CsrfChannelProcessingFilter.java:107) at com.appiancorp.security.csrf.CsrfChannelProcessingFilter.doFilter(CsrfChannelProcessingFilter.java:93) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:55) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) at org.springframework.security.web.session.ConcurrentSessionFilter.doFilter(ConcurrentSessionFilter.java:147) at org.springframework.security.web.session.ConcurrentSessionFilter.doFilter(ConcurrentSessionFilter.java:125) at com.appiancorp.security.auth.session.AppianForcedLogoutSessionFilter.doFilter(AppianForcedLogoutSessionFilter.java:70) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) at com.appiancorp.security.auth.session.LogoutReasonFilter.doFilter(LogoutReasonFilter.java:54) at com.appiancorp.security.auth.session.LogoutReasonFilter.doFilter(LogoutReasonFilter.java:36) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:110) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:80) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) at com.appiancorp.security.auth.MobileClientValidationFilter.doFilter(MobileClientValidationFilter.java:46) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346) at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:221) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:186) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:354) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:179) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:154) at com.appiancorp.security.csp.CspFilter.doFilter(CspFilter.java:84) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:179) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:154) at com.appiancorp.security.web.FrameOptionsFilter.doFilter(FrameOptionsFilter.java:40) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:179) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:154) at com.appiancorp.security.headers.AppianSecurityHeadersFilter.doFilter(AppianSecurityHeadersFilter.java:62) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:179) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:154) at com.appiancorp.common.web.HttpMethodOverrideFilter.doFilter(HttpMethodOverrideFilter.java:34) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:179) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:154) at com.appiancorp.security.cors.CorsFilter.doFilter(CorsFilter.java:281) at com.appiancorp.security.cors.CorsFilter.doFilter(CorsFilter.java:256) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:179) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:154) at com.appiancorp.security.auth.maintwindow.MaintWindowHeaderFilter.doFilter(MaintWindowHeaderFilter.java:31) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:354) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:179) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:154) at com.appiancorp.security.auth.logging.AuthenticationLoggingFilter.doFilter(AuthenticationLoggingFilter.java:37) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:179) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:154) at com.appiancorp.security.auth.mobile.MobileAuthContextFilter.doFilter(MobileAuthContextFilter.java:82) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:179) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:154) at com.appiancorp.security.auth.AuthProviderFilter.doFilter(AuthProviderFilter.java:80) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:179) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:154) at com.appiancorp.common.web.UserAgentFilter.doFilter(UserAgentFilter.java:41) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:179) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:154) at com.appiancorp.security.web.DomainFilter.doFilter(DomainFilter.java:57) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:179) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:154) at com.appiancorp.ap2.environment.EnvironmentFilter.doFilter(EnvironmentFilter.java:87) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:179) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:154) at com.appiancorp.common.web.ThreadLocalRequestFilter.doFilter(ThreadLocalRequestFilter.java:34) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:179) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:154) at com.appiancorp.security.web.SessionFailoverFilter.doFilter(SessionFailoverFilter.java:60) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:179) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:154) at com.appiancorp.tomcat.session.SessionSerializationRequestWrappingFilter.doFilter(SessionSerializationRequestWrappingFilter.java:36) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:354) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:179) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:154) at com.appiancorp.ap2.NullByteInjectionFilter.doFilter(NullByteInjectionFilter.java:32) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:179) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:154) at com.appiancorp.ap2.EncodingFilter.doFilter(EncodingFilter.java:58) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:179) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:154) at com.appiancorp.common.web.HttpStrictTransportSecurityFilter.doFilter(HttpStrictTransportSecurityFilter.java:50) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:179) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:154) at com.appiancorp.monitoring.prometheus.HttpResponseMetricsFilter.doFilter(HttpResponseMetricsFilter.java:79) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:179) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:154) at com.appiancorp.tracing.web.AppianTracingFilter.doFilter(AppianTracingFilter.java:143) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:354) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:179) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:154) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at com.appiancorp.tomcat.session.valves.UpdateValve.invoke(UpdateValve.java:32) at com.appiancorp.tomcat.session.valves.UsageValve.invoke(UsageValve.java:35) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:596) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:670) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:765) at com.appiancorp.tomcat.cookies.PartitionedCookieMigrationValve.invoke(PartitionedCookieMigrationValve.java:36) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:346) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:424) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:928) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1786) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.lang.Thread.run(Thread.java:750)Caused by: com.appiancorp.suiteapi.common.exceptions.AppianRuntimeException: com.appiancorp.suiteapi.common.exceptions.AppianException: Unexpected error executing query (type: [HseIncidentAllIncSegnalazViewDT21391], query: [Report on Record Type], order by: [[Sort[idRepApp asc]]], filters:[((idRepApp = TypedValue[it=1,v=118784]) AND ((plantId in TypedValue[it=101,v={1,2,4,5,6,7,8,11,12,14,15,16,17,19,20,24,25,26,27,28,30,31,33,34,35,36,37,38,40,41,42,43,44,45,47,50,51,52,55,69,71,72,73,74,75,77,78,79,80,81,82,84}]) OR (SeriousFlag = TypedValue[it=1,v=1])))]) (APNX-1-4164-028) at com.appiancorp.type.external.teneoimpl.QueryRuleExceptionHandler.handle(QueryRuleExceptionHandler.java:52) at com.appiancorp.type.external.teneoimpl.TimedWorkRunner.run(TimedWorkRunner.java:69) at com.appiancorp.type.external.teneoimpl.ProjectionQueryHandler.getResult(ProjectionQueryHandler.java:217) at com.appiancorp.type.external.teneoimpl.QueryHandler.execute(QueryHandler.java:103) at com.appiancorp.type.external.teneoimpl.HibernateQueryExecutor.execute(HibernateQueryExecutor.java:47) at com.appiancorp.type.external.teneoimpl.TeneoQueryExecutor.execute(TeneoQueryExecutor.java:123) at com.appiancorp.type.external.teneoimpl.TeneoDataStore.query(TeneoDataStore.java:911) at com.appiancorp.record.data.sourcedataaccessors.RecordEntityDataAccessor.lambda$queryDataStoreEntity$0(RecordEntityDataAccessor.java:57) at com.appiancorp.type.external.teneoimpl.TeneoDataStoreJdbcTransactionStrategy.runInJdbcTransaction(TeneoDataStoreJdbcTransactionStrategy.java:37) at com.appiancorp.type.external.teneoimpl.TeneoDataStoreTransactionRunner.chooseTransactionTypeAndRun(TeneoDataStoreTransactionRunner.java:45) at com.appiancorp.type.external.teneoimpl.TeneoDataStoreTransactionRunner.runInTransaction(TeneoDataStoreTransactionRunner.java:40) at com.appiancorp.type.external.teneoimpl.TeneoDataStore.runInTransaction(TeneoDataStore.java:483) at com.appiancorp.record.data.sourcedataaccessors.RecordEntityDataAccessor.queryDataStoreEntity(RecordEntityDataAccessor.java:56) ... 286 moreCaused by: org.hibernate.QueryTimeoutException: could not extract ResultSet at org.hibernate.dialect.Oracle8iDialect$3.convert(Oracle8iDialect.java:577) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:37) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:67) at org.hibernate.loader.Loader.getResultSet(Loader.java:2322) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2075) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2037) at org.hibernate.loader.Loader.doQuery(Loader.java:956) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:357) at org.hibernate.loader.Loader.doList(Loader.java:2868) at org.hibernate.loader.Loader.doList(Loader.java:2850) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2682) at org.hibernate.loader.Loader.list(Loader.java:2677) at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:109) at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1922) at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:370) at com.appiancorp.type.external.teneoimpl.ProjectionQueryHandler$6.call(ProjectionQueryHandler.java:220) at com.appiancorp.type.external.teneoimpl.ProjectionQueryHandler$6.call(ProjectionQueryHandler.java:217) at com.appiancorp.type.external.teneoimpl.TimedWorkRunner.run(TimedWorkRunner.java:65) ... 297 moreCaused by: java.sql.SQLTimeoutException: ORA-01013: user requested cancel of current operation
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:630) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:564) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1151) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:771) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:299) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:498) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:152) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:937) at oracle.jdbc.driver.OracleStatement.prepareDefineBufferAndExecute(OracleStatement.java:1172) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1101) at oracle.jdbc.driver.OracleStatement.executeSQLSelect(OracleStatement.java:1426) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1309) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3746) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3855) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1098) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57) ... 312 moreCaused by: Error : 1013, Position : 446, Sql = select * from ( select this_."ID_REP_APP" as y0_, this_."SERIOUS_FLAG" as y1_, this_."STATUS_SEGNALAZIONI" as y2_, this_."LIGHT_DATA_ENTRY" as y3_, this_."LIGHT_LOCAL" as y4_, this_."LIGHT_REQUEST_SERIOUS" as y5_, this_."LIGHT_EDIT_INCIDENT" as y6_, this_."EVENT" as y7_, this_."PLANT" as y8_, this_."IDINCIDENT" as y9_, this_."ID" as y10_, this_."ID_SEGNALAZIONI_RELATED" as y11_, this_."ID_BBS_RELATED" as y12_, this_."PLANT_ID" as y13_ from "V_INC_ALL_INC_SEGNALAZ" this_ where (this_."ID_REP_APP"=:1 and ((this_."PLANT_ID" in (:2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 )) or this_."SERIOUS_FLAG"=:54 )) order by y0_ asc ) where rownum <= :55 , OriginalSql = select * from ( select this_."ID_REP_APP" as y0_, this_."SERIOUS_FLAG" as y1_, this_."STATUS_SEGNALAZIONI" as y2_, this_."LIGHT_DATA_ENTRY" as y3_, this_."LIGHT_LOCAL" as y4_, this_."LIGHT_REQUEST_SERIOUS" as y5_, this_."LIGHT_EDIT_INCIDENT" as y6_, this_."EVENT" as y7_, this_."PLANT" as y8_, this_."IDINCIDENT" as y9_, this_."ID" as y10_, this_."ID_SEGNALAZIONI_RELATED" as y11_, this_."ID_BBS_RELATED" as y12_, this_."PLANT_ID" as y13_ from "V_INC_ALL_INC_SEGNALAZ" this_ where (this_."ID_REP_APP"=? and ((this_."PLANT_ID" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) or this_."SERIOUS_FLAG"=?)) order by y0_ asc ) where rownum <= ?, Error Msg = ORA-01013: user requested cancel of current operation
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:637) ... 329 more
Discussion posts and replies are publicly visible
Well, I do not see a question.
But to solve this, you will have to speed up that view or find a different way to implement that requirement.
I bet, as mentioned in the error message, you are hitting the timeout or memory limit.
As Stefan mentioned, you have to find a different way to implement it.What we did in a similar case:
We used a stored procedure to dump the content of the view every 15 minutes into a flat table (using a process model)
We defined a record type based on that table and inform the user on the UI at what time it was last updated.
Also, you have the capability to perform a sync on that flat table with data fabric by executing a 'fake deployment' of the record typeutilizing the Deployment APIs. Doing so, has the benefit that you don't have to deal with the primary keys. Appian will sync the whole record type. Data Fabric is of course only an option, if the number of records (4 million) are not exceeded.
We have made good experience with this approach. Hope that helps.
Agreed, I might look at indexing on the view in this case as well.
Additionally, I would caution against querying based on a list of ID inputs, as this is not scalable if the list can grow continuously. Alternative solutions will depend on the use case and current configurations.