Using Siebel Tools > Using Siebel Tools > Workspaces Administration >

Flattening Workspace Versions

Although the Workspace mode in the master database is enabled by default, Oracle Siebel Tools is delivered with a monolithic repository without workspaces, so there is a slight change in the preparation for the build process. In this case, you need to run a full migration utility directly on the master database. Because the full migration utility is not workspace-aware, the flattening workspace process has to be run on the package master database, which is derived by cloning the master database and flattening the workspaces to obtain all the repository changes from the master database without workspace information.

Thus, the flattening of workspaces essentially collapses the MAIN branch to a single version with all the latest changes and subsequently deletes all the workspaces. The flattening process also restores the time stamps throughout the hierarchy of all objects, so the upgrade process (IRM) has no impact.

Other than the package master creation, other steps in the build process remain intact. Note that all steps such as the interface artifact migration or the Siebel Repository File generation must be run only on the package master.

A workspace administrator who is also the owner of the MAIN workspace (root, parent, or master workspace) can perform the process of flattening workspace version using the command prompt. No other users can perform this process.

After the flattening workspace version process has successfully completed, Siebel Tools will be opened in the non-workspace mode (as in the previous releases of Siebel Tools) when you access Siebel Tools.

CAUTION:  In order for the flattening process to run successfully, the parameter ServerDbODBCDataSource under the [Siebel] section in the Tools.cfg file must point to the correct data source.

This example shows the setting of the parameter ServerDbODBCDataSource under the [Siebel] section in the tools.cfg file:

[Siebel]

...

...

...

ReportsODBCDataSource = Siebel Reports: Access

LocalDbODBCDataSource = m:/siebel Local DB

ServerDbODBCDataSource = "ORAJQ141"

DockRepositoryName = Siebel Repository

HoldExportOdbcConnection = FALSE

...

...

...

To flatten the workspace versions using the command prompt

1. Open the Command Prompt window from your computer by clicking the Start button and then selecting the Run option.

   The Run window appears.

2. Enter the value CMD in the Open field.

   The Command Prompt window opens.

3. Change the directory in the Command Prompt window to the <TOOLS_HOME>/BIN folder using this command:

   cd <TOOLS_HOME>/BIN

4. Run either one of the following flattening workspace commands:
   • Run this command to mark all indexes as non-unique indexes and flatten the workspace versions:

   siebdev /c tools.cfg /l enu /d ServerDataSrc /u <User ID> /p <password> /FlattenWorkspace /DropIndexes <DB_user_name> <DB_password> <DB_platform>

   For example:

   C:\Siebel\TOOLS\BIN>siebdev /c tools.cfg /l enu /d ServerDataSrc /u sadmin /p sadmin /FlattenWorkspace /DropIndexes sadmin sadmin ORACLE

   NOTE:  The user that uses DB_user_name and DB_password in this command must have the privileges to execute the DDL statements.

   OR

   • Run this command to only flatten the workspace versions:

   siebdev /c tools.cfg /u <User ID> /p <password> /d ServerDataSrc /FlattenWorkspace

   For example:

   C:\Siebel\TOOLS\BIN>siebdev /c tools.cfg /l enu /d ServerDataSrc /u sadmin /p sadmin /FlattenWorkspace

5. Confirm that the flatting workspace version process shows the process is successfully completed.