Running a Schema Validation on the Database

The schema validation utility finds missing, extra, and modified schema objects for a P6 database.

To run a schema validation, complete the following steps:

In the software download, locate the utility in the Database Download folder.
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

)
Run validate.bat (with Windows) or validate.sh (with UNIX or Linux).
With 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. The default port is 1521.
- Database name (SID): Enter the Oracle SID for your database.
  Note: Schema validation of Oracle Autonomous Databases is not yet supported.
With a Microsoft SQL Server 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 usernames.
Review the results of the schema validation utility that display in the browser.

Related Topics