[nikitausefi]

hi,
I'm using community version .when I was testing my workflow I noticed that I get the following error when the number of cases gets more than 300.

2.PNG (9.29 KiB) Viewed 11153 times

and no case count is loaded either.

3.PNG (6.91 KiB) Viewed 11153 times

this is my system information:

1.PNG (60.78 KiB) Viewed 11153 times

is there a way to fix this problem?
regards.

[programerboy]

Hi,
For solve this problem check the following link:
http://pmlearning.info/article.php?t=fix-participated-error-in-processmaker
Thanks

[nikitausefi]

thank you for the answer. However we didn't get the "errorCode 200" error as the link suggested, but we tried the solution any way and still get the error.

we managed to read some of the code and we examined our query log.at last we found a very time consuming query ( I just copied a fraction as it was very long )

4.png (35.07 KiB) Viewed 9371 times

we are not sure this is the cause of the problem or not.

[Ironguts25]

Have you tried clearing or rebuilding the Case Cache List?

https://wiki.processmaker.com/3.2/Clearing_the_Case_List_Cache

[nikitausefi]

yes but still no luck.

2.PNG (9.29 KiB) Viewed 9342 times

we deleted all the cases to check what causes this. we saw the error went away but as soon as the number of cases hits 316, it crashes again

[programerboy]

Hi,
I attached a sample config file, Please check this link again:
http://pmlearning.info/article.php?t=fix-participated-error-in-processmaker
Thanks

[nikitausefi]

Hi,
we tried the config file but still the same problem

[Ironguts25]

Maybe try increasing your thread stack size? Seems like a potential memory issue.

https://wiki.processmaker.com/3.2/Additional_Configuration#Increasing_the_Thread_Stack_Size

[programerboy]

Hi,
I made a video to help you solve this problem, you can watch it and solve your problem accordingly.

Please check the following video:
http://pmlearning.info/video.php?t=fix_error_participated_processmaker
Thanks