Skip to content
ProjectControls.com
Oracle Primavera - PM6

Unable to open the P6 programs

In the Open Standard
Shah. HBMember for 17 years 10 months
Created
8
4
0

Hi

Is there any solution for the below problem which pop's up on opening any program

 

 

Database Server Error: Could not allocate space for object 'dbo.DLTACTV'.'ndx_dltactv_usession' in database 'pmdb$primavera' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
Warning: The join order has been enforced because a local join hint is used.
Warning: The join order has been enforced because a local join hint is used.
Warning: The join order has been enforced because a local join hint is used.
Warning: The join order has been enforced because a local join hint is used.
Warning: The join order has been enforced because a local join hint is used.
 
Regards
Shahul
Save Follow Follow forum Report
Reply New topic

8 replies

Oldest first
  1. 0
    Luca Basile ·
    #1

    Hi Are you running a

    Hi Are you running a stand-alone or Server platform? In any case sound like you run out of space in the holding machine
    Report
  2. 0
    Shah. HB ·
    #2

    Yes i do run stand alone ,is

    Yes i do run stand alone ,is there any solution but i am unable to open any program and it is not allowing to delete and import too

     

    Regards

    Shahul

    Report
  3. 0
    Amit Parmar (PMP) ·
    #3

    Hi Shahul,Can you please

    Hi Shahul,

    Can you please specify the event code number or post a print screen of the error..It will give a better understanding of the error.

    Regards

    Amit

    Check out my blog on Primavera at http://www.primaverablog.in

    Report
  4. 0
    Ronald Winter ·
    #4

    Shahul,   Sadly, you are just

    Shahul,

     

    Sadly, you are just the next P6 stand-alone user to discover Oracle’s built-in limit of 4 GB database size.  SQL Express and Oracle Express both limit their free database programs to 4 GB.  Once you reach that limit (without warning, I might add) the entire system stops working.  You are not even allowed to access the database in order to delete out material that would solve the problem.

     

    While there are a few desperate work-arounds posted in the Oracle Knowledgebase, the only real solution is to restore an old backup (you made a database backup, didn’t you?) or to uninstall Oracle Express/SQL Express and re-install it.  After the re-install, you will need to re-define the P6 OBS and then import all of your XER files.  THEN you need to make a database backup so that you don’t have to go through this painful process another time.

     

    Both Oracle and Microsoft want you to upgrade to their paid programs in order to run databases larger than 4 GB.  That is still another option.

     

    Use the Oracle Express management program (Windows Start Button / All Programs / Oracle Database 10g Express Edition / Go to the Database Home Page) or the similar SQL Express management program to confirm that you have exceeded the allowable database size.  Then go to the Oracle Knowledgebase and confirm what I have said.  Good luck!

    Report
  5. 0
    Mark Greenhalgh ·
    #5

    Thanks Ron, It makes me want

    Thanks Ron, It makes me want to logon to 127.0.0.1:8080 and make a program that will always monitor how close I am getting to the 4 GB limit.  Mark

    Report
  6. 0
    Shah. HB ·
    #6

    Thanks to all,let me give a

    Thanks to all,let me give a try to fix it

    Report
  7. 0
    Leo Nicholson ·
    #7

    Very old post, but I am

    Very old post, but I am having this problem with P6.1 Standalone.

    Which newer versions avoid this?

    Report
  8. 0
    Leo Nicholson ·
    #8

    Very old post, but I am

    Very old post, but I am having this problem with P6.1 Standalone.

    Which newer versions avoid this?

    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?