While connecting to an external MySQL database - am getting this error. How do i fix it?
So far have done below:
- Service Center> Database Connections> New Database Connections> populated fields> Test> Connection String was Successful> Apply Factory setting everywhere
- Integration Studio> Created New Extension> Selected MySQL> gave a name> Entities> Connect to external Table> Could see previous made connection> Next> Error Retrieving Databases: The given key was not present in the dictionary
Since i already have another connection which is working fine - not sure what OutSystems is asking for with the above mentioned error.
Would also mention - dumb when it comes to SQL and Servers.
Please Help!
thanks Kilian - did the same but to no avail. the response was this -
"we don't support My SQL 8.0, just MySQL 5.6 (5.6.5 or later within the 5.6 version, all editions) and MySQL 5.7 (5.7.22 or later within the 5.7 version, all editions) as per our documentation."
however i moved with another external database to get my things moving.
Appreciate your guidance.
Just to add: after i have "Save" - and when i click on the Save and "Apply Settings to the Factory" - OS does NOT do that, it just show me a message saying "Changes saved. Apply those changes to the Factory by clicking the "Save and Apply Settings to the Factory button. Read about applying configuration settings. Read about "applying configuration settings." - hence there is some issue while i apply Factory Settings.
Also to add -
this is the error message in the monitoring logs while Integration (studio) - getting external Table or View under Entity.
Hi Vishill,
Best thing you can do is open a support case with OutSystems Support, so they can help troubleshoot.
I have the same problem.
How can I solve it please!