deployment of APIServer.war throws error

Document ID : KB000074722
Last Modified Date : 29/03/2018
Show Technical Document Details
Issue:
Sometimes deployment of APIServer.war throws error as below :

----------------

[domain@10.0.32.165:9990 /] deploy /apps/LAC_v41/production/APIServer.war --force
{"WFLYDCXXXX: Operation failed or was rolled back on all servers. Server failures:" => {"server-group" => {"main-server-group" => {"host" => {"host2" => {"lac-server21" => {"WFLYCTLXXXX: Failed services" => {"jboss.undertow.deployment.default-server.default-host./APIServer" => "org.jboss.msc.service.StartException in service jboss.undertow.deployment.default-server.default-host./APIServer: java.lang.RuntimeException: java.lang.RuntimeException: Exception while loading or upgrading CA Live API Creator providers
Caused by: java.lang.RuntimeException: java.lang.RuntimeException: Exception while loading or upgrading CA Live API Creator providers
Caused by: java.lang.RuntimeException: Exception while loading or upgrading CA Live API Creator providers
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'lacclusterdb.listener_providers' doesn't exist"}}}}}}}}

--------------
Environment:
Wildfly JBoss application server
Cause:
We believe that this is being caused by a timing issue when starting up LAC, where the connections and listeners are started up before the admin database is fully upgraded. We will look to address this in a future release of LAC so that this problem will not appear in future upgrades.
Resolution:
Re-deploying APIServer.war file resolves this issue