Non-Project Time (Issues with extra tasks being displayed)

[Comcast News]

We are working on an issue for a client, and so far Microsoft has been
unable to find a resoultion to the issue. First, I will give you a little
background information. Our client had a previous installation of Microsoft
Project Server 2002, and they were unhappy with it's performance and bug
issues, so they wanted to upgrade to Microsoft Project Server 2003. We
installed Microsoft Project Server 2003 (all components, using SQL Server
Enterprise, Analysis Server, Windows SharePoint Services) and succesfully
migrated all of there data from SharePoint Team Services and Microsoft
Project Server 2002 into the 2003 version. Some bugs did occur, but we were
able to fix them.

A little while later, they are reporting that anybody that is part of the
enterprise resource pool will now see a task called "NonProject Time." in
web access. The project that is associated with this task (according to
what the TASKS page say's) is called NonProject Time. This project does not
exsist anywhere in Microsoft Project server, we have tried the database
cleanup wizard, and a tool that Microsoft provided us that mass removes
Projects and resources but were unable to find the project anywhere. Upon
checking through EVERY SINGLE OPTION, in Microsoft Project Web server, we
found nothing that could remove these extra taks from displaying. These
tasks were built in 2002, and are no longer needed (or functioning). When
you try to change anything on these tasks, we get an error message "This
task is non working time". I have a screenshot of the TASKS that are
displaying in Microsoft Project Server 2003.

You can view it at: http://www.advisicon.com/NonProject Time.png

These tasks may have manually been added in Microsoft Project Server 2002,
but we don't have this information and the person that originally worked on
2002 is unavailable for comment. I opened a support issue with Microsoft,
but they have not been very helpful with this issue so far. We even
provided them a copy of the SQL database and they were able to reproduce the
issue. There only suggestion so far was to fix the issue in 2002, and the
migrate again. The only issue with this is the fact that the client has
been using Microsoft Project Server 2003 for 3 months, and it has a lot of
new data that we can't afford to lose.

I'm very dedicated to fixing this issue, and have a working duplicate copy
of there system up and running for testing. So if you have any ideas (even
terrible ones), I would be more than happy and able to test them.

 

[Gary L. Chefetz [MVP]]

Sometimes it's better to rebuild than to muck around waiting for Microsoft
to come up with a solution. They did give you the correct answer, though.
Unfortunately it's not an option now as your client has gone 3 months down
the road.

A sure-fire way to over come this is to take the system down for a weekend
and rebuild in roughly this way:

Backup your current database (you may want to restore it to non-production
instance later)

Save all the plans as MPP files - you'll need a strategy here to preserve
data based on the way your client is using the system

Save your resource pool as an mpp file - again you need a good strategy to
preserve enterprise custom data.

Save all your custom Project Enterprise Views to an mpp file

Backup your Ent Global

Run the setupdb.cmd file on the production database to completely wipe it
out

Import everything back into the production instance

Perform necessary housekeeping tasks such as resetting project ownership,
resource group membership, and more depending on your situation.

Be sure to spend some time planning and testing your approach.

It's not pretty, but it will accomplish your goal.

Disclaimer: The above steps do not comprise a recipe, simply a rough outline
that must be expanded!!!!!!!!!!!!!!

 

[Claudia]

Yes I have please run the following against your project server database using query analyzer:

DESCRIPTION OF ISSUE:
--------------------------------------------
Email notifications being sent out aftert the task are completed

CRITERIA FOR RESOLUTION:
-----------------------------------
Please run the following scripts against your project server database

SQL script for the Reminders problem

This script needs to be run against the database in the SQL Query Analyzer.

update MSP_WEB_REMINDER_TYPES
set WRMND_QUERY=N'select A.WPROJ_ID, A.TASK_NAME, A.ASSN_START_DATE, A.ASSN_FINISH_DATE, A.ASSN_WORK, A.ASSN_REM_WORK from MSP_WEB_ASSIGNMENTS A, MSP_WEB_PROJECTS P where A.WRES_ID=^0 and (^1) and A.WPROJ_ID=P.WPROJ_ID and P.WPROJ_IS_NONWORKING=0 and A.WASSN_DELETED_IN_PROJ=0 and A.WASSN_REMOVED_BY_RESOURCE=0 order by A.WPROJ_ID, A.ASSN_START_DATE'
where WRMND_TYPE_ID=11001

update MSP_WEB_REMINDER_TYPES
set WRMND_QUERY=N'select A.WPROJ_ID, A.TASK_NAME, A.ASSN_START_DATE, A.ASSN_FINISH_DATE, A.ASSN_WORK, A.ASSN_REM_WORK from MSP_WEB_ASSIGNMENTS A, MSP_WEB_PROJECTS P where A.WRES_ID=^0 and (^1) and A.WPROJ_ID=P.WPROJ_ID and P.WPROJ_IS_NONWORKING=0 and A.WASSN_DELETED_IN_PROJ=0 and A.WASSN_REMOVED_BY_RESOURCE=0 order by A.WPROJ_ID, A.ASSN_FINISH_DATE'
where WRMND_TYPE_ID in (11002, 11003, 11004, 11005, 11006)

update MSP_WEB_REMINDER_TYPES
set WRMND_QUERY=N'select A.WPROJ_ID, A.WRES_ID, TASK_ID, TASK_NAME, RES_NAME, ASSN_START_DATE, ASSN_FINISH_DATE, ASSN_WORK, ASSN_REM_WORK from MSP_WEB_ASSIGNMENTS A, MSP_WEB_RESOURCES R, MSP_WEB_PROJECTS P where A.WPROJ_ID=P.WPROJ_ID and WRES_ID_MGR=^0 and (^1) and A.WRES_ID=R.WRES_ID and A.WASSN_DELETED_IN_PROJ=0 order by A.WPROJ_ID, A.WRES_ID, ASSN_FINISH_DATE'
where WRMND_TYPE_ID in (21001, 21002, 21003)

update MSP_WEB_REMINDER_TYPES
set WRMND_QUERY=N'select A.WPROJ_ID, A.WRES_ID, TASK_ID, TASK_NAME, RES_NAME, ASSN_START_DATE, ASSN_FINISH_DATE, ASSN_WORK, ASSN_REM_WORK from MSP_WEB_ASSIGNMENTS A, MSP_WEB_RESOURCES R, MSP_WEB_PROJECTS P where A.WPROJ_ID=P.WPROJ_ID and WRES_ID_MGR=^0 and (^1) and A.WRES_ID=R.WRES_ID and A.WASSN_DELETED_IN_PROJ=0 order by A.WPROJ_ID, A.WRES_ID, ASSN_START_DATE'
where WRMND_TYPE_ID=21004


Chris

We run into the same problem at a customer site where we upgraded to
Project Server 2003 from version 2002.
The solution was to run specific queries in the ProjectServer DB:
1) Delete from the MSP_WEB_PROJECTS table the Project named
"NonProject Time" (should be PROJID =1)
2) Delete from the MSP_WEB_ASSIGNMENTS all records related to the
assignment to PROJID = 1
3) Delete from the MSP_WEB_WORK all records related to the assignment
to PROJID = 1
4) Delete from the MSP_WEB_NONWORKING_CATEGORIES all records

Eventually, after this "cleaning" the Task page will display without
NonProject Time project!!!

Claudia