After recently upgrading to CE 7.2.1 we discovered that the sites on this installation were running slowly. After some investigation we discovered that there are around 20 general exception entries being written to the event log every minute.
The exception just states:
System.InvalidCastException: Object cannot be cast from DBNull to other types.
at System.DBNull.System.IConvertible.ToInt32(IFormatProvider provider)
at DotNetNuke.Services.Search.UserIndexer.GetSearchDocuments(Int32 portalId, DateTime startDate)
Does anyone know how we can correct this?