Hi,
I am operating in the following corporate environment:
P6 Professional v20.12; Citrix hosted; SQL database; don't know database size but projects add up to 4.5 million activities.
The issue I have is that when I select certain menu items in the Activities window (typically Group and Sort, Columns, Bars) there is a delay of about 7 seconds before the popup box appears.
In other windows (Projects, WBS, Resource Assignments) it operates normally.
Oracle's Knowledge Base does not seem to have any information on the issue.
Has anyone else experienced this?
Is it an Oracle issue, a Citrix issue, or a database issue?
Any help would be appreciated. It drives me crazy.
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