I am trying to install Appian but I am encountering an error on starting the application server.
logs:
Using CATALINA_BASE: "C:\appian223\appian\tomcat\apache-tomcat" Using CATALINA_HOME: "C:\appian223\appian\tomcat\apache-tomcat" Using CATALINA_TMPDIR: "C:\appian223\appian\tomcat\apache-tomcat\temp" Using JRE_HOME: "C:\appian223\appian\java" Using CLASSPATH: "C:\appian223\appian\tomcat\apache-tomcat\bin\bootstrap.jar;C:\appian223\appian\tomcat\apache-tomcat\bin\tomcat-juli.jar" Using CATALINA_OPTS: " -Dfile.encoding=UTF-8 -Duser.timezone=GMT -Djava.naming.factory.initial=com.appiancorp.tomcat.naming.TomcatInitialContextFactory -Djava.awt.headless=true -Djava.net.preferIPv4Stack=true -Dorg.osgi.framework.security=osgi -Dsun.net.inetaddr.ttl=60 -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000 -Dtomcat.cacheArchiveEntries=true -Dio.opentracing.contrib.jdbc.excludeFastQueryThresholdMs=100 -Dio.opentracing.contrib.jdbc.slowQueryThresholdMs=200 -XX:-TieredCompilation -XX:ReservedCodeCacheSize=256M -XX:+UseG1GC -XX:+ExplicitGCInvokesConcurrent -XX:+UseStringDeduplication -XX:+PrintGCDetails -XX:+PrintGCDateStamps -XX:+UseGCLogFileRotation -XX:+PrintGCApplicationStoppedTime -XX:+PrintGCApplicationConcurrentTime -XX:+SafepointTimeout -XX:SafepointTimeoutDelay=10000 -XX:NumberOfGCLogFiles=25 -XX:GCLogFileSize=3M -XX:+HeapDumpOnOutOfMemoryError -XX:+UseMembar -verbose:gc -Dae.home=C:\appian223\appian -Xloggc:C:\appian223\appian\logs\tomcat\gc.log -Xms2048m -Xmx2048m" Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Server version name: Apache Tomcat/8.5.82 Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Server built: Aug 8 2022 21:26:07 UTC Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Server version number: 8.5.82.0 Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: OS Name: Windows 10 Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: OS Version: 10.0 Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Architecture: amd64 Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Java Home: C:\appian223\appian\java\jre Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: JVM Version: 1.8.0_345-b01 Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: JVM Vendor: Temurin Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: CATALINA_BASE: C:\appian223\appian\tomcat\apache-tomcat Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: CATALINA_HOME: C:\appian223\appian\tomcat\apache-tomcat Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Djava.util.logging.config.file=C:\appian223\appian\tomcat\apache-tomcat\conf\logging.properties Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Djdk.tls.ephemeralDHKeySize=2048 Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Dfile.encoding=UTF-8 Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Duser.timezone=GMT Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Djava.naming.factory.initial=com.appiancorp.tomcat.naming.TomcatInitialContextFactory Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Djava.awt.headless=true Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Djava.net.preferIPv4Stack=true Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Dorg.osgi.framework.security=osgi Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Dsun.net.inetaddr.ttl=60 Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Dsun.rmi.dgc.client.gcInterval=3600000 Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Dsun.rmi.dgc.server.gcInterval=3600000 Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Dtomcat.cacheArchiveEntries=true Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Dio.opentracing.contrib.jdbc.excludeFastQueryThresholdMs=100 Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Dio.opentracing.contrib.jdbc.slowQueryThresholdMs=200 Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -XX:-TieredCompilation Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -XX:ReservedCodeCacheSize=256M Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -XX:+UseG1GC Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -XX:+ExplicitGCInvokesConcurrent Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -XX:+UseStringDeduplication Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -XX:+PrintGCDetails Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -XX:+PrintGCDateStamps Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -XX:+UseGCLogFileRotation Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -XX:+PrintGCApplicationStoppedTime Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -XX:+PrintGCApplicationConcurrentTime Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -XX:+SafepointTimeout Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -XX:SafepointTimeoutDelay=10000 Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -XX:NumberOfGCLogFiles=25 Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -XX:GCLogFileSize=3M Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -XX:+HeapDumpOnOutOfMemoryError Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -XX:+UseMembar Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -verbose:gc Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Dae.home=C:\appian223\appian Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Xloggc:C:\appian223\appian\logs\tomcat\gc.log Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Xms2048m Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Xmx2048m Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Dignore.endorsed.dirs= Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Dcatalina.base=C:\appian223\appian\tomcat\apache-tomcat Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Dcatalina.home=C:\appian223\appian\tomcat\apache-tomcat Oct 04, 2022 9:43:26 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Djava.io.tmpdir=C:\appian223\appian\tomcat\apache-tomcat\temp Oct 04, 2022 9:43:27 PM org.apache.coyote.AbstractProtocol init INFO: Initializing ProtocolHandler ["http-nio-8080"] Oct 04, 2022 9:43:27 PM org.apache.coyote.AbstractProtocol init INFO: Initializing ProtocolHandler ["ajp-nio-0.0.0.0-8009"] Oct 04, 2022 9:43:27 PM org.apache.catalina.startup.Catalina load INFO: Initialization processed in 816 ms Oct 04, 2022 9:43:27 PM org.apache.catalina.core.StandardService startInternal INFO: Starting service [Catalina] Oct 04, 2022 9:43:27 PM org.apache.catalina.core.StandardEngine startInternal INFO: Starting Servlet engine: [Apache Tomcat/8.5.82] Oct 04, 2022 9:43:27 PM org.apache.catalina.startup.HostConfig deployDescriptor INFO: Deploying deployment descriptor [C:\appian223\appian\tomcat\apache-tomcat\conf\Catalina\localhost\suite.xml] Tomcat Cache Archive Entries [true] Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. Oct 04, 2022 9:43:52 PM org.apache.catalina.core.ApplicationContext log INFO: No Spring WebApplicationInitializer types detected on classpath log4j:WARN No appenders could be found for logger (org.apache.commons.configuration.PropertiesConfiguration). log4j:WARN Please initialize the log4j system properly. log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info. log4j:WARN Exception while initializing AppianRollingFileAppender named 'INTEGRATION_REQ_RESP_ALL' java.util.regex.PatternSyntaxException: Illegal/unsupported escape sequence near index 20 C:\appian223\appian\logs/perflogs/http-requests-and-responses/integration_req_resp_activity(\.[0-9]{4}_[0-9]{2}_[0-9]{2})\.([0-9]+).log ^ at java.util.regex.Pattern.error(Pattern.java:1969) at java.util.regex.Pattern.escape(Pattern.java:2485) at java.util.regex.Pattern.atom(Pattern.java:2212) at java.util.regex.Pattern.sequence(Pattern.java:2144) at java.util.regex.Pattern.expr(Pattern.java:2010) at java.util.regex.Pattern.compile(Pattern.java:1702) at java.util.regex.Pattern.<init>(Pattern.java:1352) at java.util.regex.Pattern.compile(Pattern.java:1028) at com.appiancorp.common.logging.rolling.RollingUtils.getFilePathPattern(RollingUtils.java:76) at com.appiancorp.common.logging.rolling.DailyRollingPolicyDeleteManager.initialize(DailyRollingPolicyDeleteManager.java:51) at com.appiancorp.common.logging.rolling.DailyRollingPolicy.initialize(DailyRollingPolicy.java:121) at com.appiancorp.common.logging.rolling.AppianRollingFileAppender.activateOptions(AppianRollingFileAppender.java:74) at org.apache.log4j.config.PropertySetter.activate(PropertySetter.java:284) at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:160) at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:100) at org.apache.log4j.PropertyConfigurator.parseAppender(PropertyConfigurator.java:802) at org.apache.log4j.PropertyConfigurator.parseCategory(PropertyConfigurator.java:738) at org.apache.log4j.PropertyConfigurator.parseCatsAndRenderers(PropertyConfigurator.java:652) at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:518) at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:421) at com.appiancorp.common.logging.LoggingPropertyWatchdog.doOnChange(LoggingPropertyWatchdog.java:20) at org.apache.log4j.helpers.FileWatchdog.checkAndConfigure(FileWatchdog.java:85) at org.apache.log4j.helpers.FileWatchdog.<init>(FileWatchdog.java:59) at com.appiancorp.common.logging.LoggingPropertyWatchdog.<init>(LoggingPropertyWatchdog.java:13) at com.appiancorp.common.logging.LoggingPropertyConfigurator.configureAndWatch(LoggingPropertyConfigurator.java:34) at com.appiancorp.common.logging.LoggingPropertyConfigurator.configureFile(LoggingPropertyConfigurator.java:22) at com.appiancorp.common.logging.ConfigureLog4j.configure(ConfigureLog4j.java:284) at com.appiancorp.common.logging.ConfigureLog4j.configure(ConfigureLog4j.java:134) at com.appiancorp.common.logging.ConfigureLog4j.initialize(ConfigureLog4j.java:55) at com.appiancorp.common.logging.ConfigureLog4j.contextInitialized(ConfigureLog4j.java:64) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4763) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5232) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:753) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:727) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:695) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:673) at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1881) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:750) 2022-10-04 21:43:53,006 [wait-for-component] INFO com.appiancorp.tools.WaitForServers - Waiting for servers to be up... 2022-10-04 21:43:53,029 [wait-for-component] INFO com.appiancorp.common.persistence.search.SearchServerClientConfiguration - Using the Search Server client configuration specified in C:\appian223\appian\conf\appian-topology.xml. 2022-10-04 21:43:53,200 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:43:53,271 [wait-for-component] INFO com.appiancorp.common.persistence.search.AppianSearchSpringConfig - initializing client with server addresses: [localhost:9200] 2022-10-04 21:43:53,604 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Appian component Data Server is healthy 2022-10-04 21:43:54,176 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Appian component Kafka Topics is healthy 2022-10-04 21:43:54,352 [wait-for-component] INFO com.appiancorp.cache.CacheBase - Initializing Cache komodo_lastUpdateTxId [com.appiancorp.cache.DefaultLirsCacheWrapper] with Configuration: {appian.cacheattributes.MaxSpoolPerRun=-1, appian.cacheattributes.MemoryCacheName=com.appiancorp.cache.JavaCachingSystemLirs, appian.cacheattributes.MaxObjects=10000, appian.cache.metrics.tracingEnabled=false, appian.cacheattributes.MaxEntrySizeBytes=-1, appian.cacheattributes.MaxCacheSizeBytes=-1, appian.cacheattributes.SegmentCount=-1, appian.cacheattributes.distributionMode=LOCAL_WITH_DISTRIBUTED_CLEAR, appian.elementattributes.MaxLifeSeconds=-1, appian.cacheattributes.cacheKey=komodo_lastUpdateTxId, appian.cacheattributes.bytesTrackingEnabled=false, appian.cacheattributes.MaxMemoryIdleTimeSeconds=300, appian.cacheattributes.cacheName=komodo_lastUpdateTxId, appian.cacheattributes.ShrinkerIntervalSeconds=3600} 2022-10-04 21:43:54,378 [wait-for-component] INFO com.appiancorp.tools.WaitForServers - Waiting for analytics to be ready... 2022-10-04 21:43:54,558 [wait-for-component] INFO com.appiancorp.cache.CacheBase - Initializing Cache types.type [com.appiancorp.cache.DefaultLirsCacheWrapper] with Configuration: {appian.cacheattributes.MemoryCacheName=com.appiancorp.cache.JavaCachingSystemCoupledLirs, appian.cacheattributes.MaxObjects=20000, //=AN-165948 use a single segment to work around deadlocks due to coupled keys having different hashes, appian.cacheattributes.SegmentCount=1, appian.cacheattributes.distributionMode=LOCAL_WITH_DISTRIBUTED_CLEAR, appian.cacheattributes.cacheKey=appian/cache/jcs-datatype-config.ccf, appian.cacheattributes.MaxMemoryIdleTimeSeconds=14400, appian.cacheattributes.cacheName=types.type, appian.cacheattributes.ShrinkerIntervalSeconds=3600} 2022-10-04 21:43:54,623 [wait-for-component] INFO com.appiancorp.cache.CacheBase - Initializing Cache userPreferences [com.appiancorp.cache.DefaultLirsCacheWrapper] with Configuration: {appian.cacheattributes.MaxMemoryIdleTimeSeconds=1200, appian.cache.metrics.collectFullMetrics=false, appian.cacheattributes.ShrinkerIntervalSeconds=600, appian.cacheattributes.distributionMode=LOCAL_WITH_DISTRIBUTED_CLEAR, appian.cacheattributes.MaxObjects=5000, appian.cacheattributes.cacheKey=appian/cache/jcs-userPreferences-config.ccf, appian.cacheattributes.MemoryCacheName=com.appiancorp.cache.JavaCachingSystemLirs, appian.cacheattributes.cacheName=userPreferences} 2022-10-04 21:43:54,655 [wait-for-component] INFO com.appiancorp.cache.CacheBase - Initializing Cache globalization [com.appiancorp.cache.DefaultLirsCacheWrapper] with Configuration: {appian.cacheattributes.MaxMemoryIdleTimeSeconds=14400, appian.cache.metrics.collectFullMetrics=false, appian.cacheattributes.ShrinkerIntervalSeconds=3600, appian.cacheattributes.distributionMode=LOCAL_WITH_DISTRIBUTED_CLEAR, appian.cacheattributes.MaxObjects=10, appian.cacheattributes.cacheKey=appian/cache/jcs-globalization-config.ccf, appian.cacheattributes.MemoryCacheName=com.appiancorp.cache.JavaCachingSystemLirs, appian.cacheattributes.cacheName=globalization} 2022-10-04 21:43:54,659 [wait-for-component] INFO com.appiancorp.cache.CacheBase - Initializing Cache i18n [com.appiancorp.cache.DefaultLirsCacheWrapper] with Configuration: {appian.cacheattributes.MaxMemoryIdleTimeSeconds=14400, appian.cache.metrics.collectFullMetrics=false, appian.cacheattributes.ShrinkerIntervalSeconds=3600, appian.cacheattributes.distributionMode=LOCAL_ONLY, appian.cacheattributes.MaxObjects=1500, appian.cacheattributes.cacheKey=appian/cache/jcs-i18n-config.ccf, appian.cacheattributes.MemoryCacheName=com.appiancorp.cache.JavaCachingSystemLirs, appian.cacheattributes.cacheName=i18n} 2022-10-04 21:43:54,694 [wait-for-component] INFO com.appiancorp.cache.CacheBase - Initializing Cache groupNames [com.appiancorp.cache.DefaultLirsCacheWrapper] with Configuration: {appian.cacheattributes.MemoryCacheName=com.appiancorp.cache.JavaCachingSystemLirs, appian.cacheattributes.MaxObjects=5000, appian.cache.metrics.collectFullMetrics=false, appian.cacheattributes.distributionMode=LOCAL_WITH_DISTRIBUTED_CLEAR, appian.cacheattributes.cacheKey=appian/cache/jcs-groupNameCache-config.ccf, appian.elementattributes.MaxLifeSeconds=5400, appian.cacheattributes.MaxMemoryIdleTimeSeconds=1800, appian.cacheattributes.cacheName=groupNames, appian.cacheattributes.ShrinkerIntervalSeconds=2700} 2022-10-04 21:43:54,695 [wait-for-component] INFO com.appiancorp.cache.CacheBase - Initializing Cache groupMemberships [com.appiancorp.cache.DefaultLirsCacheWrapper] with Configuration: {appian.cacheattributes.MaxMemoryIdleTimeSeconds=1200, appian.cache.metrics.collectFullMetrics=false, appian.cacheattributes.ShrinkerIntervalSeconds=600, appian.cacheattributes.distributionMode=LOCAL_WITH_DISTRIBUTED_CLEAR, appian.cacheattributes.MaxObjects=5000, appian.cacheattributes.cacheKey=appian/cache/jcs-groupMembershipCache-config.ccf, appian.cacheattributes.MemoryCacheName=com.appiancorp.cache.JavaCachingSystemLirs, appian.cacheattributes.cacheName=groupMemberships} 2022-10-04 21:43:54,900 [wait-for-component] INFO com.appiancorp.tools.WaitForServers - ... done. 2022-10-04 21:43:55,334 [wait-for-component] INFO com.appiancorp.common.persistence.search.AppianSearchSpringConfig - client configured nodes: [[host=http://localhost:9200]] 2022-10-04 21:43:55,453 [wait-for-component] INFO com.appiancorp.cache.CacheBase - Initializing Cache favoritesCache [com.appiancorp.cache.DefaultLirsCacheWrapper] with Configuration: {appian.cacheattributes.MemoryCacheName=com.appiancorp.cache.JavaCachingSystemLirs, appian.cacheattributes.MaxObjects=40000, appian.cache.metrics.collectFullMetrics=false, appian.cacheattributes.distributionMode=LOCAL_ONLY, appian.cacheattributes.cacheKey=appian/cache/jcs-favoritesCache-config.ccf, appian.elementattributes.MaxLifeSeconds=7200, appian.cacheattributes.MaxMemoryIdleTimeSeconds=7200, appian.cacheattributes.cacheName=favoritesCache, appian.cacheattributes.ShrinkerIntervalSeconds=10800} 2022-10-04 21:43:55,510 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Appian component Engines is healthy 2022-10-04 21:43:55,605 [wait-for-component] INFO com.appiancorp.common.persistence.search.AppianSearchSpringConfig - search server: productName=ElasticSearch, productVersion=7.17.1, driverName=org.elasticsearch.client.RestHighLevelClient, driverVersion=7.17.1 2022-10-04 21:43:55,658 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Appian component Search Server is healthy 2022-10-04 21:43:58,201 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:44:03,211 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:44:08,216 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:44:13,230 [wait-for-component] ERROR com.appiancorp.common.startup.healthcheck.PrimaryRdbmsHealthCheck - javax.naming.NameNotFoundException: Name [appian223Primary] is not bound in this Context. Unable to find [appian223Primary]. 2022-10-04 21:44:13,230 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:44:18,235 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:44:23,247 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:44:28,260 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:44:33,262 [wait-for-component] ERROR com.appiancorp.common.startup.healthcheck.PrimaryRdbmsHealthCheck - javax.naming.NameNotFoundException: Name [appian223Primary] is not bound in this Context. Unable to find [appian223Primary]. 2022-10-04 21:44:33,262 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:44:38,272 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:44:43,272 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:44:48,277 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:44:53,287 [wait-for-component] ERROR com.appiancorp.common.startup.healthcheck.PrimaryRdbmsHealthCheck - javax.naming.NameNotFoundException: Name [appian223Primary] is not bound in this Context. Unable to find [appian223Primary]. 2022-10-04 21:44:53,287 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:44:58,297 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:45:03,306 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:45:08,318 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:45:13,332 [wait-for-component] ERROR com.appiancorp.common.startup.healthcheck.PrimaryRdbmsHealthCheck - javax.naming.NameNotFoundException: Name [appian223Primary] is not bound in this Context. Unable to find [appian223Primary]. 2022-10-04 21:45:13,332 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:45:18,347 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:45:23,362 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:45:28,365 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:45:33,381 [wait-for-component] ERROR com.appiancorp.common.startup.healthcheck.PrimaryRdbmsHealthCheck - javax.naming.NameNotFoundException: Name [appian223Primary] is not bound in this Context. Unable to find [appian223Primary]. 2022-10-04 21:45:33,381 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:45:38,391 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:45:43,395 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:45:48,395 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:45:53,408 [wait-for-component] ERROR com.appiancorp.common.startup.healthcheck.PrimaryRdbmsHealthCheck - javax.naming.NameNotFoundException: Name [appian223Primary] is not bound in this Context. Unable to find [appian223Primary]. 2022-10-04 21:45:53,408 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:45:58,412 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:46:03,423 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:46:08,432 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:46:13,440 [wait-for-component] ERROR com.appiancorp.common.startup.healthcheck.PrimaryRdbmsHealthCheck - javax.naming.NameNotFoundException: Name [appian223Primary] is not bound in this Context. Unable to find [appian223Primary]. 2022-10-04 21:46:13,440 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:46:18,440 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:46:23,441 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:46:28,452 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:46:33,464 [wait-for-component] ERROR com.appiancorp.common.startup.healthcheck.PrimaryRdbmsHealthCheck - javax.naming.NameNotFoundException: Name [appian223Primary] is not bound in this Context. Unable to find [appian223Primary]. 2022-10-04 21:46:33,464 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:46:38,477 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:46:43,483 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:46:48,488 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:46:53,502 [wait-for-component] ERROR com.appiancorp.common.startup.healthcheck.PrimaryRdbmsHealthCheck - javax.naming.NameNotFoundException: Name [appian223Primary] is not bound in this Context. Unable to find [appian223Primary]. 2022-10-04 21:46:53,503 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:46:58,507 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:47:03,519 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:47:08,521 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:47:13,527 [wait-for-component] ERROR com.appiancorp.common.startup.healthcheck.PrimaryRdbmsHealthCheck - javax.naming.NameNotFoundException: Name [appian223Primary] is not bound in this Context. Unable to find [appian223Primary]. 2022-10-04 21:47:13,527 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:47:18,530 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:47:23,541 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:47:28,545 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:47:33,548 [wait-for-component] ERROR com.appiancorp.common.startup.healthcheck.PrimaryRdbmsHealthCheck - javax.naming.NameNotFoundException: Name [appian223Primary] is not bound in this Context. Unable to find [appian223Primary]. 2022-10-04 21:47:33,548 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:47:38,550 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:47:43,552 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:47:48,567 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:47:53,569 [wait-for-component] ERROR com.appiancorp.common.startup.healthcheck.PrimaryRdbmsHealthCheck - javax.naming.NameNotFoundException: Name [appian223Primary] is not bound in this Context. Unable to find [appian223Primary]. 2022-10-04 21:47:53,569 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:47:58,579 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:48:03,586 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:48:08,599 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:48:13,612 [wait-for-component] ERROR com.appiancorp.common.startup.healthcheck.PrimaryRdbmsHealthCheck - javax.naming.NameNotFoundException: Name [appian223Primary] is not bound in this Context. Unable to find [appian223Primary]. 2022-10-04 21:48:13,612 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:48:18,622 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:48:23,637 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:48:28,646 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:48:33,662 [wait-for-component] ERROR com.appiancorp.common.startup.healthcheck.PrimaryRdbmsHealthCheck - javax.naming.NameNotFoundException: Name [appian223Primary] is not bound in this Context. Unable to find [appian223Primary]. 2022-10-04 21:48:33,662 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:48:38,677 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:48:43,688 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:48:48,702 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:48:53,709 [wait-for-component] ERROR com.appiancorp.common.startup.healthcheck.PrimaryRdbmsHealthCheck - javax.naming.NameNotFoundException: Name [appian223Primary] is not bound in this Context. Unable to find [appian223Primary]. 2022-10-04 21:48:53,709 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:48:58,722 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:49:03,738 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:49:08,742 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:49:13,745 [wait-for-component] ERROR com.appiancorp.common.startup.healthcheck.PrimaryRdbmsHealthCheck - javax.naming.NameNotFoundException: Name [appian223Primary] is not bound in this Context. Unable to find [appian223Primary]. 2022-10-04 21:49:13,745 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:49:18,760 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:49:23,770 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:49:28,775 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:49:33,785 [wait-for-component] ERROR com.appiancorp.common.startup.healthcheck.PrimaryRdbmsHealthCheck - javax.naming.NameNotFoundException: Name [appian223Primary] is not bound in this Context. Unable to find [appian223Primary]. 2022-10-04 21:49:33,785 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:49:38,793 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:49:43,808 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:49:48,810 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:49:53,822 [wait-for-component] ERROR com.appiancorp.common.startup.healthcheck.PrimaryRdbmsHealthCheck - javax.naming.NameNotFoundException: Name [appian223Primary] is not bound in this Context. Unable to find [appian223Primary]. 2022-10-04 21:49:53,822 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:49:58,828 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:50:03,834 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:50:08,835 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:50:13,842 [wait-for-component] ERROR com.appiancorp.common.startup.healthcheck.PrimaryRdbmsHealthCheck - javax.naming.NameNotFoundException: Name [appian223Primary] is not bound in this Context. Unable to find [appian223Primary]. 2022-10-04 21:50:13,843 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:50:18,845 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:50:23,851 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:50:28,866 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:50:33,871 [wait-for-component] ERROR com.appiancorp.common.startup.healthcheck.PrimaryRdbmsHealthCheck - javax.naming.NameNotFoundException: Name [appian223Primary] is not bound in this Context. Unable to find [appian223Primary]. 2022-10-04 21:50:33,871 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:50:38,884 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:50:43,892 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:50:48,897 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:50:53,911 [wait-for-component] ERROR com.appiancorp.common.startup.healthcheck.PrimaryRdbmsHealthCheck - javax.naming.NameNotFoundException: Name [appian223Primary] is not bound in this Context. Unable to find [appian223Primary]. 2022-10-04 21:50:53,911 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:50:58,924 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:51:03,930 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:51:08,938 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:51:13,949 [wait-for-component] ERROR com.appiancorp.common.startup.healthcheck.PrimaryRdbmsHealthCheck - javax.naming.NameNotFoundException: Name [appian223Primary] is not bound in this Context. Unable to find [appian223Primary]. 2022-10-04 21:51:13,949 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:51:18,961 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:51:23,967 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:51:28,972 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:51:33,985 [wait-for-component] ERROR com.appiancorp.common.startup.healthcheck.PrimaryRdbmsHealthCheck - javax.naming.NameNotFoundException: Name [appian223Primary] is not bound in this Context. Unable to find [appian223Primary]. 2022-10-04 21:51:33,985 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:51:38,997 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:51:44,013 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:51:49,027 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:51:54,034 [wait-for-component] ERROR com.appiancorp.common.startup.healthcheck.PrimaryRdbmsHealthCheck - javax.naming.NameNotFoundException: Name [appian223Primary] is not bound in this Context. Unable to find [appian223Primary]. 2022-10-04 21:51:54,034 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:51:59,043 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:52:04,044 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:52:09,048 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:52:14,056 [wait-for-component] ERROR com.appiancorp.common.startup.healthcheck.PrimaryRdbmsHealthCheck - javax.naming.NameNotFoundException: Name [appian223Primary] is not bound in this Context. Unable to find [appian223Primary]. 2022-10-04 21:52:14,056 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:52:19,066 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:52:24,078 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:52:29,089 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:52:34,102 [wait-for-component] ERROR com.appiancorp.common.startup.healthcheck.PrimaryRdbmsHealthCheck - javax.naming.NameNotFoundException: Name [appian223Primary] is not bound in this Context. Unable to find [appian223Primary]. 2022-10-04 21:52:34,102 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:52:39,105 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:52:44,120 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:52:49,123 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:52:54,132 [wait-for-component] ERROR com.appiancorp.common.startup.healthcheck.PrimaryRdbmsHealthCheck - javax.naming.NameNotFoundException: Name [appian223Primary] is not bound in this Context. Unable to find [appian223Primary]. 2022-10-04 21:52:54,133 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:52:59,142 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:53:04,157 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:53:09,166 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:53:14,173 [wait-for-component] ERROR com.appiancorp.common.startup.healthcheck.PrimaryRdbmsHealthCheck - javax.naming.NameNotFoundException: Name [appian223Primary] is not bound in this Context. Unable to find [appian223Primary]. 2022-10-04 21:53:14,173 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:53:19,176 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:53:24,191 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:53:29,195 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:53:34,212 [wait-for-component] ERROR com.appiancorp.common.startup.healthcheck.PrimaryRdbmsHealthCheck - javax.naming.NameNotFoundException: Name [appian223Primary] is not bound in this Context. Unable to find [appian223Primary]. 2022-10-04 21:53:34,212 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:53:39,225 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:53:44,231 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:53:49,235 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:53:54,238 [wait-for-component] ERROR com.appiancorp.common.startup.healthcheck.PrimaryRdbmsHealthCheck - javax.naming.NameNotFoundException: Name [appian223Primary] is not bound in this Context. Unable to find [appian223Primary]. 2022-10-04 21:53:54,238 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:53:59,241 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:54:04,254 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:54:09,257 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:54:14,269 [wait-for-component] ERROR com.appiancorp.common.startup.healthcheck.PrimaryRdbmsHealthCheck - javax.naming.NameNotFoundException: Name [appian223Primary] is not bound in this Context. Unable to find [appian223Primary]. 2022-10-04 21:54:14,269 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:54:19,280 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:54:24,288 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:54:29,297 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:54:34,301 [wait-for-component] ERROR com.appiancorp.common.startup.healthcheck.PrimaryRdbmsHealthCheck - javax.naming.NameNotFoundException: Name [appian223Primary] is not bound in this Context. Unable to find [appian223Primary]. 2022-10-04 21:54:34,302 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:54:39,316 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:54:44,329 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:54:49,338 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:54:54,353 [wait-for-component] ERROR com.appiancorp.common.startup.healthcheck.PrimaryRdbmsHealthCheck - javax.naming.NameNotFoundException: Name [appian223Primary] is not bound in this Context. Unable to find [appian223Primary]. 2022-10-04 21:54:54,353 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:54:59,357 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:55:04,369 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:55:09,383 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-04 21:55:14,394 [wait-for-component] ERROR com.appiancorp.common.startup.healthcheck.PrimaryRdbmsHealthCheck - javax.naming.NameNotFoundException: Name [appian223Primary] is not bound in this Context. Unable to find [appian223Primary]. 2022-10-04 21:55:14,394 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy...
also tried this https://community.appian.com/support/w/kb/1138/kb-1718-tomcat-fails-to-deploy-appian-or-start-all-services-successfully but the error still exists.
Discussion posts and replies are publicly visible
Which relational database and jdbc driver version are you using? I think you have an unsupported driver installed and the app server can't connect with the db. Check here the supported DB's and drivers:
https://docs.appian.com/suite/help/22.3/System_Requirements.html#databases
Hi Dimitris, I was using MySQL 8.0.30 and Connector/J 8.0.30. Then, I change to Connector/J 5.1.49. After changing and restarting the process, the issue is still the same.
Can you post the new logs and the configuration of the Appian primary DB if possible..
Using CATALINA_BASE: "C:\appian223\appian\tomcat\apache-tomcat" Using CATALINA_HOME: "C:\appian223\appian\tomcat\apache-tomcat" Using CATALINA_TMPDIR: "C:\appian223\appian\tomcat\apache-tomcat\temp" Using JRE_HOME: "C:\appian223\appian\java" Using CLASSPATH: "C:\appian223\appian\tomcat\apache-tomcat\bin\bootstrap.jar;C:\appian223\appian\tomcat\apache-tomcat\bin\tomcat-juli.jar" Using CATALINA_OPTS: " -Dfile.encoding=UTF-8 -Duser.timezone=GMT -Djava.naming.factory.initial=com.appiancorp.tomcat.naming.TomcatInitialContextFactory -Djava.awt.headless=true -Djava.net.preferIPv4Stack=true -Dorg.osgi.framework.security=osgi -Dsun.net.inetaddr.ttl=60 -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000 -Dtomcat.cacheArchiveEntries=true -Dio.opentracing.contrib.jdbc.excludeFastQueryThresholdMs=100 -Dio.opentracing.contrib.jdbc.slowQueryThresholdMs=200 -XX:-TieredCompilation -XX:ReservedCodeCacheSize=256M -XX:+UseG1GC -XX:+ExplicitGCInvokesConcurrent -XX:+UseStringDeduplication -XX:+PrintGCDetails -XX:+PrintGCDateStamps -XX:+UseGCLogFileRotation -XX:+PrintGCApplicationStoppedTime -XX:+PrintGCApplicationConcurrentTime -XX:+SafepointTimeout -XX:SafepointTimeoutDelay=10000 -XX:NumberOfGCLogFiles=25 -XX:GCLogFileSize=3M -XX:+HeapDumpOnOutOfMemoryError -XX:+UseMembar -verbose:gc -Dae.home=C:\appian223\appian -Xloggc:C:\appian223\appian\logs\tomcat\gc.log -Xms2048m -Xmx2048m" Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Server version name: Apache Tomcat/8.5.82 Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Server built: Aug 8 2022 21:26:07 UTC Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Server version number: 8.5.82.0 Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: OS Name: Windows 10 Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: OS Version: 10.0 Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Architecture: amd64 Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Java Home: C:\appian223\appian\java\jre Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: JVM Version: 1.8.0_345-b01 Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: JVM Vendor: Temurin Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: CATALINA_BASE: C:\appian223\appian\tomcat\apache-tomcat Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: CATALINA_HOME: C:\appian223\appian\tomcat\apache-tomcat Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Djava.util.logging.config.file=C:\appian223\appian\tomcat\apache-tomcat\conf\logging.properties Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Djdk.tls.ephemeralDHKeySize=2048 Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Dfile.encoding=UTF-8 Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Duser.timezone=GMT Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Djava.naming.factory.initial=com.appiancorp.tomcat.naming.TomcatInitialContextFactory Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Djava.awt.headless=true Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Djava.net.preferIPv4Stack=true Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Dorg.osgi.framework.security=osgi Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Dsun.net.inetaddr.ttl=60 Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Dsun.rmi.dgc.client.gcInterval=3600000 Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Dsun.rmi.dgc.server.gcInterval=3600000 Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Dtomcat.cacheArchiveEntries=true Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Dio.opentracing.contrib.jdbc.excludeFastQueryThresholdMs=100 Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Dio.opentracing.contrib.jdbc.slowQueryThresholdMs=200 Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -XX:-TieredCompilation Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -XX:ReservedCodeCacheSize=256M Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -XX:+UseG1GC Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -XX:+ExplicitGCInvokesConcurrent Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -XX:+UseStringDeduplication Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -XX:+PrintGCDetails Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -XX:+PrintGCDateStamps Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -XX:+UseGCLogFileRotation Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -XX:+PrintGCApplicationStoppedTime Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -XX:+PrintGCApplicationConcurrentTime Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -XX:+SafepointTimeout Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -XX:SafepointTimeoutDelay=10000 Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -XX:NumberOfGCLogFiles=25 Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -XX:GCLogFileSize=3M Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -XX:+HeapDumpOnOutOfMemoryError Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -XX:+UseMembar Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -verbose:gc Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Dae.home=C:\appian223\appian Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Xloggc:C:\appian223\appian\logs\tomcat\gc.log Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Xms2048m Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Xmx2048m Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Dignore.endorsed.dirs= Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Dcatalina.base=C:\appian223\appian\tomcat\apache-tomcat Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Dcatalina.home=C:\appian223\appian\tomcat\apache-tomcat Oct 05, 2022 2:55:52 AM org.apache.catalina.startup.VersionLoggerListener log INFO: Command line argument: -Djava.io.tmpdir=C:\appian223\appian\tomcat\apache-tomcat\temp Oct 05, 2022 2:55:53 AM org.apache.coyote.AbstractProtocol init INFO: Initializing ProtocolHandler ["http-nio-8080"] Oct 05, 2022 2:55:53 AM org.apache.coyote.AbstractProtocol init INFO: Initializing ProtocolHandler ["ajp-nio-0.0.0.0-8009"] Oct 05, 2022 2:55:53 AM org.apache.catalina.startup.Catalina load INFO: Initialization processed in 731 ms Oct 05, 2022 2:55:53 AM org.apache.catalina.core.StandardService startInternal INFO: Starting service [Catalina] Oct 05, 2022 2:55:53 AM org.apache.catalina.core.StandardEngine startInternal INFO: Starting Servlet engine: [Apache Tomcat/8.5.82] Oct 05, 2022 2:55:53 AM org.apache.catalina.startup.HostConfig deployDescriptor INFO: Deploying deployment descriptor [C:\appian223\appian\tomcat\apache-tomcat\conf\Catalina\localhost\suite.xml] Tomcat Cache Archive Entries [true] Oct 05, 2022 2:56:02 AM org.apache.tomcat.jdbc.pool.ConnectionPool init SEVERE: Unable to create initial connections of pool. java.sql.SQLException: Unable to load class: com.mysql.cj.jdbc.Driver from ClassLoader:java.net.URLClassLoader@4a574795;ClassLoader:AppianWebappClassLoader context: suite delegate: false ----------> Parent Classloader: java.net.URLClassLoader@4a574795 at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:316) at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:228) at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:764) at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:692) at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:496) at org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:154) at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:121) at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:110) at org.apache.tomcat.jdbc.pool.DataSourceFactory.createDataSource(DataSourceFactory.java:560) at org.apache.tomcat.jdbc.pool.DataSourceFactory.getObjectInstance(DataSourceFactory.java:244) at com.appiancorp.tomcat.datasource.EncodedPasswordDataSourceFactory.getObjectInstance(EncodedPasswordDataSourceFactory.java:52) at org.apache.naming.factory.FactoryBase.getObjectInstance(FactoryBase.java:96) at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:332) at org.apache.naming.NamingContext.lookup(NamingContext.java:846) at org.apache.naming.NamingContext.lookup(NamingContext.java:157) at org.apache.naming.NamingContext.lookup(NamingContext.java:834) at org.apache.naming.NamingContext.lookup(NamingContext.java:171) at org.apache.catalina.core.NamingContextListener.addResource(NamingContextListener.java:1013) at org.apache.catalina.core.NamingContextListener.createNamingContext(NamingContextListener.java:552) at org.apache.catalina.core.NamingContextListener.lifecycleEvent(NamingContextListener.java:245) at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:123) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5130) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:753) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:727) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:695) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:673) at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1881) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:750) Caused by: java.lang.ClassNotFoundException: Unable to load class: com.mysql.cj.jdbc.Driver from ClassLoader:java.net.URLClassLoader@4a574795;ClassLoader:AppianWebappClassLoader context: suite delegate: false ----------> Parent Classloader: java.net.URLClassLoader@4a574795 at org.apache.tomcat.jdbc.pool.ClassLoaderUtil.loadClass(ClassLoaderUtil.java:56) at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:305) ... 32 more Caused by: java.lang.ClassNotFoundException: com.mysql.cj.jdbc.Driver at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1420) at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1228) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:348) at org.apache.tomcat.jdbc.pool.ClassLoaderUtil.loadClass(ClassLoaderUtil.java:38) ... 33 more Oct 05, 2022 2:56:02 AM org.apache.naming.NamingContext lookup WARNING: Unexpected exception resolving reference java.sql.SQLException: Unable to load class: com.mysql.cj.jdbc.Driver from ClassLoader:java.net.URLClassLoader@4a574795;ClassLoader:AppianWebappClassLoader context: suite delegate: false ----------> Parent Classloader: java.net.URLClassLoader@4a574795 at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:316) at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:228) at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:764) at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:692) at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:496) at org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:154) at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:121) at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:110) at org.apache.tomcat.jdbc.pool.DataSourceFactory.createDataSource(DataSourceFactory.java:560) at org.apache.tomcat.jdbc.pool.DataSourceFactory.getObjectInstance(DataSourceFactory.java:244) at com.appiancorp.tomcat.datasource.EncodedPasswordDataSourceFactory.getObjectInstance(EncodedPasswordDataSourceFactory.java:52) at org.apache.naming.factory.FactoryBase.getObjectInstance(FactoryBase.java:96) at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:332) at org.apache.naming.NamingContext.lookup(NamingContext.java:846) at org.apache.naming.NamingContext.lookup(NamingContext.java:157) at org.apache.naming.NamingContext.lookup(NamingContext.java:834) at org.apache.naming.NamingContext.lookup(NamingContext.java:171) at org.apache.catalina.core.NamingContextListener.addResource(NamingContextListener.java:1013) at org.apache.catalina.core.NamingContextListener.createNamingContext(NamingContextListener.java:552) at org.apache.catalina.core.NamingContextListener.lifecycleEvent(NamingContextListener.java:245) at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:123) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5130) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:753) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:727) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:695) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:673) at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1881) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:750) Caused by: java.lang.ClassNotFoundException: Unable to load class: com.mysql.cj.jdbc.Driver from ClassLoader:java.net.URLClassLoader@4a574795;ClassLoader:AppianWebappClassLoader context: suite delegate: false ----------> Parent Classloader: java.net.URLClassLoader@4a574795 at org.apache.tomcat.jdbc.pool.ClassLoaderUtil.loadClass(ClassLoaderUtil.java:56) at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:305) ... 32 more Caused by: java.lang.ClassNotFoundException: com.mysql.cj.jdbc.Driver at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1420) at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1228) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:348) at org.apache.tomcat.jdbc.pool.ClassLoaderUtil.loadClass(ClassLoaderUtil.java:38) ... 33 more Oct 05, 2022 2:56:02 AM org.apache.catalina.core.NamingContextListener addResource WARNING: Failed to register in JMX: [javax.naming.NamingException: Unexpected exception resolving reference [Root exception is java.sql.SQLException: Unable to load class: com.mysql.cj.jdbc.Driver from ClassLoader:java.net.URLClassLoader@4a574795;ClassLoader:AppianWebappClassLoader context: suite delegate: false ----------> Parent Classloader: java.net.URLClassLoader@4a574795 ]] Oct 05, 2022 2:56:05 AM org.apache.catalina.core.ApplicationContext log INFO: No Spring WebApplicationInitializer types detected on classpath log4j:WARN No appenders could be found for logger (org.apache.commons.configuration.PropertiesConfiguration). log4j:WARN Please initialize the log4j system properly. log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info. log4j:WARN Exception while initializing AppianRollingFileAppender named 'INTEGRATION_REQ_RESP_ALL' java.util.regex.PatternSyntaxException: Illegal/unsupported escape sequence near index 20 C:\appian223\appian\logs/perflogs/http-requests-and-responses/integration_req_resp_activity(\.[0-9]{4}_[0-9]{2}_[0-9]{2})\.([0-9]+).log ^ at java.util.regex.Pattern.error(Pattern.java:1969) at java.util.regex.Pattern.escape(Pattern.java:2485) at java.util.regex.Pattern.atom(Pattern.java:2212) at java.util.regex.Pattern.sequence(Pattern.java:2144) at java.util.regex.Pattern.expr(Pattern.java:2010) at java.util.regex.Pattern.compile(Pattern.java:1702) at java.util.regex.Pattern.<init>(Pattern.java:1352) at java.util.regex.Pattern.compile(Pattern.java:1028) at com.appiancorp.common.logging.rolling.RollingUtils.getFilePathPattern(RollingUtils.java:76) at com.appiancorp.common.logging.rolling.DailyRollingPolicyDeleteManager.initialize(DailyRollingPolicyDeleteManager.java:51) at com.appiancorp.common.logging.rolling.DailyRollingPolicy.initialize(DailyRollingPolicy.java:121) at com.appiancorp.common.logging.rolling.AppianRollingFileAppender.activateOptions(AppianRollingFileAppender.java:74) at org.apache.log4j.config.PropertySetter.activate(PropertySetter.java:284) at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:160) at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:100) at org.apache.log4j.PropertyConfigurator.parseAppender(PropertyConfigurator.java:802) at org.apache.log4j.PropertyConfigurator.parseCategory(PropertyConfigurator.java:738) at org.apache.log4j.PropertyConfigurator.parseCatsAndRenderers(PropertyConfigurator.java:652) at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:518) at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:421) at com.appiancorp.common.logging.LoggingPropertyWatchdog.doOnChange(LoggingPropertyWatchdog.java:20) at org.apache.log4j.helpers.FileWatchdog.checkAndConfigure(FileWatchdog.java:85) at org.apache.log4j.helpers.FileWatchdog.<init>(FileWatchdog.java:59) at com.appiancorp.common.logging.LoggingPropertyWatchdog.<init>(LoggingPropertyWatchdog.java:13) at com.appiancorp.common.logging.LoggingPropertyConfigurator.configureAndWatch(LoggingPropertyConfigurator.java:34) at com.appiancorp.common.logging.LoggingPropertyConfigurator.configureFile(LoggingPropertyConfigurator.java:22) at com.appiancorp.common.logging.ConfigureLog4j.configure(ConfigureLog4j.java:284) at com.appiancorp.common.logging.ConfigureLog4j.configure(ConfigureLog4j.java:134) at com.appiancorp.common.logging.ConfigureLog4j.initialize(ConfigureLog4j.java:55) at com.appiancorp.common.logging.ConfigureLog4j.contextInitialized(ConfigureLog4j.java:64) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4763) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5232) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:753) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:727) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:695) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:673) at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1881) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:750) 2022-10-05 02:56:06,363 [wait-for-component] INFO com.appiancorp.tools.WaitForServers - Waiting for servers to be up... 2022-10-05 02:56:06,378 [wait-for-component] INFO com.appiancorp.common.persistence.search.SearchServerClientConfiguration - Using the Search Server client configuration specified in C:\appian223\appian\conf\appian-topology.xml. 2022-10-05 02:56:06,528 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-05 02:56:06,598 [wait-for-component] INFO com.appiancorp.common.persistence.search.AppianSearchSpringConfig - initializing client with server addresses: [localhost:9200] 2022-10-05 02:56:07,123 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Appian component Data Server is healthy 2022-10-05 02:56:07,578 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Appian component Kafka Topics is healthy 2022-10-05 02:56:07,918 [wait-for-component] INFO com.appiancorp.cache.CacheBase - Initializing Cache komodo_lastUpdateTxId [com.appiancorp.cache.DefaultLirsCacheWrapper] with Configuration: {appian.cacheattributes.MaxSpoolPerRun=-1, appian.cacheattributes.MemoryCacheName=com.appiancorp.cache.JavaCachingSystemLirs, appian.cacheattributes.MaxObjects=10000, appian.cache.metrics.tracingEnabled=false, appian.cacheattributes.MaxEntrySizeBytes=-1, appian.cacheattributes.MaxCacheSizeBytes=-1, appian.cacheattributes.SegmentCount=-1, appian.cacheattributes.distributionMode=LOCAL_WITH_DISTRIBUTED_CLEAR, appian.elementattributes.MaxLifeSeconds=-1, appian.cacheattributes.cacheKey=komodo_lastUpdateTxId, appian.cacheattributes.bytesTrackingEnabled=false, appian.cacheattributes.MaxMemoryIdleTimeSeconds=300, appian.cacheattributes.cacheName=komodo_lastUpdateTxId, appian.cacheattributes.ShrinkerIntervalSeconds=3600} 2022-10-05 02:56:07,936 [wait-for-component] INFO com.appiancorp.tools.WaitForServers - Waiting for analytics to be ready... 2022-10-05 02:56:08,051 [wait-for-component] INFO com.appiancorp.cache.CacheBase - Initializing Cache types.type [com.appiancorp.cache.DefaultLirsCacheWrapper] with Configuration: {appian.cacheattributes.MemoryCacheName=com.appiancorp.cache.JavaCachingSystemCoupledLirs, appian.cacheattributes.MaxObjects=20000, //=AN-165948 use a single segment to work around deadlocks due to coupled keys having different hashes, appian.cacheattributes.SegmentCount=1, appian.cacheattributes.distributionMode=LOCAL_WITH_DISTRIBUTED_CLEAR, appian.cacheattributes.cacheKey=appian/cache/jcs-datatype-config.ccf, appian.cacheattributes.MaxMemoryIdleTimeSeconds=14400, appian.cacheattributes.cacheName=types.type, appian.cacheattributes.ShrinkerIntervalSeconds=3600} 2022-10-05 02:56:08,109 [wait-for-component] INFO com.appiancorp.cache.CacheBase - Initializing Cache userPreferences [com.appiancorp.cache.DefaultLirsCacheWrapper] with Configuration: {appian.cacheattributes.MaxMemoryIdleTimeSeconds=1200, appian.cache.metrics.collectFullMetrics=false, appian.cacheattributes.ShrinkerIntervalSeconds=600, appian.cacheattributes.distributionMode=LOCAL_WITH_DISTRIBUTED_CLEAR, appian.cacheattributes.MaxObjects=5000, appian.cacheattributes.cacheKey=appian/cache/jcs-userPreferences-config.ccf, appian.cacheattributes.MemoryCacheName=com.appiancorp.cache.JavaCachingSystemLirs, appian.cacheattributes.cacheName=userPreferences} 2022-10-05 02:56:08,141 [wait-for-component] INFO com.appiancorp.cache.CacheBase - Initializing Cache globalization [com.appiancorp.cache.DefaultLirsCacheWrapper] with Configuration: {appian.cacheattributes.MaxMemoryIdleTimeSeconds=14400, appian.cache.metrics.collectFullMetrics=false, appian.cacheattributes.ShrinkerIntervalSeconds=3600, appian.cacheattributes.distributionMode=LOCAL_WITH_DISTRIBUTED_CLEAR, appian.cacheattributes.MaxObjects=10, appian.cacheattributes.cacheKey=appian/cache/jcs-globalization-config.ccf, appian.cacheattributes.MemoryCacheName=com.appiancorp.cache.JavaCachingSystemLirs, appian.cacheattributes.cacheName=globalization} 2022-10-05 02:56:08,145 [wait-for-component] INFO com.appiancorp.cache.CacheBase - Initializing Cache i18n [com.appiancorp.cache.DefaultLirsCacheWrapper] with Configuration: {appian.cacheattributes.MaxMemoryIdleTimeSeconds=14400, appian.cache.metrics.collectFullMetrics=false, appian.cacheattributes.ShrinkerIntervalSeconds=3600, appian.cacheattributes.distributionMode=LOCAL_ONLY, appian.cacheattributes.MaxObjects=1500, appian.cacheattributes.cacheKey=appian/cache/jcs-i18n-config.ccf, appian.cacheattributes.MemoryCacheName=com.appiancorp.cache.JavaCachingSystemLirs, appian.cacheattributes.cacheName=i18n} 2022-10-05 02:56:08,191 [wait-for-component] INFO com.appiancorp.cache.CacheBase - Initializing Cache groupNames [com.appiancorp.cache.DefaultLirsCacheWrapper] with Configuration: {appian.cacheattributes.MemoryCacheName=com.appiancorp.cache.JavaCachingSystemLirs, appian.cacheattributes.MaxObjects=5000, appian.cache.metrics.collectFullMetrics=false, appian.cacheattributes.distributionMode=LOCAL_WITH_DISTRIBUTED_CLEAR, appian.cacheattributes.cacheKey=appian/cache/jcs-groupNameCache-config.ccf, appian.elementattributes.MaxLifeSeconds=5400, appian.cacheattributes.MaxMemoryIdleTimeSeconds=1800, appian.cacheattributes.cacheName=groupNames, appian.cacheattributes.ShrinkerIntervalSeconds=2700} 2022-10-05 02:56:08,193 [wait-for-component] INFO com.appiancorp.cache.CacheBase - Initializing Cache groupMemberships [com.appiancorp.cache.DefaultLirsCacheWrapper] with Configuration: {appian.cacheattributes.MaxMemoryIdleTimeSeconds=1200, appian.cache.metrics.collectFullMetrics=false, appian.cacheattributes.ShrinkerIntervalSeconds=600, appian.cacheattributes.distributionMode=LOCAL_WITH_DISTRIBUTED_CLEAR, appian.cacheattributes.MaxObjects=5000, appian.cacheattributes.cacheKey=appian/cache/jcs-groupMembershipCache-config.ccf, appian.cacheattributes.MemoryCacheName=com.appiancorp.cache.JavaCachingSystemLirs, appian.cacheattributes.cacheName=groupMemberships} 2022-10-05 02:56:08,437 [wait-for-component] INFO com.appiancorp.tools.WaitForServers - ... done. 2022-10-05 02:56:08,820 [wait-for-component] INFO com.appiancorp.common.persistence.search.AppianSearchSpringConfig - client configured nodes: [[host=http://localhost:9200]] 2022-10-05 02:56:08,953 [wait-for-component] INFO com.appiancorp.cache.CacheBase - Initializing Cache favoritesCache [com.appiancorp.cache.DefaultLirsCacheWrapper] with Configuration: {appian.cacheattributes.MemoryCacheName=com.appiancorp.cache.JavaCachingSystemLirs, appian.cacheattributes.MaxObjects=40000, appian.cache.metrics.collectFullMetrics=false, appian.cacheattributes.distributionMode=LOCAL_ONLY, appian.cacheattributes.cacheKey=appian/cache/jcs-favoritesCache-config.ccf, appian.elementattributes.MaxLifeSeconds=7200, appian.cacheattributes.MaxMemoryIdleTimeSeconds=7200, appian.cacheattributes.cacheName=favoritesCache, appian.cacheattributes.ShrinkerIntervalSeconds=10800} 2022-10-05 02:56:08,991 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Appian component Engines is healthy 2022-10-05 02:56:09,011 [wait-for-component] INFO com.appiancorp.common.persistence.search.AppianSearchSpringConfig - search server: productName=ElasticSearch, productVersion=7.17.1, driverName=org.elasticsearch.client.RestHighLevelClient, driverVersion=7.17.1 2022-10-05 02:56:09,057 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Appian component Search Server is healthy 2022-10-05 02:56:11,534 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-05 02:56:16,540 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-05 02:56:21,556 [wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy... 2022-10-05 02:56:26,562 [wait-for-component] ERROR com.appiancorp.common.startup.healthcheck.PrimaryRdbmsHealthCheck - javax.naming.NameNotFoundException: Name [appian223Primary] is not bound in this Context. Unable to find [appian223Primary]
Did you configure the connection between Appian and the server where the DB is installed?
Here is what I mean:
https://docs.appian.com/suite/help/22.3/Configuring_Relational_Databases.html#mysql
For setting up the primary database you have to follow exactly what is mentioned here in the "RDBMS Configuration" section:
https://docs.appian.com/suite/help/22.3/Windows_Installation_Guide.html#rdbms-configurations
Don't forget to do all the configurations in the REPO location and then deploy them to your Appian instance.
Yes, I did those steps.
tomcat resources xml:
<Resource name="jdbc/MySqlDataSource" factory="com.appiancorp.tomcat.datasource.EncodedPasswordDataSourceFactory" type="javax.sql.DataSource" driverClassName="com.mysql.cj.jdbc.Driver" url="jdbc:mysql://practice-aws-db.cpkrckzng6iv.us-east-1.rds.amazonaws.com:3306/appian223Primary?useOldAliasMetadataBehavior=true" username="username here" password="encoded password here" initialSize="5" maxActive="200" defaultTransactionIsolation="READ_COMMITTED" maxWait="30000" minIdle="5" minEvictableIdleTimeMillis="90000" timeBetweenEvictionRunsMillis="450000" validationQuery="SELECT 1" testOnBorrow="true"/>custom.properties:
########################## Data Sources ##########################
## Appian must have a dedicated data source. Set the value to the JNDI name of## the data source that will be used as the Appian data source.## Note: This data source must point to a separate tablespace than any listed## in the conf.data.datasources configuration.conf.data.APPIAN_DATA_SOURCE=jdbc/appian223Primary## Comma-separated list of JNDI names of data sources on the application server## that will be used to store business data. This list is used by the Query## Database smart service and Data Stores.#conf.data.datasources=
for the tomcat I just the driverClassName com.mysql.cj.jdbc.Driver to com.mysql.jdbc.Driver to remove one of the error above.
Based on the documentation the driverClassName config should be:
driverClassName="com.mysql.jdbc.Driver"
and in your config file is:
driverClassName="com.mysql.cj.jdbc.Driver"
Check your logs also:
Oct 05, 2022 2:56:02 AM org.apache.tomcat.jdbc.pool.ConnectionPool initSEVERE: Unable to create initial connections of pool.java.sql.SQLException: Unable to load class: com.mysql.cj.jdbc.Driver from ClassLoader:java.net.URLClassLoader@4a574795;ClassLoader:AppianWebappClassLoader context: suite delegate: false----------> Parent Classloader:java.net.URLClassLoader@4a574795
at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:316)
Yes, I just did that to remove the error java.sql.SQLException: Unable to load.But the issue is still there.
[wait-for-component] ERROR com.appiancorp.common.startup.healthcheck.PrimaryRdbmsHealthCheck - javax.naming.NameNotFoundException: Name [appian223Primary] is not bound in this Context. Unable to find [appian223Primary].[wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy...[wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy...[wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy...[wait-for-component] INFO com.appiancorp.common.startup.WaitForStatefulComponents - Waiting for Appian component Primary datasource RDBMS to be healthy...
Yes, I was able to do that and it removed the error on java.sql.SQLException: Unable to load class.For the error javax.naming.NameNotFoundException: Name [appian223Primary] is not bound in this Context. Unable to find [appian223Primary]. It is still there.
In the custom.properties file, you should put the same JNDI name that you configured before in tomcatResources.xml file. The names should match. So in your case, the config should be:
conf.data.APPIAN_DATA_SOURCE=jdbc/MySqlDataSource
<Resource name="jdbc/MySqlDataSource"
Thank you Dimitris. It's working now.