Hi All ,
Wnated to understand if anyone has seen the below issue -
I am trying to install 19.2 on my windows machine with MQSQL as my DB -
all my engines/data servers and search server came up properly , howvere , when i start my tomcat i see the below issue
2019-07-11 18:13:38,672 [localhost-startStop-1] INFO com.appiancorp.common.persistence.search.SearchServerClientConfiguration - Using the Search Server client configuration specified in appian-topology.xml.2019-07-11 18:13:56,498 [localhost-startStop-1] INFO com.appiancorp.rdbms.hb.DataSourceManagerHbImpl - [jdbc/AppianPrimaryDS] Checking schema and migrating if necessary (appian/db/changelog/db-changelog-master.xml)...2019-07-11 18:18:08,312 [localhost-startStop-1] ERROR liquibase.changelog.ChangeSet - Change Set db-changelog-000015.xml::000015.2.1::appian failed. Error: Data truncation: Truncated incorrect DOUBLE value: 'false' [Failed SQL: UPDATE appian_primary.tp_feed_entry SET is_targeted = 'true' WHERE is_unsecured='false']2019-07-11 18:18:08,570 [localhost-startStop-1] INFO com.appian.dl.repo.es.client.TransportClientManager - Shutting down client.2019-07-11 18:18:08,583 [localhost-startStop-1] ERROR org.springframework.web.context.ContextLoader - Context initialization failedorg.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.security.filterChains': Cannot resolve reference to bean 'org.springframework.security.web.DefaultSecurityFilterChain#57' while setting bean property 'sourceList' with key [57]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.security.web.DefaultSecurityFilterChain#57': 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]: Instantiation of bean 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/AppianPrimaryDS] Error during schema migration.
Discussion posts and replies are publicly visible
Just to confirm that I’ve seen this behaviour with Appian 18.4 and MySql Commercial Server 8.0.16 as well as MySql Server Community Edition 8.0.17. Something on the database engine no longer accepts this kind of implicit type casting. The only acceptable solution was to revert to MySql 8.0.15.