SBL-DAT-00380: Column '%1' is defined more than once in table definition '%2'.

Applies to:

Siebel Tools - Version: 7.7.2.6 SIA [18372] - Release: V7
Sun Solaris SPARC (64-bit)
Product Release: V7 (Enterprise)
Version: 7.7.2.6 [18372] Life Sci
Database: Oracle 9.2.0.6
Application Server OS: Sun Solaris 9
Database Server OS: Sun Solaris 9

This document was previously published as Siebel SR 38-3289868991.

Symptoms

SBL-DAT-00380

Hi,
After generating an all compile from the Siebel Repository we are receiving an error whenever we are trying to run genbscript . Seems a corrupt srf is being generated. The error that pops up after trying to run genbscript is

Siebel Enterprise Applications has encountered a problem and needs to close .We are sorry for the inconvenience.
If you were in the middle of something, the information you were working on might be lost.
For more information about this error,click here.

Error Signature
AppName:genbscript.exe
AppVer:7.7.2.6
MOdName: sslcshar.dll
ModVer: 7.7.2.6
Offset
00007740

We have also seen the support web for the siebel error SBL-DAT-00380 .
Please find attached a log file which has been generated .Could you please also let us know the LOV values that are being used by Siebel Tools during Compilation.

Thanks

Solution

Message 1

For the benefits of other users:

Customer encountered error when trying to run genbscripts against their srf file.

The following error and Call Stack were even found in the Siebel.log

ObjMgrLog    Error    1    0    2007-03-02 05:40:42    (objdef.cpp (5404)) SBL-DAT-00380: Column 'ROW_ID' is defined more than once in table definition 'S_PRI_LST_BU'.

- CALL STACK -
sslcshar +0x7740 = CCFMap<CCFElemStr,CCFElemPtr<void> >::GetStartPosition() +0x0 sscfdm +0x4ea2b = CSSFieldList::ResetBCFieldIndexes() +0x23f5b
sscfdm +0x54145 = CSSFieldList::ResetBCFieldIndexes() +0x29675
sscfdm +0x108ba = CSSSavedSqlParts::SetPartInvalid() +0x194a
sscfdm +0x6095d = CSSModelPhysDef::Load() +0xad


Resolution:

It was suspected that this was related to issue on the LOV record. Increased in logging on the Siebel Tools log, siebdev.log, shows that Siebel Tools was accessing LOV of type 'COLUMN_DATA_TYPE' and 'CASCADE_MODE' during compilation.

It was found that there were LOV of type 'COLUMN_DATA_TYPE' and 'CASCADE_MODE' with Poland entries (Unshipped Language entries). Removing these LOV of type 'COLUMN_DATA_TYPE' and 'CASCADE_MODE' with Poland entries resolved the issue.

Many Thanks,
Siebel Technical Support.

Applies to:

Siebel Tools - Version: 7.5.3 [16157] - Release: V7
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 7.5.3 [16157]
Database: Microsoft SQL Server 7.0 SP 3
Application Server OS: Microsoft Windows 2000 Server
Database Server OS: Microsoft Windows 2000 Server

This document was previously published as Siebel SR 38-1737259703.
***Checked for relevance on 15-Feb-2010***

Symptoms

SBL-JCA-00227, SBL-DAT-00380

Supportweb,

We are currently experiencing an issue when performing a full compile connected to the server databases of our development and test environments. Full compiles created for any of the languages we use produces a .srf file smaller than 41 Mb. When we place this srf on the server or use it for a dedicated client, the client immediately crashes with an Access Violation error.

The event viewer lists the following information:

The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Exception 0xc0000005 at 0x0046a119
Thread: 0x00000708, Process 0x00000644

- CONTEXT -
EIP: 0x00000401, EFL: 0x00010246, FS: 0x00000038, GS: 0x00000000
CS: 0x0000001b, DS: 0x00000023, SS: 0x00000023, ES: 0x00000023
EAX: 0x00000000, EBX: 0x0b1d7b54, ECX: 0x0a961614, EDX: 0x00000000
ESI: 0x00471360, EDI: 0x0a961614, EBP: 0x002d0456, ESP: 0x00439a04

- CALL STACK -
sslcshar +0x1a119 = SSstring::operator=() +0xa9
sslcshar +0x214fc = CCFPropertySet::SetProperty() +0x1c
SSCACMBC +0x3f06b = CSSBCBase::LoadAuditTrail() +0x23b
SSCACMBC +0xadc0 = CSSBCBase::SqlSetFieldValue() +0xb0
sscfom +0x3067a = CSSBusComp::SetFieldValue() +0x6ca
sscfom +0x3abcd = CSSBusComp::ValidatePickValue() +0x60d
sscfom +0x304d9 = CSSBusComp::SetFieldValue() +0x529
sscfomlg +0x55af = CSSELBusCompImpl::SetFieldValue() +0x3af
sscfjs +0xaacf = CSSBusCompJSDongle::SetFieldValue() +0xaf
sscfjs +0x3c50d = callFunction() +0x92d
sscfjs +0x392f2 = secodeInterpret() +0x952
sscfjs +0x3bb70 = callFunctionFully() +0x30
sscfjs +0x31f5c = jseCallFunctionEx() +0x33c
sscfjs +0x9411 = CSSJSDongle::CallEvent() +0x481
sscfjs +0x154c = CSSJavaScriptMechInst::CallEvent() +0x14c
sscfel +0x4382 = CSSELIface::ForwardEvent() +0x92
sscfel +0x4528 = CSSELI...

Cause

It has been found that the customer has used an unsupported way to deploy an unshipped language. Instead of copying only the LOV records needed in the user interface a script has been executed which copied also LOV records used by Siebel Tools. As Siebel Tools has accesed these records and found the Belgian translations instead of the expected English values the srf file has been corrupted

Solution

Message 1

For the benefit of other readers.

DESCRIPTION:
After running a full compile the Siebel application does not start up and immediately crashes.

CAUSE:
It has been found that the customer has used an unsupported way to deploy an unshipped language. Instead of copying only the LOV records needed in the user interface a script has been executed which copied also LOV records used by Siebel Tools. As Siebel Tools has accesed these records and found the Belgian translations instead of the expected English values the srf file has been corrupted.

SOLUTION:

After deleting the Belgian LOV records the full compile generated a working srf file.

The following enhancement request have been logged to prevent similar cases in the future:

12-T7PUHT: Please document which LOV types are allowed to be copied to unshipped language
12-T7PUFP: Tools generates a corrupt srf file when customer copied all LOV records to unshipped language
12-T7PUIY: There should be a wizard which helps the customers to deploy an unshipped language


Thank you
Siebel Technical Support
Additional keywords:

Shut down, exception, crash, full compile, MLOV, unshipped

Message 2

Setting the log level to 5 will log the following errors in Siebel.log:

ObjMgrLog    OpenSrf    5    2005-02-01 08:44:45    Begin: OpenSRF
ObjMgrLog    Error    4    2005-02-01 08:44:46    (SBL-DAT-00380) Column 'ROW_ID' is defined more than once in table definition 'S_PRI_LST_BU'.

ObjMgrLog    OpenSrf    5    2005-02-01 08:44:45    Begin: OpenSRF
ObjMgrLog    Error    4    2005-02-01 08:44:46    (SBL-DAT-00380) Column 'ROW_ID' is defined more than once in table definition 'S_PRI_LST_BU'.

Please ask your systems administrator to check your application configuration.

Exception 0xc0000005 at 0x0045e300

Thread: 0x00000f6c, Process 0x0000037c



- CONTEXT -

EIP: 0x00000000, EFL: 0x00010202, FS: 0x00000038, GS: 0x00000000

CS: 0x0000001b, DS: 0x00000023, SS: 0x00000023, ES: 0x00000023

EAX: 0x00000001, EBX: 0x0013ec48, ECX: 0x00000014, EDX: 0x0013ec78

ESI: 0x0155c908, EDI: 0x00000000, EBP: 0x00000000, ESP: 0x0013fff8



- CALL STACK -

sslcshar +0xe300 = CCFMap<CCFElemStr,CCFElemPtr<void> >::GetStartPosition() +0x0

sscfdm +0x66630 = CSSObjDefMgr::SetupTableDenorms() +0xe0

sscfdm +0x38dfc = CSSObjDefMgr::Load() +0x22c

sscfdm +0x13b1a = CSSContextManager::Load() +0x3a

sscfdm +0x79a77 = CSSModelPhysDef::Load() +0xb7

sscfom +0xaef5 = CSSModel::Load() +0x45

siebel +0x5085 = CSSTWShellApp::CreateModel() +0x105

siebel +0x6477 = CSSTWShellApp::InitInstance() +0x1167

MFC42u +0x12566 = Ordinal1569() +0x47

kernel32 +0x2141a = GetCurrentDirectoryW() +0x44

Message 3

The event log shows the following:

The description for Event ID ( 1002 ) in Source ( Siebel Application ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Exception 0xc0000005 at 0x0045e300
Thread: 0x00000e38, Process 0x00000f08

- CONTEXT -
EIP: 0x00000000, EFL: 0x00010202, FS: 0x00000038, GS: 0x00000000
CS: 0x0000001b, DS: 0x00000023, SS: 0x00000023, ES: 0x00000023
EAX: 0x00000001, EBX: 0x0013ec48, ECX: 0x00000014, EDX: 0x0013ec78
ESI: 0x01559e38, EDI: 0x00000000, EBP: 0x00000000, ESP: 0x0013fff8

- CALL STACK -
sslcshar +0xe300 = CCFMap<CCFElemStr,CCFElemPtr<void> >::GetStartPosition() +0x0
sscfdm +0x66630 = CSSObjDefMgr::SetupTableDenorms() +0xe0
sscfdm +0x38dfc = CSSObjDefMgr::Load() +0x22c
sscfdm +0x13b1a = CSSContextManager::Load() +0x3a
sscfdm +0x79a77 = CSSModelPhysDef::Load() +0xb7
sscfom +0xaef5 = CSSModel::Load() +0x45
siebel +0x5085 = CSSTWShellApp::CreateModel() +0x105
siebel +0x6477 = CSSTWShellApp::InitInstance() +0x1167
MFC42u +0x12566 = Ordinal1569() +0x47
kernel32 +0x2141a = GetCurrentDirectoryW() +0x44


And:

Faulting application siebel.exe, version 7.5.3.4, faulting module sslcshar.dll, version 7.5.3.3, fault address 0x0000e300.

**** Update******

The Siebel Bookshelf has been updated to include information regarding the integration of an unshipped language to the application:
Siebel Bookshelf: 8.0 (+)
Siebel Global Deployment Guide> Chapter 6: Localizing Global Deployments> Localizing an Unshipped Language