Workflows are not being triggered

[dodom2]

I had this issue last month and thought it was my server because I couldn't find a solution so I changed my entire server. Im kinda worried the issue may show its face again. So a good solution is always welcome'd

[rabii]

Glad you sort it out now. i think it would better to let the development know about this so they could investigate their end why such issue happened and if they could provide a fix in future upgrade of advanced pack.
Thanks

[Jakub Grufik]

eymen-elkum hello man,

thank you a lot for the summarization of the issue and solution. I am currently very busy at work trying to clean up all the data affected by the outage of workflows so I was going to make this summary at the end of this week.

I will keep checking this and I will also put together some report with information on what happened and how we resolved it from my point of view at the end of this week.

Last but not least, a huge THANK YOU goes to the whole team and to all of YOU guys who were trying to help me with this issue. It is always a pleasure to cooperate with such experienced and helpful people like you.

If there will be ANYTHING I could help you with do not hesitate to reach me here or by email at grufik.k@gmail.com

Great job guys! Thank you!
Have a nice rest of the day

[eymen-elkum]

Hello everyone,

Yesterday I managed to work on this issue with Jakub Grufik using TeamViewer, it took about one hour, and I would like to share the feedback here.

First of all, this is not the first time I face this problem, and every time I fix it, I go over multiple steps and some steps repeated more than one time till it fixed.

I think this is related to the size of table job in most cases, on the case here we found more than 4 million record and that is too much for some servers, I suggest the following points to manage this:

• Check the size of table named "job", will be safe to remove all records with status != pending and date is older than one week, you can use this sql statement:
  DELETE * FROM `job` WHERE status <> 'Pending' AND date(execute_time) < '2022-11-28';
• I think it is good choice to change the cleanup time cleanup params like cleanupJobPeriod
• I suggest to change the value on clean up job from 1 1 * * 0 TO 1 1 * * *
  

remove the job and re add it again then rebuild, if you have lot of personal or group email account I suggest to increase the server parameters or just make the job that fetching email more slower, every 2 minutes is good maybe.

Sorry for the maybe bad explanation because of writing quickly, hope I have the time later to make an article about this topic that cover some other points about crm management.

[lazovic]

Jakub Grufik,

Incredibly happy to hear! We look forward to a description of the problem and, of course, a description of its solution.

[Jakub Grufik]

hello mate, we already fixed the issue with the CEO, I will prepare the report what happened and how we fixed it. Thanks a lot!

[lazovic]

Jakub Grufik,

1. Do you have any unofficial extensions or code customizations?
2. Have you tried putting a new instance on your server, do workflows work there?

I recommend contacting EspoCRM technical support. Most likely, there will be a need to access your instance and/or server.

[Jakub Grufik]

eymen-elkum hey man, did you forget about our call? I was waiting the whole weekend. Tried to reach you via email.

Our management staff is not happy about not working system and are already considering switching to another CRM because of it.

We really tried to fix it on our own, but so far no luck. We just need to know if it's fixable or not and what options we have.

Thanks for help

[Jakub Grufik]

hello guys, any news please? I was not able to figure it out on my own yet.

Scheduled workflows still not working

[Jakub Grufik]

thanks man, resent

[eymen-elkum]

eymen@eblasoft.com.tr

[Jakub Grufik]

damn, email got back to me because the recipient: eymen@eblasoft.com does not exist according to google..

[Jakub Grufik]

eymen-elkum hello sir, email sent

[Jakub Grufik]

eymen-elkum hello man, thanks a lot for the offer.

I am now trying to reach our guy who implemented espoCRM to explain me how to copy the real project to the test instance, I will try to fix the issue in the test instance then and if I wont be successful then we can schedule the videocall+teamviewer if its OK for you.

Thanks a lot one more time

[eymen-elkum]

Jakub Grufik if nothing succeeds with your current tries let me know, we will need a screen share with your computer for about 30 minutes to debug it, let me know on email eymen@eblasoft.com
We will share the result here for any future similar case