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

Last updated on JUNE 22, 2023

Applies to:

Symptoms

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


STEPS
-----------------------
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'"

Cause

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