1. Have the engines been started successfully? 2. Can you attach the output of running /server/_scripts/diagnostic/checkengine.bat =================================================================== _APP_ _ACTIVE_GW_ _STATUS_ _ISSUES_ Discussion Forums 1/1 Okay Notifications Service 1/1 Okay Notifications Email Processor 1/1 Okay Channels 1/1 Okay Collaboration 1/1 Okay Collaboration Statistics 1/1 Okay Personalization 1/1 Okay Portal 1/1 Okay Process-Design 1/1 Okay Process-Analytics0000 1/1 Okay Process-Analytics0001 1/1 Okay Process-Analytics0002 1/1 Okay Process-Exec00 1/1 Okay Process-Exec01 1/1 Okay Process-Exec02 1/1 Okay [root@host ~]# =================================================================== 3. Has the search server been started successfully? Search Server not started successfully ======================================================================= [root@host ~]# /usr/local/appian/search-server/bin/start.sh Sourcing start.conf SS_JAVA_OPTS: -Xms1024m -Xmx1024m -XX:+UseParNewGC -XX:+UseConcMarkSweepGC -XX:CMSInitiatingOccupancyFraction=75 -XX:+UseCMSInitiatingOccupancyOnly -Djava.awt.headless=true -Djava.net.preferIPv4Stack=true -Duser.timezone=GMT Unable to start Appian Search Server. [root@host ~]# ======================================================================== 4. For the rdbms authentication issues, verified the password and encoding in both the appian-ds.xml and standalone.xml After these steps if the issue is still unresolved, please attach 1. The new server.log --> Attached 2. Checkengine output as above [root@host ~]# /usr/local/appian/server/_scripts/diagnostic/checkengine.sh K 3.3 2009-08-26 Copyright (C) 1993-2009 Kx Systems l64 4CPU host.incess.local 4 TEST 2015-10-17 Appian - Partner Development #46510 Querying the 15 gateways now ... ............... Query complete --- --- --- --- --- --- --- --- ## Discussion Forums ## (2015-08-24 05:34:58 GMT) ## Discussion Forums ## Application Issues (Discussion Forums) No issues detected. Gateway Issues (Discussion Forums) _GW_ _Severity_ _Details_ 1 N/A No issues detected. Gateway Details (Discussion Forums): Gateway Chain(s): GW 1 (STANDALONE) _GW_ _Host_ _Port_ _Resp_ _Trans_ _Conn_ _Online_ _Size_ 1 localhost 5000 0.000 1 1 9 mins 564 KB Legend: Resp - The response time of the gateway (seconds). Trans - The number of transactions in the log. Conn - The total number of read/write connections. Online - The amount of time which the server has been online. Size - The current size of the database. --- --- --- --- --- --- --- --- ## Notifications Service ## (2015-08-24 05:34:58 GMT) ## Notifications Service ## Application Issues (Notifications Service) No issues detected. Gateway Issues (Notifications Service) _GW_ _Severity_ _Details_ 1 N/A No issues detected. Gateway Details (Notifications Service): Gateway Chain(s): GW 1 (STANDALONE) _GW_ _Host_ _Port_ _Resp_ _Trans_ _Conn_ _Online_ _Size_ 1 localhost 5002 0.003 0 1 9 mins 847 KB Legend: Resp - The response time of the gateway (seconds). Trans - The number of transactions in the log. Conn - The total number of read/write connections. Online - The amount of time which the server has been online. Size - The current size of the database. --- --- --- --- --- --- --- --- ## Notifications Email Processor ## (2015-08-24 05:34:58 GMT) ## Notifications Email Processor ## Application Issues (Notifications Email Processor) No issues detected. Gateway Issues (Notifications Email Processor) _GW_ _Severity_ _Details_ 1 N/A No issues detected. Gateway Details (Notifications Email Processor): Gateway Chain(s): GW 1 (STANDALONE) _GW_ _Host_ _Port_ _Resp_ _Trans_ _Conn_ _Online_ _Size_ 1 localhost 5004 0.001 0 1 8 mins 603 KB Legend: Resp - The response time of the gateway (seconds). Trans - The number of transactions in the log. Conn - The total number of read/write connections. Online - The amount of time which the server has been online. Size - The current size of the database. --- --- --- --- --- --- --- --- ## Channels ## (2015-08-24 05:34:58 GMT) ## Channels ## Application Issues (Channels) No issues detected. Gateway Issues (Channels) _GW_ _Severity_ _Details_ 1 N/A No issues detected. Gateway Details (Channels): Gateway Chain(s): GW 1 (STANDALONE) _GW_ _Host_ _Port_ _Resp_ _Trans_ _Conn_ _Online_ _Size_ 1 localhost 5006 0.001 0 1 9 mins 287 KB Legend: Resp - The response time of the gateway (seconds). Trans - The number of transactions in the log. Conn - The total number of read/write connections. Online - The amount of time which the server has been online. Size - The current size of the database. --- --- --- --- --- --- --- --- ## Collaboration ## (2015-08-24 05:34:58 GMT) ## Collaboration ## Application Issues (Collaboration) No issues detected. Gateway Issues (Collaboration) _GW_ _Severity_ _Details_ 1 N/A No issues detected. Gateway Details (Collaboration): Gateway Chain(s): GW 1 (STANDALONE) _GW_ _Host_ _Port_ _Resp_ _Trans_ _Conn_ _Online_ _Size_ 1 localhost 5008 0.001 70 2 8 mins 2 MB Legend: Resp - The response time of the gateway (seconds). Trans - The number of transactions in the log. Conn - The total number of read/write connections. Online - The amount of time which the server has been online. Size - The current size of the database. --- --- --- --- --- --- --- --- ## Collaboration Statistics ## (2015-08-24 05:34:58 GMT) ## Collaboration Statistics ## Application Issues (Collaboration Statistics) No issues detected. Gateway Issues (Collaboration Statistics) _GW_ _Severity_ _Details_ 1 N/A No issues detected. Gateway Details (Collaboration Statistics): Gateway Chain(s): GW 1 (STANDALONE) _GW_ _Host_ _Port_ _Resp_ _Trans_ _Conn_ _Online_ _Size_ 1 localhost 5010 0.001 0 1 8 mins 97 KB Legend: Resp - The response time of the gateway (seconds). Trans - The number of transactions in the log. Conn - The total number of read/write connections. Online - The amount of time which the server has been online. Size - The current size of the database. --- --- --- --- --- --- --- --- ## Personalization ## (2015-08-24 05:34:58 GMT) ## Personalization ## Application Issues (Personalization) No issues detected. Gateway Issues (Personalization) _GW_ _Severity_ _Details_ 1 N/A No issues detected. Gateway Details (Personalization): Gateway Chain(s): GW 1 (STANDALONE) _GW_ _Host_ _Port_ _Resp_ _Trans_ _Conn_ _Online_ _Size_ 1 localhost 5012 0.000 3 2 9 mins 1015 KB Legend: Resp - The response time of the gateway (seconds). Trans - The number of transactions in the log. Conn - The total number of read/write connections. Online - The amount of time which the server has been online. Size - The current size of the database. --- --- --- --- --- --- --- --- ## Portal ## (2015-08-24 05:34:58 GMT) ## Portal ## Application Issues (Portal) No issues detected. Gateway Issues (Portal) _GW_ _Severity_ _Details_ 1 N/A No issues detected. Gateway Details (Portal): Gateway Chain(s): GW 1 (STANDALONE) _GW_ _Host_ _Port_ _Resp_ _Trans_ _Conn_ _Online_ _Size_ 1 localhost 5014 0.001 5 2 9 mins 839 KB Legend: Resp - The response time of the gateway (seconds). Trans - The number of transactions in the log. Conn - The total number of read/write connections. Online - The amount of time which the server has been online. Size - The current size of the database. --- --- --- --- --- --- --- --- ## Process-Design ## (2015-08-24 05:34:58 GMT) ## Process-Design ## Application Issues (Process-Design) No issues detected. Gateway Issues (Process-Design) _GW_ _Severity_ _Details_ 1 N/A No issues detected. Gateway Details (Process-Design): Gateway Chain(s): GW 1 (STANDALONE) _GW_ _Host_ _Port_ _Resp_ _Trans_ _Conn_ _Online_ _Size_ 1 localhost 5016 0.002 82 2 8 mins 4 MB Legend: Resp - The response time of the gateway (seconds). Trans - The number of transactions in the log. Conn - The total number of read/write connections. Online - The amount of time which the server has been online. Size - The current size of the database. --- --- --- --- --- --- --- --- ## Process-Analytics0000 ## (2015-08-24 05:34:58 GMT) ## Process-Analytics0000 ## Application Issues (Process-Analytics0000) No issues detected. Gateway Issues (Process-Analytics0000) _GW_ _Severity_ _Details_ 1 N/A No issues detected. Gateway Details (Process-Analytics0000): Gateway Chain(s): GW 1 (STANDALONE) _GW_ _Host_ _Port_ _Resp_ _Trans_ _Conn_ _Online_ _Size_ 1 localhost 5018 0.000 13 2 9 mins 2 MB Legend: Resp - The response time of the gateway (seconds). Trans - The number of transactions in the log. Conn - The total number of read/write connections. Online - The amount of time which the server has been online. Size - The current size of the database. --- --- --- --- --- --- --- --- ## Process-Analytics0001 ## (2015-08-24 05:34:58 GMT) ## Process-Analytics0001 ## Application Issues (Process-Analytics0001) No issues detected. Gateway Issues (Process-Analytics0001) _GW_ _Severity_ _Details_ 1 N/A No issues detected. Gateway Details (Process-Analytics0001): Gateway Chain(s): GW 1 (STANDALONE) _GW_ _Host_ _Port_ _Resp_ _Trans_ _Conn_ _Online_ _Size_ 1 localhost 5020 0.001 13 2 9 mins 2 MB Legend: Resp - The response time of the gateway (seconds). Trans - The number of transactions in the log. Conn - The total number of read/write connections. Online - The amount of time which the server has been online. Size - The current size of the database. --- --- --- --- --- --- --- --- ## Process-Analytics0002 ## (2015-08-24 05:34:58 GMT) ## Process-Analytics0002 ## Application Issues (Process-Analytics0002) No issues detected. Gateway Issues (Process-Analytics0002) _GW_ _Severity_ _Details_ 1 N/A No issues detected. Gateway Details (Process-Analytics0002): Gateway Chain(s): GW 1 (STANDALONE) _GW_ _Host_ _Port_ _Resp_ _Trans_ _Conn_ _Online_ _Size_ 1 localhost 5022 0.000 13 2 9 mins 2 MB Legend: Resp - The response time of the gateway (seconds). Trans - The number of transactions in the log. Conn - The total number of read/write connections. Online - The amount of time which the server has been online. Size - The current size of the database. --- --- --- --- --- --- --- --- ## Process-Exec00 ## (2015-08-24 05:34:58 GMT) ## Process-Exec00 ## Application Issues (Process-Exec00) No issues detected. Gateway Issues (Process-Exec00) _GW_ _Severity_ _Details_ 1 N/A No issues detected. Gateway Details (Process-Exec00): Gateway Chain(s): GW 1 (STANDALONE) _GW_ _Host_ _Port_ _Resp_ _Trans_ _Conn_ _Online_ _Size_ 1 localhost 5024 0.002 32 2 8 mins 6 MB Legend: Resp - The response time of the gateway (seconds). Trans - The number of transactions in the log. Conn - The total number of read/write connections. Online - The amount of time which the server has been online. Size - The current size of the database. --- --- --- --- --- --- --- --- ## Process-Exec01 ## (2015-08-24 05:34:58 GMT) ## Process-Exec01 ## Application Issues (Process-Exec01) No issues detected. Gateway Issues (Process-Exec01) _GW_ _Severity_ _Details_ 1 N/A No issues detected. Gateway Details (Process-Exec01): Gateway Chain(s): GW 1 (STANDALONE) _GW_ _Host_ _Port_ _Resp_ _Trans_ _Conn_ _Online_ _Size_ 1 localhost 5026 0.002 32 2 8 mins 6 MB Legend: Resp - The response time of the gateway (seconds). Trans - The number of transactions in the log. Conn - The total number of read/write connections. Online - The amount of time which the server has been online. Size - The current size of the database. --- --- --- --- --- --- --- --- ## Process-Exec02 ## (2015-08-24 05:34:58 GMT) ## Process-Exec02 ## Application Issues (Process-Exec02) No issues detected. Gateway Issues (Process-Exec02) _GW_ _Severity_ _Details_ 1 N/A No issues detected. Gateway Details (Process-Exec02): Gateway Chain(s): GW 1 (STANDALONE) _GW_ _Host_ _Port_ _Resp_ _Trans_ _Conn_ _Online_ _Size_ 1 localhost 5028 0.001 33 2 8 mins 6 MB Legend: Resp - The response time of the gateway (seconds). Trans - The number of transactions in the log. Conn - The total number of read/write connections. Online - The amount of time which the server has been online. Size - The current size of the database. --- --- --- --- --- --- --- --- S U M M A R Y (2015-08-24 05:34:58.562 GMT) S U M M A R Y _APP_ _ACTIVE_GW_ _STATUS_ _ISSUES_ Discussion Forums 1/1 Okay Notifications Service 1/1 Okay Notifications Email Processor 1/1 Okay Channels 1/1 Okay Collaboration 1/1 Okay Collaboration Statistics 1/1 Okay Personalization 1/1 Okay Portal 1/1 Okay Process-Design 1/1 Okay Process-Analytics0000 1/1 Okay Process-Analytics0001 1/1 Okay Process-Analytics0002 1/1 Okay Process-Exec00 1/1 Okay Process-Exec01 1/1 Okay Process-Exec02 1/1 Okay [root@host ~]# 3. appian-ds.xml ---> Under /usr/local/jboss/jboss-eap-6.4/standalone/deployments/ ======================================= 4. standalone.xml --> Under /usr/local/jboss/jboss-eap-6.4/standalone/configuration/ ===================================================================================================================== localhost 3306 primarydatastore true UTF-8 com.mysql.jdbc.jdbc2.optional.MysqlXADataSource com.mysql.jdbc ds-name-security TRANSACTION_READ_COMMITTED 5 100 5000 5 localhost 3306 secondarydatastore true UTF-8 com.mysql.jdbc.jdbc2.optional.MysqlXADataSource com.mysql.jdbc ds-name-security TRANSACTION_READ_COMMITTED 5 100 5000 5 ===================================================================================================================== 5. Screenshots of the directories /standalone/deployments and /ear [root@host deployments]# ls -ltr total 20 -rw-rw-r-- 1 root root 9041 Mar 27 14:26 README.txt -rw-r--r-- 1 root root 2332 Aug 24 09:08 appian-ds.xml -rw-r--r-- 1 root root 13 Aug 24 09:37 appian-ds.xml.undeployed [root@host deployments]# >>>>>>>>>>>>>>>>>>>>>> [root@host ear]# ls -ltr total 8 drwxr-xr-x 13 root root 4096 Aug 24 08:43 suite.ear -rw-r--r-- 1 root root 2615 Aug 24 11:03 suite.ear.failed [root@host ear]#