In a development a project, we are deploying RPD multiple times and checking the RPD consistency after each deployment would be task.
We could use the Oracle BI Server validaterpd utility to check the validity of all metadata objects in a repository in command prompt.
Running this utility
performs the same validation checks as the Consistency Check Manager in
the Administration Tool.
The validaterpd utility is available on both Windows (validaterpd.cmd) and Linux (validaterpd.sh) systems.
The location of the validaterpd utility is:
$BI_DOMAIN/bitools/bin
Syntax
****************
The validaterpd utility takes the following parameters:
validaterpd {-R repository_name | -I input_file_pathname |-D MDS_XML_document_directory} [-P repository_password] {-O output_txt_file_name |-C output_csv_file_name | -X output_xml_file_name} [-8] [-F fixed_rpd_name|-E] [-S] [-B]
Where:
repository_name is the name and path of the binary
Oracle BI repository file that you want to validate.
input_file_pathname is the name and path of the XML input
file that you want to validate.
MDS_XML_document_directory is the location of the input MDS XML
documents.
repository_password is the password for the repository that
you want to validate.
The repository_password argument is optional. If you don't
provide the password argument, you're prompted to enter the password when you
run the command.
output_txt_file_name is the name and path of a text(.txt or .log) file
where the validation results are recorded.
output_csv_file_name is the name and path of a csv file where
the validation results are recorded.
output_xml_file_name is the name and path of an XML file
where the validation results are recorded.
Examples
******************
The following example generates an output file called results.log that contains validation information for the repository called repository.rpd
You must provide the full path names to your repository files, both the input files and the output files, if they're located in a different directory.
./validaterpd.sh -R /home/bose/repository.rpd -O /home/bose/repository.log
Repository password: Type_Your_Repository_Password
The following example generates an output file
called results.csv that
contains validation information for the repository contained in the MDS XML
documents located at C:\MDS_dir:
./validaterpd.sh -D C:\MDS_dir -C results.csv
Give
password: my_rpd_password
Just run head -n10 of the output text, log, csv or XML file to see the first 10 lines of the results. We are good with the deployed repository if there is no errors.
$ head -n10 /home/bose/repository.log
Cheers!
Bose
