Error when importing Timesheets

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)
 
J

JamieG

I should add that this error occurs immediately after I hit the Import
Timesheets button. On weeks where the timesheet is "clean", I'm able to see
the drop down list and the grid that shows my time, and everything works
fine. On the bad weeks, this error appears right away and I never see the
Import screen.

Thanks.

JamieG said:
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top