Non-project Administrative tasks appear in Project Server 2003 after upgrade from Project Server 200

[Dries van der Colff]

We have recently upgraded a Project Server 2002 installation to 2003. The
2002 installation had active non-project tasks appearing in the timesheets.

After the upgrade, the administrative tasks still appear in the 2003
timesheets, and we don't know how to get rid of those tasks, since the
Project Server 2002 non-project time functionality has been replaced in
Project 2003 with Administrative projects, and with it the tools dealing
with non-project tasks have been omitted as well.

Help would be much appreciated.

 

[johndellenbagh]

We have recently upgraded a Project Server 2002 installation to 2003. The
2002 installation had active non-project tasks appearing in the timesheets.

After the upgrade, the administrative tasks still appear in the 2003
timesheets, and we don't know how to get rid of those tasks, since the
Project Server 2002 non-project time functionality has been replaced in
Project 2003 with Administrative projects, and with it the tools dealing
with non-project tasks have been omitted as well.

Help would be much appreciated.

Dries,

The solution below should resolve your issue.

The information in this article applies to:

- Microsoft Office Project Professional 2003

- Microsoft Office Project Server 2003

- Microsoft Project Web Access

- Microsoft Project Server 2002
------------------------------------------------------------------------------
SYMPTOMS:
==========
Customer migrated from Project Server 2002 to Microsoft Office Project Server 2003
Go to resource task sheet
Expected:
Only to see tasks associated with project plans

Actual:
See tasks associated with project plans and also see Non Project Time
CAUSE:
=======
The database was migrated from 2002

The 2002 database has Non Project categories

Resources added time to the Non Project categories

RESOLUTION:
===========
delete
from MSP_WEB_NONWORKING
delete
from MSP_WEB_NONWORKING_CATEGORIES
delete
from MSP_WEB_MESSAGES_NONWORKING
delete
from MSP_WEB_WORK
where WASSN_ID in (select WASSN_ID
from MSP_WEB_ASSIGNMENTS
where WNWRK_ID >99
delete
from MSP_WEB_ASSIGNMENTS
where WNWRK_ID > 99



John Dellenbaugh, MCSA/MCSE- Win 2000
Microsoft Enterprise Services & Support for Business Applications

Email: (e-mail address removed)

Phone: 425-704-5962

Hours: 7am-4pm PST (M-F)

 

[Gary L. Chefetz \(MVP\)]

John:

Is there a KB for this?

--

Gary L. Chefetz, MVP
"We wrote the book on Project Server
http://www.msprojectexperts.com

-

 

[Dries van der Colff]

Thanx John

I tested the queries, and it got rid of the administrative tasks appearing
in timesheets in our lab. I am still a bit hesitant to run the queries
against a live production database at our client, though. Has the procedure
been thoroughly tested for unexpected side-effects?

Regards

Dries

 

[johndellenbagh]

Dries / Gary,

As of now there is no MSFT KB article for this but I will speak with
our content manager to push for KB creation. The product group does
not recognize this as a bug since they intended for the Non-project
time to migrate over, largly due to customers who want to see the non
project time from their Project 2002 db, then use Administrtive
projects to track additional Non-project time.

As far as I know, I don't know or haven't seen any side affects. The
queries are pretty specific to the non-project time and do not affect
other tables. I have delivered this as a solution to some pretty
large companies and have not heard of any side affects.

If you need to discuss this further, please feel free to contact me at
MSFT (e-mail address removed) or 425-704-5962.

I hope this helps.

John Dellenbaugh
MCSE/MCSA
425-501-3705
(e-mail address removed)

 

[Gary L. Chefetz \(MVP\)]

John:

Thankfully, I've made sure that none of my clients implemented this feature
in 2002, so no direct impact here, but I do thank you for pushing the
content folks. In the tradition of 2002, now that the service pack has been
out six months, it's time for the documentation to appear.<g>

--

Gary L. Chefetz, MVP
"We wrote the book on Project Server
http://www.msprojectexperts.com

-