Hi guys, We're having a strange issue with a query rule on one of

A Score Level 1
Hi guys,

We're having a strange issue with a query rule on one of our sites. We're seeing 'Error evaluating function 'queryruleexec' : Unexpected error executing query' in the front-end and this in the logs:

14:33:26,501 INFO [stdout] (ajp-/0.0.0.0:8009-36) 2015-05-27 14:33:26,499 [ajp-/0.0.0.0:8009-36] ERROR com.appiancorp.suiteapi.content.ContentAccess - An error occurred while trying to test the rule: [Content:id=null,name=tyutyu,type=32,subtype=1,visibility=35,security=143,attributes={dep_functions=[Ljava.lang.String;@691f04b6, dep_rules=[Ljava.lang.Long;@736e7ea4, definition=#"84b9b493-3954-4456-8f78-9376bf6ec92d"("Enable Therapy Services", "Moving Minds")
14:33:26,501 INFO [stdout] (ajp-/0.0.0.0:8009-36)
14:33:26,501 INFO [stdout] (ajp-/0.0.0.0:8009-36) , dep_types=[Ljava.lang.String;@5b3c7c30, dep_variables=[[Ljava.lang.String;@5ffd621b}]
14:33:26,501 INFO [stdout] (ajp-/0.0.0.0:8009-36) com.appiancorp.process.expression.E...

OriginalPostID-150460

OriginalPostID-150460

  Discussion posts and replies are publicly visible

Parents
  • ...xpressionRuntimeException$AppianExceptionProvider: Expression evaluation error in rule 'mm_clientgroupbynameprovider' at function 'queryruleexec': Error evaluating function 'queryruleexec' : Unexpected error executing query (type: [MMClientGroupDT393], query: [MM_ClientGroupByNameProvider], order by: [[]], filters:[((Provider.Name = TypedValue[it=3,v=Moving Minds]) AND (Name = TypedValue[it=3,v=Enable Therapy Services]))]) (APNX-1-4198-000)

    This suggested a problem with the Provider nested CDT. I changed this in the database to use a different ProviderID and the rule worked fine. I changed it back to the old ProviderID and it breaks again. We've tested the rule with other ClientNames for that ProviderID and it works without problems. Any ideas?

    The caused by items are below:

    14:33:26,520 INFO [stdout] (ajp-/0.0.0.0:8009-36) Caused by: com.appiancorp.suiteapi.common.exceptions.AppianRuntimeException: com.appiancorp.suiteapi.common.exceptions.AppianException: Unex...
Reply
  • ...xpressionRuntimeException$AppianExceptionProvider: Expression evaluation error in rule 'mm_clientgroupbynameprovider' at function 'queryruleexec': Error evaluating function 'queryruleexec' : Unexpected error executing query (type: [MMClientGroupDT393], query: [MM_ClientGroupByNameProvider], order by: [[]], filters:[((Provider.Name = TypedValue[it=3,v=Moving Minds]) AND (Name = TypedValue[it=3,v=Enable Therapy Services]))]) (APNX-1-4198-000)

    This suggested a problem with the Provider nested CDT. I changed this in the database to use a different ProviderID and the rule worked fine. I changed it back to the old ProviderID and it breaks again. We've tested the rule with other ClientNames for that ProviderID and it works without problems. Any ideas?

    The caused by items are below:

    14:33:26,520 INFO [stdout] (ajp-/0.0.0.0:8009-36) Caused by: com.appiancorp.suiteapi.common.exceptions.AppianRuntimeException: com.appiancorp.suiteapi.common.exceptions.AppianException: Unex...
Children
No Data