Local machine installation without FQDN and Error with starting up a local demo installation

jboss startup error.txt

Tried adding %SystemRoot%\System32\Wbem to the envrionment PATH and reinstalled Appian, this time Engine started, Search server started, but when starting the JBOSS, still there is an error :: Services which failed to start: service jboss.web.deployment.default-host./suite

And also an error when running search server stating The system cannot find the batch label specified - ensureSsP - so I followed some previous instructions and deleted the Plugin of appian-es-auth

So I stopped the JBOSS, Search server and engines, checked status and then deleted the failed and changed to dodeploy and tried again. But the issue is still present. Please help

Looking forward for help in fixing this issue.

Attached the server log and Jboss error too

2671.server.log

Error Jboss.doc

Hi Aswin,

I changed the memory settings as you suggested, but still encounter the same exact error message. Please see the complete results of the commands in the attachment. Looking forward for your advice.

Thank you!

You need to change custom.properties to have the correct jndi name mentioned inside appian-ds.xml. Inside appian-ds.xml you have named primary and secondary databases's jndi name as jdbc/AppianPrimaryDS and jdbc/AppianBusinessDS.....so in custom.properties file it should be named the same. Looking at the logs, I noticed two problems:

1. jdbc/AppianDS is being mentioned. I assume you have that spelled out wrong inside custom.properties file. Please change to:

conf.data.APPIAN_DATA_SOURCE=jdbc/AppianPrimaryDS and conf.data.datasources=jdbc/AppianBusinessDS

2. Also please check appian-ds.xml, I see in the logs: 

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'appian17.4_primary'

I assume that you created databases by the name "APPIAN_SCHEMA" and "BUSINESS_SCHEMA". So why appian17.4_primary? Please verify database name as APPIAN_SCHEMA and BUSINESS_SCHEMA inside appian-ds.xml.

Also one new thing I want you to try out is to set permission Mysql config.docxthrough SQL workbench. I am attaching a word doc of how I do it. Please follow that.

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'appian17.4_primary'

I assume that you created databases by the name "APPIAN_SCHEMA" and "BUSINESS_SCHEMA". So why appian17.4_primary? Please verify database name as APPIAN_SCHEMA and BUSINESS_SCHEMA inside appian-ds.xml. 

                                                                                                                          |

                                                                                                                          |

I used the default instruction from the quickstart guide to change the line in Repo file and not the original file. Do you want me to replace the line with <xa-datasource-property name="URL">jdbc:mysql://localhost:3306/appian17.4_APPIAN_SCHEMA?useOldAliasMetadataBehavior=true</xa-datasource-property>

Yes...pls change your appian-ds.xml to the file being attached...

<?xml version="1.0" encoding="UTF-8"?>
<datasources xmlns="www.jboss.org/.../schema">
<xa-datasource
jndi-name="jdbc/AppianPrimaryDS"
pool-name="MySqlDS"
enabled="true"
use-java-context="false">
<xa-datasource-property name="serverName">localhost</xa-datasource-property>
<xa-datasource-property name="portNumber">3306</xa-datasource-property>
<xa-datasource-property name="databaseName">APPIAN_SCHEMA</xa-datasource-property>
<xa-datasource-property name="useUnicode">true</xa-datasource-property>
<xa-datasource-property name="characterEncoding">UTF-8</xa-datasource-property>
<xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
<driver>com.mysql.jdbc</driver>
<security>
<security-domain>ds-name-security-primary</security-domain>
</security>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
<xa-pool>
<min-pool-size>5</min-pool-size>
<max-pool-size>100</max-pool-size>
</xa-pool>
<timeout>
<blocking-timeout-millis>5000</blocking-timeout-millis>
<idle-timeout-minutes>5</idle-timeout-minutes>
</timeout>
</xa-datasource>
<datasources xmlns="www.jboss.org/.../schema">
<xa-datasource
jndi-name="jdbc/AppianBusinessDS"
pool-name="MySqlDS"
enabled="true"
use-java-context="false">
<xa-datasource-property name="serverName">localhost</xa-datasource-property>
<xa-datasource-property name="portNumber">3306</xa-datasource-property>
<xa-datasource-property name="databaseName">BUSINESS_SCHEMA</xa-datasource-property>
<xa-datasource-property name="useUnicode">true</xa-datasource-property>
<xa-datasource-property name="characterEncoding">UTF-8</xa-datasource-property>
<xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
<driver>com.mysql.jdbc</driver>
<security>
<security-domain>ds-name-security-business</security-domain>
</security>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
<xa-pool>
<min-pool-size>5</min-pool-size>
<max-pool-size>100</max-pool-size>
</xa-pool>
<timeout>
<blocking-timeout-millis>5000</blocking-timeout-millis>
<idle-timeout-minutes>5</idle-timeout-minutes>
</timeout>
</xa-datasource>
</datasources>

Still facing the error loading JBOSS. I have attached the CMD result and also the server log2480.server.lognew error.doc

To add, my computer has 8 GB of memory with no other application running. As adviced I have stopped all running tasks from Task manager too.