Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Event PPUSP-2728-E

6 replies [Last post]
Thu, 2019-10-03 08:52
Paul Zacharia
User offline. Last seen 4 years 26 weeks ago. Offline
Joined: 12 Jul 2014
Posts: 19
Groups: Planning, Claims & Contracting

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?

Top

Replies

Mon, 2019-10-14 13:48
#1
Zoltan Palffy
User offline. Last seen 3 weeks 1 day ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

 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 systemnext 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

Top
Sat, 2019-10-12 07:12
#2
Paul Zacharia
User offline. Last seen 4 years 26 weeks ago. Offline
Joined: 12 Jul 2014
Posts: 19
Groups: Planning, Claims & Contracting
Access violation at address 0000000000EA5179 in module 'PM.exe'. Read of address 0000000000000018
Top
Sat, 2019-10-12 07:15
#3
Paul Zacharia
User offline. Last seen 4 years 26 weeks ago. Offline
Joined: 12 Jul 2014
Posts: 19
Groups: Planning, Claims & Contracting
Access violation at address 0000000000EA5179 in module 'PM.exe'. Read of address 0000000000000018
Top
Thu, 2019-10-10 13:51
#4
Zoltan Palffy
User offline. Last seen 3 weeks 1 day ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

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

Top
Wed, 2019-10-09 13:24
#5
Paul Zacharia
User offline. Last seen 4 years 26 weeks ago. Offline
Joined: 12 Jul 2014
Posts: 19
Groups: Planning, Claims & Contracting
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
Top
Thu, 2019-10-03 12:11
#6
Zoltan Palffy
User offline. Last seen 3 weeks 1 day ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

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

 

Top