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.
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.
Hi
just for the record, it looks they have addressed this issue (AN-137015) in 19.2 with Hotfix package E and backported to 19.1 Hoftix package E. I assume this code is also part of 19.3.
Is this issue resolved? I am seeing a similar issue while installing Appian 21.1 with MySQL. Please respond to this post if there is any solution for this.Thanks.