I am trying to install the Appian 8.0. As a part of this installation I have in

ramakg

A Score Level 1

over 10 years ago

I am trying to install the Appian 8.0. As a part of this installation I have installed Jboss EAP 6.3 and MySQL 5.6. when I start the jboss I am getting the below error message. Any inputs on this?

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 primary data source. (APNX-1-4179-004)
          at com.appiancorp.suiteapi.common.exceptions.AppianRuntimeException.<init>(AppianRuntimeException.java:52) [appian-suiteapi.jar:]
          at com.appiancorp.common.config.FatalConfigurationException.<init>(FatalConfigurationException.java:23) [appian-common.jar:]
          at com.appiancorp.rdbms.config.PrimaryDataSourceConfig.finish(PrimaryDataSourceConfig.java:29) [appian-rdbms.jar:]
          at com.app...

Discussion posts and replies are publicly visible

0 ramakg
A Score Level 1
over 10 years ago

i am not migrating any version, installing brand new server 7.8 with Jboss EAP 6.3 and MYQL 6.5.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Tejas Kargutkar
Appian Employee
over 10 years ago

MySql 6.5 is not supported version of databases:
forum.appian.com/.../System_Requirements.html

Can you test this with a supported version on a brand new schema and make sure that the user specified in the appian-ds.xml has the appropriate rights to the primary schema ?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 ramakg
A Score Level 1
over 10 years ago

By mistake I have mentioned 6,5 but I have installed 5.6.22 version. Still getting the same error message. Please help me to over come this issue.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Tejas Kargutkar
Appian Employee
over 10 years ago

Did you try this with a fresh new schema ?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 ramakg
A Score Level 1
over 10 years ago

I have tried many times by installing and uninstalling the software and created and tested with many databases/schemas but I am ending up with the same issues again and again.

I am planning to try with MSSQL instead of MySQL. But not sure that the problem with database or the Appian installation.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Tejas Kargutkar
Appian Employee
over 10 years ago

This issue seems similar to the following post:forum.appian.com/.../e-128511
I would suggest, rechecking the database configuration and making sure it's exactly according to the documentation. Also make sure you are using the right driver to make the connection. Download it from the link provided in the documentation.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 ramakg
A Score Level 1
over 10 years ago

Hi Tejan
I have followed all the steps as per the documentation. Is it possible to provide the suitable driver details?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Tejas Kargutkar
Appian Employee
over 10 years ago

I am providing the link from the documentation. Make sure you have configured the appian-ds.xml, module.xml, standalone.xml,custom.properties correctly to establish a successful connection with the primary database.

dev.mysql.com/.../
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 ramakg
A Score Level 1
over 10 years ago

Now its working!!! Thank you for your suggestions.
Resolution:
I connected the sample database and not getting any error message and working fine. the problem with creation of database in My SQL. I assume some steps are missing in the documentation.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel