Siebel Database Upgrade Guide > Postupgrade Tasks for the Siebel Database and File System >

Validating Dock Objects and Rule Definitions in the Siebel Database


Upgrades from: All Supported Siebel releases.

Environments: Development, production test, production.

Platforms: Windows, UNIX, IBM z/OS.

This topic is part of an upgrade process. See How to Perform a Siebel Database Upgrade.

Changes to visibility rules and dock objects require the assistance of Oracle Advanced Customer Services.

If you deploy Siebel Business Applications to mobile users with local databases, you can run the DICTUTL utility to verify that all dock objects and rule definitions are correct. Dock objects allow mobile users to synchronize their local databases with the Siebel Server. Rules determine which data users synchronize. For more information about dock objects and rules, see Siebel Tools Online Help and Siebel Remote and Replication Manager Administration Guide.

To verify that all dock object and rule definitions are correct

  1. Navigate to the following directory:

    Windows: SIEBEL_ROOT\bin

    UNIX: $SIEBEL_ROOT/bin

  2. Type the following command using the parameters specified in Table 39:

    dictutl /C ODBC_DATASOURCE /U USERNAME /P PASSWORD /D TABLEOWNER /N "REPOSITORY_NAME" /A y 2> logfile.log

    Table 39. Command Line Flags for DICTUTL
    Flag
    Parameter
    Description
    Required

    /C

    ODBC_DATASOURCE

    ODBC datasource name

    Yes

    /U

    USERNAME

    User name to log in to database

    Yes

    /P

    PASSWORD

    User password to log in to database

    Yes

    /D

    TABLEOWNER

    User name of tableowner

    Yes

    /N

    "REPOSITORY_NAME"

    Name of repository for dictionary (the parameter must be bounded within double quotes)

    Yes

    /A

    y or n

    Enter the y parameter to ignore the dictionary cache. Enter n if you do not want to ignore the dictionary cache.

    Yes

  3. Review the LOGFILE.log file:
    1. Open the file in Microsoft Excel. If the file is too large for Excel to display the whole file, break the file into two files and examine each separately.
    2. Query for the word error.
    3. If you locate errors, write down the exact error text.
    4. Query for the word syntax.
    5. If you locate syntax errors, write down the exact error text.
    6. To determine if the errors must be resolved, contact your Oracle sales representative for Oracle Advanced Customer Services to request assistance from Oracle's Application Expert Services.

      The following types of entries indicate that no errors were found:

      • Errors: 0
      • Syntax OK
Related Topics

Preserving Siebel Dock Objects and Visibility Rules

Siebel Database Upgrade Guide Copyright © 2008, Oracle. All rights reserved.