Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Missing Project ID

14 replies [Last post]
Tue, 2008-04-15 03:56
Ferdinand U.
User offline. Last seen 6 years 44 weeks ago. Offline
Joined: 19 Jul 2007
Posts: 142
Groups: Pinoy Planning Planet Community
Hi all!

I have imported a project group from P3 to P6, say Project ID 0299, now i deleted the project’s activities (only Activities, not the project group). When i opened the Projects (from Enterprise, Projects) the project 0299 is missing,when i try to add new project with ID 0299, it is showing "the project ID must be unique" in yhe dialog box.. how can i find that missing project 0299? need help
Top

Replies

Tue, 2008-04-15 09:06
#1
DANG CORP
User offline. Last seen 8 years 43 weeks ago. Offline
Joined: 3 Oct 2004
Posts: 71
Groups: None
u welcome matey,

word of advise,

try not to use numbers as ur PROJECT ID,

or else, when u bring into excel (which is often)

ur 0299 will become ---> "299" (notice the zero is taken out)

as EXCEL is too smart, it assume its a number and so on,


then u will get lost when u need to search for project id of 299 ,,, etc...


maybe called it your initial "FU-0299" or "P0299" etc.... u get the point


Vu Dang
dangcorp.com


Top
Tue, 2008-04-15 08:40
#2
Ferdinand U.
User offline. Last seen 6 years 44 weeks ago. Offline
Joined: 19 Jul 2007
Posts: 142
Groups: Pinoy Planning Planet Community
whow, my boss did it, he come across all task related tables and deleted all 0299 ids in the database, now its ok




thank you mr vu and dieter
Top
Tue, 2008-04-15 07:11
#3
DANG CORP
User offline. Last seen 8 years 43 weeks ago. Offline
Joined: 3 Oct 2004
Posts: 71
Groups: None
that is normal,

once u remove it,it shuold all be gone isnt it?

Vu Dang
Top
Tue, 2008-04-15 07:05
#4
Ferdinand U.
User offline. Last seen 6 years 44 weeks ago. Offline
Joined: 19 Jul 2007
Posts: 142
Groups: Pinoy Planning Planet Community
i notice something that it shows under column update_user (from do.task,colum Proj_id)as DAMONBG INSTEAD OF ADMIN
Top
Tue, 2008-04-15 07:04
#5
DANG CORP
User offline. Last seen 8 years 43 weeks ago. Offline
Joined: 3 Oct 2004
Posts: 71
Groups: None
go into the task table and remove all tasks that have that PROJECT ID...

what they are saying is: u got a tasks that is attached to that proejct u r trying to remove.


Top
Tue, 2008-04-15 07:02
#6
Ferdinand U.
User offline. Last seen 6 years 44 weeks ago. Offline
Joined: 19 Jul 2007
Posts: 142
Groups: Pinoy Planning Planet Community
i have tried to delete the row but it keep on letting me change something in dbo.task under column proj_id,

i tried to delete that row containing 0299 but it shows the same
Top
Tue, 2008-04-15 06:53
#7
DANG CORP
User offline. Last seen 8 years 43 weeks ago. Offline
Joined: 3 Oct 2004
Posts: 71
Groups: None
in p6, when u delete a project, it still there.

so since u can open the DB, (good on u)



"project" and "projwbs"
both ok,,, i know, funny design.
that is why p3e is slow sometimes,


go to the project table and projwbs
and look for that project ID and rmeove that ROW...


kool?


Top
Tue, 2008-04-15 06:50
#8
Ferdinand U.
User offline. Last seen 6 years 44 weeks ago. Offline
Joined: 19 Jul 2007
Posts: 142
Groups: Pinoy Planning Planet Community
hi vu

i have deleted the baseline instead of restoring it, but when i use the ID 0299, it still requires "Unique ID Name", this means i havent solve the problem yet.. the ID still exists in the database, maybe u have other ideas

i was able to open the database and so the ID 0299, whats the next move
Top
Tue, 2008-04-15 06:38
#9
DANG CORP
User offline. Last seen 8 years 43 weeks ago. Offline
Joined: 3 Oct 2004
Posts: 71
Groups: None
open that "X" project first,

then click "project on the menu"

then click MAIN BLINE

then window pop up,

look for "RESTORE"


Top
Tue, 2008-04-15 06:35
#10
Ferdinand U.
User offline. Last seen 6 years 44 weeks ago. Offline
Joined: 19 Jul 2007
Posts: 142
Groups: Pinoy Planning Planet Community
hi

how can i release the baseline project from the existing project from MAINTAIN BASELINE? i am still new in P6, i saw the file already but dont know how to take it back as part of the project group again, thnx
Top
Tue, 2008-04-15 06:23
#11
DANG CORP
User offline. Last seen 8 years 43 weeks ago. Offline
Joined: 3 Oct 2004
Posts: 71
Groups: None
or another way, if you dont know how to look in DATABASE table is:


open up all the PROJECTS!!!!


and go to maintain baseline, and u will see that,
it has all the baseline list for each proejct,,,

of course,, this will incluse ur missing project too....

"0299"

but the bad thing about this way is,,, PRIMAVERA dont show project ID,, (silly thing) it only shows u PROJECT NAME!!!!

so i hope ur "0299" have a quite unique name matey.

Vu Dang
dangcorp.com


try it out and see how u go,.


--------and what Dieter meant is,,, make sure u r ADMIN super user to make sure u can see all projects... it could be simple as that. :) but i am sure u would of try this already.
Top
Tue, 2008-04-15 06:12
#12
DANG CORP
User offline. Last seen 8 years 43 weeks ago. Offline
Joined: 3 Oct 2004
Posts: 71
Groups: None
Hi Ferdinand,

"in SUMMARY"
-- u get this when that project is a baseline of another project, that u r not aware of....

-- "its funny i know"




this happen to one b4,

if you know about database,
then do this.
========
go into the database table and search for the project ID,
u will notice that, the project "0299" is a baseline of another project,,,,, for example "X"

once u know that the X has a baseline of project "0299"
go into the PRIMAVERA and open up "X"

u will notice that it has a baseline of "0299"


so --what u do now, is RELEASE "0299" as a normal project and bingo, u r done.



-----------------




if you dont know how to view rows in DATABASE
then do this.
---
call up the primavera guys and says, and ask them how to find out which project have this "0299" as a baseline.

then they will go into the database and find out for you.


Top
Tue, 2008-04-15 06:10
#13
Ferdinand U.
User offline. Last seen 6 years 44 weeks ago. Offline
Joined: 19 Jul 2007
Posts: 142
Groups: Pinoy Planning Planet Community
Thank You Mr Wambach

I have already tried that (Find command) and i have tried many solutions (All default Filter, Layouts, Group/Sort, incl No Group), but i couldnt find any possible solution. Or maybe there is a command to hide or unhide project?
Top
Tue, 2008-04-15 05:12
#14
Dieter Wambach
User offline. Last seen 7 years 10 weeks ago. Offline
Joined: 15 Jan 2007
Posts: 1350
Groups: Petro-Chem / Oil & Gas, TILOS
Hi Ferdinand
View "Projects" --> move mouse int column with Project-ID --> "Ctrl"-key together with "F" --> Type "0299" --> the project will be highlighted.
If not, then you have no access rights to this project - sounds strange but might happen. Then you should ask the admin.
Regards
Dieter
Top