My Oracle Support Banner

Unable To Flatten Workspace On SIT Environment (Doc ID 2437646.1)

Last updated on JUNE 22, 2023

Applies to:

Siebel Tools - Version 17.3 [IP2017] to 17.5 [IP2017] [Release V17]
Information in this document applies to any platform.


Unable to flatten Workspace on SIT environment
Migrated the code multiple times from DEV to SIT environment. It created around 14 workspaces in SIT environment and flattened the workspace. This will be easier to migrate the code to later environments.

Ran the below command :

<Siebel Home>\Tools\BIN>siebdev /c tools.cfg /u SADMIN /p S****** /d ServerDataSrc /FlattenWorkspace

It errors out as below.
GenericLog GenericError 1 000000025b602b58:0 2018-07-31 17:52:40 DELETE FROM dbo.S_SEED_MOD_OBJ WHERE REPOSITORY_ID = '1-63WQ-1';

SQLError Statement 0 000000025b602b58:0 2018-07-31 17:52:40 SQL Statement: DELETE FROM dbo.S_SEED_MOD_OBJ WHERE REPOSITORY_ID = '1-63WQ-1';

DBCLog DBCLogError      --> [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'REPOSITORY_ID'.
GenericLog GenericError --> S0022: [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'REPOSITORY_ID'.
ObjMgrBusServiceLog     --> (wsflattening.cpp (322)) SBL-GEN-00000: Unable to load message 0xffff

The issue can be reproduced at will with the following steps:
1. siebdev /c tools.cfg /u SADMIN /p S****** /d ServerDataSrc /FlattenWorkspace

    After execution of the #1 error can be seen: Flatten Workspace Fails with Error "Invalid column name 'REPOSITORY_ID'"


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.