An error occurred with the following error message: "Validation phase is beginning. "
the package ID is 80150.
I referred to https://skyvia.com/resources/docs/index.html?synchronization_overview.htm
I got the following result, and the data hasn't been fully synchronized.
Besides, the foregin key column 'Account__c' (I have removed the foregin key constraint before synchronized for sure) remains the salesforce key value, which won't help with retrieving the relationship back between Lead table and Account table. Any idea?
"Lost connection to MySQL server during query"
We recommend you to perform these steps:
1. Increase the "Command Timeout" value for your MySQL connection. For this switch to the Connections page and click your MySQL connection.
Then click Edit. In the connection editor click Advanced, and then set a bigger value for the "Command Timeout" property.
2. Increase the values of the following parameters at your MySQL Server:
For more information, please refer to http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html
As for foreign keys, you are using simple Column mapping for Account__c column in the Leads task. This means that values from Salesforce Account__c field will be sent to the target database Account__c column. If you wish to store IDs of corresponding Account records created in the database, we recommend you to look at the Relation mapping.