I have a query entity rule which works in DEV and QA with no issues. However i

Certified Senior Developer
I have a query entity rule which works in DEV and QA with no issues. However it fails with "Expression evaluation error at function a!queryEntity [line 2]: An error occurred while retrieving the data." in Production, but ONLY when the batch size is set to anything other than -1. The query is against a secondary datasource which tends to have latency issues at times. Note, there is much higher volume in Production that DEV and QA.

OriginalPostID-191331

OriginalPostID-191331

  Discussion posts and replies are publicly visible

Parents
  • Hi rogerp63, Could you please verify if any of the data in production table for any of the columns is exceeding the max size of the length. We have once seen similar issue, where our Dev environments were not having the data as present in production. so when we tried to run the same in QA it errored out as the value its trying to cast is huge. Kindly check if any of the columns data exceeds the allowed values.. I recommend as "sikhivahans", mentioned looking into the application-server.log to see exception message, the caused by would give you exact reason why its failing.
Reply
  • Hi rogerp63, Could you please verify if any of the data in production table for any of the columns is exceeding the max size of the length. We have once seen similar issue, where our Dev environments were not having the data as present in production. so when we tried to run the same in QA it errored out as the value its trying to cast is huge. Kindly check if any of the columns data exceeds the allowed values.. I recommend as "sikhivahans", mentioned looking into the application-server.log to see exception message, the caused by would give you exact reason why its failing.
Children
No Data