SBL-DAT-00511: A transaction is already in progress

Applies to:

Siebel System Software - Version: 7.8.2 SIA [19213] and later   [Release: V7 and later ]
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 7.8.2 [19213] 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""""

Symptoms

Create an Integration Object based on Contact to synchronize external data with Siebel using XML. Call the "Synchronize" method from the "EAI Siebel Adapter" business service.

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)




Cause

This behavior was reproducible on the workflow and business service simulator on Siebel 7.8.2.3 [19221] 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.

Solution

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.

References

BUG:12-1G0PAAX - ERROR WHILE DOING A SYNCHRONIZE WITH THE EAI SIEBEL ADAPTER

Applies to:

Product Release: V7 (Enterprise)
Version: 7.5.3.5 [16183] Cons Sec
Database: Oracle 9.2.0.4
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.

Symptoms

SBL-GEN-00000, SBL-SFS-00211, SBL-DAT-00471, SBL-DAT-00511

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.

Thanks

Solution

Message 1

For the benefit of other users:

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

Message 2

continued from previous update ...

This is also documented in the following SupportWeb posting:
Service Request #: 38-1061492791 - UNABLE TO GENERATE ASSET TRANSACTIONS FROM PART TRACKER
Version: 7.5.2.100 [15252] 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

Message 3

continued from previous 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.

PLEASE NOTE:
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: 7.8.1.1 [19044] and later   [Release: V7 and later ]
Oracle Solaris on SPARC (64-bit)
Product Release: V7 (Enterprise)
Version: 7.8.1.1 [19044]
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***

Symptoms

The workflow process 'UCM Account Batch Data Management Workflow' is erroring out with the following error message in the logs

[0] No rows retrieved corresponding to the business component 'DeDuplication - SSA Account Key'(SBL-EAI-04378) (IDS_ERR_EAI_SA_BC_NO_DATA)

Cause

Data quality was not enabled.

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 [0] 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



Solution

Enable data quality as per bookshelf