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
We actually have also run into this issue. Opened a case with support, but it's still unresolved.
It's something to do with primary database initialization
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']
It will work up to MySQL 8.0.15. Something changed in 8.0.16 that causes this change in behavior. Fix is in progress.