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
Member for16 years3 months
Submitted by Zoltan Palffy on Thu, 2019-10-03 13:11
Member for
16 years 3 monthsClick 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
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 monthsAccess violation at address
Member for
11 years 3 monthsAccess violation at address
Member for
16 years 3 monthscan you click on the error
can you click on the error and select More and post that information as well please
Member for
11 years 3 monthsThank 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
Member for
16 years 3 monthsyou 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