sitecore - 选择媒体在 Sitecore 中没有返回任何项目 - 如何添加构面？

Question

我们最近将 Sitecore 从 6.5 升级到 7.1。新版本中上传和选择图片的界面发生了变化。当您上传图像并尝试搜索以选择它时。它说“没有找到元素”有人遇到过同样的问题吗？你是怎么解决的？

我安装了新版本的 Sitecore 7.1，没有出现此问题。

我有一种感觉，它应该是媒体库项目的索引配置或构建索引。当您检查对 Sitecore 的请求时，以下 url

/-/item/v1/sitecore/shell?facetsRootItemId=%7B7F43D3D0-CAC6-45D8-96FE-B76F4A117F9B%7D&search=%7B%22statusCode%22%3A500%2C%22error%22%3A%7B%22message%22%3A%22Index%20sitecore_master_index%20was%20not%20found%22%7D%7D&root=%7B3D6658D8-A0BF-4E75-B3E2-D050FABCF4E1%7D&searchConfig=%7BB0DF45DF-EA31-4C11-9E34-98B41DF549C5%7D&sc_content=master&language=en&format=%24convert_date_to_friendly_format&fields=__Created%7CDimensions&pageIndex=0&pageSize=20

返回

{"statusCode":200,"result":{"totalCount":0,"resultCount":0,"items":[],"facets":[{"Name":"Dimensions","Values ":[]},{"名称":"媒体类型","值":[]},{"名称":"已更新","值":[{"计数":0,"显示文本":"今天","优先级":1,"文本":"今天","值":"__smallupdateddate:[20140114 至 20140114]"},{"Count":0,"DisplayText":"昨天","优先级":2,"Text":"昨天","Value":"__smallupdateddate:[20140113 TO 20140113]"},{"Count":0,"DisplayText":"几天前","Priority":3,"Text":"几天前","Value":"__smallupdateddate:[20140110 至 20140112]"},{"Count":0,"DisplayText":"上个月","Priority":4,"Text": "上个月","Value":"__smallupdateddate:[20131214 TO 20140109]"},{"Count":0,"DisplayText":"几个月前","Priority":5,"Text":"几个月前","值":"__smallupdateddate:[20130914 至 20131213]"},{"计数":0,"DisplayText":"较旧","优先级":6,"文本":"较旧","值":"__smallupdateddate:[00010101 至 20130913]"}]}]}}

我检查了日志并注意到，当 Sitecore 尝试索引媒体项目时，它会抛出以下异常

8328 16:37:58 ERROR Could not run the 'getMediaStream' pipeline for '/sitecore/media library/Files/Investors/Reports and Presentations/Prospectus/2009/MAp 2009 Entitlement Offer Booklet 20091014'. Original media data will be used.
Exception: System.Data.SqlClient.SqlException
Message: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The wait operation timed out.)
Source: .Net SqlClient Data Provider
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.Open()
   at Sitecore.Data.SqlServer.SqlServerDataProvider.GetBlobSize(Guid blobId)
   at Sitecore.Data.SqlServer.SqlServerDataProvider.GetBlobStream(Guid blobId, CallContext context)
   at Sitecore.Data.DataProviders.DataProvider.GetBlobStream(Guid blobId, CallContext context, DataProviderCollection providers)
   at Sitecore.Data.DataSource.GetBlobStream(Guid blobId)
   at Sitecore.Nexus.Data.DataCommands.GetBlobStreamCommand.Execute(Guid ?, Database )
   at Sitecore.Nexus.Data.NexusDataApi.GetBlobStream(Guid blobId, Database database)
   at Sitecore.Data.Engines.DataCommands.GetBlobStreamCommand.DoExecute()
   at Sitecore.Data.Engines.EngineCommand`2.Execute()
   at Sitecore.Data.Engines.DataEngine.GetBlobStream(Guid blobId)
   at Sitecore.Data.Managers.ItemProvider.GetBlobStream(Guid blobId, Database database)
   at Sitecore.Data.Managers.ItemManager.GetBlobStream(Guid blobId, Database database)
   at Sitecore.Data.Managers.ItemManager.GetBlobStream(Field field)
   at Sitecore.Resources.Media.MediaData.GetBlobStream()
   at Sitecore.Resources.Media.GetMediaStreamPipelineArgs.get_OutputStream()
   at Sitecore.Resources.Media.ResizeProcessor.Process(GetMediaStreamPipelineArgs args)
   at (Object , Object[] )
   at Sitecore.Pipelines.CorePipeline.Run(PipelineArgs args)
   at Sitecore.Resources.Media.Media.GetStreamFromPipeline(MediaOptions options, Boolean& canBeCached)

Nested Exception

Exception: System.ComponentModel.Win32Exception

<小时/>

Sitecore 给我们回复了以下回复。如果您遇到同样的问题，我会及时通知您。

getMediaStream 从数据库中检索媒体数据(文件本身)。看起来您遇到了内容搜索不关闭媒体流的错误，这导致数据库连接泄漏。此错误已在 Sitecore 7.0 update 3 中修复，但尚未合并到 Sitecore 7.1 中。

Answer 1

听起来您的内容搜索索引尚未重建或配置不正确。尝试打开内容编辑器。右键单击顶部功能区并检查开发人员功能区是否已启用。转到开发人员功能区并选择“全部重建”。这将重建索引。

还要确保在配置中定义了索引。转到您的 App_Config/include 并确保您拥有 Sitecore.ContentSearch.config、Sitecore.ContentSearch.Lucene.DefaultIndexConfiguration.config、Sitecore.ContentSearch.Lucene.Index.Core.config、Sitecore.ContentSearch.Lucene.Index 文件。 Master.config 和 Sitecore.ContentSearch.Lucene.Index.Web.config。