WebFOCUS Repository Post-Installation Tasks

Topics:

How to:

This section explains how to create the WebFOCUS Repository and verify the WebFOCUS Client configuration.

For NLS configuration information, review this section and consult the WebFOCUS Security and Administration manual.

WebFOCUS Repository Table Creation

The table creation utility creates or drops and creates all Repository tables. To drop and re-create only specific table groups, you can use utilities available with your database software. This is useful if you wish to remove all library data, but keep your schedules and address books.

Since the WebFOCUS Repository has been restructured as of WebFOCUS 8.2 and is different from previous WebFOCUS releases, you must create a new Repository when migrating from earlier WebFOCUS 7.7.x versions. For more information on migrating existing ReportCaster data, see the Migration manual.

Procedure: How to Create the Repository Tables

To create the Repository tables:

  1. Navigate to the following directory:
    drive:\ibi\WebFOCUS82\utilities\WFReposUtil

    Note: During installation, if the Create WebFOCUS Repository check box is selected, then the installer will run the WFReposUtilCMDLine.bat file in CREATE_INSERT mode. If any errors occur during this process, you can view the WFReposUtilCMDLine.log file for details. If the Create WebFOCUS Repository check box is not selected during installation (in the case of an existing Repository), then you must manually run the WFReposUtilGUI.bat file in DROP_CREATE_INSERT mode. Alternatively, you can run the WFReposUtilCMDLine.bat file in DROP_CREATE_INSERT mode.

  2. Run the WFReposUtilCMDLine.bat file by right-clicking the file and selecting the Run as Administrator option.

    This utility creates a .log file with the same name in the same location after running it.

    A Command Window opens, which allows you to create tables or to drop and re-create tables.

  3. Enter a selection from the list of available options:
    • create
    • create_or_extend
    • insert
    • create_insert
    • update
    • drop
    • extract
    • create_ddl
    • quit
  4. Press Enter to continue.

    A prompt for credentials displays. These are credentials for the database connection.

    Note:
    • If updates are performed, the User ID needs to have permissions to create and alter tables.
    • Depending on the option selected, you may be prompted for WebFOCUS Administrator credentials.

    A message appears if any errors occur during the Repository creation or re-creation process.

WebFOCUS

Feedback