Hi,
I have been searching everywhere for a solution to this problem, I am getting the following constant errors in my events:
AssemblyVersion: -1
PortalID: -1
PortalName:
UserID: -1
UserName:
ActiveTabID: -1
ActiveTabName:
RawURL:
AbsoluteURL:
AbsoluteURLReferrer:
UserAgent:
DefaultDataProvider:
ExceptionGUID:
InnerException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_SearchItemWordPosition_SearchItemWord". The conflict occurred in database "database", table "dbo.SearchItemWord", column 'SearchItemWordID'. The statement has been terminated.
FileName:
FileLineNumber: -1
FileColumnNumber: -1
Method:
StackTrace:
Message: System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_SearchItemWordPosition_SearchItemWord". The conflict occurred in database "database", table "dbo.SearchItemWord", column 'SearchItemWordID'. 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.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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues)at DotNetNuke.Data.SqlDataProvider.AddSearchItemWordPosition(Int32 SearchItemWordID, String ContentPositions)at DotNetNuke.Services.Search.SearchDataStore.AddIndexWords(Int32 IndexId, SearchItemInfo SearchItem, String Language)at DotNetNuke.Services.Search.SearchDataStore.StoreSearchItems(SearchItemInfoCollection SearchItems)
Source:
Server Name: HEX
My search schedule history is also showing the following for the search schedular:
| Description |
Duration (ms) |
Succeeded |
Start/End/Next Start |
| DotNetNuke.Services.Search.SearchEngineScheduler, DOTNETNUKE |
Completed re-indexing content |
36.843 |
True |
S: 21/08/2007 1:16:09 PM
E: 21/08/2007 1:16:46 PM
N: 21/08/2007 4:16:09 PM |
| DotNetNuke.Services.Search.SearchEngineScheduler, DOTNETNUKE |
Completed re-indexing content |
36.966 |
True |
S: 21/08/2007 1:16:09 PM
E: 21/08/2007 1:16:46 PM
N: 21/08/2007 4:16:09 PM |
| DotNetNuke.Services.Search.SearchEngineScheduler, DOTNETNUKE |
Completed re-indexing content |
38.124 |
True |
S: 21/08/2007 10:15:41 AM
E: 21/08/2007 10:16:19 AM
N: 21/08/2007 1:15:41 PM |
| DotNetNuke.Services.Search.SearchEngineScheduler, DOTNETNUKE |
Completed re-indexing content |
38.123 |
True |
S: 21/08/2007 10:15:41 AM
E: 21/08/2007 10:16:19 AM
N: 21/08/2007 1:15:41 PM |
| DotNetNuke.Services.Search.SearchEngineScheduler, DOTNETNUKE |
Completed re-indexing content |
32.157 |
True |
S: 21/08/2007 7:15:13 AM
E: 21/08/2007 7:15:45 AM
N: 21/08/2007 10:15:13 AM |
| DotNetNuke.Services.Search.SearchEngineScheduler, DOTNETNUKE |
Completed re-indexing content |
32.643 |
True |
S: 21/08/2007 7:15:13 AM
E: 21/08/2007 7:15:45 AM
N: 21/08/2007 10:15:13 AM |
| DotNetNuke.Services.Search.SearchEngineScheduler, DOTNETNUKE |
Completed re-indexing content |
19.86 |
True |
S: 21/08/2007 4:14:47 AM
E: 21/08/2007 4:15:07 AM
N: 21/08/2007 7:14:47 AM |
| DotNetNuke.Services.Search.SearchEngineScheduler, DOTNETNUKE |
Completed re-indexing content |
51.14 |
True |
S: 21/08/2007 4:08:12 AM
E: 21/08/2007 4:09:03 AM
N: 21/08/2007 7:08:12 AM |
etc....
I have two domains pointing to on DNN installation and have asked my provider to only have one application pool pointing to my site, which they say they have done. Can anyone help?