Previous Topic: Error with Browser-Based UIsNext Topic: Resolve a Third-Party Server Connection Failure

Troubleshooting › SA Manager and UI Server Troubleshooting › Resolve an SA Store Database Connection Failure

Resolve an SA Store Database Connection Failure

Symptom:

I received an email notification that CA SOI has detected an SA Store Database connection failure.

Solution:

You set email notifications for database failures.

  1. Verify that the server is configured correctly and functioning outside of CA SOI.
  2. Verify that the SA Store connection is working correctly using the DB Connectivity debug page. There are debug pages for the SA Manager server and for the UI server:
    1. For each server, run the DB Connectivity report.
    2. View the report and review the following information:
      • The database connection, which determines if the server can connect to the SA Store Database at all.
      • The query speed test, which determines how fast the underlying database structure can respond to a simple query without accessing the database tables.
  3. If the SA Manager server is offline and comes back online, CA SOI should detect the connection. If CA SOI is not connecting to the server, restart the SOI Application Manager service.