I have a portal that was upgraded from 6.2 to 8.0.4.  For the most part things seem to be working.  However, the other day I tried to open Host Settings and got a DNN Error "object reference not set ...."  I saw this earlier and fixed it for the Host Extensions page (orphaned skin issue). When I opened the event viewer to see what the problem was for this issue it was flooded with General Exceptions.  I am seeing a ton of these:

AbsoluteURL:

DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke

ExceptionGUID:a99025bf-5b9e-40a4-a19d-7f8af8ce8530

AssemblyVersion:

PortalId:-1

UserId:-1

TabId:-1

RawUrl:

Referrer:

UserAgent:

ExceptionHash:JGBBl/XeE72KWRZWvoV1Sg==

Message:Conversion failed when converting the nvarchar value 'Mr' to data type int.

StackTrace:

   at System.Data.SqlClient.SqlConnection. (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.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
   at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   at System.Data.SqlClient.SqlDataReader.Read()
   at DotNetNuke.Services.Search.UserIndexer.FindModifiedUsers(Int32 portalId, DateTime startDateLocal, IDictionary`2 searchDocuments, IList`1 profileDefinitions, IList`1& indexedUsers, Int32& startUserId)
   at DotNetNuke.Services.Search.UserIndexer.IndexSearchDocuments(Int32 portalId, ScheduleHistoryItem schedule, DateTime startDateLocal, Action`1 indexer)

InnerMessage:

InnerStackTrace:

Source:.Net SqlClient Data Provider

FileName:

FileLineNumber:0

FileColumnNumber:0

Method:

Server Name: KGISCCPRWEB1

----------------------------------------------

and a bunch of these:

AbsoluteURL:/Portal_803/Default.aspx

DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke

ExceptionGUID:36ff8cf5-6e5e-45a4-a794-710173cec0d5

AssemblyVersion:

PortalId:-1

UserId:-1

TabId:-1

RawUrl:

Referrer:

UserAgent:

ExceptionHash:lH+7/efea9nQxuu5aby0og==

Message:IsSystem

StackTrace:

   at System.Data.SqlClient.SqlDataReader.GetOrdinal(String name)
   at System.Data.SqlClient.SqlDataReader.get_Item(String name)
   at DotNetNuke.Entities.Tabs.TabInfo.Fill(IDataReader dr)
   at DotNetNuke.Common.Utilities.CBO.FillObjectFromReader(Object objObject, IDataReader dr)

InnerMessage:

InnerStackTrace:

Source:System.Data

FileName:

FileLineNumber:0

FileColumnNumber:0

Method:

Server Name: KGISCCPRWEB1

I have tried several things but I have no idea where the problem might be.  Any suggestions?  I have tried the TurboDNN DBConfig and "AdjustDNN..." scripts but they didn't help any although they ran successfully.

Yes and I assume that is part of the problem.  When I upgraded from 8.0.3 to 8.0.4  I forgot to run the TurboUnSchema script before I attempted the upgrade.  When the upgrade failed, I went back and ran the TurboUnschema and attempted the upgrade again.  Seems like it failed again (can't remember been a couple of days) but when I opened the site everything seemed to be working.  When I tried to look at my host settings yesterday it failed to load the page and that is when I started to look into the issue.

I have backups and will simply roll back and attempt again if needed.  However, I would like to know where the problem is in case it happens again in the future.

For future reference, if the upgrade fails because I forget to run the Unschema script, should I restore the DB from backup, restore the DNN files and then try it again from scratch?

Thanks