Connection Manager Shutdown with Oracle Data Source

Our Oracle connections start to shutdown very often. This happen from when we have begging developing sail project (with query rule, a!query entity and so on).

This is an example of our error message. Any Suggestion?

2016-07-06 14:05:14,587 [http-amaltea.it.pirelli.com/151.10.76.28:8080-2] ERROR org.hibernate.util.JDBCExceptionReporter - javax.resource.ResourceException: IJ000451: The connection manager is shutdown: java:/jdbc/PirelliOracleDS
2016-07-06 14:05:14,588 [http-amaltea.it.pirelli.com/151.10.76.28:8080-2] ERROR com.appiancorp.rest.record.data.RecordRestService - Unable to retrieve record summary for record w/ type RecordType [id=321, uuid=c9a5afaa-3423-4d44-bd55-81544c47fa2d, name=BI Forecast Release, sourceTypeStr={http://www.appian.com/ae/types/2009}DataStoreEntity, sourceUuidStr=76e86701-983e-4f61-91d9-60edae6c4aa2@_a-0000dccc-f709-8000-9e06-010000010000_34042] and id 7
com.appiancorp.suiteapi.common.exceptions.AppianExc...

OriginalPostID-222118

OriginalPostID-222118

  Discussion posts and replies are publicly visible

  • ...eption: An error occurred while retrieving the data for “BI Forecast Release”. (APNX-1-4205-003)
              at com.appiancorp.suiteapi.common.exceptions.AppianRuntimeException.<init>(AppianRuntimeException.java:52)
              at com.appiancorp.record.data.RecordDataSourceEntityImpl$RecordEntityDataAccessor.queryDataStoreEntity(RecordDataSourceEntityImpl.java:127)
              at com.appiancorp.record.data.RecordDataSourceEntityImpl$RecordEntityDataAccessor.getRecordsInner(RecordDataSourceEntityImpl.java:102)
              at com.appiancorp.record.data.RecordDataSource$RecordDataAccessor.getRecordsData(RecordDataSource.java:67)
              at com.appiancorp.record.data.RecordDataSource$TypedValueRecordDataAccessor.getRecordsData(RecordDataSource.java:174)
              at com.appiancorp.record.data.RecordDataSource$TypedValueRecordDataAccessor.getRecordsData(RecordDataSource.java:168)
              at com.appiancorp.record.data.RecordDataSource$TypedValueRecordDataAccessor.getRecordData(RecordDataSource.java:202)
              at com.appiancorp.record.data...
  • ....RecordDataSource$TypedValueRecordDataAccessor.getRecordData(RecordDataSource.java:136)
              at com.appiancorp.record.data.RecordDataSource$RecordDataAccessor.getRecordDataForExpressions(RecordDataSource.java:100)
              at com.appiancorp.record.data.RecordBindingProviderFactory$RecordBindingProviderFactoryImpl$RecordBindingProvider.generateBindings(RecordBindingProviderFactory.java:122)
              at com.appiancorp.record.data.RecordBindingProviderFactory$RecordBindingProviderFactoryImpl$RecordBindingProvider.generateBindings(RecordBindingProviderFactory.java:110)
              at com.appiancorp.record.data.RecordBindingProviderFactory$RecordBindingProviderFactoryImpl$RecordBindingProvider.getBindings(RecordBindingProviderFactory.java:97)
              at com.appiancorp.record.ui.RecordUiSourceFactoryImpl.buildRecordUiBuilder(RecordUiSourceFactoryImpl.java:96)
              at com.appiancorp.record.ui.RecordUiBuilderFactory$RecordUiBuilderFactoryImpl.build(RecordUiBuilderFactory.java:145)
              at com.appiancorp.record.ui.Recor...
  • ... dUiBuilderFactory$RecordUiBuilderFactoryImpl.buildAndCache(RecordUiBuilderFactory.java:120)
              at com.appiancorp.record.ui.RecordUiBuilderFactory$RecordUiBuilderFactoryImpl.get(RecordUiBuilderFactory.java:165)
              at sun.reflect.GeneratedMethodAccessor3573.invoke(Unknown Source)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
              at java.lang.reflect.Method.invoke(Method.java:497)
              at com.atlassian.plugin.osgi.hostcomponents.impl.DefaultComponentRegistrar$ContextClassLoaderSettingInvocationHandler.invoke(DefaultComponentRegistrar.java:129)
              at com.sun.proxy.$Proxy306.get(Unknown Source)
              at sun.reflect.GeneratedMethodAccessor3573.invoke(Unknown Source)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
              at java.lang.reflect.Method.invoke(Method.java:497)
              at com.atlassian.plugin.osgi.bridge.external.HostComponentFactoryBean$DynamicServiceInvocationHandler.invoke(HostComponentFactoryBean.java:1...
  • ... 54)
              at com.sun.proxy.$Proxy306.get(Unknown Source)
              at com.appiancorp.rest.record.data.RecordRestService.getRecordSummary(RecordRestService.java:259)
              at com.appiancorp.rest.record.data.RecordRestService.getRecordSummaryUINormal(RecordRestService.java:240)
              at com.appiancorp.rest.record.data.RecordRestService.addRecordSummary(RecordRestService.java:789)
              at com.appiancorp.rest.record.data.RecordRestService.getRecord(RecordRestService.java:698)
              at sun.reflect.GeneratedMethodAccessor3787.invoke(Unknown Source)
              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$TypeOutInvoker$1.invoke(DispatchProviderHelper.java:205)
              at com.atlassian.plugins.rest.common.interceptor.impl.DispatchProviderHelper$1.intercept(DispatchProviderHelper.java:100)
              at com.atlassian.plugins.rest.common.interceptor.impl.Defaul...
  • ... tMethodInvocation.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$TypeOutInvoker._dispatch(DispatchProviderHelper.java:201)
              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.s...
  • ... ervlet.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 org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)
              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 org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)
              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 org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)
              at com.appi...
  • ... ancorp.tempo.util.PerformanceLogFilter.doFilter(PerformanceLogFilter.java:57)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)
              at com.appiancorp.common.web.PathMatchExclusionFilter.doFilter(PathMatchExclusionFilter.java:68)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)
              at com.appiancorp.security.web.FrameOptionsFilter.doFilter(FrameOptionsFilter.java:25)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)
              at com.appiancorp.security.auth.ForceSetPasswordFilter.doFilter(ForceSetPasswordFilter.java:47)
              at org.apache.catalina...