My event log is getting hammered by the same error. This is only affecting my 5.0 installation.  It appears that the search indexer is having issues with pages that contain the Reports module. I have attempted to empty the search indexer tables but the problem seems to persist.  The following tables were emptied:

• SearchItemWord
• SearchWord
• SearchItem
• SearchItemWordPosition

 The following is the error message that is being repeated:

• ActiveTabName: Search Admin Raw
• URL: /tabid/29/portalid/0/Default.aspx
• AbsoluteURL: /Default.aspx
• UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.2; en-US) AppleWebKit/525.19 (KHTML, like Gecko) Version/3.1.2 Safari/525.21
• DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
• ExceptionGUID: ce63432c-e229-45e3-bd5f-ebbe5a3d8629
• InnerException: Cannot insert duplicate key row in object 'dbo.dnn_SearchItem' with unique index 'IX_dnn_SearchItem'. The statement has been terminated.
• FileName:
• FileLineNumber: 0
• FileColumnNumber: 0
• Method: System.Data.SqlClient.SqlConnection.OnError
• StackTrace:
• Message: DotNetNuke.Services.Exceptions.SearchException: Cannot insert duplicate key row in object 'dbo.dnn_SearchItem' with unique index 'IX_dnn_SearchItem'. The statement has been terminated. ---> System.Data.SqlClient.SqlException: Cannot insert duplicate key row in object 'dbo.dnn_SearchItem' with unique index 'IX_dnn_SearchItem'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() 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) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddSearchItem(String Title, String Description, Int32 Author, DateTime PubDate, Int32 ModuleId, String Key, String Guid, Int32 ImageFileId) at DotNetNuke.Services.Search.SearchDataStoreController.AddSearchItem(SearchItemInfo item) at DotNetNuke.Services.Search.SearchDataStore.StoreSearchItems(SearchItemInfoCollection SearchItems) --- End of inner exception stack trace ---

Any help is appreciated.

Thanks.

Derek

I did more testing on this issue.  I get the exception when my report has multiple rows.  My reports that only have one row do not throw the exception.