Hi
Can ypu help me
After restorenback uup with dhis2 tools next génération
The server reponse
HTTP 404 – Non trouvé
Thanks
Hey @daniel1,
Please send your catalina log files, are there any errors? What’s the Java Version, postgresql version, and the version of the DHIS2 instance that you are using?
May I also ask you to write the steps you did to get this? Thank you!
I used this dhis2 tools tutorial GitHub - bobjolliffe/dhis2-tools-ng: Next generation dhis2-tools
reCapableBeanFactory.java:1846)
Oct 12 13:21:15 staging tomcat9[286]: at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1774)
Oct 12 13:21:15 staging tomcat9[286]: … 110 more
Oct 12 13:21:15 staging tomcat9[286]: Caused by: org.flywaydb.core.internal.sqlscript.FlywaySqlScriptException:
Oct 12 13:21:15 staging tomcat9[286]: Migration V2_31_1__Migrations_for_release_v31.sql failed
Oct 12 13:21:15 staging tomcat9[286]: --------------------------------------------------------
Oct 12 13:21:15 staging tomcat9[286]: SQL State : 42830
Oct 12 13:21:15 staging tomcat9[286]: Error Code : 0
Oct 12 13:21:15 staging tomcat9[286]: Message : ERROR: there is no unique constraint matching given keys for referenced table “fileresource”
Oct 12 13:21:15 staging tomcat9[286]: Location : org/hisp/dhis/db/migration/2.31/V2_31_1__Migrations_for_release_v31.sql (/var/lib/tomcat9/file:/var/lib/tomcat9/webapps/staging/WEB-INF/lib/dhis-support-db-migration-2.33.2.jar!/org/hisp/dhis/db/migration/2.31/V2_31_1__Migrations_for_release_v31.sql)
Oct 12 13:21:15 staging tomcat9[286]: Line : 88
Oct 12 13:21:15 staging tomcat9[286]: Statement : alter table userinfo
Oct 12 13:21:15 staging tomcat9[286]: add constraint fk_user_fileresourceid foreign key (avatar) references fileresource (fileresourceid)
Oct 12 13:21:15 staging tomcat9[286]: at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.handleException(DefaultSqlScriptExecutor.java:274)
Oct 12 13:21:15 staging tomcat9[286]: at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.executeStatement(DefaultSqlScriptExecutor.java:220)
Oct 12 13:21:15 staging tomcat9[286]: at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.execute(DefaultSqlScriptExecutor.java:127)
Oct 12 13:21:15 staging tomcat9[286]: at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:70)
Oct 12 13:21:15 staging tomcat9[286]: at org.flywaydb.core.internal.command.DbMigrate.doMigrateGroup(DbMigrate.java:366)
Oct 12 13:21:15 staging tomcat9[286]: … 134 more
Oct 12 13:21:15 staging tomcat9[286]: Caused by: org.postgresql.util.PSQLException: ERROR: there is no unique constraint matching given keys for referenced table “fileresource”
Oct 12 13:21:15 staging tomcat9[286]: at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
Oct 12 13:21:15 staging tomcat9[286]: at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
Oct 12 13:21:15 staging tomcat9[286]: at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
Oct 12 13:21:15 staging tomcat9[286]: at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
Oct 12 13:21:15 staging tomcat9[286]: at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
Oct 12 13:21:15 staging tomcat9[286]: at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
Oct 12 13:21:15 staging tomcat9[286]: at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
Oct 12 13:21:15 staging tomcat9[286]: at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
Oct 12 13:21:15 staging tomcat9[286]: at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:266)
Oct 12 13:21:15 staging tomcat9[286]: at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:75)
Oct 12 13:21:15 staging tomcat9[286]: at org.flywaydb.core.internal.jdbc.JdbcTemplate.executeStatement(JdbcTemplate.java:244)
Oct 12 13:21:15 staging tomcat9[286]: at org.flywaydb.core.internal.sqlscript.ParsedSqlStatement.execute(ParsedSqlStatement.java:111)
Oct 12 13:21:15 staging tomcat9[286]: at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.executeStatement(DefaultSqlScriptExecutor.java:208)
Oct 12 13:21:15 staging tomcat9[286]: … 137 more
Hey,
Would you like to try to clear the cache in the browser and see if the issue persists? Thanks, here’s a guide on how to really clear the cache: Really clear the cache - DHIS2 Documentation