Hi All, I created a query rule and executing it. Some times it is wor

Hi All,

I created a query rule and executing it. Some times it is working fine but some times the same query is not working and giving the below error (please refer the attachment)

Thanks in advance....

OriginalPostID-103665

OriginalPostID-103665

  Discussion posts and replies are publicly visible

Parents
  • Hi Ayusha, Thank you very much for your time.
    As per your suggestions,
    1)
    I tried fetching only relevant data by passing inputs, then it is giving the below error.
    Tried fetching first 3 columns separately, one go and 4 column separately. Even I deleted 4 column and tried these scenarios. Result is same.
    -------Error---------
    "There was an error testing the rule:

    Expression evaluation error in rule 'trialrule' at function 'queryruleexec': Error evaluating function 'queryruleexec' : Unexpected error executing query (type: [TrialTableDT628], query: [trialRule], order by: [[]], filters:[[]])"
    ------------------
    2) Also I am able to insert the data into table using "Write to Data Store Entity" smart service. No error.
Reply
  • Hi Ayusha, Thank you very much for your time.
    As per your suggestions,
    1)
    I tried fetching only relevant data by passing inputs, then it is giving the below error.
    Tried fetching first 3 columns separately, one go and 4 column separately. Even I deleted 4 column and tried these scenarios. Result is same.
    -------Error---------
    "There was an error testing the rule:

    Expression evaluation error in rule 'trialrule' at function 'queryruleexec': Error evaluating function 'queryruleexec' : Unexpected error executing query (type: [TrialTableDT628], query: [trialRule], order by: [[]], filters:[[]])"
    ------------------
    2) Also I am able to insert the data into table using "Write to Data Store Entity" smart service. No error.
Children
No Data