Event PPUSP-2728-E

Member for

16 years 3 months

 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

Member for

11 years 3 months

Access violation at address 0000000000EA5179 in module 'PM.exe'. Read of address 0000000000000018

Member for

11 years 3 months

Access violation at address 0000000000EA5179 in module 'PM.exe'. Read of address 0000000000000018

Member for

16 years 3 months

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

Member for

11 years 3 months

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

Member for

16 years 3 months

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