Remove the streams between the InForm study schema and the Cognos 8.2 environment, and uninstall the Reporting schema

Previous Topic

Next Topic

Book Contents

Remove the streams between the InForm study schema and the Cognos 8.2 environment, and uninstall the Reporting schema

Perform the following steps for every study on the InForm 4.6, 4.7, or 5.0 application server.

  1. Run deinstall_reporting_diffdb.sql.

    Note: If you are using a single database for your study and reporting, run deinstall_reporting_samedb.sql.

    This script uses the configdiffdb.sql file from the previous installation, so make sure the correct file is in place.

    Run this script as many times as necessary, to remove each study.

    1. Open a Command Prompt window.
    2. Log in to SQL*Plus with /nolog.
    3. At the SQL*Plus prompt, type the following command:

      @deinstall_reporting_diffdb.sql

    4. After you run the script, check for errors by searching for the word Error in the log file.
    5. Correct any problems and run the script again until it does not find anything to remove and does not find any errors.
  2. Run remove_streams_setup_info_diffdb.sql.

    Note: If you are using a single database for your study and reporting, this step is not required.

    This script removes the references of the study from the Streams_Setup_Info table.

    1. Open a Command Prompt window.
    2. Log in to SQL*Plus with /nolog.
    3. At the SQL*Plus prompt, type the following command:

      @remove_streams_setup_info_diffdb.sql

    4. After you run the script, check for errors by searching for the word Error in the log file.
    5. Correct any problems and run the script again until it does not find anything to remove and does not find any errors.
Send Feedback