P6 Data base exceeds 4GB space.
- Created
- 5
- 4
Dear All,
In the P6 8.3 version, the data base has exceeds the 4GB space, and unable to import, export or delete projects.
1. I could delete several small projects without resources and when I tried to delete bid projects "Event Code PRMDB-3293-E" and Access Error: ORA-12952 appeared.
2. I tried to delete activities in the project one by one, then increased the no of activities etc. It was working and then I tried to delete few big projects. It again worked.
3. Again the same problem reappreared after some time with the same message of 4GB space exceeding.
4. I tried "Truncate table REFRDEL" and "compact storage" by SQL command. Also I tried the SQL command "Delete from POBS"
5. Still no changes and now the main issue is I am unable to loin to P6, as the same message of exceeding the 4GB space is reappearing. The space availablity is showing 100% used.
Is there any options to solve this problem of login and to get back the free space. Is there any possibility to create a new data base with 4GB capacity (keeping the existing as it is), so that I can import the new projects into it.
Thanks and Best Regards
Kannan
5 replies
Oldest first- 0Zoltan Palffy ·
other optionsoption #1you can
other options
option #1
you can shrink the database and the file
option #2
you can create another database
here is link on how to create another database
https://tensix.com/2017/05/creating-a-new-sqlite-database-in-primavera-p6-professional/
if you do not have sql light just choose Microsoft SQL Server/SQL Server
MAKE SURE TO USE A DIFFERNT DATBASE NAME USE YOUR INITIALS LIKE KC.DB
- 0Zoltan Palffy ·
As per option 1 , what is the
As per option 1 , what is the procedure to shrink the data base and files.
to shrink the database go into the SQL and highlight the database then right click and select TASK then shrink then database then do the same for the file shrink file
s per option 2, my current data base in not SQL Lite. So I believe that I have to down load it first.
NO what everdat base that you use create another database using that if its oracle or SQL
if you send me your email address I can send detaield instructions regarding both options.
Log in or join to reply
ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.
Existing members: your original username and password still work. Forgot password?