Hi all,
I'm using Case Management in a application that is already in production and a lot of times we have the Error Executing Query bug, and I looked in the logs and everything points to the Case_GetActivities API, I don't have this bug in DEV or QAS environment only in production. Below I share the options that I'm using in Case_GetActivities and the error log:
Does anyone knows who to solve this problem?
Hi Vanilson Lourenço,
Do you have some conditions to apply in the Case_GetActivities?
I believe that the error could be related to the volume of data on prod, you could try to delete some old data related to processes and activities that could be removed.
For that use the following forge component
https://www.outsystems.com/forge/component-overview/1313/bpt-utils-o11
If didn't solve open a support case on outsystems
Hope that it helps you
Hi @Vanilson Lourenço,
seems like the issue is with production data. Sometimes if data has special characters or text which is like linux command can causes the issue.
Best way to reproduce and resolve this issue is - you have to dump production data in you dev or staging environment and then try to reproduct and debug it.
Thanks,
Madhuri