Skip to content

Event PPUSP-2728-E

Paul ZachariaMember for 12 years 3 months
Created
6
3
0

Hi,

I am getting an event interception PPUSP-2728-E. The details of the error is as follows.

PasteProjectUsingSP returned error -1
Error inserting into PROJCOST
ORA-12952: The request exceeds the maximum allowed database size of 4 GB
Unable to copy tasks in NEW_WBS
Error creating new wbs

How to resolve it?

6 replies

Oldest first
  1. 0
    Zoltan Palffy ·

    you are over the 4 gig size

    you are over the 4 gig size limit 

    option #1 is using microsoft sql as you under laying data base (clean POSB tables)

     Click on start All Programs, Microsoft SQl Server 2005, SLQ Server Management Studio

    Authentication: Should be SQL Server Authentication

    Login: sa

    Password: Prima123Vera

    Then click connect

    Expand the database folder and click on pmdb$primavera

    Then up top select new query

    Then type this

    updatestatistics project with fullscan ,all

    updatestatistics task with fullscan, all

    execsp_updatestats

    then right click and select execute

    you can then celan the POBS tables

    up top select new query

    then type this

    delete POBS;

    the right click and select execute

    now you can close and exit out of sql

     

    option #2 add another database

    option #3 install the full version of microsoft sql (no 4 gig size limit)

    Option #4 export some of your old projects to an xer file and then delete the projects

    option #5 compress the data base and compress the file

    option #1 is using microsoft sql as you under laying data base (clean POSB tables)

     Click on start All Programs, Microsoft SQl Server 2005, SLQ Server Management Studio

    Authentication: Should be SQL Server Authentication

    Login: sa

    Password: Prima123Vera

    Then click connect

    Expand the database folder and right click on pmdb$primavera

    Then select Task

    Then select Shrink

    Then Select Database

    Then select Ok

    Next 

     right click on pmdb$primavera

    Then select Task

    Then select Shrink

    Then Select File

    Then select Ok

     

  2. 0
    Paul Zacharia ·

    Thank you Zoltan. My database

    Thank you Zoltan. My database was Oracle. So I reinstalled Primavera 17 and SQL database. Now I am getting a new error AVAA0-0896-E. Access violation at address 0000000EA5179 in module ‘PM.exe’. Read of address 0000000018. Could you please advice how to solve this. Thanks, Paul
  3. 0
    Zoltan Palffy ·

    can you click on the error

    can you click on the error and select More and post that information as well please

  4. 0
    Paul Zacharia ·

    Access violation at address

    Access violation at address 0000000000EA5179 in module 'PM.exe'. Read of address 0000000000000018
  5. 0
    Paul Zacharia ·

    Access violation at address

    Access violation at address 0000000000EA5179 in module 'PM.exe'. Read of address 0000000000000018
  6. 0
    Zoltan Palffy ·

    Click on start All Programs,

     Click on start All Programs, Microsoft SQl Server 2005, SLQ Server Management Studio

    Authentication: Should be SQL Server Authentication

    Login: sa

    Password: Prima123Vera

    Then click connect

    Expand the database folder and click on pmdb$primavera

    Then up top select new query

    next type the following

    exec system_monitor

    exec data_monitor

    then right click execute 

    Re-run the exec data_monitor until it returns 0 for "Total Rows Deleted/Changed:".

    next select new query

    type truncate table refrdel
     
    then right click execute 
     
    reboot the system
    next shrink the database

    Click on start All Programs, Microsoft SQl Server 2005, SLQ Server Management Studio

    Authentication: Should be SQL Server Authentication

    Login: sa

    Password: Prima123Vera

    Then click connect

    Expand the database folder and click on pmdb$primavera

    right click and select Task

    then select shrink database

    then ok 

    close sql

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?