My Oracle Support Banner

UCM Transaction Manager query using the wrong id value - leading to error "The operation is invalid ... " (Doc ID 876690.1)

Last updated on FEBRUARY 04, 2019

Applies to:

Siebel Universal Customer Master - Version 8.0.0.2 [20412] and later
Information in this document applies to any platform.



Symptoms

When sending a crmml message into the UCM system, the message contains xml tag for PartyUid and Id.

When a new set of PartyUid and Id values are submitted into the UCM system, this creates a new account into the UCM system.

Then, another crmml message is sent to UCM system with a new PartyUid value but same Id value. In this case, the UCM workflow 'UCM Transaction Manager' business service should use the value from Id tag to query for a best version record. Since the new account created earlier has this Id value, it would have produced a match and performed an upsert using the crmml message in the 2nd request.

However, the problem is that the 'UCM Transaction Manager' business service is querying for the best version record using the value from the wrong xml tag. The query should be using the value from the incoming crmml message Id tag to find the best version record. Instead, the 'UCM Transaction Manager' is using the value from the PartyUid tag, the query using this value returns 0 rows, which then generates an error and causes the entire transaction to fail with the following messages:

ObjMgrBusCompLog Warning 2 0000001a4a48901c:0 2009-06-29 04:55:22 (sqlobj.cpp (26590)) SBL-DAT-00461: The operation is invalid when there are no rows available.

EAISiebAdpt EAISiebAdptWrn 2 0000001a4a48901c:0 2009-06-29 04:55:22 CIF Transaction Mgr Failed to find current record for incoming record with SDH Id User Key
ObjMgrBusServiceLog Error 1 0000001a4a48901c:0 2009-06-29 04:55:22 (fasvcciftransmgr.cpp (2467)) SBL-IAI-00462: CIF Transaction Mgr Failed to find current record for incoming record with SDH Id User Key
EAISiebAdpt EAISiebAdptWrn 2 0000001a4a48901c:0 2009-06-29 04:55:22 CIF Transaction Mgr service: Existing Account Best Version Record with RowId = 1-4QHSLF not found for System Id Siebel
ObjMgrBusServiceLog Error 1 0000001a4a48901c:0 2009-06-29 04:55:22 (fasvcciftransmgr.cpp (1787)) SBL-IAI-00502: CIF Transaction Mgr service: Existing Account Best Version Record with RowId = 1-4QHSLF not found for System Id Siebel

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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