Search stopped working / Index page failed

Øyvind Jonassen

Vote:

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)
ClientConnectionId:8d673706-3dda-4529-bf3b-5cdc5244e077

Regards

Øyvind

#117028

Feb 10, 2015 10:34

Linh Doan Cuu

Vote:

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.

Regards

Linh Doan

#117081

Feb 11, 2015 11:17