Hi Michel, My guess here is that you may be running the DSpace 7 version of the "update-sequences" script on your DSpace 6 database. (The DSpace 7 version of that script will expect some DSpace 7 tables to exist...which is why you are getting an error.)
If you want to run this script *prior* to the database migration (./dspace database migrate), then you should run the DSpace *6* version of the "update-sequences" script (e.g. from the old DSpace 6 installation). For example: psql -U [database-user] -f [dspace-6-install]/etc/postgres/update-sequences.sql [database-name] (If you have misplaced this older version of the "update-sequences.sql" script, then you could simply download it from https://github.com/DSpace/DSpace/blob/dspace-6_x/dspace/etc/postgres/update-sequences.sql and run that using a similar "psql" command) Tim On Wednesday, August 23, 2023 at 7:37:54 AM UTC-5 [email protected] wrote: > We need to redo the previous migration. > Running the update-sequences command returns the error below. > > C:\dspace\bin>*dspace database update-sequences* >> Using DSpace installation in: C:\dspace >> Running >> org/dspace/storage/rdbms/sqlmigration/postgres/update-sequences.sql >> >> * Caught exception:** org.postgresql.util.PSQLException: ERROR: relation >> "systemwidealert" does not exist* >> Posição: 923 >> at >> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2713) >> at >> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2401) >> at >> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:368) >> at >> org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:498) >> at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:415) >> at >> org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:335) >> at >> org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:321) >> at >> org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:297) >> at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:292) >> at >> org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:193) >> at >> org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:193) >> at >> org.dspace.storage.rdbms.DatabaseUtils.main(DatabaseUtils.java:405) >> at >> java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104) >> at java.base/java.lang.reflect.Method.invoke(Method.java:577) >> at >> org.dspace.app.launcher.ScriptLauncher.runOneCommand(ScriptLauncher.java:277) >> at >> org.dspace.app.launcher.ScriptLauncher.handleScript(ScriptLauncher.java:133) >> at >> org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:98) > > > Data Base > [image: image.png] > > > > -- > Atenciosamente, > *Michel Pinheiro Montenegro* > - *Bacharel* em Sistema de Informação > - [Lato Sensu] *Especialista* em Engenharia de Sistemas > - [Stricto Sensu] *Mestre* em Ciência da Computação > - [Stricto Sensu] *Doutorando* em Ciência da Computação > > E-mail/Gtalk: [email protected] > -- All messages to this mailing list should adhere to the Code of Conduct: https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx --- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/2ec573fc-30f1-4a2d-849e-27b3fc988581n%40googlegroups.com.
