DNN Forums

Ask questions about your website to get help learning DNN and help resolve issues.
  • Search Forums
    Advanced Search
Prev
Next
Forums Our Community General Discussion

System Exception: IsSystem

 10 Replies
 4 Subscribed to this topic
 28 Subscribed to this forum
Sort:
Page 1 of 212 > >>
Author
Messages
HansZ
New Around Here
Posts: 17
New Around Here
8/17/2020 1:08 PM

We are running under DNN Release 09.04.04 and are receivng a fatal error continuously and with many modules, including the base DNN installation as shown below:

What is the cause of this exception and how is it repaired?

08/17/2020 12:54:19

General Exception

 

The Villages Woodworkers Club 

AbsoluteURL /localvwc/Default.aspx DefaultDataProvider DotNetNuke.Data.Sql 

AbsoluteURL:/localvwc/Default.aspx

DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke

ExceptionGUID:f20c3ca3-9989-47c4-ad99-ed6f9ea6377b

AssemblyVersion:

PortalId:-1

UserId:-1

TabId:-1

RawUrl:

Referrer:

UserAgent:

ExceptionHash:Nk4I1Bqc86r3nSp4HxRGtk2XjBM=

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:

Server Name: HansPC

HansZ
New Around Here
Posts: 17
New Around Here
8/17/2020 1:14 PM
The following is the corresponding entry in the Logs directory:
2020-08-17 12:54:19,279 [HansPC][Thread:32][ERROR] DotNetNuke.Services.Exceptions.Exceptions - System.IndexOutOfRangeException: IsSystem
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)
Joe Craig
Veteran Member
Posts: 1246
Veteran Member
MVP
MVP
You're an MVP!
8/17/2020 2:29 PM
Have you recently upgraded DNN? If so, from which version?
HansZ
New Around Here
Posts: 17
New Around Here
8/17/2020 2:57 PM

Joe,

We upgraded many months ago starting with 08.04 then up through the revisons to 09.04.04.

 

Joe Craig
Veteran Member
Posts: 1246
Veteran Member
MVP
MVP
You're an MVP!
8/17/2020 11:56 PM
Can I also assume that you upgraded modules, too?
Hans Zassenhaus
Growing Member
Posts: 36
Growing Member
New Poster
New Poster
Congrats on posting!
8/18/2020 9:21 AM

Joe,

to the best of my knowledge, I have upgraded all of the modules.  Though, there is no listing that I know of that provides this type of information.

 
Mark Buelsing
Growing Member
Posts: 80
Growing Member
8/18/2020 9:52 AM
In the log entry, there is a reference to the Tabs table. From a distance it appears DNN is attempting to access the Tabs table and having a problem reading it as expected. I would try to recall my actions regarding making & renaming & deleting pages. I would especially investigate modules you have used that do these things. And eventually I would look at the Tabs table directly and compare it to another instance of DNN or to a backup without the problem to make sure all the fields are there and spelled correctly. I would also have a keen look at the data in the Tabs table to look for outliers in the data that don't match the other entries in the same column.
Hans Zassenhaus
Growing Member
Posts: 36
Growing Member
New Poster
New Poster
Congrats on posting!
8/18/2020 11:04 AM

Mark

Thank you for the hints at a solution.  I will review the TABS table and compare it with the mirror site operating under 8.0.4.

 

 
Joe Craig
Veteran Member
Posts: 1246
Veteran Member
MVP
MVP
You're an MVP!
8/18/2020 11:07 AM
As for module versions, see the Extensions page in the Persona Bar. The installed version of each module is listed. You can check to verify that all modules are compatible with your version of DNN. The modules installed with DNN 9.4.4 should (with maybe a couple of exceptions) also be denoted as versions 9.4.4.

Check modules on GitHub. Most community modules are at https://github.com/DNNCommunity.

If you have any commercial modules, check with the vendor.

For other modules, check with the developer.
Hans Zassenhaus
Growing Member
Posts: 36
Growing Member
New Poster
New Poster
Congrats on posting!
8/18/2020 12:40 PM

Mark,

I reviewed the entries in the TABS table and found some anomalies.  Also, I emptied the page references in the Recycle Bin, some of which were from 2017.  I am still getting the IsSystem error. 

So, my question is on the TABS table the IsSystem column is either 1 or 0.  However, ALL of the entries in the TABS table for IsSystem are 0.  Is this correct or should the pages referencing the Host or Admin sections be identified with a value of 1?

Joe,

I am reviewing each of the modules to ensure they have been released for DNN Release 9.x.

Page 1 of 212 > >>

These Forums are for the discussion of the open source CMS DNN platform and ecosystem.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. If you have (suspected) security issues, please DO NOT post them in the forums but instead follow the official DNN security policy. 
  2. No Advertising. This includes the promotion of commercial and non-commercial products or services which are not directly related to DNN.
  3. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  4. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  5. No Flaming or Trolling.
  6. No Profanity, Racism, or Prejudice.
  7. Site Moderators have the final word on approving / removing a thread or post or comment.
  8. English language posting only, please.

Would you like to help us?

Awesome! Simply post in the forums using the link below and we'll get you started.

Get Involved