PS2007 My Tasks, an unexpected error has occurred

[HMH]

I can no longer see any tasks in the My Task page. Any ideas would be
appreciated.

This is a PS2007 SP1 development system. At first, My Tasks seemed to work
fine in our post-installation tests.

---Sorry for the length below.
We then migrated all resources and enterprise codes migrated successfully
from PS2003. We accidentally migrated about a hundred projects, with only two
or three failing to migrate. But migration completed successfully.

Projects looked fine in Project Centeral and anywhere we looked. Projects
synced up with enterprise resources without error.

But My Tasks failed to show anything, just gave error message.

Note: My Timesheets always appeared to show the correct information, whether
or not My Tasks had an error.

Deleted all the projects. My Tasks page opens fine again, but there are no
tasks -- expected.

Tried importing one small project, My Tasks failed.

Deleted that project. My Tasks opened up without tasks.

Created a completely new project that was very simple. Made assignments
similar to the project created for our installation test.

My Tasks failed with the error.

Changed the only two assignments in the project to other resources and those
people as the assignment owner.

My Tasks page showed no records as expected.

If I changed the owner to any assignment, My Tasks would fail.

If I change the resource to myself but left the owner as someone else, then
My Tasks page would open and show no records, although the resource
availability showed the correct available time for all the assignments.

Event log is consistent in the error. The bare information on this:
Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Exception type: InvalidCastException
Exception message: Specified cast is not valid.
Request URL: http://atkrapp029d/pwa/tasks.aspx
Stack trace (first line only): at
Microsoft.Office.Project.DataEdit.Dal.DalDataAccess.ProjDataRow.ConvertBool(Object value)

We also modified two settings in the web config so that the errors were
displayed in a normal ASP.NET style, and the information was identical each
time.

Any ideas are greatly appreciated.

 

[Bilal]

Hi
It sounds that you have some corrupeted tasks in one or more project
please refer to my blog post that addredd this point
http://ebilal.spaces.live.com/blog/cns!1EB5037F50572440!819.entry
please let me know if that worked with you

--

Best Regards

Bilal Okour
blog : http://ebilal.spaces.live.com

 

[Mac Hart]

Thanks for your input and ideas.

Still having the same problem. Here are the details that may help
troubleshoot the problem.

* There is only one project in the entire database and it has three tasks.
* Each task has a single assignment to a valid enterprise resource
(including me).
* Received 0 row count when I ran the SQL script against both the Published
and Draft databases,
* Went ahead and marked the task Publish to "no", then published, then "yes"
then published. Wanted to try, just in case this changes something. Same
error.
* Changed assignment owner to various values. When I am an assignment owner,
the My Tasks view has the error. When I own no assignments, the My Tasks
opens properly showing no records.
* Saved project as XML with a different name. Deleted published project in
the system. Opened XML project and saved-published under the new name. This
new project is the only one in project server now. Same error.
* Changed assignment owner to various values. Same results as before.
* Deleted timesheet since it had assignments from deleted projects.
Recreated timesheet and it shows the correct assignments.
* Checked with My Tasks, same error. Just as a sanity check changed
assignment owner to various values. Same results as before.

I will be glad to try anything.This is holding up our migration to Project
Server 2007. To us, this is a show stopper until we get this fixed.

Mac Hart
Software Engineer
Atlanta, GA

 

[Mac Hart]

Does anyone know which stored procedure, view, etc. feeds the webpart on the
My Tasks page. I tried hunting for that and couldn't find it. Or if you have
a SQL statement that performs the exact same data retrieval, that would also
help find the problem.

Thanks,

Mac Hart
aka "HMH" <[email protected]>

 

[Mike Christensen]

Does anyone know which stored procedure, view, etc. feeds the webpart on the
My Tasks page. I tried hunting for that and couldn't find it. Or if you have
a SQL statement that performs the exact same data retrieval, that would also
help find the problem.

Thanks,

Mac Hart
aka "HMH" <[email protected]>

That would be MSP_WEB_SP_QRY_Statusing_ReadStatus.

If I could see a full stack trace, I could isolate the problem.
ProjDataRow is used for all sorts of stuff, it simply means it's
incrementing through columns in a DataRow and was expecting one of the
columns to be a bool, but it's null or something else.

Also, make sure SP1 is installed - SP1 fixes a large number of these
sorts of issues.

Mike

 

[Mac Hart]

Mike, thanks for checking this out. The following is the text from the event
viewer relating to the specific problem.

Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 2/18/2008
Time: 11:33:42 AM
User: N/A
Computer: ATKRAPP029D
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 2/18/2008 11:33:42 AM
Event time (UTC): 2/18/2008 4:33:42 PM
Event ID: 2fb47dfa32dc4e15a2f6e79abc794161
Event sequence: 18
Event occurrence: 3
Event detail code: 0

Application information:
Application domain: /LM/W3SVC/940385100/Root-2-128478231291743188
Trust level: WSS_Minimal
Application Virtual Path: /
Application Path: E:\GroupShares\wss\VirtualDirectories\80\
Machine name: ATKRAPP029D

Process information:
Process ID: 2288
Process name: w3wp.exe
Account name: CDORAV00\SA_ps2007_02d

Exception information:
Exception type: InvalidCastException
Exception message: Specified cast is not valid.

Request information:
Request URL: http://atkrapp029d/pwa/tasks.aspx
Request path: /pwa/tasks.aspx
User host address: 10.3.3.133
User: CDORAV00\HMHART
Is authenticated: True
Authentication Type: NTLM
Thread account name: CDORAV00\SA_ps2007_02d

Thread information:
Thread ID: 7
Thread account name: CDORAV00\SA_ps2007_02d
Is impersonating: False
Stack trace: at
Microsoft.Office.Project.DataEdit.Dal.DalDataAccess.ProjDataRow.ConvertBool(Object
value)
at
Microsoft.Office.Project.DataEdit.Dal.DalDataAccess.ProjDataRow.GetBool(Int32
i)
at
Microsoft.Office.Project.DataEdit.Dal.DalDataAccess.FillProjData(IProjData
data, Guid docGuid, DataRow row)
at
Microsoft.Office.Project.PWA.StatusingLib.StatusingDataAccess.GetProjData(Guid
docGuid)
at Microsoft.Office.Project.DataEdit.Document.SvrDoc..ctor(Guid docGuid,
ISvrDataAccess dataAccess, SvrDoc entDoc, Boolean fGetProjData, SvrDoc
resourcePool, Boolean bUseProjectResources)
at Microsoft.Office.Project.DataEdit.Document.SvrDoc..ctor(Guid docGuid,
ISvrDataAccess dataAccess, SvrDoc entDoc)
at
Microsoft.Office.Project.PWA.StatusingLib.StatusingDataEdit.CacheNCData(Boolean
onDeserialized)
at
Microsoft.Office.Project.PWA.StatusingLib.StatusingDataEdit..ctor(StatusingDataAccess
svrDataAccess)
at Microsoft.Office.Project.PWA.WebParts.TaskPart.QueryViewData()
at
Microsoft.Office.Project.PWA.WebParts.DHTMLViewPart.OnDataBinding(EventArgs
e)
at
Microsoft.Office.Project.PWA.WebParts.TaskBasePart.OnDataBinding(EventArgs
e)
at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
at
Microsoft.Office.Project.PWA.WebParts.PWAPart.PageLoadCompleteInternal(Object
sender, EventArgs e)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Page.OnLoadComplete(EventArgs e)
at System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)


Custom event details:

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

 

[Mac Hart]

Mike,

We also experimented this morning. There were no event log messages as a
result of this experimentation, but the effects on the "My Tasks" page were
about the same. Hope this helps.
=====
"My Tasks" Page Experiment, 2/22/2008 8:02 AM

This experiment shows the result of varying combinations for assignments and
their effects on the My Tasks page.
The setup:
1. Project Server 2007 development system with only one project in the
system
2. All projects were deleted; one project created with three tasks
3. All timesheets from a previous test were deleted. (Note: these results
from this experiment are the same as before any timesheet tests were run.)
4. Experiment was started
5. All previous assignments removed in step 3 below and the experiment
continued

The following are results from the experiment. Each step has a step number,
then the action, then the result as related to the "My Tasks".

1 Started PWA and went directly to the My Tasks page = Error page
2 Recalled and then deleted all timesheets, then checked My Tasks page =
Error page
3 Deleted all assignments in the only project in the system. = Page shows
without any tasks under table headings, as it should
4 Added one assignment to the first task in the project. A different
resource (not myself) was set as the assignment resource and owner. = Page
shows as above, as expected, with no tasks.
5 Added one assignment to the second task. I am both the assignment owner
and resource. = Error page
6 Changed the assignment owner to the resource for step 4. I am still the
resource for the assignment. = Page shows without any tasks under the
headings.
7 Deleted that assignment. Created a new assignment with a different owner
and resource. = Page shows without any tasks under table headings, as it
should
8 On this last assignment, changed the owner to myself but left the
resource as it was. = Error page

General note about the home page: The home page showed that I had a task
assigned to me only when I was the task owner. When I was the resource and a
different person the owner, home page showed I had no tasks.
=====

 

[Mike Christensen]

Mike,

We also experimented this morning. There were no event log messages as a
result of this experimentation, but the effects on the "My Tasks" page were
about the same. Hope this helps.
=====
"My Tasks" Page Experiment, 2/22/2008 8:02 AM

This experiment shows the result of varying combinations for assignments and
their effects on the My Tasks page.
The setup:
1.  Project Server 2007 development system with only one project in the
system
2.  All projects were deleted; one project created  with three tasks
3.  All timesheets from a previous test were deleted. (Note: these results
from this experiment are the same as before any timesheet tests were run.)
4.  Experiment was started
5.  All previous assignments removed in step 3 below and the experiment
continued

The following are results from the experiment. Each step has a step number,
then the action, then the result as related to the "My Tasks".

1  Started PWA and went directly to the My Tasks page = Error page
2  Recalled and then deleted all timesheets, then checked My Tasks page =
Error page
3  Deleted all assignments in the only project in the system. = Page shows
without any tasks under table headings, as it should
4  Added one assignment to the first task in the project. A different
resource (not myself) was set as the assignment resource and owner. = Page
shows as above, as expected, with no tasks.
5  Added one assignment to the second task. I am both the assignment owner
and resource. = Error page
6  Changed the assignment owner to the resource for step 4. I am still the
resource for the assignment. = Page shows without any tasks under the
headings.
7  Deleted that assignment. Created a new assignment with a different owner
and resource. = Page shows without any tasks under table headings, as it
should
8  On this last assignment, changed the owner to myself but left the
resource as it was. = Error page

General note about the home page: The home page showed that I had a task
assigned to me only when I was the task owner. When I was the resource anda
different person the owner, home page showed I had no tasks.
=====

Hi - Can you get the server in a bad state so the error above will
appear, then open up Query Analyzer and run the following query in the
P12ProjectServerPublished db. All values should be either 0 or 1. If
any of them are NULL, that is what's causing the crash. If this is
the case, it would be interesting to see exactly where they are
getting nulled out since this is a bug..

SELECT
PROJ_INFO_SCHED_FROM,
PROJ_MOVE_ACTUAL_IF_LATER,
PROJ_MOVE_REMAINING_TO_STATUS,
PROJ_MOVE_REMAINING_IF_EARLIER,
PROJ_MOVE_ACTUAL_TO_STATUS
FROM MSP_PROJECTS

A work around would be to change any NULL values to 0 to repair your
database..

Thanks!
Mike

 

[Mac Hart]

Nothing in this table looks suspicious. I ran the query and all the fields
had something in them. Then I simply listed all the fields and searched for
a NULL. There are only two projects. The one that I created and is causing
the problem. The other in this table is the global table that was installed
as part of the system.

The project did NOT have any NULL value in a place where the global table
had a value.

Fields with NULL:
PROJ_PROP_AUTHOR (global only)
PROJ_PROP_CATEGORY
PROJ_PROP_COMPANY (global only)
PROJ_INFO_CURRENT_DATE
PROJ_OPT_DEF_OVT_RATE
PROJ_OPT_DEF_STD_RATE
PROJ_PROP_KEYWORDS
PROJ_PROP_MANAGER
PROJ_POOL_ATTACHED_TO
PROJ_INFO_STATUS_DATE
PROJ_PROP_SUBJECT
PROJ_CHECKOUTBY
PROJ_CHECKOUTDATE
PROJ_PROJECT
PROJ_TIMESTAMP
WPROJ_DESCRIPTION
WLOCAL_PATH
WPATH
WDSN_UID
WPROJ_IS_CONSOLIDATED_PROJECT
WPROJ_RES_CAN_DECLINE
WPROJ_DEFAULT_PROJ_UID
WPROJ_LAST_PUB (global only)
OPT_DEF_START_TIME
OPT_DEF_FINISH_TIME
WPROJ_STS_SUBWEB_NAME (global only)
WSTS_SERVER_UID (global only)
WPROJ_ISSUE_LIST_NAME (global only)
WPROJ_RISK_LIST_NAME (global only)
WSS_PWA_ADMIN_ROLE_ID (global only)
WSS_PWA_PROJECT_MANAGER_ROLE_ID (global only)
WSS_PWA_TEAM_MEMBER_ROLE_ID (global only)
WSS_PWA_READER_ROLE_ID (global only)
PROJ_PROPOSAL_WORKFLOW_INSTANCE_UID
PROJ_READ_LOCK_DATE
PROJ_WRITE_LOCK_DATE
PROJ_WRITE_PENDING_DATE
PROJ_VERSION
PROGRAM_UID
CAL_UID_BASELINE
PROJ_WBS_PREFIX

I am going to run a query against the task and assignment tables to see what
I can find there.

Mac Hart

 

[Mike Christensen]

Nothing in this table looks suspicious. I ran the query and all the fields
had something in them. Then I simply listed all the fields and searched for
a NULL. There are only two projects. The one that I created and is causing
the problem. The other in this table is the global table that was installed
as part of the system.

The project did NOT have any NULL value in a place where the global table
had a value.

Fields with NULL:
PROJ_PROP_AUTHOR (global only)
PROJ_PROP_CATEGORY
PROJ_PROP_COMPANY (global only)
PROJ_INFO_CURRENT_DATE
PROJ_OPT_DEF_OVT_RATE
PROJ_OPT_DEF_STD_RATE
PROJ_PROP_KEYWORDS
PROJ_PROP_MANAGER
PROJ_POOL_ATTACHED_TO
PROJ_INFO_STATUS_DATE
PROJ_PROP_SUBJECT
PROJ_CHECKOUTBY
PROJ_CHECKOUTDATE
PROJ_PROJECT
PROJ_TIMESTAMP
WPROJ_DESCRIPTION
WLOCAL_PATH
WPATH
WDSN_UID
WPROJ_IS_CONSOLIDATED_PROJECT
WPROJ_RES_CAN_DECLINE
WPROJ_DEFAULT_PROJ_UID
WPROJ_LAST_PUB (global only)
OPT_DEF_START_TIME
OPT_DEF_FINISH_TIME
WPROJ_STS_SUBWEB_NAME (global only)
WSTS_SERVER_UID (global only)
WPROJ_ISSUE_LIST_NAME (global only)
WPROJ_RISK_LIST_NAME (global only)
WSS_PWA_ADMIN_ROLE_ID (global only)
WSS_PWA_PROJECT_MANAGER_ROLE_ID (global only)
WSS_PWA_TEAM_MEMBER_ROLE_ID (global only)
WSS_PWA_READER_ROLE_ID (global only)
PROJ_PROPOSAL_WORKFLOW_INSTANCE_UID
PROJ_READ_LOCK_DATE
PROJ_WRITE_LOCK_DATE
PROJ_WRITE_PENDING_DATE
PROJ_VERSION
PROGRAM_UID
CAL_UID_BASELINE
PROJ_WBS_PREFIX

I am going to run a query against the task and assignment tables to see what
I can find there.

Mac Hart

The fact the stack trace is crashing in FillProjData means it's having
a problem with a row in MSP_PROJECTS, and the fact it's crashing in
GetBool means it's trying to read one of the bool columns. The list I
gave you was all the bool columns, minus the ones that don't allow
null. So I'm kinda stumped.. Can we take this offline, if you send
me your email address I'll try to get more information on your
database. THanks!

Mike

 

[TLBartz]

Did you get this resolved? I just started having this problem today and it
was after we upgraded to SP1. We are in a test/development enviroment also.

 

[chenli5833]

Did you get this resolved? I just started having this problem today and it
was after we upgraded to SP1. We are in a test/development enviroment also.






















- ÏÔʾÒýÓõÄÎÄ×Ö -

Hi all,

Is the problem resolved? I am having the same problem, would anyone
please let me know how to fix it ? thanks so much,

Wendy Li

 

[TLBartz]

Yes I did. I had to delete the web part and readd it.

Server Settings - Site Actions (upper-right hand corner of screen) - site
settings - web parts.

Edit TaskPart.webpart and then delete it.

Click 'New' and add it back.