Where is the MySQL database on the Appian server? I need to solve a problem

Hi Stephen,

Based on your description, I am assuming you are working with an on-premise installation of Appian. There are a number of ways your on-premise architecture could have been configured so it will be hard to give you definitive answers without more details. With that said, it may be best to coordinate with an Appian Support engineer to make sure you aren't sharing private architecture or connection information that needs to remain secure. An engineer can provide much more detailed answers based on information you can share with them.

If you would like to explore this further before reaching out to support, the first thing you can look into is the admin console's data source configuration. You are looking for the business data source's connection string. That should hopefully give you more insight into what server and schema you are looking for. You will then need to coordinate with your DBA to get credentials for that schema and connect with the appropriate tool for the database (i.e. sql server management studio, etc). Once you have access to the database, you can see if you have an issue with your primary, etc and make adjustment via SQL.

It is possible to create some query rules in Appian to try to analyze the issues, but if your issue is actually a database configuration problem it will likely be much easier to triage and resolve in the database.

https://docs.appian.com/suite/help/17.3/Appian_Administration_Console.html#Data_Sources

https://docs.appian.com/suite/help/17.3/Configuring_Relational_Databases.html

Hi Stephen,

Based on your description, I am assuming you are working with an on-premise installation of Appian. There are a number of ways your on-premise architecture could have been configured so it will be hard to give you definitive answers without more details. With that said, it may be best to coordinate with an Appian Support engineer to make sure you aren't sharing private architecture or connection information that needs to remain secure. An engineer can provide much more detailed answers based on information you can share with them.

If you would like to explore this further before reaching out to support, the first thing you can look into is the admin console's data source configuration. You are looking for the business data source's connection string. That should hopefully give you more insight into what server and schema you are looking for. You will then need to coordinate with your DBA to get credentials for that schema and connect with the appropriate tool for the database (i.e. sql server management studio, etc). Once you have access to the database, you can see if you have an issue with your primary, etc and make adjustment via SQL.

It is possible to create some query rules in Appian to try to analyze the issues, but if your issue is actually a database configuration problem it will likely be much easier to triage and resolve in the database.

https://docs.appian.com/suite/help/17.3/Appian_Administration_Console.html#Data_Sources

https://docs.appian.com/suite/help/17.3/Configuring_Relational_Databases.html

Thank you for the answer. We do have both and mysql and oracle connection. However, there is no mysql system online, so I am digging about looking for the tables I need in Oracle.

By the way, why did you remove all the 17.3 links?

I don't think the documentation for those features has changed much since 17.3. You could still reference the latest sections in the documentation if it would be helpful.

https://docs.appian.com/suite/help/latest/Appian_Administration_Console.html#data-sources

https://docs.appian.com/suite/help/latest/Configuring_Relational_Databases.html

Older documentation gets removed by Appian over time as previous versions of the software go beyond their support lifecycle. 17.3 has been out of support since 2019.