Hi,
I am getting an event interception PPUSP-2728-E. The details of the error is as follows.
PasteProjectUsingSP returned error -1Error inserting into PROJCOSTORA-12952: The request exceeds the maximum allowed database size of 4 GBUnable to copy tasks in NEW_WBSError creating new wbs
How to resolve it?
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
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
can you click on the error and select More and post that information as well please
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
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