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) orvalidate.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.