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.

How can i add a new data base for P6.V7

12 replies [Last post]
Thu, 2010-08-19 03:03
forat faris
User offline. Last seen 8 years 36 weeks ago. Offline
Joined: 24 Jul 2006
Posts: 28
Groups: None
Dear all
Greetings,
How can i add a new data base for P6.V7 ?
Before in p6.1 we had the file (ConfigAsst)..but here nothing..
Hoping for your help.
Thanks
Top

Replies

Thu, 2013-12-19 06:57
#1
Antonio Palomar
User offline. Last seen 8 years 44 weeks ago. Offline
Joined: 17 Nov 2012
Posts: 3
Groups: None

if we cannot add new data base in P6 v7, how can we un-instal it so we can install a new one

Top
Tue, 2011-03-08 13:37
#2
jas thak
User offline. Last seen 12 years 30 weeks ago. Offline
Joined: 8 Mar 2011
Posts: 2
Groups: None

Is it possible to load activities in P6.V7 to Oracle data base ?

If so, please explain how can it be done.

 

Thanks  jasthak

Top
Mon, 2010-08-23 08:51
#3
forat faris
User offline. Last seen 8 years 36 weeks ago. Offline
Joined: 24 Jul 2006
Posts: 28
Groups: None
Thank you david
it is working now ,
the corrected settings are :
DBA user name--------------------sa
DBA Password ---------------------Prima123Vera
Database host address-------------LOCALHOST\PRIMAVERA
Database host port -------------- 49701 (Based on Rodel Instructions above)
New problem coming :after reaching (creating database )
first step :Create the PMDB tables ---------------ok
second step :Load sample data------ coming this massage :
"Error in Load data from datasource SAMPLE:pmdb_ec_empty.zip : DatabaseToolException (Value not of a valid date string. Type is YYYY-MM-DD HH:mm:ss.s)"

thanks a lot
Top
Mon, 2010-08-23 08:20
#4
David Smith
User offline. Last seen 9 years 30 weeks ago. Offline
Joined: 10 Feb 2009
Posts: 7
Groups: Petro-Chem / Oil & Gas
Correction: YourComputerName\PRIMAVERA
Top
Mon, 2010-08-23 08:19
#5
David Smith
User offline. Last seen 9 years 30 weeks ago. Offline
Joined: 10 Feb 2009
Posts: 7
Groups: Petro-Chem / Oil & Gas
If it is a stand alone installation. The host name should be:
\PRIMAVERA or simply LOCALHOST\PRIMAVERA

The stand alone installation creates a named instance (PRIMAVERA) so you must include that in your database host name.

Top
Mon, 2010-08-23 07:47
#6
forat faris
User offline. Last seen 8 years 36 weeks ago. Offline
Joined: 24 Jul 2006
Posts: 28
Groups: None
Thanks again Rodel..
Not working again
i allowed to myself to send you an excel file showing my settings..
Best regards
Top
Mon, 2010-08-23 06:11
#7
Rodel Marasigan
User offline. Last seen 1 hour 44 min ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Forat,
Can you check again the TCP. It’s normally 4 numbers.
Also make sure the login are:

usersname: sa
password: Prima123Vera

Good Luck!!!

Best Regards,
Rodel
Top
Mon, 2010-08-23 06:00
#8
forat faris
User offline. Last seen 8 years 36 weeks ago. Offline
Joined: 24 Jul 2006
Posts: 28
Groups: None
Thanks a lot Rodel....
but also not working
i got the new port =49701 ,
i changed the old one 1433 with 49701
the new massage is:
SQLServerException Login failed for user ’sa’
Top
Thu, 2010-08-19 11:41
#9
David Smith
User offline. Last seen 9 years 30 weeks ago. Offline
Joined: 10 Feb 2009
Posts: 7
Groups: Petro-Chem / Oil & Gas
The utility still exists. It is now called DBSETUP.BAT and is still located in /install/database/.

The terminology is different in Oracle. What MS SQL calls a "database" is called a "Schema" in Oracle.

You can have multiple schemas, however I do not recommend it with the Oracle XE that comes with Primavera. If you have a full Oracle server you can change the logins such as: ADMUSER_NEW, PUBUSER_NEW, PRIVUSER_NEW. Use the new logins you created in the wizard when setting up your Alias.

Top
Thu, 2010-08-19 09:54
#10
Ronald Winter
User offline. Last seen 3 years 5 weeks ago. Offline
Joined: 4 Jan 2003
Posts: 928
Groups: None
Forat,

If you are using an Oracle database, then the answer is easy; there is no way to add a new database. Oracle only supports one database per server (or machine). Only MSSQL and SQL Express support multiple databases. Good luck!
Top
Sat, 2010-08-21 04:55
#11
forat faris
User offline. Last seen 8 years 36 weeks ago. Offline
Joined: 24 Jul 2006
Posts: 28
Groups: None
Dear friends Ronald&David
Thanks a lot for your replies…
Daer David
Iam using MSSQL …
I tried to use (DBSETUP.BAT) ,but after two steps , coming this window
DBA user name--------------------sa
DBA Password ---------------------(Required)
Database host address-------------My name
Database host port -------------- 1433
After entering the DBA password ,an error massage coming { SQL Server Exception : The TCP/IP connection to the host (Myname) ,port 1433 has failed :"connection refused)………….."}

regards,


Top
Sun, 2010-08-22 18:24
#12
Rodel Marasigan
User offline. Last seen 1 hour 44 min ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Forat,
Database host port - 1433 is Primavera default but may not always the case a correct port and depends of what the PC assigned to your Primavera TCP address. To check the correct TCP address you have to goto Start-> Run-> Regedit and find this address:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\PRIMAVERA\MSSQLServer\SuperSocketNetLib\Tcp\TcpPort then use that address when adding new database.

Best Regards,
Rodel
Top