Query Rule execution Error

baghavathit

Certified Senior Developer

over 8 years ago

When I tried to execute the query rule in the expression rule, I got the following error "Expression evaluation error in rule 'mhai_getuploaddatabypid' at function 'queryruleexec': Error evaluating function 'queryruleexec' : Unexpected error executing query (type: [MHAITissueSampleDT15062], query: [MHAI_getUploadDataByPid], order by: [[]], filters:[(pid = TypedValue[it=1,v=1])])" . Does anyone know why this unexpected error occurs. But the same rule works in different environment.

Discussion posts and replies are publicly visible

Parents

0 girikumard over 8 years ago

Is should not be issue with rule. Pls. check whether are they any date or timestamp fields with improper data in your table in which this query is trying to fetch. Clear all improper date/timestamp fields & then execute.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 girikumard over 8 years ago

Is should not be issue with rule. Pls. check whether are they any date or timestamp fields with improper data in your table in which this query is trying to fetch. Clear all improper date/timestamp fields & then execute.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data