When i try to launch Appian with cmd I get these errors (and more) in my tomcat log. They repeat a lot.
EDIT: I completely reinstalled everything following the quick guide, and I still get the same errors
2019-06-20 16:04:18.332 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -XX:+HeapDumpOnOutOfMemoryError
2019-06-20 16:04:19.517 SEVERE [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDescriptor Error deploying configuration descriptor [C:\appian\tomcat\apache-tomcat\conf\Catalina\localhost\suite.xml]
2019-06-20 16:04:19.555 SEVERE [localhost-startStop-1] org.apache.catalina.startup.ContextConfig.processContextConfig Parse error in context.xml for [/suite]
java.sql.SQLSyntaxErrorException: Unknown database 'appian_primary' at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
2019-06-20 16:33:24,994 [wait-for-component] ERROR com.appiancorp.common.startup.healthcheck.PrimaryRdbmsHealthCheck - javax.naming.NamingException: Unexpected exception resolving reference [Root exception is java.sql.SQLSyntaxErrorException: Unknown database 'appian_primary']2019-06-20 16:33:24,995 [wait-for-component] ERROR com.appiancorp.common.startup.WaitForStatefulComponents - Error connecting to Appian component Primary datasource RDBMS. Check Primary datasource RDBMS status and connection configuration?ERROR StatusLogger Log4j2 could not find a logging implementation. Please add log4j-core to the classpath. Using SimpleLogger to log to the console...
2019-06-20 16:33:54,917 [localhost-startStop-1] ERROR org.hibernate.connection.DatasourceConnectionProvider - Could not find datasource: jdbc/AppianDS javax.naming.NamingException: Unexpected exception resolving reference [Root exception is java.sql.SQLSyntaxErrorException: Unknown database 'appian_primary']
2019-06-20 16:33:54,957 [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 javax.persistence.PersistenceException: Unable to build EntityManagerFactory
Caused by: javax.naming.NamingException: Unexpected exception resolving reference [Root exception is java.sql.SQLSyntaxErrorException: Unknown database 'appian_primary']
2019-06-20 16:54:55,214 [localhost-startStop-1] ERROR org.hibernate.connection.DatasourceConnectionProvider - Could not find datasource: jdbc/AppianDS
Discussion posts and replies are publicly visible
Looks like Appian is having difficulty finding the database.
Is the database server service running?
yes it is
Have you defined the Primary datasource in appian-ds.xml file and is the same JNDI name getting reflected in custom.properties file through conf.data.APPIAN_DATA_SOURCE?
I've been away for a few days so I don't remember where these files are. Could you tell me where to locate them?