HI im installing appian 18.1 for a local machine with windows 10.
My jboss dont start i got the message error: JBAS014777: Services which failed to start: service jboss.web.deployment.default-host./suite
i have installed:
My server.log is this.
7206.server.log
Discussion posts and replies are publicly visible
already created tables but still the same error
Hi Jonga,
It looks like Your DB Connection is successful. But during execution one of the migration scripts is not successful:
18:47:41,405 INFO [stdout] (ServerService Thread Pool -- 121) Reason: liquibase.exception.DatabaseException: Error executing SQL UPDATE `DATABASECHANGELOG` SET `TAG` = '6.6.1.0' WHERE DATEEXECUTED = (SELECT MAX(DATEEXECUTED) FROM (SELECT DATEEXECUTED FROM `DATABASECHANGELOG`) AS X): You can't specify target table 'DATABASECHANGELOG' for update in FROM clause: 18:47:41,408 INFO [stdout] (ServerService Thread Pool -- 121) Caused By: Error executing SQL UPDATE `DATABASECHANGELOG` SET `TAG` = '6.6.1.0' WHERE DATEEXECUTED = (SELECT MAX(DATEEXECUTED) FROM (SELECT DATEEXECUTED FROM `DATABASECHANGELOG`) AS X): You can't specify target table 'DATABASECHANGELOG' for update in FROM clause:
Please refer to the below links:
https://community.appian.com/support/w/kb/293/kb-1068-error-executing-sql-update-java-sql-sqlexception-you-can-t-specify-target-table-x-for-update-in-from-clause-error-thrown-during-application-server-startup
https://stackoverflow.com/questions/45494/mysql-error-1093-cant-specify-target-table-for-update-in-from-clause
Also, after making the necessary changes make sure below is correct before starting the jboss as suggested by Benhail
Verify that the following file exists and does not have the extensions .undeployed, .isdeploying or .failed:<APPIAN_HOME>\_admin\_scripts\configure\templates\ear\suite.ear.dodeployDelete the following file if it has the extensions .undeployed, .isdeploying or .failed:<JBOSS_HOME>\standalone\deployments\appian-mysql-ds.xml.deployed
"{ \"JBAS014671: Failed services\" => {\"jboss.web.deployment.default-host./suite\" => \"org.jboss.msc.service.StartException in service jboss.web.deployment.default-host./suite: org.jboss.msc.service.StartException in anonymous service: JBAS018040: Failed to start context Caused by: org.jboss.msc.service.StartException in anonymous service: JBAS018040: Failed to start context\"}, \"JBAS014771: Services with missing/unavailable dependencies\" => [ \"jboss.naming.context.java.comp.suite.jms-process-integration-handler.JmsProcessIntegrationHandlerBean.ValidatorFactory is missing [jboss.naming.context.java.comp.suite.jms-process-integration-handler.JmsProcessIntegrationHandlerBean]\", \"jboss.naming.context.java.comp.suite.jms-process-integration-handler.JmsProcessIntegrationHandlerBean.Validator is missing [jboss.naming.context.java.comp.suite.jms-process-integration-handler.JmsProcessIntegrationHandlerBean]\", \"jboss.naming.context.java.comp.suite.email-handler.EmailHandlerBean.ValidatorFactory is missing [jboss.naming.context.java.comp.suite.email-handler.EmailHandlerBean]\", \"jboss.naming.context.java.comp.suite.unattended-request-handler.UnattendedRequestHandlerBean.Validator is missing [jboss.naming.context.java.comp.suite.unattended-request-handler.UnattendedRequestHandlerBean]\", \"jboss.naming.context.java.comp.suite.email-handler.EmailHandlerBean.Validator is missing [jboss.naming.context.java.comp.suite.email-handler.EmailHandlerBean]\", \"jboss.deployment.subunit.\\\"suite.ear\\\".\\\"email-handler.jar\\\".INSTALL is missing [jboss.deployment.subunit.\\\"suite.ear\\\".\\\"jms-process-integration-handler.jar\\\".deploymentCompleteService]\", \"jboss.deployment.subunit.\\\"suite.ear\\\".\\\"jms-process-integration-handler.jar\\\".INSTALL is missing [jboss.deployment.subunit.\\\"suite.ear\\\".\\\"unattended-request-handler.jar\\\".deploymentCompleteService]\", \"jboss.deployment.unit.\\\"suite.ear\\\".deploymentCompleteService is missing [jboss.deployment.subunit.\\\"suite.ear\\\".\\\"email-handler.jar\\\".deploymentCompleteService, jboss.deployment.subunit.\\\"suite.ear\\\".\\\"jms-process-integration-handler.jar\\\".deploymentCompleteService, jboss.deployment.subunit.\\\"suite.ear\\\".\\\"unattended-request-handler.jar\\\".deploymentCompleteService]\", \"jboss.naming.context.java.comp.suite.unattended-request-handler.UnattendedRequestHandlerBean.ValidatorFactory is missing [jboss.naming.context.java.comp.suite.unattended-request-handler.UnattendedRequestHandlerBean]\" ] }"
this is my suite.ear.failed does this help??
i do it like that ¿is that correct?
server.log.xml
here it is
It still says a DB Error Buddy, Can I have access (RDP or Teamviewer) and solve your issue?
Sorry was kinda busy and wasn't been able to login to the community
Hi Jonga ,
The Jboss EAP which version you are using , Like 6.4.0 OR 6.4.1?
In System Requirement they mentioned Minimum JBoss Enterprise Application Platform 6.4 (6.4.14 or later).
Please check the System Requirements , AFAIK May be this one also cause an issue.