Hi Steve, I believe you may have to run:
./dspace database migrate ignored as described in https://wiki.lyrasis.org/display/DSDOC7x/Migrating+DSpace+to+a+new+server James On Tue, Nov 28, 2023 at 9:15 AM Steve Michaels < steve.micha...@westernsem.edu> wrote: > When I run "migrate" I'm receiving a relation "cwf_pooltask" does not > exist ERROR. We have been using the XML workflow, consequently DS 3431 > Add Policies for BasicWorkflow is still at version 5.7.2017.05.05. > > The full last error is: > --------------------------------------------------------------- > -- DS-4239 Migrate the workflow.xml to spring > --------------------------------------------------------------- > -- This script will rename the default workflow "default" name > -- to the new "defaultWorkflow" identifier > --------------------------------------------------------------- > > UPDATE cwf_pooltask SET workflow_id='defaultWorkflow' WHERE > workflow_id='default' > > at > org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.handleException(DefaultSqlScriptExecutor.java:275) > at > org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.executeStatement(DefaultSqlScriptExecutor.java:222) > at > org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.execute(DefaultSqlScriptExecutor.java:126) > at > org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.executeOnce(SqlMigrationExecutor.java:69) > at > org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.lambda$execute$0(SqlMigrationExecutor.java:58) > at > org.flywaydb.core.internal.database.DefaultExecutionStrategy.execute(DefaultExecutionStrategy.java:27) > at > org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:57) > at > org.flywaydb.core.internal.command.DbMigrate.doMigrateGroup(DbMigrate.java:377) > ... 25 more > Caused by: org.postgresql.util.PSQLException: ERROR: relation > "cwf_pooltask" does not exist > Position: 684 > 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.flywaydb.core.internal.jdbc.JdbcTemplate.executeStatement(JdbcTemplate.java:201) > at > org.flywaydb.core.internal.sqlscript.ParsedSqlStatement.execute(ParsedSqlStatement.java:95) > at > org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.executeStatement(DefaultSqlScriptExecutor.java:210) > ... 31 more > > -- > 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 dspace-tech+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/dspace-tech/91ab8d70-a24e-4bf1-aa5a-5585ce0bd40dn%40googlegroups.com > <https://groups.google.com/d/msgid/dspace-tech/91ab8d70-a24e-4bf1-aa5a-5585ce0bd40dn%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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 dspace-tech+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/CAAosP7UFw563b2U7RWwzLaPHm7%3DSqWG3izDhiRGuADxMdawa%3DQ%40mail.gmail.com.
