Applies to:Siebel System Software - Version: 7.8.2 SIA 
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 7.8.2  Fin Svcs
Database: Microsoft SQL Server 2000 SP4
Application Server OS: Microsoft Windows 2000 Professional
Database Server OS: Microsoft Windows 2000 Professional
This document was previously published as Siebel SR 38-3136795571.
""""Checked for relevance on 19-NOV-2010""""
When there were Accounts to disassociate from a Contact (integration component Contact_Account) on the XML, Siebel raised the following error:
Error Code: (SBL-BPR-00162)--(SBL-DAT-00511)
Error Message: Error invoking service 'EAI Siebel Adapter', method 'Synchronize' at step 'Sync'.(SBL-BPR-00162)
Method 'DeleteRecord' of business component 'Account' (integration component 'Contact_Account') returned the following error:
"A transaction is already in progress(SBL-DAT-00511)"(SBL-EAI-04376)
This behavior was reproducible on the workflow and business service simulator on Siebel 22.214.171.124  SIA and SEA and with the Synchronize and Update methods from the EAI Siebel Adapter.
After further researches the behavior was found to be a product defect and the Change Request 12-1G0PAAX has been created regarding this issue.
As a workaround, please do not use operations on MVG associations and, instead, create a new child BC based on the intersection table to achieve the functionality .
It gives full control on all EAI operations that happens.
It requires a new BO and new IO as well.
BUG:12-1G0PAAX - ERROR WHILE DOING A SYNCHRONIZE WITH THE EAI SIEBEL ADAPTER
Applies to:Product Release: V7 (Enterprise)
Version: 126.96.36.199  Cons Sec
Database: Oracle 188.8.131.52
Application Server OS: Microsoft Windows 2000 Advanced Server SP 2
Database Server OS: Sun Solaris 8
This document was previously published as Siebel SR 38-2621404712.
An Account has been created and an asset created from a serialised product bundle has been
allocated to this account in the Assets screen. When attempting to install new components or
de-install existing components of this asset through the Parts Tracker tab, upon hitting the
commit button, an error message is received saying "Unable to Generate Asset Transaction
(SBL-SFS-00211)" The assets exist in the appropriate inventory location, which is correctly
specified on the Part Tracker line.
The customer had old assets in the database, which could not be modified through Activity > Part Tracker. There were two reasons for this:
1) The log file showed the following sequence of events:
Query for asset 1-PRGJL (parent asset in the activity)
with inner join between SIEBEL.S_ASSET T22, SIEBEL.S_ASSET_POSTN T11, SIEBEL.S_PARTY T13:
T11.POSITION_ID = '1-X324' AND T22.ROW_ID = T11.ASSET_ID AND
T13.ROW_ID = T11.POSITION_ID AND
=> Fetch Rows: 0
ObjMgrLog Error 4 ... (SBL-DAT-00471) Invalid operation when not executed.
ObjMgrLog Error 4 ... (SBL-SFS-00211) Unable to generate asset transaction.
ObjMgrDataObjLog EndTransaction 4 ... EndTransaction (ABORT) was called ...
This means that the part movement is aborted because the parent asset is not visible to the current user.
In other words, for a user to be allowed to change the structure of an asset (e.g. de-install a sub-component) the user must be in the asset's access team.
... continued in next update
This is also documented in the following SupportWeb posting:
Service Request #: 38-1061492791 - UNABLE TO GENERATE ASSET TRANSACTIONS FROM PART TRACKER
Version: 184.108.40.206  Life Sci
Database: Microsoft SQL Server 2000 SP 2
Application Server OS: Microsoft Windows 2000 Server
Database Server OS: Microsoft Windows 2000 Server
=> 1. Change Request# 12-HTQ23Q has been logged and fixed in Siebel 7.7.
=> 2. The workaround for Siebel Industry Applications version 7.5.2 and 7.5.3 is to add the field engineer who will perform the part movement to Assets > Access Team for the parent Asset record. After this the field engineer can commit the Part Tracker without error.
... continued in next update
2) After adding the field engineer to the asset's access team the log file showed the following sequence of events:
ObjMgrLog Error 4 2005-11-15 11:21:24 (SBL-DAT-00511) A transaction is already in progress
ObjMgrLog Error 4 2005-11-15 11:21:24 SBL-GEN-00000 Unable to load message 0xffff
ObjMgrLog Error 4 2005-11-15 11:21:24 (SBL-SFS-00211) Unable to generate asset transaction.
ObjMgrDataObjLog EndTransaction 4 2005-11-15 11:21:24 EndTransaction (ABORT) was called 8cf73e8
The first error message also occurs during successful asset de-installation and can be ignored.
The reason for the second error message was that the old asset had an invalid Root Asset Id: [Root Asset Id] = [Id].
The solution is to update the old assets through scripting.
The customer created a script to do the following:
Query for all assets with [Parent Asset Id] != NULL and [Id] = [Root Asset Id]. Then for each of these get the whole [Parent Asset Id] hierarchy until an asset is reached with [Parent Asset Id] = NULL. The [Id] of this asset must be assigned to the [Root Asset Id] of all the assets in the hierarchy.
In any case you should backup your database before updating records by scripts or other means!!!
Kind regards from
Heidrun Brittain, Siebel Technical Support
Additional Keywords: Asset Mgmt - Asset - SubCompUpdate Processing, PAR_ASSET_ID, ROOT_ASSET_ID = ROW_ID.
Applies to:Siebel Universal Customer Master - Version: 220.127.116.11 
Oracle Solaris on SPARC (64-bit)
Product Release: V7 (Enterprise)
Version: 18.104.22.168 
Database: Oracle 10g
Application Server OS: Sun Solaris 9
Database Server OS: Sun Solaris 9
This document was previously published as Siebel SR 38-2989014511.
***Checked for relevance on 10-NOV-2010***
 No rows retrieved corresponding to the business component 'DeDuplication - SSA Account Key'(SBL-EAI-04378) (IDS_ERR_EAI_SA_BC_NO_DATA)
In WfProcMgr log it starts with this:
8,789 4/3/2006 20:18 1 (ucmsvccdm.cpp (428)) SBL-IAI-00443: UCM Data Quality Manager Found no match
For each record processed, this path was executed:
Instantiating step definition 'Process NoMatch'.
Invoking method 'HandleMatchCase' on business service 'UCM Batch Manager'
In this step rows are being inserted/updated on various tables such as ACCNT_POSTN, S_ORG_BU, S_PARTY, S_ORG_EXT, etc.
And when inserting into S_PARTY this error occurs:
20,456 4/3/2006 20:18 4 BEGIN INSERT INTO UCMBASE.S_PARTY ( CONFLICT_ID, LAST_UPD, CREATED, LAST_UPD_BY, CREATED_BY, MODIFICATION_NUM, ROW_ID, GROUP_TYPE_CD, NAME, PARTY_TYPE_CD, PARTY_UID) VALUES
(query.cpp (5066)) SBL-DAT-00416: No field matches identifier 'ADL Status'. Please ask your systems administrator to check your application configuration.
20,590 4/3/2006 20:18 3 Executing process definition 'UCM Key ReGenerate Workflow'.
20,612 4/3/2006 20:18 4 Invoking method 'Delete' on business service 'EAI Siebel Adapter'.
20,613 4/3/2006 20:18 4 Input: @0*0*2*0*0*0*10*SearchSpec56*[DeDuplication - SSA Account Key.Account ID] = '1-1625J'13*IntObjectName31*DeDuplication - SSA Account Key
20,625 4/3/2006 20:18 2 (physmod.cpp (3673)) SBL-DAT-00511: A transaction is already in progress
20,637 4/3/2006 20:18 1  No rows retrieved corresponding to the business component 'DeDuplication - SSA Account Key'(SBL-EAI-04378) (IDS_ERR_EAI_SA_BC_NO_DATA)
20,640 4/3/2006 20:18 1 (stepexec.cpp (803)) SBL-BPR-00162: Error invoking service 'EAI Siebel Adapter', method 'Delete' at step 'Delete Key'.
20,665 4/3/2006 20:18 1 (adptutils.cpp (5113)) SBL-EAI-04451: Method 'WriteRecord' of business component 'Account' (integration component 'Account') for record with search specification '[Party UId] = "A6520ED9-CA9D-4221-880A-0FA8152FA895"' returned the following error:"Err
20,666 4/3/2006 20:18 4 EndTransaction (ABORT) was called on DB connection 140c2bc8