Error loading MySQL data with Refresh All

[braybrookj]

Hey,

I changed the connector for my MySQL data from an ODBC to a MySQL connector yesterday. Everything seemed to be ok.

Today, I've pressed Refresh to refresh all of the data sources and have the below error:

Unnexpecred Error: Container exited unexpectedly with code 0x80004005. Used Features: odbc.datasource/myodbc5a.dll/05.03.0006/MySQL/5.6.10-log,ADOMD.NET/11.0.6020.0

However, if I right click on and update each of the tables seperately, all of them successfully refresh.

Any ideas why the refresh all doesn't work?

Thanks in advance

[Eric_Zhang]

@braybrookj

Connecting and refreshing a MySQL data source work fine in my test. Can you try to clean up the data source setting("file"->"options and settings"->"data source settings") and recreate?

Also please check you've installed the correct driver.

[braybrookj]

I have double checked teh driver and have recreated the tables.

Still no joy with the refresh all.

EDIT - The error now appears underneath a data source I am pulling in from Analysis Services.

[braybrookj]

Sorry for the delay.

As mentioned in the OP, the connector works. If I right click on the MySQL tables and refresh individually, there is no issue.

It is only I use Refresh All that the issue occurs.

[Greg_Deckler]

Hmm, no that's an interesting one. You could post it in the Issues area.

[braybrookj]

Thanks, I'll give that a try!