Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...dashboard module not working on fresh installationdashboard module not working on fresh installation
Previous
 
Next
New Post
1/24/2012 11:57 AM
 

I have a fresh installation of dotnetnuke 6.1.2. When I try to load the dashboard, i receive the following error:

A critical error has occurred. Property accessor 'ShortFileName' on object 'DotNetNuke.Modules.Dashboard.Components.Database.DbFileInfo' threw the following exception:'StartIndex cannot be less than zero. Parameter name: startIndex' 

Based on previous threads, I've taken a look at my SQL account permissions. I'm using SQL Server 2005 on a separate box from my web server. I've tried giving my SQL account permissions on the master database so it can retrieve database info, but I still receive the error.

here's the complete info from the dnn Event Viewer. Thanks in advance for any guidance on getting my dashboard working

AssemblyVersion: 6.1.2

PortalID: 0

PortalName: MyPortal

UserID: 1

UserName: admin

ActiveTabID: 37

ActiveTabName: Dashboard

RawURL: /Host/Dashboard/tabid/37/portalid/0/Default.aspx

AbsoluteURL: /Default.aspx

AbsoluteURLReferrer: http://mydomain.com/Host/tabid/7/portalid/0/Default.aspx

UserAgent: Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0)

DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider

ExceptionGUID: b8580155-87e9-45f7-9075-57980600d97a

InnerException: Property accessor 'ShortFileName' on object 'DotNetNuke.Modules.Dashboard.Components.Database.DbFileInfo' threw the following exception:'StartIndex cannot be less than zero. Parameter name: startIndex'

FileName:

FileLineNumber: 0

FileColumnNumber: 0

Method: System.String.InternalSubStringWithChecks

StackTrace:

Message: DotNetNuke.Services.Exceptions.PageLoadException: Property accessor 'ShortFileName' on object 'DotNetNuke.Modules.Dashboard.Components.Database.DbFileInfo' threw the following exception:'StartIndex cannot be less than zero. Parameter name: startIndex' ---> System.Reflection.TargetInvocationException: Property accessor 'ShortFileName' on object 'DotNetNuke.Modules.Dashboard.Components.Database.DbFileInfo' threw the following exception:'StartIndex cannot be less than zero. Parameter name: startIndex' ---> System.ArgumentOutOfRangeException: StartIndex cannot be less than zero. Parameter name: startIndex at System.String.InternalSubStringWithChecks(Int32 startIndex, Int32 length, Boolean fAlwaysCopy) at DotNetNuke.Modules.Dashboard.Components.Database.DbFileInfo.get_ShortFileName() --- End of inner exception stack trace --- at System.ComponentModel.ReflectPropertyDescriptor.GetValue(Object component) at System.Web.UI.DataBinder.GetPropertyValue(Object container, String propName) at System.Web.UI.DataBinder.Eval(Object container, String[] expressionParts) at ASP.desktopmodules_admin_dashboard_modules_database_ascx.__DataBinding__control27(Object sender, EventArgs e) at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) at System.Web.UI.Control.DataBindChildren() at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) at System.Web.UI.Control.DataBindChildren() at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) at System.Web.UI.WebControls.GridView.CreateRow(Int32 rowIndex, Int32 dataSourceIndex, DataControlRowType rowType, DataControlRowState rowState, Boolean dataBind, Object dataItem, DataControlField[] fields, TableRowCollection rows, PagedDataSource pagedDataSource) at System.Web.UI.WebControls.GridView.CreateChildControls(IEnumerable dataSource, Boolean dataBinding) at System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data) at System.Web.UI.WebControls.GridView.PerformDataBinding(IEnumerable data) at System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data) at System.Web.UI.WebControls.DataBoundControl.PerformSelect() at DotNetNuke.Modules.Dashboard.Controls.Database.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---

Source:

Server Name: myserver


 
New Post
1/24/2012 1:02 PM
 

What results are returned if you execute (in SQL Server Management Studio or other similar tool) the stored procedure:

{databaseOwner}[{objectQualifier}Dashboard_GetDbFileInfo]

replacing the {databaseOwner} token with your installation's databaseOwner (most likely "dbo.") and the {objectQualifier} token with your site's objectQualifier (most likely an empty string).

When creating the database did you place the database user that you created in the db_owner schema and role membership?

 


Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner
 
New Post
1/24/2012 1:26 PM
 
Thanks for the reply!

 Here are the results of the stored procedure, which seem valid:

USE [DotNetNuke]
GO


DECLARE @return_value int


EXEC @return_value = [dbo].[Dashboard_GetDbFileInfo]


SELECT 'Return Value' = @return_value


GO

Results

DATA DotNetNuke 51200 E:\sqldata\DotNetNuke.mdf
LOG DotNetNuke_log 39936 G:\DotNetNuke_log.ldf

William Severance wrote:

When creating the database did you place the database user that you created in the db_owner schema and role membership?

 

It appears I did not have the database user in db_owner schema, just the role. I had reviewed the readme.txt when installing, it said "make sure you grant sufficient database permissions (db_owner is commonly used)", so perhaps I mistakenly thought the role was sufficient. I tried putting the user in the schema now, but it didn't seem to make a difference. Any more advice? Thanks again.

 
New Post
1/24/2012 1:37 PM
 
Possible solution: i noticed my log file was on the root of a drive. I moved it into a folder, and now it works for some reason. i had a notion that maybe whatever function it was using to get the file path didn't like that it was located on the root of the drive.
 
New Post
1/24/2012 2:11 PM
 
I confirmed moving the file off the drive root to a folder was definitely the solution. I moved it back and forth to test. Just in case anybody else was having the same issue..

And thanks, William, for your helpful post.
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...dashboard module not working on fresh installationdashboard module not working on fresh installation


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

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

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. 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.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out