Error creating bean with name 'serviceWsdlImportChecker' defined in class path resource [com/l7tech/server/resources/ssgApplicationContext.xml] after migrated ssg with mysqldump

Products

• CA API Gateway

Issue/Introduction

Following documentation for "Manual Expedited Appliance Upgrade", a database dump was performed. 

mysqldump ssg --routines > /home/ssgconfig/<source_Gateway>.sql

The command finished successfully, however, the gateway services fsil to start. Log file shows the following :

2024-05-28T18:38:38.765-0300 INFO    1 com.l7tech.util.Background: Cancelling background task 'com.l7tech.gateway.common.spring.remoting.http.p@5bEdited8' (com.l7tech.gateway.common.spring.remoting.http.p)
2024-05-28T18:38:38.776-0300 WARNING 1 com.l7tech.server.boot.GatewayMain: Error starting server : Error creating bean with name 'serviceWsdlImportChecker' defined in class path resource [com/l7tech/server/resources/ssgApplicationContext.xml]: Invocation of init method failed; nested exception is javax.persistence.EntityNotFoundException: No row with the given identifier exists: [com.l7tech.objectmodel.folder.Folder#2b287c3bc78fe347fb350ed16f8c7947]
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'serviceWsdlImportChecker' defined in class path resource [com/l7tech/server/resources/ssgApplicationContext.xml]: Invocation of init method failed; nested exception is javax.persistence.EntityNotFoundException: No row with the given identifier exists: [com.l7tech.objectmodel.folder.Folder#2b287c3bc78fe347fb350ed16f8c7947]
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1786)

Caused by: javax.persistence.EntityNotFoundException: No row with the given identifier exists: [com.l7tech.objectmodel.folder.Folder#2b287c3bc78fe347fb350ed16f8c7947]

**** Unable to start the server:  Error starting server : Error creating bean with name 'serviceWsdlImportChecker' defined in class path resource [com/l7tech/server/resources/ssgApplicationContext.xml]: Invocation of init method failed; nested exception is javax.persistence.EntityNotFoundException: No row with the given identifier exists: [com.l7tech.objectmodel.folder.Folder#2b287c3bc78fe347fb350ed16f8c7947]

Environment

API Gateway 11.0

Cause

The current disk size was smaller than the database dump. As a result, the mysqldump was completed without error, however, it was corrupted.

Resolution

Add more disk space to allow the mysqldump operations and allow the services to startup with a healthy database

API Gateway: Not able to increase VM disk space