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

caz

A Score Level 1

over 9 years ago

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...

Discussion posts and replies are publicly visible

Parents

0 caz
A Score Level 1
over 9 years ago

...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...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 caz
A Score Level 1
over 9 years ago

...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...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data