SQL failure message after "Get All Latest"

[ngong]

I have imported an .eap file to a database created in MariaDB. The packages are version controlled via SCC/PTC. When I do a "Get All Latest" with the model based on MariaDB, I get an SQL failure:



Any advice what to do next in order to update the database from the packages stored in PTC?

[Geert Bellekens]

Check the odbc settings.

MySQL is rather particular about that, and some errors only surface in specific conditions.

If that's not it I guess you better contact support.

Geert

PS. Also run a project integrity check and fix the error to be sure.

[ngong]

Thank you, Geert.

I'll stay away from MariaDB in favor of SQL Server (or ... Express). For the same .eap file it worked without such messages.
Seems that EA is tested mainly for MS interfaces.

[Nizam]

Not sure if that is what Geert intended. Whilst we've used MS Sql in many deployments, One of the recent presentations in the London User Group mentioned MariaDB and MySQL as the most recommended (and optimized) DB choice for EA.

May be worth trying to resolve the DB connection before making a switch to other DB

please check the links below
http://sparxsystems.com/enterprise_architect_user_guide/13.5/model_repository/createanewmariadbrepository.html
http://sparxsystems.com/enterprise_architect_user_guide/13.5/model_repository/setupmariadbodbcdriver.html
http://sparxsystems.com/enterprise_architect_user_guide/13.5/model_repository/upsizingtomariadb.html

Especially these settings

• Return matched rows instead of affected rows ('Connection' or 'Cursors/Results' tab)
  Allow big result sets ('Connection' tab)