Bentley OpenUtilities CONNECT Edition Help

To Propagate CU Updates from Master database to Oracle Lite

Because of performance issues, CU data is propagated from Master database using the Oracle Lite utility "OLLOAD" which can load data from text files (in certain format) into oracle lite database.
  1. Remove any previous CU data text files that exists in .\Program Files\Bentley\UtilitiesDesigner\
  2. Using the Bentley provided "ItemExport.xls" run the "DownloadUnitDatatoText" to create new CU data text files.
  3. Copy the files to .\Program Files\Bentley\UtilitiesDesigner\
  4. At the command prompt, run the LOADDATA.BAT utility, from ..\Program Files\Bentley\UtilitiesDesigner\, with the following parameters. Use parameters in the order specified and use a space to separate each value.

    Cmd:\> LoadData <OracleLite_Home> < EDUsername>

    Where:

    • Directory where you have the Oracle 10g Lite installed.
    • Workflow Manager User name.
      Note: This user name must match the username used to create the oracle lite replication database on this machine.

For Example: Cmd:\> LoadData C:\Oracle\OraLite10g administrator