Hello,

(we have installed 30+ dnn websites since dnn 3.3 up to dnn 4.8)

We are using dnn 4.8.0 for a website atm, and are running into various General Exceptions.

All goes well installing the website, adding some pages and configuring some standard settings.

We are using the following 3rd party modules: the multilanguage modules from www.apollo-software.nl and ReportGrid from www.dnaxp.net

After adding a role, adding a user, adding that user to that role, using the website for a bit and adding some text, thing suddenly go wrong,

We have tried using a fresh DNN 4.8 install but after everything is set and ready, the errors are there again.

This might be hard to overlook, but maybe the errors will ring a bell for someone and maybe they can point me in the right direction, which would be greately appriciated !

The following errors are generated and all pages we try to go to, regardless of the logged in user,
and after a couple refreshes (or 5 minutes) everything goes fine again:

System.IndexOutOfRangeException: TabPermissionID 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.Security.Permissions.TabPermissionController.FillTabPermissionInfo(IDataReader dr, Boolean CheckForOpenDataReader) at DotNetNuke.Security.Permissions.TabPermissionController.FillTabPermissionDictionary(IDataReader dr)

and:

System.IndexOutOfRangeException: PARAMETER_NAME 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 System.Data.SqlClient.SqlCommand.DeriveParameters() at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.GetTabPermissionsByTabID(Int32 TabID, Int32 PermissionID) at DotNetNuke.Security.Permissions.TabPermissionController.GetTabPermissionsCollectionByTabID(Int32 TabID, Int32 PortalId) at DotNetNuke.Entities.Tabs.TabController.FillTabInfo(IDataReader dr, Boolean CheckForOpenDataReader, Boolean CheckForLegacyFields) at DotNetNuke.Entities.Tabs.TabController.FillTabInfoCollection(IDataReader dr, Boolean CheckForLegacyFields)

and:

System.InvalidOperationException: The stored procedure 'dbo.GetTabPermissionsByTabID' doesn't exist. at System.Data.SqlClient.SqlCommand.DeriveParameters() at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.GetTabPermissionsByTabID(Int32 TabID, Int32 PermissionID) at DotNetNuke.Security.Permissions.TabPermissionController.GetTabPermissionsCollectionByTabID(Int32 TabID, Int32 PortalId) at DotNetNuke.Entities.Tabs.TabController.FillTabInfo(IDataReader dr, Boolean CheckForOpenDataReader, Boolean CheckForLegacyFields) at DotNetNuke.Entities.Tabs.TabController.FillTabInfoDictionary(IDataReader dr)

Thank you for your reply

The performance settings are default dnn 4.8.0:

- Page State Persistence: Page
- Module Caching Method: Disk
- Performance Setting: Moderate Caching
- Authenticated Cacheability: ServerAndNoCache
- Compression Setting: No Compression
- Use Whitespace Filter: unticked

And the database connection:

in connectionstrings:

<add name="SiteSqlServer" connectionString="Server=.\MYSERVER;Database=mydatabase;uid=mylogin;pwd=mypassword;" providerName="System.Data.SqlClient" />

in appsettings:

<add key="SiteSqlServer" value="Server=.\MYSERVER;Database=mydatabase;uid=mylogin;pwd=mypassword;"/>

I am using SQL SERVER EXPRESS 2005, and I was first using the sql express connectionstring (which gave the errors as well), but now I am using the SQL Server connectionstring.

We do experience this on dotnetnuke.com, althouhg it is intermittent.

It appears to be due to connection pool problems under heavy load in teh SQLClient.

See this thread for more info.