Citrix Provisioning Services Console Timeout

Whilst modifying several objects in Provisioning services console the console took a long time and intermittently timed out with the following error:-

Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated.

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Mapi.Command.TryDeleteSql(List`1 sqlParms, String sqlStatement, MapiConnection connection, String tableName)
at Mapi.CommandsRun.CommandRunRemoveDiskLocator.Execute(List`1 authGroups, List`1 parameters, MapiConnection connection)
at Mapi.CommandsRun.CommandTypeRun.InternalExecute(String command, List`1 authGroups, List`1 parameters, MapiConnection connection)
at Mapi.CommandsRun.CommandRunAssignDiskLocator.Execute(List`1 authGroups, List`1 parameters, MapiConnection connection)
at Mapi.CommandsRun.CommandTypeRun.Execute(String command, List`1 authGroups, List`1 parameters, MapiConnection connection)
at Mapi.CommandsSet.CommandMacroSet.Execute(List`1 authGroups, List`1 commands, MapiConnection connection)
at Mapi.CommandsSet.CommandTypeMacroSet.Execute(String user, String domain, List`1 commands)

I found this issue happens mostly when the SQL server is remote or not responding to Provisioning Services servers in time. This is a know issue with PvS 5.1 and 5.6 and will be fixed in a later release.

A workaround is to disable the DB Offline by removing the tick on Enable offline database support option temporarily

You will now need to restart the following service on each PvS server in the farm.