Project Configurator Error During Import

[Middleware User]

() Hi,

We are interested in using Project Configurator in our environment. We tried to do an export/import between two test systems and are running into an issue during the import. I've attached a screenshot of the error we are receiving. After we receive this error, we are not able to restore our system back to xml file backup before trying the import, we have to restore the database. Any suggestions of what may be happening?

Much Thanks. (project-config-dump).txt)

[Middleware User]

The issue here was that we were using the MySQL MYiSAM engine. After moving to the InnoDB engine this is now workign successfully.

[José Marañón [Awnaba Software S.L.]]

Noreen, Apparently something changed in Atlassian Answers this summer and disconnected users from the tags they were following (at least in this case). Sorry, that made me miss this question. Nevertheless. I am glad you found the solution by yourself. Take into account that Project Configurator requires transactions to be enabled in your database, in order to guarantee that the configuration load will be rolled back if there is any error (so you are not left with a half-applied configuration). MySQL MyISAM engine does not support transactions, so it is not a good choice for Project Configurator. We will improve documentation in this aspect.

[Middleware User]

The issue here was that we were using the MySQL MYiSAM engine. After moving to the InnoDB engine this is now workign successfully.