ec-jrc / re3gistry

Re3gistry is a reusable open source solution for managing and sharing ‘reference codes’, ensuring semantic interoperability across organisations.
European Union Public License 1.2
27 stars 21 forks source link

Error installing software by choosing the migration option #427

Open antamasal opened 1 month ago

antamasal commented 1 month ago

When I install the software by choosing the migration option, when I configure the database and click start, the process returns me to the first step of the wizard. In the log, I only see that it has successfully logged into the database. The version I am migrating is: Re3gistry 1.3.1 How could I finish the installation using the migration option? Thank you

iratigarzon commented 1 month ago

Dear @antamasal,

Do you want to migrate from version 1.3.1 to the current version (2.5.3)?

Best regards, Irati.

antamasal commented 1 month ago

Yes, exactly Thanks!

iratigarzon commented 1 month ago

Dear @antamasal,

Could you please send us a dump of your database? This will allow us to attempt to recreate the error in our local instance and provide you with more detailed information.

Best regards, Irati

antamasal commented 1 month ago

I have done it again from the beginning. When the wizard starts, I put the migration option and username and password. When I write the data, in the log I can see that it says that you have been able to log in and when I click install, it redirects me to the first step. I attach the backup.

backup_re3gistry6.zip

_[EL Info]: 2024-05-29 16:43:12.416--ServerSession(1807173135)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158 [EL Info]: connection: 2024-05-29 16:43:12.543--ServerSession(1807173135)--/file:/opt/instalacionre3gistry6/apache-tomcat-9.0.88/webapps/re3gistry2/WEB-INF/lib/Re3gistry2Migration-1.0.jar_Re3gistry2Migrationurl=jdbc:postgresql://localhost:5432/database=postgres login successful

Thanks

antamasal commented 1 month ago

Any idea of ​​the error? Best regards,

iratigarzon commented 1 month ago

Dear @antamasal,

We have tried running in our local instance, and it is working as expected. However, we have encountered an issue with passing your backup dump (.dmp) to a SQL file.

Could you please upload a SQL file? So we can check if an error is thrown related to the database (That maybe doesn't appear in the logs) when you click on the "Install" button.

Best regards,

Irati.

antamasal commented 4 weeks ago

Hii!, Here is the export in SQL format so you can review it better. Looking at the export of the database, when I click the start button no error appears in the log but it has not finished installing. Looking at the target database, I notice that many of the records have not been passed. Thanks and greetings

re3gistry.txt

antamasal commented 3 weeks ago

Any idea of ​​the error? Best regards,

iratigarzon commented 2 weeks ago

Dear @antamasal,

We have reviewed the dump you provided and identified an issue with the migration process. It appears that the error occurs while trying to migrate the CustomAttribute table, which is causing the process to redirect you back to the first step. We are checking this issue and will inform you as soon as we have a solution.

Best regards,

Irati.

antamasal commented 2 weeks ago

Hi! Okay,I'll wait for you to tell me the solution. Best regards,

antamasal commented 3 days ago

Hi!! Is there any news on this topic? Thanks