Hello Everyone,
We have a database view with 45 columns and it taken 4sec of time(40k records) to execute from database view. Also DT created for this view in appian, now we mapped this DB view to Record and it was thrown below error:
Expression evaluation error [evaluation ID = fead6:13bce] at function a!recordList_ui_design: An error occurred because the record types source is currently unavailable, or the query reached a timeout or memory limit. (APNX-1-4198-000)
It's looks like a wired behavior of Record because as per the community it will support 40L records. Could someone help me out to fix the issue.
DS also verified and published without error.
FYI, We can't see the data in record after we mapped to DB view and it shown the error message as mentioned above.
stdout log here:
Caused by: com.appiancorp.core.expr.exceptions.IssuedException: com.appiancorp.core.expr.exceptions.ExpressionRuntimeException$AppianExceptionProvider: Expression evaluation error [evaluation ID = 4bab8:cf6da] at function a!recordList: An error occurred because the record types source is currently unavailable, or the query reached a timeout or memory limit. (APNX-1-4198-000) at a!gridField_v1_recordData.(SYSTEM_SYSRULES_gridField_v1_recordData:417) at a!gridField_v1_internal.(SYSTEM_SYSRULES_gridField_v1_internal:344) at a!gridField_v1.(SYSTEM_SYSRULES_gridField_v1:4) at a!recordGridField.(SYSTEM_SYSRULES_recordGridField:51) at a!recordList_buildGridContents.(SYSTEM_SYSRULES_recordList_buildGridContents:1) at a!recordList_web.(SYSTEM_SYSRULES_recordList_web:49) at a!recordList_ui_persisted.(SYSTEM_SYSRULES_recordList_ui_persisted:29) at a!recordList.(SYSTEM_SYSRULES_recordList:15) at ______________________________SAIL_TO_JAVA_BOUNDARY______________________________.esId=4bab8eb01a1be41459fc7a8bbc8c812f:cf6da088cb89db36(Unknown Source) at com.appiancorp.core.expr.exceptions.ExpressionRuntimeException.<init>(ExpressionRuntimeException.java:112) at com.appiancorp.core.expr.exceptions.ExpressionRuntimeException.<init>(ExpressionRuntimeException.java:101) at com.appiancorp.core.expr.exceptions.AppianScriptException.<init>(AppianScriptException.java:20) at com.appiancorp.core.expr.exceptions.ParseException.<init>(ParseException.java:16) at com.appiancorp.core.expr.exceptions.FunctionException.<init>(FunctionException.java:11) at com.appiancorp.core.expr.exceptions.IssuedException.<init>(IssuedException.java:14) at com.appiancorp.core.expr.fn.info.IssueError.eval(IssueError.java:43) at com.appiancorp.core.expr.fn.Function.eval0(Function.java:62) at com.appiancorp.core.expr.DefaultEvaluable.eval(DefaultEvaluable.java:213) at com.appiancorp.core.expr.FunctionCallDelegate$InternalFunctionCallWithContext.eval(FunctionCallDelegate.java:290) at com.appiancorp.core.expr.FunctionCallDelegate.evalFunctionCall(FunctionCallDelegate.java:107) at com.appiancorp.core.expr.AppianScriptContextTop.evalInternalFunction(AppianScriptContextTop.java:590) at com.appiancorp.core.expr.AppianScriptContextChild.evalInternalFunction(AppianScriptContextChild.java:295) at com.appiancorp.core.expr.tree.FunctionCall.evalImmediate(FunctionCall.java:602) at com.appiancorp.core.expr.tree.FunctionCall.evalEvaluable(FunctionCall.java:550) at com.appiancorp.core.expr.tree.FunctionCall.evalWrapped(FunctionCall.java:662) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.Tree.eval0(Tree.java:438) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.tree.Try.eval0(Try.java:121) at com.appiancorp.core.expr.tree.TreeEvaluable.evalWrapped(TreeEvaluable.java:111) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.SpecialFunction.eval0(SpecialFunction.java:112) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.tree.If.evalInner(If.java:178) at com.appiancorp.core.expr.tree.If.eval0(If.java:108) at com.appiancorp.core.expr.tree.TreeEvaluable.evalWrapped(TreeEvaluable.java:111) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.SpecialFunction.eval0(SpecialFunction.java:112) at com.appiancorp.core.expr.Tree.evalWrapped(Tree.java:312) at com.appiancorp.core.expr.Tree.eval(Tree.java:294) at com.appiancorp.core.expr.tree.WithAssignment.evalLet(WithAssignment.java:32) at com.appiancorp.core.expr.tree.AbstractLetAssignment.eval(AbstractLetAssignment.java:75) at com.appiancorp.core.expr.tree.AbstractLetFunction.executeSerial(AbstractLetFunction.java:370) at com.appiancorp.core.expr.tree.AbstractLetFunction.processBindings(AbstractLetFunction.java:354) at com.appiancorp.core.expr.tree.AbstractLetFunction.eval00(AbstractLetFunction.java:95) at com.appiancorp.core.expr.tree.With.eval0(With.java:103) at com.appiancorp.core.expr.tree.TreeEvaluable.evalWrapped(TreeEvaluable.java:111) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.SpecialFunction.eval0(SpecialFunction.java:112) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.rule.Rule.evalBody(Rule.java:1531) at com.appiancorp.core.expr.rule.Rule.doEval(Rule.java:924) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:811) at com.appiancorp.core.expr.rule.Rule.evalAndCache(Rule.java:705) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:697) at com.appiancorp.core.expr.rule.Rule.evalWithMetrics(Rule.java:678) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:664) at com.appiancorp.core.expr.LambdaEvaluable.eval(LambdaEvaluable.java:73) at com.appiancorp.core.expr.tree.FunctionCall.evalEvaluable(FunctionCall.java:538) at com.appiancorp.core.expr.tree.FunctionCall.evalWrapped(FunctionCall.java:662) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.Tree.eval0(Tree.java:438) at com.appiancorp.core.expr.Tree.evalWrapped(Tree.java:312) at com.appiancorp.core.expr.Tree.eval(Tree.java:294) at com.appiancorp.core.expr.tree.WithAssignment.evalLet(WithAssignment.java:32) at com.appiancorp.core.expr.tree.AbstractLetAssignment.eval(AbstractLetAssignment.java:75) at com.appiancorp.core.expr.tree.AbstractLetFunction.executeSerial(AbstractLetFunction.java:370) at com.appiancorp.core.expr.tree.AbstractLetFunction.processBindings(AbstractLetFunction.java:354) at com.appiancorp.core.expr.tree.AbstractLetFunction.eval00(AbstractLetFunction.java:95) at com.appiancorp.core.expr.tree.With.eval0(With.java:103) at com.appiancorp.core.expr.tree.TreeEvaluable.evalWrapped(TreeEvaluable.java:111) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.SpecialFunction.eval0(SpecialFunction.java:112) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.rule.Rule.evalBody(Rule.java:1531) at com.appiancorp.core.expr.rule.Rule.doEval(Rule.java:924) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:811) at com.appiancorp.core.expr.rule.Rule.evalAndCache(Rule.java:705) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:697) at com.appiancorp.core.expr.rule.Rule.evalWithMetrics(Rule.java:678) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:664) at com.appiancorp.core.expr.LambdaEvaluable.eval(LambdaEvaluable.java:73) at com.appiancorp.core.expr.tree.FunctionCall.evalEvaluable(FunctionCall.java:538) at com.appiancorp.core.expr.tree.FunctionCall.evalWrapped(FunctionCall.java:662) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.Tree.eval0(Tree.java:438) at com.appiancorp.core.expr.Tree.evalWrapped(Tree.java:312) at com.appiancorp.core.expr.Tree.eval(Tree.java:294) at com.appiancorp.core.expr.tree.LocalVariablesAssignment.evaluateTree(LocalVariablesAssignment.java:633) at com.appiancorp.core.expr.tree.LocalVariablesAssignment.evalLetConfigured(LocalVariablesAssignment.java:209) at com.appiancorp.core.expr.tree.LocalVariablesAssignment.evalLet(LocalVariablesAssignment.java:113) at com.appiancorp.core.expr.tree.AbstractLetAssignment.eval(AbstractLetAssignment.java:75) at com.appiancorp.core.expr.tree.AbstractLetFunction.executeSerial(AbstractLetFunction.java:370) at com.appiancorp.core.expr.tree.AbstractLetFunction.processBindings(AbstractLetFunction.java:354) at com.appiancorp.core.expr.tree.AbstractLetFunction.eval00(AbstractLetFunction.java:95) at com.appiancorp.core.expr.tree.LocalVariables.eval0(LocalVariables.java:105) at com.appiancorp.core.expr.tree.TreeEvaluable.evalWrapped(TreeEvaluable.java:111) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.SpecialFunction.eval0(SpecialFunction.java:112) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.tree.Eval.evalTarget(Eval.java:173) at com.appiancorp.core.expr.tree.Eval.eval(Eval.java:163) at com.appiancorp.core.expr.tree.Eval.eval(Eval.java:146) at com.appiancorp.core.expr.tree.Eval.eval0(Eval.java:121) at com.appiancorp.core.expr.tree.TreeEvaluable.evalWrapped(TreeEvaluable.java:111) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.SpecialFunction.eval0(SpecialFunction.java:112) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.tree.AbstractLetFunction.evaluateLetBody(AbstractLetFunction.java:168) at com.appiancorp.core.expr.tree.AbstractLetFunction.eval00(AbstractLetFunction.java:112) at com.appiancorp.core.expr.tree.LocalVariables.eval0(LocalVariables.java:105) at com.appiancorp.core.expr.tree.TreeEvaluable.evalWrapped(TreeEvaluable.java:111) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.SpecialFunction.eval0(SpecialFunction.java:112) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.tree.If.evalInner(If.java:198) at com.appiancorp.core.expr.tree.If.eval0(If.java:108) at com.appiancorp.core.expr.tree.TreeEvaluable.evalWrapped(TreeEvaluable.java:111) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.SpecialFunction.eval0(SpecialFunction.java:112) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.rule.Rule.evalBody(Rule.java:1531) at com.appiancorp.core.expr.rule.Rule.doEval(Rule.java:924) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:811) at com.appiancorp.core.expr.rule.Rule.evalAndCache(Rule.java:705) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:697) at com.appiancorp.core.expr.rule.Rule.evalWithMetrics(Rule.java:678) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:664) at com.appiancorp.core.expr.tree.FreeformRule.evalWrapped(FreeformRule.java:162) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.FreeformRule.eval0(FreeformRule.java:133) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.tree.AbstractLetFunction.evaluateLetBody(AbstractLetFunction.java:168) at com.appiancorp.core.expr.tree.AbstractLetFunction.eval00(AbstractLetFunction.java:112) at com.appiancorp.core.expr.tree.LocalVariables.eval0(LocalVariables.java:105) at com.appiancorp.core.expr.tree.TreeEvaluable.evalWrapped(TreeEvaluable.java:111) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.SpecialFunction.eval0(SpecialFunction.java:112) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.common.monitoring.MonitoringFunctionBase.evalInner(MonitoringFunctionBase.java:92) at com.appiancorp.common.monitoring.MonitoringFunctionBase.evaluateAndLogMetric(MonitoringFunctionBase.java:52) at com.appiancorp.common.monitoring.GridFieldRecordDataMonitoringFunction.evaluateAndLogRecordGridFieldMetric(GridFieldRecordDataMonitoringFunction.java:70) at com.appiancorp.common.monitoring.GridFieldRecordDataMonitoring.eval0(GridFieldRecordDataMonitoring.java:69) at com.appiancorp.core.expr.tree.TreeEvaluable.evalWrapped(TreeEvaluable.java:111) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.SpecialFunction.eval0(SpecialFunction.java:112) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.tree.AbstractLetFunction.evaluateLetBody(AbstractLetFunction.java:168) at com.appiancorp.core.expr.tree.AbstractLetFunction.eval00(AbstractLetFunction.java:112) at com.appiancorp.core.expr.tree.LocalVariables.eval0(LocalVariables.java:105) at com.appiancorp.core.expr.tree.TreeEvaluable.evalWrapped(TreeEvaluable.java:111) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.SpecialFunction.eval0(SpecialFunction.java:112) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.rule.Rule.evalBody(Rule.java:1531) at com.appiancorp.core.expr.rule.Rule.doEval(Rule.java:924) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:811) at com.appiancorp.core.expr.rule.Rule.evalAndCache(Rule.java:705) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:697) at com.appiancorp.core.expr.rule.Rule.evalWithMetrics(Rule.java:678) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:664) at com.appiancorp.core.expr.tree.FreeformRule.evalWrapped(FreeformRule.java:162) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.FreeformRule.eval0(FreeformRule.java:133) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.tree.AbstractLetFunction.evaluateLetBody(AbstractLetFunction.java:168) at com.appiancorp.core.expr.tree.AbstractLetFunction.eval00(AbstractLetFunction.java:112) at com.appiancorp.core.expr.tree.With.eval0(With.java:103) at com.appiancorp.core.expr.tree.TreeEvaluable.evalWrapped(TreeEvaluable.java:111) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.SpecialFunction.eval0(SpecialFunction.java:112) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.fn.WithEvalState.eval0(WithEvalState.java:106) at com.appiancorp.core.expr.tree.TreeEvaluable.evalWrapped(TreeEvaluable.java:111) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.SpecialFunction.eval0(SpecialFunction.java:112) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.tree.If.evalInner(If.java:178) at com.appiancorp.core.expr.tree.If.eval0(If.java:108) at com.appiancorp.core.expr.tree.TreeEvaluable.evalWrapped(TreeEvaluable.java:111) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.SpecialFunction.eval0(SpecialFunction.java:112) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.tree.AbstractLetFunction.evaluateLetBody(AbstractLetFunction.java:168) at com.appiancorp.core.expr.tree.AbstractLetFunction.eval00(AbstractLetFunction.java:112) at com.appiancorp.core.expr.tree.LocalVariables.eval0(LocalVariables.java:105) at com.appiancorp.core.expr.tree.TreeEvaluable.evalWrapped(TreeEvaluable.java:111) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.SpecialFunction.eval0(SpecialFunction.java:112) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.common.monitoring.MonitoringFunctionBase.evalInner(MonitoringFunctionBase.java:92) at com.appiancorp.common.monitoring.MonitoringFunctionBase.evaluateAndLogMetric(MonitoringFunctionBase.java:52) at com.appiancorp.common.monitoring.MonitoringFunctionBase.evaluateAndLogMetric(MonitoringFunctionBase.java:41) at com.appiancorp.common.monitoring.GridFieldMonitoring.eval0(GridFieldMonitoring.java:72) at com.appiancorp.core.expr.tree.TreeEvaluable.evalWrapped(TreeEvaluable.java:111) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.SpecialFunction.eval0(SpecialFunction.java:112) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.rule.Rule.evalBody(Rule.java:1531) at com.appiancorp.core.expr.rule.Rule.doEval(Rule.java:924) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:811) at com.appiancorp.core.expr.rule.Rule.evalAndCache(Rule.java:705) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:697) at com.appiancorp.core.expr.rule.Rule.evalWithMetrics(Rule.java:678) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:664) at com.appiancorp.core.expr.tree.FreeformRule.evalWrapped(FreeformRule.java:162) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.FreeformRule.eval0(FreeformRule.java:133) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.fn.WithEvalState.eval0(WithEvalState.java:106) at com.appiancorp.core.expr.tree.TreeEvaluable.evalWrapped(TreeEvaluable.java:111) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.SpecialFunction.eval0(SpecialFunction.java:112) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.rule.Rule.evalBody(Rule.java:1531) at com.appiancorp.core.expr.rule.Rule.doEval(Rule.java:924) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:811) at com.appiancorp.core.expr.rule.Rule.evalAndCache(Rule.java:705) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:697) at com.appiancorp.core.expr.rule.Rule.evalWithMetrics(Rule.java:678) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:664) at com.appiancorp.core.expr.tree.FreeformRule.evalWrapped(FreeformRule.java:162) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.FreeformRule.eval0(FreeformRule.java:133) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.tree.Eval.evalTarget(Eval.java:173) at com.appiancorp.core.expr.tree.Eval.eval(Eval.java:163) at com.appiancorp.core.expr.tree.Eval.eval(Eval.java:146) at com.appiancorp.core.expr.tree.Eval.eval0(Eval.java:121) at com.appiancorp.core.expr.tree.TreeEvaluable.evalWrapped(TreeEvaluable.java:111) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.SpecialFunction.eval0(SpecialFunction.java:112) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.rule.Rule.evalTreeOrValue(Rule.java:1256) at com.appiancorp.core.expr.rule.Rule.cast(Rule.java:1198) at com.appiancorp.core.expr.rule.Rule.prepareBindingsKeywords(Rule.java:1065) at com.appiancorp.core.expr.rule.Rule.prepareBindingsKeywords(Rule.java:978) at com.appiancorp.core.expr.rule.Rule.doEval(Rule.java:905) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:811) at com.appiancorp.core.expr.rule.Rule.evalAndCache(Rule.java:705) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:697) at com.appiancorp.core.expr.rule.Rule.evalWithMetrics(Rule.java:678) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:664) at com.appiancorp.core.expr.tree.FreeformRule.evalWrapped(FreeformRule.java:162) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.FreeformRule.eval0(FreeformRule.java:133) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.tree.AbstractLetFunction.evaluateLetBody(AbstractLetFunction.java:168) at com.appiancorp.core.expr.tree.AbstractLetFunction.eval00(AbstractLetFunction.java:112) at com.appiancorp.core.expr.tree.LocalVariables.eval0(LocalVariables.java:105) at com.appiancorp.core.expr.tree.TreeEvaluable.evalWrapped(TreeEvaluable.java:111) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.SpecialFunction.eval0(SpecialFunction.java:112) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.rule.Rule.evalBody(Rule.java:1531) at com.appiancorp.core.expr.rule.Rule.doEval(Rule.java:924) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:811) at com.appiancorp.core.expr.rule.Rule.evalAndCache(Rule.java:705) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:697) at com.appiancorp.core.expr.rule.Rule.evalWithMetrics(Rule.java:678) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:664) at com.appiancorp.core.expr.LambdaEvaluable.eval(LambdaEvaluable.java:73) at com.appiancorp.core.expr.tree.FunctionCall.evalEvaluable(FunctionCall.java:538) at com.appiancorp.core.expr.tree.FunctionCall.evalWrapped(FunctionCall.java:662) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.Tree.eval0(Tree.java:438) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.rule.Rule.evalTreeOrValue(Rule.java:1256) at com.appiancorp.core.expr.rule.Rule.cast(Rule.java:1198) at com.appiancorp.core.expr.rule.Rule.prepareBindingsKeywords(Rule.java:1065) at com.appiancorp.core.expr.rule.Rule.prepareBindingsKeywords(Rule.java:978) at com.appiancorp.core.expr.rule.Rule.doEval(Rule.java:905) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:811) at com.appiancorp.core.expr.rule.Rule.evalAndCache(Rule.java:705) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:697) at com.appiancorp.core.expr.rule.Rule.evalWithMetrics(Rule.java:678) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:664) at com.appiancorp.core.expr.tree.FreeformRule.evalWrapped(FreeformRule.java:162) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.FreeformRule.eval0(FreeformRule.java:133) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.tree.AbstractLetFunction.evaluateLetBody(AbstractLetFunction.java:168) at com.appiancorp.core.expr.tree.AbstractLetFunction.eval00(AbstractLetFunction.java:112) at com.appiancorp.core.expr.tree.With.eval0(With.java:103) at com.appiancorp.core.expr.tree.TreeEvaluable.evalWrapped(TreeEvaluable.java:111) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.SpecialFunction.eval0(SpecialFunction.java:112) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.tree.AbstractLetFunction.evaluateLetBody(AbstractLetFunction.java:168) at com.appiancorp.core.expr.tree.AbstractLetFunction.eval00(AbstractLetFunction.java:112) at com.appiancorp.core.expr.tree.Load.eval0(Load.java:104) at com.appiancorp.core.expr.tree.TreeEvaluable.evalWrapped(TreeEvaluable.java:111) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.SpecialFunction.eval0(SpecialFunction.java:112) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.tree.AbstractLetFunction.evaluateLetBody(AbstractLetFunction.java:168) at com.appiancorp.core.expr.tree.AbstractLetFunction.eval00(AbstractLetFunction.java:112) at com.appiancorp.core.expr.tree.With.eval0(With.java:103) at com.appiancorp.core.expr.tree.TreeEvaluable.evalWrapped(TreeEvaluable.java:111) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.SpecialFunction.eval0(SpecialFunction.java:112) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.tree.performancelog.PerformanceLogFunction.eval0(PerformanceLogFunction.java:133) at com.appiancorp.core.expr.tree.TreeEvaluable.evalWrapped(TreeEvaluable.java:111) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.SpecialFunction.eval0(SpecialFunction.java:112) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.rule.Rule.evalBody(Rule.java:1531) at com.appiancorp.core.expr.rule.Rule.doEval(Rule.java:924) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:811) at com.appiancorp.core.expr.rule.Rule.evalAndCache(Rule.java:705) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:697) at com.appiancorp.core.expr.rule.Rule.evalWithMetrics(Rule.java:678) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:664) at com.appiancorp.core.expr.tree.FreeformRule.evalWrapped(FreeformRule.java:162) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.FreeformRule.eval0(FreeformRule.java:133) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.tree.ListAtIndices.evalWrapped(ListAtIndices.java:241) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.Tree.eval0(Tree.java:438) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.rule.Rule.evalTreeOrValue(Rule.java:1256) at com.appiancorp.core.expr.rule.Rule.cast(Rule.java:1198) at com.appiancorp.core.expr.rule.Rule.prepareBindingsKeywords(Rule.java:1065) at com.appiancorp.core.expr.rule.Rule.prepareBindingsKeywords(Rule.java:978) at com.appiancorp.core.expr.rule.Rule.doEval(Rule.java:905) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:811) at com.appiancorp.core.expr.rule.Rule.evalAndCache(Rule.java:705) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:697) at com.appiancorp.core.expr.rule.Rule.evalWithMetrics(Rule.java:678) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:664) at com.appiancorp.core.expr.tree.FreeformRule.evalWrapped(FreeformRule.java:162) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.FreeformRule.eval0(FreeformRule.java:133) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.tree.If.evalInner(If.java:178) at com.appiancorp.core.expr.tree.If.eval0(If.java:108) at com.appiancorp.core.expr.tree.TreeEvaluable.evalWrapped(TreeEvaluable.java:111) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.SpecialFunction.eval0(SpecialFunction.java:112) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.tree.AbstractLetFunction.evaluateLetBody(AbstractLetFunction.java:168) at com.appiancorp.core.expr.tree.AbstractLetFunction.eval00(AbstractLetFunction.java:112) at com.appiancorp.core.expr.tree.LocalVariables.eval0(LocalVariables.java:105) at com.appiancorp.core.expr.tree.TreeEvaluable.evalWrapped(TreeEvaluable.java:111) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.SpecialFunction.eval0(SpecialFunction.java:112) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.tree.performancelog.PerformanceLogFunction.eval0(PerformanceLogFunction.java:133) at com.appiancorp.core.expr.tree.TreeEvaluable.evalWrapped(TreeEvaluable.java:111) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.SpecialFunction.eval0(SpecialFunction.java:112) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.rule.Rule.evalBody(Rule.java:1531) at com.appiancorp.core.expr.rule.Rule.doEval(Rule.java:924) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:811) at com.appiancorp.core.expr.rule.Rule.evalAndCache(Rule.java:705) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:697) at com.appiancorp.core.expr.rule.Rule.evalWithMetrics(Rule.java:678) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:664) at com.appiancorp.core.expr.tree.FreeformRule.evalWrapped(FreeformRule.java:162) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.FreeformRule.eval0(FreeformRule.java:133) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.common.monitoring.NotifyRecordList.eval0(NotifyRecordList.java:87) at com.appiancorp.core.expr.tree.TreeEvaluable.evalWrapped(TreeEvaluable.java:111) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.SpecialFunction.eval0(SpecialFunction.java:112) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.tree.AbstractLetFunction.evaluateLetBody(AbstractLetFunction.java:168) at com.appiancorp.core.expr.tree.AbstractLetFunction.eval00(AbstractLetFunction.java:112) at com.appiancorp.core.expr.tree.LocalVariables.eval0(LocalVariables.java:105) at com.appiancorp.core.expr.tree.TreeEvaluable.evalWrapped(TreeEvaluable.java:111) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.SpecialFunction.eval0(SpecialFunction.java:112) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.tree.AbstractLetFunction.evaluateLetBody(AbstractLetFunction.java:168) at com.appiancorp.core.expr.tree.AbstractLetFunction.eval00(AbstractLetFunction.java:112) at com.appiancorp.core.expr.tree.Load.eval0(Load.java:104) at com.appiancorp.core.expr.tree.TreeEvaluable.evalWrapped(TreeEvaluable.java:111) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.SpecialFunction.eval0(SpecialFunction.java:112) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.rule.Rule.evalBody(Rule.java:1531) at com.appiancorp.core.expr.rule.Rule.doEval(Rule.java:924) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:811) at com.appiancorp.core.expr.rule.Rule.evalAndCache(Rule.java:705) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:697) at com.appiancorp.core.expr.rule.Rule.evalWithMetrics(Rule.java:678) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:664) at com.appiancorp.core.expr.tree.FreeformRule.evalWrapped(FreeformRule.java:162) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.FreeformRule.eval0(FreeformRule.java:133) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.tree.If.evalInner(If.java:198) at com.appiancorp.core.expr.tree.If.eval0(If.java:108) at com.appiancorp.core.expr.tree.TreeEvaluable.evalWrapped(TreeEvaluable.java:111) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.SpecialFunction.eval0(SpecialFunction.java:112) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.tree.performancelog.PerformanceLogFunction.eval0(PerformanceLogFunction.java:133) at com.appiancorp.core.expr.tree.TreeEvaluable.evalWrapped(TreeEvaluable.java:111) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.SpecialFunction.eval0(SpecialFunction.java:112) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.rule.Rule.evalBody(Rule.java:1531) at com.appiancorp.core.expr.rule.Rule.doEval(Rule.java:924) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:811) at com.appiancorp.core.expr.rule.Rule.evalAndCache(Rule.java:705) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:697) at com.appiancorp.core.expr.rule.Rule.evalWithMetrics(Rule.java:678) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:664) at com.appiancorp.core.expr.tree.FreeformRule.evalWrapped(FreeformRule.java:162) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.FreeformRule.eval0(FreeformRule.java:133) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.tree.If.evalInner(If.java:178) at com.appiancorp.core.expr.tree.If.eval0(If.java:108) at com.appiancorp.core.expr.tree.TreeEvaluable.evalWrapped(TreeEvaluable.java:111) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.SpecialFunction.eval0(SpecialFunction.java:112) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.rule.Rule.evalTreeOrValue(Rule.java:1256) at com.appiancorp.core.expr.rule.Rule.cast(Rule.java:1198) at com.appiancorp.core.expr.rule.Rule.prepareBindingsKeywords(Rule.java:1065) at com.appiancorp.core.expr.rule.Rule.prepareBindingsKeywords(Rule.java:978) at com.appiancorp.core.expr.rule.Rule.doEval(Rule.java:905) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:811) at com.appiancorp.core.expr.rule.Rule.evalAndCache(Rule.java:705) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:697) at com.appiancorp.core.expr.rule.Rule.evalWithMetrics(Rule.java:678) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:664) at com.appiancorp.core.expr.tree.FreeformRule.evalWrapped(FreeformRule.java:162) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.FreeformRule.eval0(FreeformRule.java:133) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.tree.Eval.evalTarget(Eval.java:173) at com.appiancorp.core.expr.tree.Eval.eval(Eval.java:163) at com.appiancorp.core.expr.tree.Eval.eval(Eval.java:146) at com.appiancorp.core.expr.tree.Eval.eval0(Eval.java:121) at com.appiancorp.core.expr.tree.TreeEvaluable.evalWrapped(TreeEvaluable.java:111) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.SpecialFunction.eval0(SpecialFunction.java:112) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.tree.Eval.evalTarget(Eval.java:173) at com.appiancorp.core.expr.tree.Eval.eval(Eval.java:163) at com.appiancorp.core.expr.tree.Eval.eval(Eval.java:146) at com.appiancorp.core.expr.tree.Eval.eval0(Eval.java:121) at com.appiancorp.core.expr.tree.TreeEvaluable.evalWrapped(TreeEvaluable.java:111) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.SpecialFunction.eval0(SpecialFunction.java:112) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.fn.WithEvalState.eval0(WithEvalState.java:106) at com.appiancorp.core.expr.tree.TreeEvaluable.evalWrapped(TreeEvaluable.java:111) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.SpecialFunction.eval0(SpecialFunction.java:112) at com.appiancorp.core.expr.Tree.evalWrapped(Tree.java:312) at com.appiancorp.core.expr.Tree.eval(Tree.java:294) at com.appiancorp.core.expr.tree.WithAssignment.evalLet(WithAssignment.java:32) at com.appiancorp.core.expr.tree.AbstractLetAssignment.eval(AbstractLetAssignment.java:75) at com.appiancorp.core.expr.tree.AbstractLetFunction.executeSerial(AbstractLetFunction.java:370) at com.appiancorp.core.expr.tree.AbstractLetFunction.processBindings(AbstractLetFunction.java:354) at com.appiancorp.core.expr.tree.AbstractLetFunction.eval00(AbstractLetFunction.java:95) at com.appiancorp.core.expr.tree.With.eval0(With.java:103) at com.appiancorp.core.expr.tree.TreeEvaluable.evalWrapped(TreeEvaluable.java:111) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.SpecialFunction.eval0(SpecialFunction.java:112) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.rule.Rule.evalBody(Rule.java:1531) at com.appiancorp.core.expr.rule.Rule.doEval(Rule.java:924) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:811) at com.appiancorp.core.expr.rule.Rule.evalAndCache(Rule.java:705) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:697) at com.appiancorp.core.expr.rule.Rule.evalWithMetrics(Rule.java:678) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:664) at com.appiancorp.core.expr.tree.FreeformRule.evalWrapped(FreeformRule.java:162) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.FreeformRule.eval0(FreeformRule.java:133) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.rule.Rule.evalTreeOrValue(Rule.java:1256) at com.appiancorp.core.expr.rule.Rule.cast(Rule.java:1198) at com.appiancorp.core.expr.rule.Rule.prepareBindingsPositionalInternalSerial(Rule.java:1179) at com.appiancorp.core.expr.rule.Rule.prepareBindingsPositional(Rule.java:1109) at com.appiancorp.core.expr.rule.Rule.doEval(Rule.java:857) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:811) at com.appiancorp.core.expr.rule.Rule.evalAndCache(Rule.java:705) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:697) at com.appiancorp.core.expr.rule.Rule.evalWithMetrics(Rule.java:678) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:664) at com.appiancorp.core.expr.tree.FreeformRule.evalWrapped(FreeformRule.java:162) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.FreeformRule.eval0(FreeformRule.java:133) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.rule.Rule.evalTreeOrValue(Rule.java:1256) at com.appiancorp.core.expr.rule.Rule.cast(Rule.java:1198) at com.appiancorp.core.expr.rule.Rule.prepareBindingsKeywords(Rule.java:1065) at com.appiancorp.core.expr.rule.Rule.prepareBindingsKeywords(Rule.java:978) at com.appiancorp.core.expr.rule.Rule.doEval(Rule.java:905) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:811) at com.appiancorp.core.expr.rule.Rule.evalAndCache(Rule.java:705) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:697) at com.appiancorp.core.expr.rule.Rule.evalWithMetrics(Rule.java:678) at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:664) at com.appiancorp.core.expr.tree.FreeformRule.evalWrapped(FreeformRule.java:162) at com.appiancorp.core.expr.Tree.eval(Tree.java:448) at com.appiancorp.core.expr.tree.FreeformRule.eval0(FreeformRule.java:133) at com.appiancorp.core.expr.Tree.eval(Tree.java:341) at com.appiancorp.core.expr.Parse.evalInner(Parse.java:433) at com.appiancorp.core.expr.Parse.eval(Parse.java:383) at com.appiancorp.sail.UserInterfaceGenerator.lambda$doEvaluation$1(UserInterfaceGenerator.java:590) at com.appiancorp.sail.server.ServerFeatureContextTracker.trackMethod(ServerFeatureContextTracker.java:27) at com.appiancorp.sail.UserInterfaceGenerator.doEvaluation(UserInterfaceGenerator.java:587) at com.appiancorp.sail.UserInterfaceGenerator.evaluateUiExpression(UserInterfaceGenerator.java:343) at com.appiancorp.sail.UserInterfaceGenerator.generateUserInterface(UserInterfaceGenerator.java:269) at com.appiancorp.sail.UserInterfaceGenerator.generateUserInterface(UserInterfaceGenerator.java:159) at com.appiancorp.sail.ValueUiEvaluator.doFirstEvaluation(ValueUiEvaluator.java:409) at com.appiancorp.sail.ValueUiEvaluator.eval(ValueUiEvaluator.java:160) at com.appiancorp.sail.ValueUiEvaluator.eval(ValueUiEvaluator.java:131) at com.appiancorp.sail.TvUiEvaluator.eval(TvUiEvaluator.java:34) at com.appiancorp.sail.TvUiEvaluator.eval(TvUiEvaluator.java:21) at com.appiancorp.sail.UiEvaluator.eval(UiEvaluator.java:98) at com.appiancorp.sail.UiEvaluator.evalInner(UiEvaluator.java:41)
Discussion posts and replies are publicly visible
You cannot load 40k rows into memory. Please share what you try to achieve and we can support you.
It's record mapped to view and per page it will show 20 rows. In this case it should not throw an error like above. It looks like a wired to me because another record we mapped to different view and shown 80k records in record. This view is taking 28 sec to execute in DB but still the data is loaded into record.
My requirement is below:
I have a DB view with 40k records and mapping to appian record to show the data in landing page
Hi Could try initially optimizing your db view? adding indexes to your columns and later could you try once?