Sitecore站点/项目发布在初始化时挂起 [英] Sitecore Site/Item Publishing hangs at Initializing
本文介绍了Sitecore站点/项目发布在初始化时挂起的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
核心数据库出现问题,该数据库已由前一天的备份数据库还原。
之后,网站运行良好,但是,我们在发布任何更改时遇到了问题。一旦ER点击发布按钮,"发布初始化.."消息只是持续了很长时间。截至"发布开始/结束"时,事件日志中也未捕获任何内容。
因此,当我们尝试使用数据库清理工具清理主/Web数据库时,SQL错误弹出。
有没有人有解决此类问题的办法?
这是我在"Web"数据库清理时收到的错误。
Job started: CleanUpDatabases|System.Exception: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.Data.DataException: Error executing SQL command: declare @x bigint set @x = 0 DECLARE @item TABLE(ID uniqueidentifier,parentID uniqueidentifier) INSERT INTO @item (ID,parentID) SELECT [ID],[ParentID] FROM [Items] DECLARE @temp TABLE(ID uniqueidentifier) WHILE (SELECT count(id) FROM @item ) <> @x begin set @x = (SELECT count(id) FROM @item ) delete from @temp; insert into @temp (ID) SELECT id FROM @item where parentID = @nullId update @item SET Parentid =@nullId where Parentid in (select id from @temp) delete from @item where id in (select id from @temp) end UPDATE [Items] SET [Parentid] = @nullId where [ID] in (select id from @item) ; DELETE from [Items] where [ID] in (select id from @item) ---> System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception: The wait operation timed out
--- End of inner exception stack trace ---
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
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, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Sitecore.Data.DataProviders.Sql.DataProviderCommand.ExecuteNonQuery()
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
at Sitecore.Data.DataProviders.Sql.DataProviderCommand.ExecuteNonQuery()
at Sitecore.Data.DataProviders.Sql.SqlDataApi.<>c__DisplayClass15.<Execute>b__14()
at Sitecore.Data.DataProviders.NullRetryer.Execute[T](Func`1 action, Action recover)
at Sitecore.Data.DataProviders.Sql.SqlDataProvider.CleanupDatabase(CallContext context)
at Sitecore.Data.DataProviders.DataProvider.CleanupDatabase(CallContext context, DataProviderCollection providers)
at Sitecore.Shell.Applications.Databases.CleanUp.CleanUpForm.Cleaner.CleanUp()|Job ended: CleanUpDatabases (units processed: )
推荐答案
此处提供说明:
https://sitecorebasics.wordpress.com/2011/04/12/timeout-error-when-running-cleanupdatabases-job/
您需要增加Sitecore配置中的DefaultSQLTimeout
设置。
请尝试将其设置为30分钟。
<setting name="DataProviderTimeout" value="00:30:00″ />
此处也有回答:
https://sitecorebasics.wordpress.com/2011/04/12/timeout-error-when-running-cleanupdatabases-job/
这篇关于Sitecore站点/项目发布在初始化时挂起的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文