November Happy Hour will be moved to Thursday December 5th.
AI OnAI Off
Build Failed using "catalog" indexer
yes that sounds plausible. those two jobs will both load entries to index. you can quickly test by disabling the incremental one (why do you need it anyway?) and try again
Feb 02, 2023 14:39
After more investigation, turned out this happens even when incremental job is not started simultanously. I found out what kind of time out it was, and found the following page: https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/performance/troubleshoot-query-timeouts
Feb 03, 2023 13:51
Is it possible to set SqlCommand.CommandTimeout in a overriding fashion for Episerver fullindex search building?
Feb 03, 2023 14:45
No, the setting would affect the whole site and would require site restart(s). could you look into your database to see why it's timed out? i.e. see the query and execution plan
Feb 03, 2023 14:49
Are you reffering to the execution plan for this?: ecf_CatalogEntrySearch_GetResults @quan
Feb 03, 2023 15:17
I am seeing the following error when the FullIndexJob fails:
"Mediachase.Search.IndexBuildException: Build Failed using "catalog" indexer. "Exception in ecf_CatalogEntrySearch_GetResults: " ---> System.Exception: Exception in ecf_CatalogEntrySearch_GetResults: ---> System.Data.SqlClient.SqlException: Execution 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"
At the exact time one the full index job fails the incremental index jobs is supose to start. Is it possible, under some circumstances, that they can interfere?
Kind regards
Daniel