BluePrism v7.3 - BluePrism.Server.Domain.Models.UnavailableException

[MohammedAzharud]

We have Migrated some of our processes to BP7.3v around a month ago.

Recently - in the last one week, there were two instances where BOTs were unable to connect with Application Server and the BOTs were throwing below highlighted error.

We have to restart the BP Application Server Service to resolve this issue.

can anyone please suggest the possible reasons for this behavior in BP7.3v and how can this be fixed permanently.

BluePrism.Server.Domain.Models.UnavailableException: Database connection from the server is unavailable: An exception was thrown while executing a resolve operation. See the InnerException for details.

Server stack trace: 
   at BluePrism.AutomateAppCore.clsServer.EnsureDatabaseConnection()
   at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Object[]& outArgs)
   at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg)

Exception rethrown at [0]: 
   at BluePrism.AutomateAppCore.ServerFactory.CurrentConnectionValid()
   at AutomateUI.frmApplication.btc(Boolean a, Boolean b)

[faheemsd]

Dear @MohammedAzharud

The "BluePrism.Server.Domain.Models.UnavailableException" in Blue Prism indicates that there is an issue preventing the component or resource from being available. This could be due to various reasons, such as network connectivity issues, resource exhaustion, or temporary unavailability of a service.

Here are some steps you can take to troubleshoot and potentially resolve this issue:

Check Logs: Look for more detailed error messages or stack traces in the Blue Prism logs, event viewer, or any other logging mechanism you have in place. These logs might provide more context or information about the underlying cause of the unavailability.

Verify Connectivity: Ensure that the Blue Prism server and any associated services or resources (such as databases, file shares, or external systems) are accessible and functioning properly. Check network connectivity, firewall settings, and any other relevant configurations.

Resource Availability: Check for resource availability and potential bottlenecks on the Blue Prism server or any related systems. This could include CPU usage, memory usage, disk space, and database connections.

Service Health: If the unavailability is related to a specific service or component within Blue Prism, verify the health and status of that service. Restarting the service or restarting the Blue Prism server may help resolve transient issues.

Update or Patch: Ensure that you are using the latest version of Blue Prism and that all relevant updates or patches have been applied. Sometimes, known issues are addressed in newer versions or patches.

Check Database Connectivity: Ensure that the database server is up and running and that it is accessible from the Blue Prism server. Verify the network connectivity between the Blue Prism server and the database server.

Database Configuration: Double-check the database connection settings in the Blue Prism configuration. Ensure that the connection string, credentials, and other configuration parameters are correct.

Database Server Logs: Check the logs on the database server for any errors or warnings related to incoming connections. This can provide insights into why the Blue Prism server is unable to establish a connection.

Firewall Settings: Verify that the firewall settings on both the Blue Prism server and the database server allow incoming connections on the database port. Adjust the firewall settings if necessary.

Database Health: Check the health and status of the database server. Ensure that there are no issues with disk space, memory, or other resources that could be affecting its performance or availability.

Database Permissions: Ensure that the user account used by Blue Prism to connect to the database has the necessary permissions and privileges to establish a connection and perform the required operations.