Search This Blog

Sunday 19 January 2020

Use the validaterpd Utility to Check Repository Consistency

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

1 comment:

OBIEE 12c to OAS Migration

 Hi All, I have migrated successfully few projects from BI 12c to OAS 6.4. If  anyone wants help then please reach Me! Cheers! Bose

Recent Posts