Upgrade fails for CA API Developer Portal
search cancel

Upgrade fails for CA API Developer Portal


Article ID: 145251


Updated On:


CA API Developer Portal


CA API Developer portal upgrade from 4.2.9.x to various other versions such
as 4.3 and 4.5 hangs when attempting to start the portal.

During the portal startup things will hang while checking
if a db schema update is needed.



Release : 4.2.9.x 

Component : API PORTAL


The stack trace shows issue during database upgrade
Upgrade freezes on DB upgrade step with errors:
INFO 9/27/19 9:57 AM: liquibase: Successfully released change log lock
liquibase.exception.ValidationFailedException: Validation Failed:

     10 change sets check sum

       at liquibase.changelog.DatabaseChangeLog.validate(DatabaseChangeLog.java:266)
       at liquibase.Liquibase.update(Liquibase.java:210)
       at liquibase.Liquibase.update(Liquibase.java:192)
       at liquibase.integration.commandline.Main.doMigration(Main.java:1126)
       at liquibase.integration.commandline.Main.run(Main.java:184)
       at liquibase.integration.commandline.Main.main(Main.java:103)

For more information, use the --logLevel flag
ERROR: Running the portal-data liquibase scripts failed, see above for details; exiting
/opt/start.sh: line 25:     8 Killed                  socat TCP4-LISTEN:$LISTEN_PORT,fork EXEC:cat > /dev/null 2>&1
09:57:25, Stopping simple server on :8080... done


First back up Database if you have Database container/stack up then run below update command(step 2) then restart portal. If not, start portal(i.e run ./portal.sh) so database container will be up then follow below steps.
1. Backup database using: mysqldump -u<USERNAME> -p<PASSWORD> -h<HOST> portal > portal.sql
2. Execute the "update DATABASECHANGELOG set MD5SUM=null;" 
3. Restart portal