Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
7 replies
Subscribers
7 subscribers
Views
2457 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
I know that query rules limit to the amount of memory that can be returned by a
jamesm90
over 8 years ago
I know that query rules limit to the amount of memory that can be returned by a single query rule, but is there anylimit to the amount of memory that can be returned by a query entity? I want to say no, however, I've ran into a situation where a query entity will run into an error when trying to return all data from a table. The query entity 's error is simply "An error occurred while retrieving the data.", while trying to receive all the data from the table using a query rule it's a memory thereshold error. This makes me wonder if query entity has any limit on memory. Can someone shed some light on this?
OriginalPostID-166685
OriginalPostID-166685
Discussion posts and replies are publicly visible
Parents
0
jamesm90
over 8 years ago
@AkshayaN I am able to view logs. Relevant stacktrace (as much as will fit):
at function a!queryEntity [line 11]: An error occurred while retrieving the data. (APNX-1-4198-000)
\tat com.appiancorp.process.expression.ExpressionRuntimeException.
(ExpressionRuntimeException.java:70)
\tat com.appiancorp.core.expr.exceptions.AppianScriptException.
(AppianScriptException.java:25)
\tat com.appiancorp.core.expr.exceptions.ParseException.
(ParseException.java:20)
\tat com.appiancorp.core.expr.exceptions.FunctionException.
(FunctionException.java:13)
\tat com.appiancorp.core.expr.tree.FunctionCall.evalEvaluable(FunctionCall.java:329)
\tat com.appiancorp.core.expr.tree.FunctionCall.eval(FunctionCall.java:392)
\tat com.appiancorp.core.expr.Tree.eval0(Tree.java:214)
\tat com.appiancorp.core.expr.Tree.eval(Tree.java:210)
\tat com.appiancorp.core.expr.rule.Rule.evalBody(Rule.java:831)
\tat com.appiancorp.core.expr.rule.Rule.eval(Rule.java:411)
\tat com.appiancorp.core.expr.rule.Rule.eval(Rule.java:320)
\tat com.appiancorp.core.expr.rule.Rule.evalWithMetrics(Rule.java:308)
\tat com.appiancorp.core.expr.rule.Rule.eval(Rule.java:297)
\tat com.appiancorp.core.expr.tree.FreeformRule.eval(FreeformRule.java:72)
\tat com.appiancorp.core.expr.tree.FreeformRule.eval0(FreeformRule.java:49)
\tat com.appiancorp.core.expr.Tree.eval(Tree.java:210)
\tat com.appiancorp.core.expr.tree.Select.eval(Select.java:155)
\tat com.appiancorp.core.expr.tree.Select.eval(Select.java:136)
\tat com.appiancorp.core.expr.Tree.eval0(Tree.java:214)
\tat com.appiancorp.core.expr.Tree.eval(Tree.java:210)
\tat com.appiancorp.core.expr.tree.If.evalInner(If.java:134)
\tat com.appiancorp.core.expr.tree.If.eval0(If.java:59)
\tat com.appiancorp.core.expr.tree.TreeEvaluable.eval(TreeEvaluable.java:63)
\tat com.appiancorp.core.expr.tree.SpecialFunction.eval0(SpecialFunction.java:65)
\tat com.appiancorp.core.expr.Tree.eval(Tree.java:210)
\tat com.appiancorp.core.expr.rule.Rule.evalBody(Rule.java:831)
\tat com.appiancorp.core.expr.rule.Rule.eval(Rule.java:411)
\tat com.appiancorp.core.expr.rule.Rule.eval(Rule.java:320)
\tat com.appiancorp.core.expr.rule.Rule.evalWithMetrics(Rule.java:308)
\tat com.appiancorp.core.expr.rule.Rule.eval(Rule.java:297)
\tat com.appiancorp.core.expr.tree.FreeformRule.eval(FreeformRule.java:72)
\tat com.appiancorp.core.expr.tree.FreeformRule.eval0(FreeformRule.java:49)
\tat com.appiancorp.core.expr.Tree.eval(Tree.java:210)
\tat com.appiancorp.core.expr.Parse.evalInner(Parse.java:293)
\tat com.appiancorp.core.expr.Parse.eval(Parse.java:251)
\tat com.appiancorp.core.expr.Parse.eval(Parse.java:236)
\tat com.appiancorp.core.expr.AppianScriptEngine.eval(AppianScriptEngine.java:66)
\tat com.appiancorp.process.engine.ExpressionGroup.eval(ExpressionGroup.java:247)
\tat com.appiancorp.process.engine.ExpressionGroup.eval(ExpressionGroup.java:296)
\tat com.appiancorp.process.engine.ExpressionGroupRequest.execute0(ExpressionGroupRequest.java:67)
\tat com.appiancorp.process.engine.ContinuationRequest.execute(ContinuationRequest.java:80)
\tat com.appiancorp.mdb.UnattendedRequestHandlerBean.onMessage(UnattendedRequestHandlerBean.java:26)
\tat sun.reflect.GeneratedMethodAccessor604.invoke(Unknown Source)
\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
\tat java.lang.reflect.Method.invoke(Method.java:497)
\tat org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52)
\tat org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
\tat org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
\tat org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
\tat org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
\tat org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
\tat org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
jamesm90
over 8 years ago
@AkshayaN I am able to view logs. Relevant stacktrace (as much as will fit):
at function a!queryEntity [line 11]: An error occurred while retrieving the data. (APNX-1-4198-000)
\tat com.appiancorp.process.expression.ExpressionRuntimeException.
(ExpressionRuntimeException.java:70)
\tat com.appiancorp.core.expr.exceptions.AppianScriptException.
(AppianScriptException.java:25)
\tat com.appiancorp.core.expr.exceptions.ParseException.
(ParseException.java:20)
\tat com.appiancorp.core.expr.exceptions.FunctionException.
(FunctionException.java:13)
\tat com.appiancorp.core.expr.tree.FunctionCall.evalEvaluable(FunctionCall.java:329)
\tat com.appiancorp.core.expr.tree.FunctionCall.eval(FunctionCall.java:392)
\tat com.appiancorp.core.expr.Tree.eval0(Tree.java:214)
\tat com.appiancorp.core.expr.Tree.eval(Tree.java:210)
\tat com.appiancorp.core.expr.rule.Rule.evalBody(Rule.java:831)
\tat com.appiancorp.core.expr.rule.Rule.eval(Rule.java:411)
\tat com.appiancorp.core.expr.rule.Rule.eval(Rule.java:320)
\tat com.appiancorp.core.expr.rule.Rule.evalWithMetrics(Rule.java:308)
\tat com.appiancorp.core.expr.rule.Rule.eval(Rule.java:297)
\tat com.appiancorp.core.expr.tree.FreeformRule.eval(FreeformRule.java:72)
\tat com.appiancorp.core.expr.tree.FreeformRule.eval0(FreeformRule.java:49)
\tat com.appiancorp.core.expr.Tree.eval(Tree.java:210)
\tat com.appiancorp.core.expr.tree.Select.eval(Select.java:155)
\tat com.appiancorp.core.expr.tree.Select.eval(Select.java:136)
\tat com.appiancorp.core.expr.Tree.eval0(Tree.java:214)
\tat com.appiancorp.core.expr.Tree.eval(Tree.java:210)
\tat com.appiancorp.core.expr.tree.If.evalInner(If.java:134)
\tat com.appiancorp.core.expr.tree.If.eval0(If.java:59)
\tat com.appiancorp.core.expr.tree.TreeEvaluable.eval(TreeEvaluable.java:63)
\tat com.appiancorp.core.expr.tree.SpecialFunction.eval0(SpecialFunction.java:65)
\tat com.appiancorp.core.expr.Tree.eval(Tree.java:210)
\tat com.appiancorp.core.expr.rule.Rule.evalBody(Rule.java:831)
\tat com.appiancorp.core.expr.rule.Rule.eval(Rule.java:411)
\tat com.appiancorp.core.expr.rule.Rule.eval(Rule.java:320)
\tat com.appiancorp.core.expr.rule.Rule.evalWithMetrics(Rule.java:308)
\tat com.appiancorp.core.expr.rule.Rule.eval(Rule.java:297)
\tat com.appiancorp.core.expr.tree.FreeformRule.eval(FreeformRule.java:72)
\tat com.appiancorp.core.expr.tree.FreeformRule.eval0(FreeformRule.java:49)
\tat com.appiancorp.core.expr.Tree.eval(Tree.java:210)
\tat com.appiancorp.core.expr.Parse.evalInner(Parse.java:293)
\tat com.appiancorp.core.expr.Parse.eval(Parse.java:251)
\tat com.appiancorp.core.expr.Parse.eval(Parse.java:236)
\tat com.appiancorp.core.expr.AppianScriptEngine.eval(AppianScriptEngine.java:66)
\tat com.appiancorp.process.engine.ExpressionGroup.eval(ExpressionGroup.java:247)
\tat com.appiancorp.process.engine.ExpressionGroup.eval(ExpressionGroup.java:296)
\tat com.appiancorp.process.engine.ExpressionGroupRequest.execute0(ExpressionGroupRequest.java:67)
\tat com.appiancorp.process.engine.ContinuationRequest.execute(ContinuationRequest.java:80)
\tat com.appiancorp.mdb.UnattendedRequestHandlerBean.onMessage(UnattendedRequestHandlerBean.java:26)
\tat sun.reflect.GeneratedMethodAccessor604.invoke(Unknown Source)
\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
\tat java.lang.reflect.Method.invoke(Method.java:497)
\tat org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52)
\tat org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
\tat org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
\tat org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
\tat org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
\tat org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
\tat org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data