Trying to install appian 19.4

The error is "Could not open JPA EntityManager for transaction; nested exception is java.lang.IllegalStateException: [jdbc/AppianDS] Error during schema migration"

So I'd suggest the following:

1. If on linux, use the JAVA shipped with the product and set the JAVA_HOME, PATH to point to it. Example:

export JAVA_HOME=/usr/local/appian/java

export PATH=$JAVA_HOME/bin:$PATH:

2. In the tomcatResources.xml file and /tomcat/apache-tomcat/conf/Catalina/localhost/suite.xml file make sure the datasource starts with the same resource name = /jdbc/AppianDS or whatever you've called your primary database.

The key is that the resource you choose  'jdbc/AppianDS' is consistent. 

Note: You may well have decided to install the latest 20.3 release.

Hi, We are seeing the below issue while restarting the Appian server.  Please let us know if you see any error similar to this.

ERROR org.springframework.web.context.ContextLoader - Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.security.filterChains': Cannot resolve reference to bean 'org.springframework.security.web.DefaultSecurityFilterChain#65' while setting bean property 'sourceList' with key [65]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.security.web.DefaultSecurityFilterChain#65': Cannot resolve reference to bean 'mobileClientValidationFilter' while setting constructor argument with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'mobileClientValidationFilter' defined in ServletContext resource [/WEB-INF/conf/security/spring-security-05-web-api.xml]: Cannot resolve reference to bean 'httpBasicAuthenticationEntryPoint' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'httpBasicAuthenticationEntryPoint' defined in ServletContext resource [/WEB-INF/conf/security/spring-security-05-web-api.xml]: Bean instantiation via constructor failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.appiancorp.security.auth.HttpBasicAuthenticationEntryPoint]: Constructor threw exception; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction; nested exception is java.lang.IllegalStateException: [jdbc/appiandb] Error during schema migration.

I had a similar issue when installing 21.2, with the error being mentioned in the tomcat log as:

Caused by: java.lang.ClassCastException: java.time.LocalDateTime cannot be cast to java.lang.String

This was solved by replacing the mysql-connector-java-8.0.25.jar in the repo/tomcat/apache-tomcat/bin with the 8.0.22 version. 

For your issue, doing a similar replacement with an earlier version of the jar may fix it.

But 8.0.22 has vulnerability. How do we fix this

I faced this same issue while installing Appian 22.2. I replaced the driver jar. It worked. Please refer to the below link for reference.

docs.appian.com/.../System_Requirements.html