• State Not Answered
  • Replies 8 replies
  • Subscribers 7 subscribers
  • Views 2819 views
  • Users 0 members are here
Related Discussions
Home » Discussions » AI and Rules

Getting the following error while trying to execute a Query Rule, Exp

sureshb
Getting the following error while trying to execute a Query Rule,

Expression evaluation error in rule 'ct_getcustomercommunicationdetails' at function 'queryruleexec': Error evaluating function 'queryruleexec' : Unexpected error executing query (type: [CTCustomerCommunicationDetailsDT1367], query: [CT_getCustomerCommunicationdetails], order by: [[]], filters:[((active = TypedValue[it=1,v=1]) AND (customerEmail.email = TypedValue[it=3,v=random@google.com]) AND (customerPhone.phoneNumber = TypedValue[it=3,v=34567890]) AND (customerAddress.partyAddress.streetName = TypedValue[it=3,v=Collingwood]) AND (customerAddress.partyAddress.suburb = TypedValue[it=3,v=Birkdale]))])

Server log,
Caused by: com.appiancorp.suiteapi.common.exceptions.AppianRuntimeException: com.appiancorp.suiteapi.common.exceptions.AppianException

Please provide your suggestions...

OriginalPostID-127769

OriginalPostID-127769

  Discussion posts and replies are publicly visible

Parents
  • 0
    Hi, Please find below,

    ERROR com.appiancorp.suiteapi.content.ContentAccess - An error occurred while trying to test the rule: [Content:id=null,name=asdasd,type=32,subtype=1,visibility=35,security=143,attributes={dep_functions=[Ljava.lang.String;@535426f6, dep_rules=[Ljava.lang.Long;@39ca0b37, definition==#"bcdd6a6e-ac66-4fc9-af76-76ac99112480"(1,"random@google.com","34567890","Collingwood","Birkdale","","",""), dep_types=[Ljava.lang.String;@7fa66584, dep_variables=[[Ljava.lang.String;@552fe95}]
    13:22:01,063 INFO [stdout] (ajp-/0.0.0.0:8009-6) com.appiancorp.process.expression.ExpressionRuntimeException$AppianExceptionProvider: Expression evaluation error in rule 'ct_getcustomercommunicationdetails' at function 'queryruleexec': Error evaluating function 'queryruleexec' : Unexpected error executing query (type: [CTCustomerCommunicationDetailsDT1367], query: [CT_getCustomerCommunicationdetails], order by: [[]], filters:[((active = TypedValue[it=1,v=1]) AND (customerEmail.email = TypedValue[it=3,v=random@google.com]) AND (customerPhone.phoneNumber = TypedValue[it=3,v=34567890]) AND (customerAddress.partyAddress.streetName = TypedValue[it=3,v=Collingwood]) AND (customerAddress.partyAddress.suburb = TypedValue[it=3,v=Birkdale]) AND (customerAddress.partyAddress.addressLine1 = TypedValue[it=3,v=]) AND (customerAddress.partyAddress.addressLine2 = TypedValue[it=3,v=]) AND (customerAddress.partyAddress.addressLine3 = TypedValue[it=3,v=]))]) (APNX-1-4198-000)
    13:22:01,063 INFO [stdout] (ajp-/0.0.0.0:8009-6)           at com.appiancorp.process.expression.ExpressionRuntimeException.<init>(ExpressionRuntimeException.java:65)
    13:22:01,063 INFO [stdout] (ajp-/0.0.0.0:8009-6)           at com.appiancorp.core.expr.exceptions.AppianScriptException.<init>(AppianScriptException.java:24)
    13:22:01,063 INFO [stdout] (ajp-/0.0.0.0:8009-6)           at com.appiancorp.core.expr.exceptions.ParseException.<init>(ParseException.java:20)
    13:22:01,063 INFO [stdout] (ajp-/0.0.0.0:8009-6)           at com.appiancorp.core.expr.exceptions.FunctionException.<init>(FunctionException.java:13)
    13:22:01,063 INFO [stdout] (ajp-/0.0.0.0:8009-6)           at com.appiancorp.core.expr.AppianScriptContextTop.evalExternalFunction(AppianScriptContextTop.java:437)
    13:22:01,063 INFO [stdout] (ajp-/0.0.0.0:8009-6)           at com.appiancorp.core.expr.AppianScriptContextChild.evalExternalFunction(AppianScriptContextChild.java:211)
    13:22:01,063 INFO [stdout] (ajp-/0.0.0.0:8009-6)           at com.appiancorp.core.expr.tree.FunctionCall$ExternalEvaluable.eval0(FunctionCall.java:500)
    13:22:01,064 INFO [stdout] (ajp-/0.0.0.0:8009-6)           at com.appiancorp.core.expr.Evaluable.eval(Evaluable.java:165)
    13:22:01,064 INFO [stdout] (ajp-/0.0.0.0:8009-6)           at com.appiancorp.core.expr.tree.FunctionCall.evalEvaluable(FunctionCall.java:286)
    13:22:01,064 INFO [stdout] (ajp-/0.0.0.0:8009-6)           at com.appiancorp.core.expr.tree.FunctionCall.eval0(FunctionCall.java:328)
    13:22:01,064 INFO [stdout] (ajp-/0.0.0.0:8009-6)           at com.appiancorp.core.expr.Tree.eval(Tree.java:183)
    13:22:01,064 INFO [stdout] (ajp-/0.0.0.0:8009-6)           at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:322)
    13:22:01,064 INFO [stdout] (ajp-/0.0.0.0:8009-6)           at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:251)
    13:22:01,064 INFO [stdout] (ajp-/0.0.0.0:8009-6)           at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:239)
    13:22:01,064 INFO [stdout] (ajp-/0.0.0.0:8009-6)           at com.appiancorp.core.expr.tree.FreeformRule.eval(FreeformRule.java:84)
    13:22:01,064 INFO [stdout] (ajp-/0.0.0.0:8009-6)           at com.appiancorp.core.expr.tree.FreeformRule.eval0(FreeformRule.java:43)
    13:22:01,064 INFO [stdout] (ajp-/0.0.0.0:8009-6)           at com.appiancorp.core.expr.Tree.eval(Tree.java:183)
    13:22:01,064 INFO [stdout] (ajp-/0.0.0.0:8009-6)           at com.appiancorp.core.expr.Parse.evalInner(Parse.java:271)
    13:22:01,064 INFO [stdout] (ajp-/0.0.0.0:8009-6)           at com.appiancorp.core.expr.Parse.eval(Parse.java:232)
    13:22:01,064 INFO [stdout] (ajp-/0.0.0.0:8009-6)           at com.appiancorp.core.expr.Parse.eval(Parse.java:217
Reply
  • 0
    Hi, Please find below,

    ERROR com.appiancorp.suiteapi.content.ContentAccess - An error occurred while trying to test the rule: [Content:id=null,name=asdasd,type=32,subtype=1,visibility=35,security=143,attributes={dep_functions=[Ljava.lang.String;@535426f6, dep_rules=[Ljava.lang.Long;@39ca0b37, definition==#"bcdd6a6e-ac66-4fc9-af76-76ac99112480"(1,"random@google.com","34567890","Collingwood","Birkdale","","",""), dep_types=[Ljava.lang.String;@7fa66584, dep_variables=[[Ljava.lang.String;@552fe95}]
    13:22:01,063 INFO [stdout] (ajp-/0.0.0.0:8009-6) com.appiancorp.process.expression.ExpressionRuntimeException$AppianExceptionProvider: Expression evaluation error in rule 'ct_getcustomercommunicationdetails' at function 'queryruleexec': Error evaluating function 'queryruleexec' : Unexpected error executing query (type: [CTCustomerCommunicationDetailsDT1367], query: [CT_getCustomerCommunicationdetails], order by: [[]], filters:[((active = TypedValue[it=1,v=1]) AND (customerEmail.email = TypedValue[it=3,v=random@google.com]) AND (customerPhone.phoneNumber = TypedValue[it=3,v=34567890]) AND (customerAddress.partyAddress.streetName = TypedValue[it=3,v=Collingwood]) AND (customerAddress.partyAddress.suburb = TypedValue[it=3,v=Birkdale]) AND (customerAddress.partyAddress.addressLine1 = TypedValue[it=3,v=]) AND (customerAddress.partyAddress.addressLine2 = TypedValue[it=3,v=]) AND (customerAddress.partyAddress.addressLine3 = TypedValue[it=3,v=]))]) (APNX-1-4198-000)
    13:22:01,063 INFO [stdout] (ajp-/0.0.0.0:8009-6)           at com.appiancorp.process.expression.ExpressionRuntimeException.<init>(ExpressionRuntimeException.java:65)
    13:22:01,063 INFO [stdout] (ajp-/0.0.0.0:8009-6)           at com.appiancorp.core.expr.exceptions.AppianScriptException.<init>(AppianScriptException.java:24)
    13:22:01,063 INFO [stdout] (ajp-/0.0.0.0:8009-6)           at com.appiancorp.core.expr.exceptions.ParseException.<init>(ParseException.java:20)
    13:22:01,063 INFO [stdout] (ajp-/0.0.0.0:8009-6)           at com.appiancorp.core.expr.exceptions.FunctionException.<init>(FunctionException.java:13)
    13:22:01,063 INFO [stdout] (ajp-/0.0.0.0:8009-6)           at com.appiancorp.core.expr.AppianScriptContextTop.evalExternalFunction(AppianScriptContextTop.java:437)
    13:22:01,063 INFO [stdout] (ajp-/0.0.0.0:8009-6)           at com.appiancorp.core.expr.AppianScriptContextChild.evalExternalFunction(AppianScriptContextChild.java:211)
    13:22:01,063 INFO [stdout] (ajp-/0.0.0.0:8009-6)           at com.appiancorp.core.expr.tree.FunctionCall$ExternalEvaluable.eval0(FunctionCall.java:500)
    13:22:01,064 INFO [stdout] (ajp-/0.0.0.0:8009-6)           at com.appiancorp.core.expr.Evaluable.eval(Evaluable.java:165)
    13:22:01,064 INFO [stdout] (ajp-/0.0.0.0:8009-6)           at com.appiancorp.core.expr.tree.FunctionCall.evalEvaluable(FunctionCall.java:286)
    13:22:01,064 INFO [stdout] (ajp-/0.0.0.0:8009-6)           at com.appiancorp.core.expr.tree.FunctionCall.eval0(FunctionCall.java:328)
    13:22:01,064 INFO [stdout] (ajp-/0.0.0.0:8009-6)           at com.appiancorp.core.expr.Tree.eval(Tree.java:183)
    13:22:01,064 INFO [stdout] (ajp-/0.0.0.0:8009-6)           at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:322)
    13:22:01,064 INFO [stdout] (ajp-/0.0.0.0:8009-6)           at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:251)
    13:22:01,064 INFO [stdout] (ajp-/0.0.0.0:8009-6)           at com.appiancorp.core.expr.rule.Rule.eval(Rule.java:239)
    13:22:01,064 INFO [stdout] (ajp-/0.0.0.0:8009-6)           at com.appiancorp.core.expr.tree.FreeformRule.eval(FreeformRule.java:84)
    13:22:01,064 INFO [stdout] (ajp-/0.0.0.0:8009-6)           at com.appiancorp.core.expr.tree.FreeformRule.eval0(FreeformRule.java:43)
    13:22:01,064 INFO [stdout] (ajp-/0.0.0.0:8009-6)           at com.appiancorp.core.expr.Tree.eval(Tree.java:183)
    13:22:01,064 INFO [stdout] (ajp-/0.0.0.0:8009-6)           at com.appiancorp.core.expr.Parse.evalInner(Parse.java:271)
    13:22:01,064 INFO [stdout] (ajp-/0.0.0.0:8009-6)           at com.appiancorp.core.expr.Parse.eval(Parse.java:232)
    13:22:01,064 INFO [stdout] (ajp-/0.0.0.0:8009-6)           at com.appiancorp.core.expr.Parse.eval(Parse.java:217
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.