hi,

After upgrading DNN from 6.2 to DNN 07.02.01 (367) I get the following errors in Event Viewer.  This seems to be related to search as I get 7 entries of the following errors each time schedule for search runs. I believe those 7 entries are for the 7 portals I have.

AssemblyVersion:7.2.1

PortalID:-1

PortalName:

UserID:-1

UserName:

ActiveTabID:-1

ActiveTabName:

RawURL:

AbsoluteURL:

AbsoluteURLReferrer:

UserAgent:

DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke

ExceptionGUID:e3246994-d7a4-4e5b-97ad-382c491db804

InnerException:Object cannot be cast from DBNull to other types.

FileName:

FileLineNumber:0

FileColumnNumber:0

Method:System.DBNull.System.IConvertible.ToInt32

StackTrace:

Message:

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)

The errors are logged to event viewer when the search index job runs.

The Event log has no other errors. ....only the above error appears.

there is a known issue with old user accounts that were missing profiles -it was being looked at for 7.2.2 . This function call's the GetAvailableUsersForIndex sproc - you could try clearing that down so no entries are returned i.e. attempts at indexing users will not work but likely the exception will not occur

---

Buy the new Professional DNN7: Open Source .NET CMS Platform book Amazon US