P6 Database Access.

My conection to the database got bad. The user is pubuser, the database is PMDB, the password is not shown ***** and the Public Group ID is 1. The admin here says he does not know what to do, he says he installed it staight and it worked fone for me the first 2 months, until yesterday.

Oracle Primavera - PM6
D
D Artagnan 👤 Member for 17 years 8 months
· Permalink

There could be some reasons. If all what they have suggested failed then you have to get inside the MS SQL Server 2005 core.  This happens if you have 1) large data overload in the database, 2) database error in connection (inside the core), or your 3) MS SQL Server shut down without you knowing it.

1) Ok Start by checking if your MS SQL Server is running

---->Programs >  MS SQL Server 2005/2008 > SQL Server Configuration Manager (Check if all services are "green"). If "Green", then your SQL server is perfectly fine.

 

2) Proceed to the database management. Go to Programs > MS Sql server 2005/2008 > SQL Studio 

    - Username : sa ; password : Prima123Vera

   - Find your database ---> if you installed the default it should be 'pmdb$primavera", right click and 'refresh'.

Usually this works...

Please post if not, well check for some other solutions...

R
Rafael Davila 👤 Member for 22 years 3 months
· Permalink

BTW if you need to create several databases consider creating a different Windows User Account for each additional one and install the software on a Windows Virtual PC on each user account.

Please note it might only work on the separate Virtual PC's as only one database will be allowed on the regular windows environment. 

It is not as good as if using a better Microsoft or Oracle database but it shall do the trick until you upgrade your database.

Consider using free virus protection software you shall install on each virtual PC.

Free AVG is as good as the pay version.

http://free.avg.com/ww-en/homepage

R
Ronald Winter 👤 Member for 23 years 5 months
· Permalink

Juan,

The default password for the pubuser account is, pubuser (all lower-case letters.)  Good luck!

D
Daniel Limson 👤 Member for 24 years 7 months
· Permalink

Juan,

Normally, the user and password is the same "admin"

Good Luck

Daniel

R
Rafael Davila 👤 Member for 22 years 3 months
· Permalink

Juan,

You might choose one of the following options:

  • Throw away P6, forget about it and use other software. To me this would be the ideal solution as P6 is notorious for issues with the database and the amount of Bugs.
  • Keep P6 and contact ORACLE for support.
  • Keep P6 and consider contracting Miami Micro Data for training and support. I do not like P6 but probably they will, they make a living out of the issues with P6.

I will not be able to provide you with help as I would never use such software but wish good luck.

Best regards,

Rafael

Forum Sponsor

Top Posters

Josephus Enot
1 posts
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts