Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

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.

trouble hit me

11 replies [Last post]
Mon, 2009-11-30 07:31
Gordon Steyn
User offline. Last seen 15 years 43 weeks ago. Offline
Joined: 30 Nov 2009
Posts: 9
Groups: Civil Engineering
Yes I had P6 installed as a standalone. HDD crashed and no reasoned updates. Well I thought I try backing up the pmdb$primavera.dat & log file. Reinstalled application but here come the issues. Over writing the new installed file with current gives me the all known “bad public user name or password...”

How do I fix this? Seriously I need the file ASAP. Anybody?

Is there software that can read this file to recover? Can I somehow get the SQL server to open it for import…?

Tried Pubuser and Pivuser password as well as admin but no go…same error. Where is this file that stops logging authentication? Got to be a way to recover this pmdb$primavera file.

If any advise out there please give me detail for I can not stop half way missing a step that I don’t know about… SUPER THANKS to the one helping me. I am Stuck!!!
Top

Replies

Mon, 2009-11-30 11:56
#1
Gordon Steyn
User offline. Last seen 15 years 43 weeks ago. Offline
Joined: 30 Nov 2009
Posts: 9
Groups: Civil Engineering
GOT IT...!!!!!

Your commands did not seem to work separately but with a space line between command it worked and 4:53am my data is recovered. It need some work. Filters gone. Seems my coding structure is a mess. Level of effort activities lost interface milestones betwen programs. A days work and it is all running again....

Backups after updates....no I will freely wet myself and soak that Faulty HDD. Yeah !!!
Top
Mon, 2009-11-30 11:25
#2
Gordon Steyn
User offline. Last seen 15 years 43 weeks ago. Offline
Joined: 30 Nov 2009
Posts: 9
Groups: Civil Engineering
yes I can....don’t give up on me!
Top
Mon, 2009-11-30 11:16
#3
Dieter Wambach
User offline. Last seen 8 years 22 weeks ago. Offline
Joined: 15 Jan 2007
Posts: 1350
Groups: Petro-Chem / Oil & Gas, TILOS
Gordon

Can you see the users privuser and pubuser in the Object Explorer under Security --> Logins?

Do you have appropriate access rights?

Maybe your PC need some rest.

Good luck!

Dieter
Top
Mon, 2009-11-30 11:05
#4
Gordon Steyn
User offline. Last seen 15 years 43 weeks ago. Offline
Joined: 30 Nov 2009
Posts: 9
Groups: Civil Engineering
Dieter
It is 4 in the morning and I am up the bloody wall.

Line for line test and same error "...line1" and"...line2"

Sorry but this is not working. How it is working for you is beyond me.

Top
Mon, 2009-11-30 10:42
#5
Dieter Wambach
User offline. Last seen 8 years 22 weeks ago. Offline
Joined: 15 Jan 2007
Posts: 1350
Groups: Petro-Chem / Oil & Gas, TILOS
Gordon

Please check the syntax.

I checked (SQL 2005) and it worked. This script I used for MS-SQL Version 7 already.

I can’t check with 2008, but it should work.

Try to execute line by line.

Regards

Dieter
Top
Mon, 2009-11-30 10:19
#6
Gordon Steyn
User offline. Last seen 15 years 43 weeks ago. Offline
Joined: 30 Nov 2009
Posts: 9
Groups: Civil Engineering
All you guys thanks for the info but no success.

Dieter

If I do run your query then error
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near ’’’.

That helps me...not sure where to look
Top
Mon, 2009-11-30 09:47
#7
Dieter Wambach
User offline. Last seen 8 years 22 weeks ago. Offline
Joined: 15 Jan 2007
Posts: 1350
Groups: Petro-Chem / Oil & Gas, TILOS
Gordon

MS SQL-Server requires to synchronize priv- and pubuser if you transfer a database from one PC to another.

Run:
exec sp_change_users_login ’Update_One’, ’Pubuser’, ’pubuser’
exec sp_change_users_login ’Update_One’, ’Privuser’, ’privuser’

for your database and your new PC from MS-Sql Server Management Studio... .

Good luck!
Dieter
Top
Mon, 2009-11-30 09:38
#8
Gordon Steyn
User offline. Last seen 15 years 43 weeks ago. Offline
Joined: 30 Nov 2009
Posts: 9
Groups: Civil Engineering
I have two computers. The one crashed. I installed P6 on the other. What I could recover reading the faulty disk as d: drive I can get the raw pmdb$primavera file. Even if I change the other computer name to the same as faulty machine it still has error. SQL is crap. I can not over write or seem to import the file. The raw file is just there. What can open it? SQL studio can not create another datafile under database.
Top
Mon, 2009-11-30 08:46
#9
Arnold Puy
User offline. Last seen 10 years 33 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Groups: GPC Qatar, Pinoy Planning Planet Community
Hi Gordon,

I am not sure with my answer but perhaps this will help you. If this a stand-alone installation try to configure your database using the following:

Host Name: COMPUTER_NAME\PRIMAVERA
Database name: PMDB$PRIMAVERA
Username: pubuser
Password: pubuser
Public group ID: 1

Otherwise, there is something wrong with your database during the installation process.

Regards,

Arnold
Top
Mon, 2009-11-30 08:38
#10
Gordon Steyn
User offline. Last seen 15 years 43 weeks ago. Offline
Joined: 30 Nov 2009
Posts: 9
Groups: Civil Engineering
I was almost so happy but it lasted 1 minute.
Like I wrote...HDD crashed. Can not back up for restore. I can see the file so I need to get the SQL studio express to see it. But I can not seem to get the file attached. Same error...login bad user name from the word go. With the raw file I need magic. I can not understand why SQL can not read it. In the file is user name and password which seems to be the problem. Got to be a way to open it or bypass it. it is 2 am in the morning and still at it...I need a solution please help.
Top
Mon, 2009-11-30 07:39
#11
A D
User offline. Last seen 4 years 45 weeks ago. Offline
Joined: 20 May 2007
Posts: 1027
Groups: Accreditation Editors
Hi Gordon,

Check the link showing all the necessary steps

http://primavera.zxlm.cn/kb/prim54984

HTH

Cheers,
Top