0 Replies Latest reply: Dec 11, 2012 9:29 AM by Elish RSS

    Use replication to deploy web catalog

    Elish
      Hello everyone

      I am trying to use replication to deploy changes made to the web catalog between dev and test env. The process is described in Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition (chapter 17, 17.12.4.2) where it is suggested that issuing the replication command remotecopy "Exports the contents of the specified catalog folders from the source computer and imports them into the folders on the destination computer".

      I enabled replication on both servers by adding <Replication><Enabled>true</Enabled></Replication> to instanceconfig.xml (and restarting)

      I created a config.xml that describes the replication process:
      <?xml version="1.0" encoding="UTF-8"?>
      <Config>
      <General>
      <ExportDirectory>/home/obi/OracleDeployment</ExportDirectory>
      <LogExpiresHours>1200</LogExpiresHours>
      </General>
      <Server name="F1" user="weblogic" pwd="weblogic1">
      <Property name= "oracle.bi.presentation.url" value ="http://fsqobiapp01:9704/analytics/saw.dll"/>
      <Property name="oracle.bi.presentation.usesoaptcptransport" value="N"/>
      </Server>
      <Server name="D1" user="weblogic" pwd="weblogic1">
      <Property name= "oracle.bi.presentation.url" value ="http://dsqobiapp01:9704/analytics/saw.dll"/>
      <Property name="oracle.bi.presentation.usesoaptcptransport" value="N"/>
      </Server>
      </Config>

      I gave the Bi Administrator role permission to use SOAP (Administration->Manage Privileges)

      I give the command:
      ./sawrepaj.sh /C /home/obi/MiddlewareHome/Oracle_BI1/bifoundation/web/bin/sawrepaj/config.xml remotecopy D1 F1 /shared

      And I get this output:
      ./sawrepaj.sh
      Dec 11, 2012 5:20:27 PM SoapExec run
      INFO: Connect to server D1. Outcome: succeeded. Finished in 188.
      Dec 11, 2012 5:20:27 PM SoapExec run
      INFO: Connect to server F1. Outcome: succeeded. Finished in 597.
      Dec 11, 2012 5:20:30 PM SoapExec run
      INFO: Server D1, export to file D1_F1_copy.sawexp. Outcome: succeeded. Finished in 3078.
      Dec 11, 2012 5:20:30 PM SoapExec run
      INFO: Disconnect from server D1. Outcome: succeeded. Finished in 6.
      Dec 11, 2012 5:20:32 PM SoapExec run
      INFO: Server F1, import from file D1_F1_copy.sawexp, don't update log. Outcome: succeeded. Finished in 1799.
      Dec 11, 2012 5:20:32 PM SoapExec run
      INFO: Disconnect from server F1. Outcome: succeeded. Finished in 5.

      Nothing is copied to the destination server. I have no error messages in sawlog0.log on either server, except a message saying Weblogic logged in and logged out.

      Any ideas?

      Elish.