Running a Schema Validation on the Database

Contents

The schema validation utility finds missing, extra, and modified schema objects for a P6 database. Depending on the operating system, use the appropriate file to run the schema validation.

• For Windows, run validate.bat
• For Linux/Unix systems, run validate.sh

To run the schema validation, proceed as follows.

1. In the software download, locate the utility in the Database Download folder.
2. Edit the utility similar to the following:

   @echo off

   REM --------------------------------------

   REM Run the Primavera Schema Validation Tool

   REM --------------------------------------

   SET JAR_FILE_DIR=lib

   SET JAR_FILE_NAME=dbmt.jar

   SET DB_SCHEMA=ppm

   SET JVM_PROPERTIES=-Ddbmt.dbschema.package.location=%JAR_FILE_DIR% -Dprimavera.db.schema=%DB_SCHEMA% -Dcom.primavera.database.logfile=SchemaValidation.log

   SET DBMT_ACTION=application/ppmschemaval

   SET DBMT_COMMAND=schemavalpm

   set JAVA_HOME=C:\Program Files\Java\jre6

   IF NOT EXIST "%JAVA_HOME%\bin\java.exe" (

   echo JAVA_HOME IS NOT SET

   pause

   goto :EXIT

   )

3. Run validate.bat (or validate.sh).

   For an Oracle database in an Enterprise environment, enter values for the following:

   • Username: Use the appropriate ADMUSER username and password.
   • Database host address: Database server name or IP address.
   • Database host port: The port your Oracle listener is listening on. (Default is 1521)
   • Database name (SID): Enter the Oracle SID for your database.

     Note: When running for an Enterprise version of the database, you will be prompted for the appropriate privileged and public usernames.

   For a SQL Server 2005 database, enter values for the following:

   • Database host address: Database server name or IP address.
   • Database host port: The SQL port.
   • Database name: pmdb$primavera (default)

     Note: When running for an Enterprise version of the database, you will be prompted for the appropriate privileged and public user names.

4. The browser displays the results of the schema validation utility.