You are currently reviewing an older revision of this page.

DRAFT KB-XXXX The schema is invalid error with "Wrong column type in <table_name> for column <column_name>. Found: varchar, expected: longtext."

Symptoms

Appian starts successfully, but when starting tomcat, tomcat fails to start during verifying schema.

The <APPIAN_HOME>\logs\tomcat-stdOut.log file shows the following errors:

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#54' while setting bean property 'sourceList'
with key [54]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name
'org.springframework.security.web.DefaultSecurityFilterChain#54': 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/AppianConfigDS] The schema is invalid.



Caused by: org.hibernate.HibernateException: Wrong column type in <TABLE_NAME> for column <COLUMN_NAME>. Found: varchar, expected: longtext

Cause

 

 The MySQL connector file, located in: <APPIAN_HOME>\tomcat\apache-tomcat\lib being used is an unsupported version. 

 

 

 

 

Action

 

 

 

 

 

 

Workaround

 

 

 

 

 

 

Affected Versions