Hi I am calling a query rule through an expression rule in dashboard. I am

Hi
I am calling a query rule through an expression rule in dashboard. I am getting this error below.

Error:
Expression evaluation error in rule 'Queryrule' at function 'queryruleexec': Error evaluating function 'queryruleexec' : Unexpected error executing query

Thank in advance...

OriginalPostID-121084

OriginalPostID-121084

  Discussion posts and replies are publicly visible

Parents
  • Just like Colton mentioned this has to be investigated at the application-server.log level.

    In order to troubleshoot issues where the message is very generic such as: "Unexpected error executing query" you need to reproduce and then find this error in the application-server.log, once you have identified it review each of the individual "Caused by" clauses. Usually the most bottom ones (that belong to that error) will be the most informative ones in the stack trace.

    Query rules do not fail due to session time outs since they are evaluated at the server side.

    We are talking about a possible time out of the query itself in the database engine, or an issue with the column mappings, etc but again, the best way to determine the root cause is looking at the "Caused by" clauses of the error in the application-server.log
Reply
  • Just like Colton mentioned this has to be investigated at the application-server.log level.

    In order to troubleshoot issues where the message is very generic such as: "Unexpected error executing query" you need to reproduce and then find this error in the application-server.log, once you have identified it review each of the individual "Caused by" clauses. Usually the most bottom ones (that belong to that error) will be the most informative ones in the stack trace.

    Query rules do not fail due to session time outs since they are evaluated at the server side.

    We are talking about a possible time out of the query itself in the database engine, or an issue with the column mappings, etc but again, the best way to determine the root cause is looking at the "Caused by" clauses of the error in the application-server.log
Children
No Data