Hey there.

Started taking a close look at my admin log and I find several errors that I don't know how to fix.

Using DNN 9.0.3

Any insight would be welcome.

Thanks.

1. These logs were created when I logged in today (about 100 of them)
AbsoluteURL:/
DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke
ExceptionGUID:72f5a181-b55b-4b4c-b655-fda5ef04dcca
AssemblyVersion:
PortalId:-1
UserId:-1
TabId:-1
RawUrl:
Referrer:
UserAgent:
ExceptionHash:DXR+myEJdZ5QHjQS60V0ooyt1To=
Message:IsSystem
StackTrace:
at System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName) 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:


2: This is about a user name
AbsoluteURL:
DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke
ExceptionGUID:f737248d-fb6d-449b-85f8-d893095a0ddc
AssemblyVersion:
PortalId:-1
UserId:-1
TabId:-1
RawUrl:
Referrer:
UserAgent:
ExceptionHash:Y48SYgm7ShFw0boa5B3oYfiBETo=
Message:Conversion failed when converting the nvarchar value 'António' to data type int.
StackTrace:
at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (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:

3: This about a link to a page that existed in my previous Joomla site (does not exist in over a year) on the same domain. Is this a link on my site or an external one?

TabId:
PortalAlias:servicodeurgencia.pt
OriginalUrl:/index.php/pt/tratamento-de-feridas/protocolo-de-tratamento
Referer:http://servicodeurgencia.pt/
Url:http://servicodeurgencia.pt/index.php/pt/tratamento-de-feridas/protocolo-de-tratamento
UserAgent:Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/36.0.1985.125 Safari/537.36
HostAddress:165.231.99.65
HostName:165.231.99.65

and (this also outputs a hundred of the same log)

AbsoluteURL:/index.php/pt/tratamento-de-feridas/protocolo-de-tratamento
DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke
ExceptionGUID:945f533f-c132-4e05-a370-ed1fbbd4810a
AssemblyVersion:
PortalId:-1
UserId:-1
TabId:-1
RawUrl:
Referrer:
UserAgent:
ExceptionHash:i2v7ELMexpbo7xc4zVzkpS15aD4=
Message:IsSystem
StackTrace:
at System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName) 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:

#1

No ideas on this one.

#2

It looks like this is coming from the Search Indexer. I'd start by turning off search indexing for users and then check to see if that problem goes away. Which version of DNN is this. I have a dim memory that there were some problems indexing users in some older version, but I don't remember which it was.

#3

Possibly someone is trying to visit your site with an old URL? You might be able to redirect requests like that to your home page using the URL Rewriter.

---

Joe Craig
Patapsco Research Group, Ellicott City, MD
DotNetNuke Development and Services (http://patapscorg.com)

Was this a new install, or was it an upgrade?

---

Joe Craig
Patapsco Research Group, Ellicott City, MD
DotNetNuke Development and Services (http://patapscorg.com)