Cannot open the plan or run a data import due to the following error message:
An unexpected error occurred. Please report this problem to your system administrator with the following information: System.InvalidOperationException: ExecuteScalar requires an open and available connection. The connection's current state is closed.
or
An unexpected error occurred. Please report this problem to your system administrator with the following information: System.InvalidOperationException: ExecuteReader requires an open and available connection. The connection's current state is closed.
or
Orchestrate data flow has failed, The detailed information is as follows:
WriteToServer requires an open and available connection. The connection's state is closed.
The functionality has been enhanced in Orchestrate version 7.78 hotfix 20. Please upgrade to this version or above.
If this issue continues to occur, please raise a new case online and reference the title of this article.