Skip to content
ProjectControls.com
Oracle Primavera - PM6

trouble hit me

In the Open Standard
Gordon SteynMember for 16 years 10 months
Created
11
1
0
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!!!
Save Follow Follow forum Report
Reply New topic

11 replies

Oldest first
  1. 0
    A D ·
    #1
    Hi Gordon,

    Check the link showing all the necessary steps

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

    HTH

    Cheers,
    Report
  2. 0
    Gordon Steyn ·
    #2
    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.
    Report
  3. 0
    Arnold Puy ·
    #3
    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
    Report
  4. 0
    Gordon Steyn ·
    #4
    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.
    Report
  5. 0
    Dieter Wambach ·
    #5
    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
    Report
  6. 0
    Gordon Steyn ·
    #6
    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
    Report
  7. 0
    Dieter Wambach ·
    #7
    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
    Report
  8. 0
    Gordon Steyn ·
    #8
    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.

    Report
  9. 0
    Dieter Wambach ·
    #9
    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
    Report
  10. 0
    Gordon Steyn ·
    #10
    yes I can....don’t give up on me!
    Report
  11. 0
    Gordon Steyn ·
    #11
    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 !!!
    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?