Hi team, I've installed appian to local computer(Windows 7). I d

Hi Guys, I'm having error again with the jboss standalone. I've installed Appian on Windows Server 2008(R2 standard) OS. I've also setup domain controller to be able to get FQDN necessary for configurations and I've managed to deploy it with temporary license. Now, I ran below batch files consecutively.

\\<APPIAN_HOME\\>\\server\\_scripts\\start-suite.bat
\\<APPIAN_HOME\\>\\search-server\\bin\\start.bat
\\<JBOSS_HOME\\>\\bin\\standalone.bat

start-suite.bat and start.bat is fine, but the standalone.bat have issues below. I ran checkengine.bat and as per summary attached, there are no issues. See attached server log and captured checkengine summary. Please advise what are issues to fix so that i can get the appian local installation running correctly.

Errors:

04:01:45,844 INFO [org.jboss.as.controller] (DeploymentScanner-threads - 1) JBA
S014774: Service status report
JBAS014776: Newly corrected services:
service jboss.deployment.subunit."suite.ear"."jms-process-integration-hand
ler.jar".INSTALL (no longer required)
JBAS014777: Services which failed to start: service jboss.web.deployment.
default-host./suite

04:02:21,877 ERROR [stderr] (Appian Engine Timer (personalization triggering)) l
og4j:WARN No appenders could be found for logger (com.appiancorp.kougar.driver.i
pc.AppianEngineTimer).
04:02:21,879 ERROR [stderr] (Appian Engine Timer (personalization triggering)) l
og4j:WARN Please initialize the log4j system properly.

checkengine summary.txt

server.log

03:51:37,950 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/suite]] (ServerService Thread Pool -- 69) JBWEB000287: Exception sending context initialized event to listener instance of class com.appiancorp.common.config.ConfigurationLoader: com.appiancorp.common.config.FatalConfigurationException: com.appiancorp.suiteapi.common.exceptions.AppianException: An unexpected error occurred while trying to initialize and validate the Appian data source. (APNX-1-4179-004)
...
Caused by: java.lang.SecurityException: PBOX000016: Access denied: authentication failed

You have not configured the correct credentials for your Primary DS

Hi Tom, See attached new server log. I've added the user in mysql and correctly configured the primary ds.

server.log

Rename *.failed and *.undeployed marker files to *.dodeploy as per previous notes in this thread or this KB article:

forum.appian.com/.../kb-1009.html

Hi Tom, I've changed the file extensions to .dodeploy and restarted appian then jboss, but still i get the error

JBAS014777: Services which failed to start: service jboss.web.deployment.
default-host./suite

Attached is the updated server log. Please further advise. Thanks!

server.log

The relevant error is now the same one as before, regarding authentication with the primary DS. You should review your appian-ds.xml and the security domain you have configured in standalone.xml

Hi Tom,

The security domain is properly set to an existing mysql user I've created in mysql. It has the same privileges as the root user.

security-domain name="ds-name-security-primary"
security-domain name="ds-name-security-business"

In the appian-mysql-ds.xms.dev, only the system data source jdbc/AppianPrimaryDS is retained as per the appian instruction.

Please further review attached configurations if there are incorrect items. Thanks advance for your help. Really appreciate your help.

appian-mysql-ds.xml.dev

custom.properties.dev

standalone.xml.dev

web.xml

module.xml

did you solve the problem??

Using the Installation Guide as Reference, do the following:

1.Part Five: Allow Insecure Cookies
Open <REPO_HOME>\ear\suite.ear\web.war\WEB-INF\web.xml in a text editor.

Remove the following lines:
<cookie-config>
<http-only>true</http-only>
<secure>true</secure>
</cookie-config>
<tracking-mode>COOKIE</tracking-mode>
Save the file.

2.Part Ten: Deploy the Configurations
Use the configure script to validate your environment's configuration and deploy Appian.
Open the command prompt, and then run the following command: <APPIAN_HOME>\_admin\_scripts\configure\configure.bat
Choose 4 - Validate configurations.
Choose 5 - Deploy configurations, select 1 - <ENVIRONMENT>, and then select 3 - Deploy configurations to both. If prompted, select the option that corresponds with your version of JBoss.
Type Q to quit.

3.If Appian fails to start properly for any reason, check the following:

Verify that the following file exists and does not have the extensions .undeployed, .isdeploying or .failed:
<APPIAN_HOME>\_admin\_scripts\configure\templates\ear\suite.ear.dodeploy

Delete the following file if it has the extensions .undeployed, .isdeploying or .failed:
<JBOSS_HOME>\standalone\deployments\appian-mysql-ds.xml.deployed

Hope this helps

Do attach logs files for further help.