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 mayurm896 over 8 years ago

It seems as if there is no data in the table such that query condition may fall true. If that is so, then you have to handle null values. Would you please confirm and let us know what is there in table.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 mayurm896 over 8 years ago

It seems as if there is no data in the table such that query condition may fall true. If that is so, then you have to handle null values. Would you please confirm and let us know what is there in table.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data