Validating Dock Objects and Rule Definitions in the Siebel Database

Environments: Development, Test and Production.

Platforms: Windows, UNIX, IBM z/OS.

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, then 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 the following table:

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

   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, then break the file into two files and examine each separately.

   2. Query for the word error.

   3. If you locate errors, then write down the exact error text.

   4. Query for the word syntax.

   5. If you locate syntax errors, then write down the exact error text.

   6. To determine whether 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 Topic

Preserving Siebel Dock Objects and Visibility Rules