Our website use cookies to improve and personalize your experience and to display advertisements(if any). Our website may also include cookies from third parties like Google Adsense, Google Analytics, Youtube. By using the website, you consent to the use of cookies. .

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

image

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

image

2 Comments

  • BIG D

    i have only just found this work around thanks! Do you have to do this on all servers before this will work or can you just restart the stream service on the server the pvs console is attached to?

    Cheers

    Big D

    • Yendis

      Hi Big D

      Welcome Back!

      Because you are making a change to the offline database support I would highly recommend restarting the stream service on all PVS servers.

      Yendis

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Related Posts