Skip to content
ProjectControls.com
Oracle Primavera - PM6

P6 menu items popup delay

In the Open Standard
Bill HawthorneMember for 20 years 1 month
Created
1
3
0

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.

Save Follow Follow forum Report
Reply New topic

1 reply

Oldest first
  1. 0
    Zoltan Palffy ·
    #1

    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

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?