I am trying to update mysql db, with info from salesforce.
i for MySQL db, in the log, I get - aborted connection x to DB:dbname';'user'host:atomsprod1.boomi.com' (Got an error reading communication packets).
Can you give us a little more detail? There can be many reasons why you get this error. Assuming that you can connect to the Mysql instance, does this happen after a while? How much data are you sending to Mysql?
Check this page for further information: MySQL :: MySQL 5.7 Reference Manual :: B.5.2.11 Communication Errors and Aborted Connections. Perhaps this puts you on the right track.
in my process, i can connect to this mysql db and get record formats of the customer table. Then I try to insert couple of rows into it. Testing ends successfully. Then when I deploy the new version of my process and execute it, i see this msg showing up in mysql log. And the process ends successfully in boomi(cloud). But no records get added to my table in db. It happens after every execution of my process. And I dont send a lot of data at all, only couple of rows each time.
Do you say that inserting records in test mode works but not when executing the process from the process management page? Do you use an Atom cloud or a local Atom?
Retrieving data ...