Upgrading the Repository

Follow these instructions to upgrade the repository using the BI Update Metatdata Tool.

To upgrade the repository using the BI Update Metatdata Tool:
  1. Take a backup of the repository.
  2. Create a writable directory where logs will be stored.

    For example, C:\RPD_Upgrade or WORKDIR_HOME/ RPD_Upgrade

  3. Run the following command to upgrade the repository: 
    <BI_Oracle_Home>/jdk/jre/bin/java -cp 
<BI_Oracle_Home>/biapps/patch/biappspatch.jar 
oracle.as.biapps.patch.update.UpdateBIAppsMetadata bi.oracle.home=<BI Oracle Home> bi.admin.url=<BI EM Admin URL> bi.admin.username=<bi EM Admin User> 
bi.admin.password=<BI EM Admin User Password> only.apply=rpd log.file=<Work dir>/rpd.log log.level=FINEST work.dir=<writable work dir path> 
saas.env=false

Example:

/Middleware_Home/Oracle_BI1/jdk/jre/bin/java -cp 
/Middleware_Home/Oracle_BI1/biapps/patch/biappspatch.jar 
oracle.as.biapps.patch.update.UpdateBIAppsMetadata 
bi.oracle.home=/Middleware_Home>/Oracle_BI1 bi.admin.url=http://host:7001 
bi.admin.username=weblogic bi.admin.password=password only.apply=rpd 
log.file=/WORKDIR_HOME/RPD_Upgrade/rpd.log log.level=FINEST 
work.dir=/WORKDIR_HOME/RPD_Upgrade saas.env=false

    For example: After the process starts, you are prompted with the password.

    Optional Parameters:log.level - the default is INFO. The valid values are FINEST, FINE, INFO, WARNING, SEVERE.