How can i add a new data base for P6.V7
Forum Sponsor
Top Posters
Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts
if we cannot add new data base in P6 v7, how can we un-instal it so we can install a new one
Is it possible to load activities in P6.V7 to Oracle data base ?
If so, please explain how can it be done.
Thanks jasthak
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
Correction: YourComputerName\PRIMAVERA
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.
Thanks again Rodel..
Not working again
i allowed to myself to send you an excel file showing my settings..
Best regards
Forat,
Can you check again the TCP. Its normally 4 numbers.
Also make sure the login are:
usersname: sa
password: Prima123Vera
Good Luck!!!
Best Regards,
Rodel
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
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.
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!
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,
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