When trying to access a dashboard and its widgets, a connection error message appears.

The image shows the connection errors in dashboard widgets.

This is because the Bot Insight Visualization service is unable to connect to the SQL server. To resolve the problem, do the following:

Procedure

  1. Open the C:\Program Files\Automation Anywhere\Enterprise\DWAService\bin\src\main\resources\DWMP_CONNECTIONS.properties file.
  2. Check the following details and make changes where required.
    • operations.db.serverName= <SQL server hostname>
    • operations.db.portNumber= <SQL server port>
    • operations.db.user= <SQL server username>
    • operations.db.password=<SQL server password>
    • operations.db.databaseName=<Control Room database name>
    • operations.db.integratedSecurity=<Is Windows authentication being used>
  3. Try to connect to the SQL server on the Control Room database or Bot Insight database using the updated connection details.
  4. If all the connections work, restart the Bot Insight service. The dashboard widgets should now appear.