Installation > Post-Installation Verification and Configuration > WebFOCUS Repository Post-Installation Tasks

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

This section explains how to create the WebFOCUS Repository.

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.

Procedure: How to Create the WebFOCUS Repository Tables

To create the Repository tables:

  1. Ensure that the database server is available and/or started.
  2. From the Unix shell, navigate to the following WebFOCUS Utility directory:
    install_directory/ibi/WebFOCUS82/Utilities/WFReposUtil
  3. Execute the following command:
    WFReposUtilCMDLine.sh

    The following prompt is displayed: 

    Please select mode option for WFReposUtil:
1\) create            - create non-existing tables
2\) create_or_extend  - create tables or add missing columns to tables
3\) insert            - insert data into tables
4\) create_insert     - combo of above
5\) update            - update table data
6\) drop              - drop tables
7\) extract           - export database data to xml files
8\) create_ddl        - generate SQL scripts but not execute them
Q\) Quit
    Enter selection [default=4] :
  4. If this is a new installation and you need to create a new WebFOCUS Repository, press the Enter key to use the default option, 4 create_insert.

    This option will create tables and load initial values into the WebFOCUS Repository, which are required to begin using the product.

  5. If you typed option 3, insert, or option 4, create_insert:
    1. When you receive a prompt to enter the Database Repository Username, type the name of a valid user that has permission to create and alter tables in your Database Repository, and then press Enter.
    2. When you receive a prompt to enter the Database Repository Password, type the Password associated with the valid Database Repository user that you typed in sub-step a, and then press Enter.

      These values give the utility the authority to open the Database Repository and execute the insert or create insert commands.

    3. When you receive a prompt to enter the WebFOCUS Administrator ID, type a new User ID, and then press Enter.
    4. When you receive a prompt to enter a Password for the ID entered, type a new Password, and then press Enter.

      These values become the new WebFOCUS Administrator User ID and Password. Be sure to type a User Name and Password that you can refer to in future operations.

      Note: The special characters " $ are not permitted in the WebFOCUS Administrator User ID and Password during the create process.

  6. If you typed any other option:
    1. When you receive a prompt to enter the Database Repository Username, type the name of a valid Database Repository user that has permission to create and alter tables in your database, and then press Enter.
    2. When you receive a prompt to enter the Database Repository Password, type the Password associated with the valid Database Repository user that you typed in sub-step a, and then press Enter.

      These values give the utility the authority to open the Database Repository and execute the command you selected in step 6. Therefore, the User ID you type must have permission to create and alter tables in your database.

  7. You are prompted to choose a logging level for the utility:
    Please select logging level option for WFReposUtil:
1) off
2) severe
3) warning
4) info
5) config
6) fine
7) finer
8) finest
Q) To Quit

    If selected, the log file named WFReposUtilCmdLine.log will be created in the following directory: 

    /install_directory/ibi/WebFOCUS82/Utilities/WFReposUtil

    This utility uses the connection and sign-in information provided during the installation of WebFOCUS.

  8. If you receive a message listing an error and stating that the creation of the WebFOCUS Repository failed, open the WFReposUtilCMDLine.log file and review the log to identify the specific error messages that occurred at the time the utility terminated.

    Error messages can be generated by connection failures, the presentation of invalid database credentials, or failed attempts to connect to an inaccessible database.

  9. If you receive a message stating that the creation of the WebFOCUS Repository completed successfully, you can type Exit to close the Unix shell.

    Notes:

    • If the utility cannot connect to the database, ensure that the proper path to the JDBC driver appears in the following CLASSPATH value:
      /install_directory/ibi/WebFOCUS82/ReportCaster/bin/classpath
    • If the WebFOCUS installation program installed and configured Derby, this driver may be located as follows:
      /install_directory/ibi/derby/lib/derbyclient.jar

      If you are using a DB2 Repository, then an appropriate driver may be located as follows: 

      /QIBM/ProdData/HTTP/Public/jt400/lib/jt400.jar

      Consult your database documentation for additional information.

    • If you can connect to the database, but cannot create tables, ensure that the ID you typed for the database during the WebFOCUS installation has create permissions. You can change this User ID, as explained in WebFOCUS Client Verification and Configuration.

WebFOCUS

Feedback