Field name not getting fetched using MySql Connector in Query Block Properties.
Installed On-Premise Agent. Able to connect to MySql Database verified by clicking Test button
With the MySQL connection not working while it's on another machine but it will on your own, that tells me that there may be an issue with firewalls and connections setup between the Agent and the location of the MySQL server.
Specifically from this page, the following ports may need to be open if you want to proceed with using the MySQL server that is remote:
- Port 443. This port is required for outbound Agent communication with the Scribe Online website. Scribe Online can respond to Agent communication using port 443. If this port is not open, the Scribe Online Agent is not fully accessible from the Scribe Online website.
- Port 80. This port is required for outbound communication for SSL Certificate validation.
- Ports 5671 and 5672, and 9350 through 9354. These are outbound ports used by the Agent to communicate with the Enterprise Service Bus (ESB). The ESB can respond to Agent communication using the same port. If your network policies prohibit you from opening these outbound ports, contact Scribe Support for assistance with an alternate configuration.
As for "The given key was not present in the dictionary", that normally tells me that there is a field that is NULL that is required or the metadata on the connection is not up to date and causing a record required to not be found properly. It's hard to really tell since the error is generic. Since you're using an On-Premise Agent, please check the logs for any additional errors that may be the actual cause of all this. Default location of logs with On-Premise Agents can be found at the following directory in your computer:
C:\Program Files (x86)\Scribe Software\Scribe Online Agent\logs\rolling.log
All The Best,
The MySql was installed on another server not on my local machine where On-Premise Agent has been installed. I installed MySql locally and the problem is solved.
As you suggested to use Replication, I tried it using selected entities and got "The given key was not present in the dictionary. " error msg. am I doing something wrong? Please help.
The map looks fine but I'm not sure what would be causing the fields to not populate correctly. If possible, can you invite me to your Organization at email@example.com so I can take a look directly at the map to see what may be the cause?
Also, in the meantime, if you are just looking to move data from Salesforce to MySQL, you could also try using our Replication Solutions. More information on Replication Solutions can be found here: http://bit.ly/2GwJySo
All The Best,
Thanks for quick response!
I have simple POC to do, Read data from SF and dump into MySql Table. Created Database/table in my local environment and able connect using On-Premise Agent.
Table have fields name and last_name which I want to map to Lead Fields. While mapping SF fields are getting displayed but the MySql Fields are not. Showing "No mappable fields exist on the chosen entity." after showing "Loading Fields" for long time. Please find attached screenshot.