Skip to content
ProjectControls.com
Oracle Primavera - PM6

Sql Query Health Checks for Oracle based P3e/c Dat

In the Open Standard
Thomas LeahyMember for 22 years 4 months
Created
2
4
0

Does anyone have any Health check SQL Queries for the Oracle based version of P3e/c I am compiling a list of queries that if records are returned indicate a problem. I will post the code when I have built up enough to make it interesting.

Regards,
Tom Leahy
Save Follow Follow forum Report
Reply New topic

2 replies

Oldest first
  1. 0
    Ronald Winter ·
    #1
    The knowledgebase on the Primavera website contains the scripts for all of the checks that P3e makes when you ask it to check the health of your schedule. There must be 30 of them there. I believe that this is what you are asking for. Good luck!
    Report
  2. 0
    Thomas Leahy ·
    #2
    You are correct (From the Knowledge Base):

    Solution ID: 200312493611

    When the project integrity check does the first database
    portion     of the integrity check, what specifically is being
    checked?
    Problem: When the project integrity check does the first database
    portion of the integrity check, what specifically is being
    checked?

    However it only shows the SQL statements for the first portion of the Project Check. Also I am finding that these checks are by no means complete so I am adding other checks I have found that are needed.

    Cheers,
    Tom Leahy
    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?