Skip to content
ProjectControls.com
Oracle Primavera - PM6

Import failed due to exceed the datebase capacity

In the Open Standard
Jimmy XieMember for 12 years 9 months
Created
3
3
0

Hi guys

I'm useing P6 R8.1 standalone version, and have serveral projects imported in the software. Now I want to import another new project, but one tip showed up some time after the importing process started, stating the request have exceed the maximum capacity of datebase (Code:PRMDB-0398-8).

I checked my datebase, and the 4GB almost used up. I tried to delete some project from P6, while there was no much change to the used percentage of datebase.

Any advise how can this problem be solved?

Thanks.

 

Save Follow Follow forum Report
Reply New topic

3 replies

Oldest first
  1. 0
    Zoltan Palffy ·
    #1

    this is like eating an

    this is like eating an Elephant you have to delete info in chunks

    step #1

    you have to delete a few activites first then you can delete a group of activities.

    Then you can delete the projects that you no longer need

    Step #2

    create an additional database

    for instructions on how to do this click on this link

    http://pmsite.com/forums/viewthread/3329/

     

    Step #3

    Log into microsoft sql

    Run this script 

    Highlight pmdb

    Then type

    update statistics project with fullscan ,all
    update statistics task with fullscan, all

    Then right click execute

     

    Then type

    exec sp_updatestats

    Then right click execute

     

    Step #4

    compress your existing database and then compress your existiing file

    for instructions on how to do this click on this link

    http://pmsite.com/forums/viewthread/3330/

    Report
  2. 0
    Jimmy Xie ·
    #2

    Hi, ZoltanThanks for your

    Hi, Zoltan

    Thanks for your reply. Is above said mehod to add SQL datebase applicable if I'm currently using ORACLE DATEBASE?

    Report
  3. 0
    Zoltan Palffy ·
    #3

    yes the compression is for an

    yes the compression is for an sql database

    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?