Error message in Suite CRM logs for workflow

SuiteCRM Forum - English Language SuiteCRM General Discussion
1

Keep getting the same message when I run a workflow: Only On Save - Modified Record -
Conditions:

Module Field Operator Type Value
COURSE INFO Course Equal To Value Healthcare Support Assistant (General) – Major Award Level 5

Error message
Fri Oct 22 10:57:24 2021 [127][-none-][FATAL] Could not connect to DB server toc-crm-db.mysql.database.azure.com as toc_suitecrm. port : Too many connections
Fri Oct 22 11:31:42 2021 [199][-none-][FATAL] Could not connect to DB server toc-crm-db.mysql.database.azure.com as toc_suitecrm. port : Too many connections

2

Check if your Workflow is recursive, if it saves data to the record… then it might be executing infinite copies, exhausting the DB connections.

Other more complex recursion scenarios are possible: workflow that triggers hook that triggers workflow, two workflows triggering each other, etc.

3

Hi Pgr

How would I check if the workflow is recursive, there is no multiple records created, the correct number of records is created but some record fields are not populated and the same field is not populated in the other records created, e.g a Major award course has 5 sub courses included in it, I have set up a workflow that when the major award is created and saved the other 5 sub courses are created using field information from the major award, but when the sub courses are created they are all missing one field which contains the Students name.
sorry for the late reply

Thanks Ken

4

The recursion happens if

  • you have a Workflow that triggers on save of a certain record kind (say, Course)
  • in that workflow, the actions create new records of that same kind…
  • … triggering the same workflow, which in turn creates new records
  • … and this goes on indefinitely

This can be prevented with conditions that can understand the difference between the original record being created and other “child” records, so that the Workflow does not trigger for these.

Maybe looking at your logs you can see if there is a long run of activity whenever the Workflow runs.

5

Hi Pgr,

Please see the following error message that occurs when the workflow was run:
Wed Oct 27 10:05:24 2021 [1075][8f2a1190-06f3-fc66-ec03-60c089541384][ERROR] Given parameter should contains index “copy_email_addresses”
Wed Oct 27 10:05:24 2021 [1075][8f2a1190-06f3-fc66-ec03-60c089541384][ERROR] Email address copy error occured, bean was: M2_COURSE_INFO
Wed Oct 27 10:05:24 2021 [1075][8f2a1190-06f3-fc66-ec03-60c089541384][ERROR] fromUser: Conversion of 2021-10-27 10:02:01 from user format d/m/Y H:i failed
Wed Oct 27 10:05:24 2021 [1075][8f2a1190-06f3-fc66-ec03-60c089541384][ERROR] fromUser: Conversion of 2021-10-27 10:05:19 from user format d/m/Y H:i failed
Wed Oct 27 10:05:24 2021 [1075][8f2a1190-06f3-fc66-ec03-60c089541384][ERROR] fromUser: Conversion of 2021-10-27 10:02:01 from user format d/m/Y H:i failed

thanks ken

6

I don’t know… maybe something related to this checkbox in the Workflow actions?

image

Try changing it