J
JamieG
My team has had a devil of a time getting Project Server 2007 Project Web
Access to work properly. I've been brought in recently to help troubleshoot
our issues.
Our most recent problem is that we're getting the error below when people
click the Import Timesheets button. From my own personal experience, I find
that sometimes I'm able to import my timesheet and sometimes I get an error.
I find that I have better luck if I create a blank timesheet and add my tasks
in manually rather than let the system "auto-add" them for me, but lately I'm
having trouble with tasks added by hand as well.
Any suggestions? Here's the error...
Object cannot be cast from DBNull to other types. at
System.DBNull.System.IConvertible.ToDouble(IFormatProvider provider)
at System.Convert.ToDouble(Object value, IFormatProvider provider)
at Microsoft.Office.Project.Conversion.Utilities.ConvertToDouble(Object
value, Double& result)
at Microsoft.Office.Project.Conversion.WorkConverter.ToString(Object
value, WorkFormatType type, Int32 lcid)
at
Microsoft.Office.Project.Conversion.TextConverter.ToStringCore(ConversionType
type, Int32 formatType, Object value, Int32 lcid)
at
Microsoft.Office.Project.Conversion.TextConverter.ToString(ConversionType
type, Object value)
at
Microsoft.Office.Project.PWA.ApplicationPages.ImportTimesheetPage.colCurProgress_OnBeforeInitCell(XmlGridColumn sender, XmlGridColumnEventArgs args)
at
Microsoft.Office.Project.PWA.CommonControls.XmlGridColumn.FireBeforeInitCellEvent(XmlGridRow row, TableCell cell, Object value)
at
Microsoft.Office.Project.PWA.CommonControls.XmlGridNumericColumn.CreateChildControl(TableCell boundControl, Object dataValue)
at
Microsoft.Office.Project.PWA.CommonControls.XmlGridColumn.OnDataBindColumn(Object sender, EventArgs e)
at System.Web.UI.Control.OnDataBinding(EventArgs e)
at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
at System.Web.UI.Control.DataBind()
at System.Web.UI.Control.DataBindChildren()
at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
at System.Web.UI.Control.DataBind()
at System.Web.UI.WebControls.DataGrid.CreateItem(Int32 itemIndex, Int32
dataSourceIndex, ListItemType itemType, Boolean dataBind, Object dataItem,
DataGridColumn[] columns, TableRowCollection rows, PagedDataSource
pagedDataSource)
at System.Web.UI.WebControls.DataGrid.CreateControlHierarchy(Boolean
useDataSource)
at
Microsoft.Office.Project.PWA.CommonControls.XmlGrid.CreateControlHierarchy(Boolean useDataSource)
at
Microsoft.Office.Project.PWA.CommonControls.XmlGrid.OnPreRender(EventArgs e)
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Access to work properly. I've been brought in recently to help troubleshoot
our issues.
Our most recent problem is that we're getting the error below when people
click the Import Timesheets button. From my own personal experience, I find
that sometimes I'm able to import my timesheet and sometimes I get an error.
I find that I have better luck if I create a blank timesheet and add my tasks
in manually rather than let the system "auto-add" them for me, but lately I'm
having trouble with tasks added by hand as well.
Any suggestions? Here's the error...
Object cannot be cast from DBNull to other types. at
System.DBNull.System.IConvertible.ToDouble(IFormatProvider provider)
at System.Convert.ToDouble(Object value, IFormatProvider provider)
at Microsoft.Office.Project.Conversion.Utilities.ConvertToDouble(Object
value, Double& result)
at Microsoft.Office.Project.Conversion.WorkConverter.ToString(Object
value, WorkFormatType type, Int32 lcid)
at
Microsoft.Office.Project.Conversion.TextConverter.ToStringCore(ConversionType
type, Int32 formatType, Object value, Int32 lcid)
at
Microsoft.Office.Project.Conversion.TextConverter.ToString(ConversionType
type, Object value)
at
Microsoft.Office.Project.PWA.ApplicationPages.ImportTimesheetPage.colCurProgress_OnBeforeInitCell(XmlGridColumn sender, XmlGridColumnEventArgs args)
at
Microsoft.Office.Project.PWA.CommonControls.XmlGridColumn.FireBeforeInitCellEvent(XmlGridRow row, TableCell cell, Object value)
at
Microsoft.Office.Project.PWA.CommonControls.XmlGridNumericColumn.CreateChildControl(TableCell boundControl, Object dataValue)
at
Microsoft.Office.Project.PWA.CommonControls.XmlGridColumn.OnDataBindColumn(Object sender, EventArgs e)
at System.Web.UI.Control.OnDataBinding(EventArgs e)
at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
at System.Web.UI.Control.DataBind()
at System.Web.UI.Control.DataBindChildren()
at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
at System.Web.UI.Control.DataBind()
at System.Web.UI.WebControls.DataGrid.CreateItem(Int32 itemIndex, Int32
dataSourceIndex, ListItemType itemType, Boolean dataBind, Object dataItem,
DataGridColumn[] columns, TableRowCollection rows, PagedDataSource
pagedDataSource)
at System.Web.UI.WebControls.DataGrid.CreateControlHierarchy(Boolean
useDataSource)
at
Microsoft.Office.Project.PWA.CommonControls.XmlGrid.CreateControlHierarchy(Boolean useDataSource)
at
Microsoft.Office.Project.PWA.CommonControls.XmlGrid.OnPreRender(EventArgs e)
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)