Naveen Rawat asked 2 years ago
Title : I am facing issues regenerating the Siebel Repository Definition files.. Please advice.

Question :

I am facing issues regenerating the Siebel Repository Definition files.. Please advice.

1 Answers
Umesh SharmaUmesh Sharma Staff answered 2 years ago

Dear Naveen,
 
Here is a quick overview on the process for Regenerating Siebel Repository files:
 
Upgrades from: All Supported Siebel releases.
Environments: Development environment only.
Platforms: Windows, UNIX, IBM z/OS.
 
This topic is part of an upgrade process. See How to Perform a Siebel Database Upgrade.
If you have modified repository objects after the development environment upgrade (upgphys) and before upgrading the production test environment, you must regenerate the schema.ddl and custrep.dat files. These files were created during the upgphys:
 

  • Schema.ddl. This file contains the logical definition of the Siebel Database.
  • Custrep.dat. This file contains the definition of repository objects.

 
These files are used as input to the production test and production environment upgrades. If you modify the object definitions or the schema definitions in the repository after these files have been created, you must regenerate the files.
 
Regenerating the schema.ddl File
Use this procedure to regenerate the schema.ddl file.
 
To regenerate the schema.ddl file
 

  1. On the Siebel Server where the Siebel Database Server files are installed, navigate to the following location:
    • Windows: SIEBEL_ROOT\bin
    • UNIX: $SIEBEL ROOT/bin
  2. Run the following command:
    • ddldict /u DatabaseOwner /p Password /c “ODBCDataSource” /d TableOwner /f DBSRVR_ROOT\DatabasePlatform\schema.ddl /e y /a y /l SiebelLogDir\sch_dict.log /n “Siebel Repository” /t dcir

Where

  • DatabaseOwner is the Siebel Database administrator account name.
  • Password is the Siebel Database administrator account password.
  • ODBCDataSource is the ODBC name for connecting to the database. Enclose the name in quotes.
  • TableOwner is the Siebel table owner name.
  • DBSRVR_ROOT is the absolute path to the Siebel Database Server installation directory.
  • DatabasePlatform is the Siebel Database Server directory name for the database, for example Oracle. The example shows Windows path syntax. On UNIX systems, use UNIX path syntax.
  • SiebelLogdir is the path to the directory where you want the output log placed (log output directory). The example shows Windows path syntax. On UNIX systems, use UNIX path syntax.

 
 

  1. After the command completes, review the output log files for errors. If the log indicates there are errors, create a service request (SR) on OracleMetalink 3, or contact your Oracle sales representative for Oracle Advanced Customer Services to request assistance from Oracle’s Application Expert Services

 
 
Regenerating the custrep.dat File
Use this procedure to regenerate the custrep.dat file.
To regenerate the custrep.dat file
 

  1. On the Siebel Server where the Siebel Database Server files are installed, navigate to the following location:
    • Windows: SIEBEL_ROOT\bin
    • UNIX: $SIEBEL ROOT/bin
  2. Run the following command:

repimexp /a e /u DatabaseOwner /p Password /c “ODBCDataSource” /d TableOwner
/r “Siebel Repository” /f DBSRVR_ROOT\DatabasePlatform\custrep.dat
/l SiebelLogDir\exprep.log
 
where:

  • DatabaseOwner is the Siebel Database administrator account name.
  • Password is the Siebel Database administrator account password.
  • ODBCDataSource is the ODBC name for connecting to the database. Enclose the name in quotes.
  • TableOwner is the Siebel table owner name.
  • DBSRVR_ROOT is the absolute path to the Siebel Database Server installation directory. The example shows Windows path syntax. On UNIX systems, use UNIX path syntax.
  • DatabasePlatform is the Siebel Database Server directory name for the database, for example Oracle.
  • SiebelLogdir is the path to the directory where you want the output log placed (log output directory). The example shows Windows path syntax. On UNIX systems, use UNIX path syntax.

After the command completes, review the output log files for errors. If the log indicates there are errors, create a service request (SR) on OracleMetalink 3, or contact your Oracle sales representative for Oracle Advanced Customer Services to request assistance from Oracle’s Application Expert Services.
 

Cubastion is among a very small number of specialized Siebel CRM Oracle Gold Partners in SME.