Oracle Primavera - PM6 Member for 16 years 3 months Member for 16 years 4 months Submitted by Zoltan Palffy on Wed, 2022-02-02 15:39 Permalink questions and questions and suggestions Questions 1. Did this just start to happen ? 2. Have you recently upgraded your database or operating system or has there been changes on the citrix ? 3. Does this only happen when one specific project is open ? 4. Have you recently deleted a lot of projects or activities 5. Has the database been configured to run backround jobs ? Suggestions 1. Try the same thing opening a different project (too large a project) 2. Try a different layout (sometimes layouts get corrupt) 3. Test the speed to and from the cirtix 4. Have the DBA run this script to let backround jobs run this will clean up old deleted information exec initialize_background_procs; exec system_monitor; exec data_monitor; 5. Have the DBA run this to gather statistics and make the database run fatser Go to start All programs Select Microsoft SQL Server 2005 Then Microsoft SQL Server Management Studio Server name is the name of your computer\PRIMAVERA Authentication is SQL Server Authentication Login: sa Password is: Prima123Vera Select Connect On the left expand the databases and select pmdb$primavera or whatever your datbase is Uptop select New Query on the right type this update statistics project with fullscan ,all update statistics task with fullscan, all Then right click execute Then type exec sp_updatestats Then right click execute 6. Delete and POS tables Go to Start All Programs Microsoft SQL Server 2005 SQL Server Management Express Studio Server name: is name of computer Authentication: SQL Server Authentication Login: sa Password: Prima123Vera Click Connect Click on Databases and expand it Highlight pmdb$primavera Up top select New Query On the right hand side type delete pobs; Then right click and select execute Close SQL Log in or register to post comments
Member for 16 years 3 months Member for 16 years 4 months Submitted by Zoltan Palffy on Wed, 2022-02-02 15:39 Permalink questions and questions and suggestions Questions 1. Did this just start to happen ? 2. Have you recently upgraded your database or operating system or has there been changes on the citrix ? 3. Does this only happen when one specific project is open ? 4. Have you recently deleted a lot of projects or activities 5. Has the database been configured to run backround jobs ? Suggestions 1. Try the same thing opening a different project (too large a project) 2. Try a different layout (sometimes layouts get corrupt) 3. Test the speed to and from the cirtix 4. Have the DBA run this script to let backround jobs run this will clean up old deleted information exec initialize_background_procs; exec system_monitor; exec data_monitor; 5. Have the DBA run this to gather statistics and make the database run fatser Go to start All programs Select Microsoft SQL Server 2005 Then Microsoft SQL Server Management Studio Server name is the name of your computer\PRIMAVERA Authentication is SQL Server Authentication Login: sa Password is: Prima123Vera Select Connect On the left expand the databases and select pmdb$primavera or whatever your datbase is Uptop select New Query on the right type this update statistics project with fullscan ,all update statistics task with fullscan, all Then right click execute Then type exec sp_updatestats Then right click execute 6. Delete and POS tables Go to Start All Programs Microsoft SQL Server 2005 SQL Server Management Express Studio Server name: is name of computer Authentication: SQL Server Authentication Login: sa Password: Prima123Vera Click Connect Click on Databases and expand it Highlight pmdb$primavera Up top select New Query On the right hand side type delete pobs; Then right click and select execute Close SQL
Member for
16 years 3 monthsquestions and
questions and suggestions
Questions
1. Did this just start to happen ?
2. Have you recently upgraded your database or operating system or has there been changes on the citrix ?
3. Does this only happen when one specific project is open ?
4. Have you recently deleted a lot of projects or activities
5. Has the database been configured to run backround jobs ?
Suggestions
1. Try the same thing opening a different project (too large a project)
2. Try a different layout (sometimes layouts get corrupt)
3. Test the speed to and from the cirtix
4. Have the DBA run this script to let backround jobs run this will clean up old deleted information
exec initialize_background_procs;
exec system_monitor;
exec data_monitor;
5. Have the DBA run this to gather statistics and make the database run fatser
Go to start
All programs
Select Microsoft SQL Server 2005
Then Microsoft SQL Server Management Studio
Server name is the name of your computer\PRIMAVERA
Authentication is SQL Server Authentication
Login: sa
Password is: Prima123Vera
Select Connect
On the left expand the databases and select pmdb$primavera or whatever your datbase is
Uptop select New Query
on the right type this
update statistics project with fullscan ,all
update statistics task with fullscan, all
Then right click execute
Then type
exec sp_updatestats
Then right click execute
6. Delete and POS tables
Go to Start
All Programs
Microsoft SQL Server 2005
SQL Server Management Express Studio
Server name: is name of computer
Authentication: SQL Server Authentication
Login: sa
Password: Prima123Vera
Click Connect
Click on Databases and expand it
Highlight pmdb$primavera
Up top select New Query
On the right hand side type delete pobs;
Then right click and select execute
Close SQL