2015-08-24 20:55:57,437 [ajp-/0.0.0.0:8009-3] ERROR com.appiancorp.ps.plugins.downloaddatasubsetfromrule.ExportDataSubsetToExcelServlet - Expression evaluation error in rule 'test_reportgetdatasubset' (called by rule 'test_reportexport') at function a!queryEntity: An error occurred while retrieving the data.
com.appiancorp.process.expression.ExpressionRuntimeException$AppianExceptionProvider: Expression evaluation error in rule 'test_reportgetdatasubset' (called by rule 'test_reportexport') at function a!queryEntity: 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.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.op.TypeEvaluable.evalTreeOrValue(TypeEvaluable.java:175)
	at com.appiancorp.core.op.TypeEvaluable.cast0(TypeEvaluable.java:221)
	at com.appiancorp.core.op.TypeEvaluable.cast(TypeEvaluable.java:190)
	at com.appiancorp.core.op.TypeEvaluable.recordFromKeywords(TypeEvaluable.java:304)
	at com.appiancorp.core.op.TypeEvaluable.eval(TypeEvaluable.java:120)
	at com.appiancorp.core.expr.tree.TypeCall.evalType(TypeCall.java:101)
	at com.appiancorp.core.expr.tree.TypeCall.eval(TypeCall.java:83)
	at com.appiancorp.core.expr.tree.TypeCall.eval0(TypeCall.java:50)
	at com.appiancorp.core.expr.Tree.eval(Tree.java:209)
	at com.appiancorp.core.expr.tree.AbstractLetFunction.eval00(AbstractLetFunction.java:110)
	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.Parse.evalInner(Parse.java:296)
	at com.appiancorp.core.expr.Parse.eval(Parse.java:254)
	at com.appiancorp.core.expr.Parse.eval(Parse.java:239)
	at com.appiancorp.core.expr.Parse.eval(Parse.java:235)
	at com.appiancorp.core.expr.AppianScriptEngine.eval(AppianScriptEngine.java:59)
	at com.appiancorp.ps.plugins.downloaddatasubsetfromrule.ExportDataSubsetToExcelServlet.doGet(ExportDataSubsetToExcelServlet.java:68)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:734)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
	at com.atlassian.plugin.servlet.DelegatingPluginServlet.service(DelegatingPluginServlet.java:42)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
	at com.atlassian.plugin.servlet.ServletModuleContainerServlet.service(ServletModuleContainerServlet.java:52)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)
	at com.appiancorp.ap2.EntryFilter.doFilter(EntryFilter.java:40)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)
	at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
	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 com.appiancorp.ap2.PageFilter.doFilter(PageFilter.java:348)
	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.appiancorp.ap2.WrapFilter.doFilterInternal(WrapFilter.java:63)
	at com.appiancorp.common.web.PathMatchExclusionFilter.doFilter(PathMatchExclusionFilter.java:70)
	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.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)
	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.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183)
	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.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
	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 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 org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)
	at com.appiancorp.common.web.HttpMethodOverrideFilter.doFilter(HttpMethodOverrideFilter.java:34)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)
	at com.appiancorp.security.cors.CorsFilter.doFilter(CorsFilter.java:224)
	at com.appiancorp.security.cors.CorsFilter.doFilter(CorsFilter.java:199)
	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.logging.AuthenticationLoggingFilter.doFilter(AuthenticationLoggingFilter.java:37)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)
	at com.appiancorp.ap2.environment.EnvironmentFilter.doFilter(EnvironmentFilter.java:87)
	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.ThreadLocalRequestFilter.doFilter(ThreadLocalRequestFilter.java:34)
	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.WeblogicSessionAttributeClassLoaderRequestFilter.doFilter(WeblogicSessionAttributeClassLoaderRequestFilter.java:256)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)
	at com.appiancorp.ap2.NullByteInjectionFilter.doFilter(NullByteInjectionFilter.java:32)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)
	at com.appiancorp.ap2.EncodingFilter.doFilter(EncodingFilter.java:58)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:231)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:420)
	at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50)
	at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50)
	at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:150)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344)
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:490)
	at org.apache.coyote.ajp.AjpProtocol$AjpConnectionHandler.process(AjpProtocol.java:420)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:926)
	at java.lang.Thread.run(Thread.java:745)
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)
	... 162 more
Caused by: com.appiancorp.suiteapi.common.exceptions.AppianRuntimeException: com.appiancorp.suiteapi.common.exceptions.AppianException: Unexpected error executing query (type: [EmployeeDT13699], query: [queryentity expression], order by: [[Sort[ID asc]]], filters:[(createdDate <= TypedValue[it=9,v=53136-01-18 05:00:00.2])]) (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:56)
	at com.appiancorp.type.external.teneoimpl.ProjectionQueryHandler.getResult(ProjectionQueryHandler.java:207)
	at com.appiancorp.type.external.teneoimpl.QueryHandler.execute(QueryHandler.java:102)
	at com.appiancorp.type.external.teneoimpl.HibernateQueryExecutor.execute(HibernateQueryExecutor.java:40)
	at com.appiancorp.type.external.teneoimpl.TeneoQueryExecutor.execute(TeneoQueryExecutor.java:125)
	at com.appiancorp.type.external.teneoimpl.TeneoDataStore.query(TeneoDataStore.java:819)
	at com.appiancorp.core.expr.fn.query.QueryEntity.queryDataStoreEntity(QueryEntity.java:134)
	... 170 more
Caused by: org.hibernate.exception.GenericJDBCException: could not execute query
	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.loader.Loader.doList(Loader.java:2536)
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
	at org.hibernate.loader.Loader.list(Loader.java:2271)
	at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119)
	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1716)
	at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)
	at com.appiancorp.type.external.teneoimpl.ProjectionQueryHandler$6.call(ProjectionQueryHandler.java:210)
	at com.appiancorp.type.external.teneoimpl.ProjectionQueryHandler$6.call(ProjectionQueryHandler.java:207)
	at com.appiancorp.type.external.teneoimpl.TimedWorkRunner.run(TimedWorkRunner.java:52)
	... 176 more
Caused by: java.sql.SQLException: Year out of range.
	at oracle.jdbc.driver.DateCommonBinder.setOracleCYMD(OraclePreparedStatement.java:18966)
	at oracle.jdbc.driver.TimestampBinder.bind(OraclePreparedStatement.java:19245)
	at oracle.jdbc.driver.OraclePreparedStatement.setupBindBuffers(OraclePreparedStatement.java:3014)
	at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:2247)
	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3444)
	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
	at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)
	at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
	at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
	at org.hibernate.loader.Loader.doQuery(Loader.java:802)
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
	at org.hibernate.loader.Loader.doList(Loader.java:2533)
	... 184 more
2015-08-24 20:55:57,450 [ajp-/0.0.0.0:8009-3] ERROR com.appiancorp.ap2.PortalResponse - Error: 500