Try our conversational search powered by Generative AI!

Search stopped working / Index page failed



Does anubody remember the soloution to this. My search has stopped working. When i do a save and publish on a page i get this error. Does anybody remember how to fix this.

2015-02-10 10:28:17,496\t(null)\t1.3.1 IndexPage failed for page 147
System.Data.SqlClient.SqlException (0x80131904): Arithmetic overflow error converting IDENTITY to data type int.
Arithmetic overflow occurred.
   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, SqlDataReader ds)
   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 EPiServer.DataAccess.PageTextIndexDB.InsertDataIntoKeywordTable(Int32 pageID, WordCollection indexedWords, String languageBranch)
   at EPiServer.DataAccess.PageTextIndexDB.<>c__DisplayClass4.b__3()
   at EPiServer.DataAccess.DataAccessBase.<>c__DisplayClass7.b__6()
   at EPiServer.DataAccess.DatabaseFactory.Execute[TResult](Action`1 method)
   at EPiServer.LazyIndexer.IndexPage(Int32 pageID)
   at EPiServer.LazyIndexer.Worker(Object state)



Feb 10, 2015 10:34

Hi Øyvind,

It's seem like the table tblTempKeyword has ran out of identity value (since the column pkId is set as IDENTITY(1, 1) and it has INT datatype). When there are sufficient number of item inserted (and removed) from this table, the IDENTITY value could go beyond the maximum INT value (2,147,483,647) and episerver cannot insert another record to this table. Please delete all of the rows in the table tblTempKeyword, then re-seed its identity value with the following script:

DBCC CHECKIDENT ('tblTempKeyword', RESEED, 1)

You should back-up your database first before performing this action.


Linh Doan

Feb 11, 2015 11:17
This thread is locked and should be used for reference only. Please use the Episerver CMS 7 and earlier versions forum to open new discussions.
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.