Installation and Configuration Guide

Back Next

Validating the Database Schema

Use the schema validation utility to validate the database schema for any errors. The utility identifies the customized

Customer 360

resources and the custom objects that do not conform to the naming guidelines. Manually fix the errors before you upgrade

Customer 360

Open a command prompt, and go to the following directory:

<MDM installation directory>/app/tcr/bin

Run the following command:

On Windows.

validate-schema-tcr.bat

On UNIX.

validate-schema-tcr.sh

At the prompts, enter the following parameters:

Parameter	Description
MDM Hub installation directory	Fully qualified path to the directory where you installed MDM Hub.
MDM - Customer 360 installation directory	Fully qualified path to the directory that contains the Customer 360 files.
Customer 360 Operational Reference Store	Database ID of the Customer 360 Operational Reference Store.
MDM Hub user name	MDM Hub user name to access the Customer 360 Operational Reference Store.
Password	Password for the user name.

If you use a WebLogic application server, you are prompted to enter the WebLogic console password.

The utility validates the database schema. You can find the validation report as an HTML file in the following directory:

<MDM installation directory>/app/tcr/upgrade/report

To validate another database schema, press

, and enter the following parameters:

Parameter	Description
Customer 360 Operational Reference Store	Database ID of the Customer 360 Operational Reference Store.
MDM Hub user name	MDM Hub user name to access the Customer 360 Operational Reference Store.
Password	Password for the user name.