My Oracle Support Banner

UCM Survivorship Is Not Able To Update The Existing S_ADDR_PER_UPD Record For Contact Address Due To Query Having ADDR_ID IS NULL (Doc ID 2480352.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Siebel Universal Customer Master - Version 18.8 and later
Information in this document applies to any platform.

Symptoms

On : 18.8 version, Universal Customer Master

When attempting to update an address through UCMBatchProcess the following error occurs.

ERROR
-----------------------
ObjMgrBusServiceLog InvokeMethod 4 00000e295b9f084c:0 2018-09-19 14:59:41 Begin: Business Service 'UCM Survivorship Engine' invoke method: 'RegisterAttrGroupData' at 15c0dc80
EAITransaction EAITransactionGeneric 3 00000e295b9f084c:0 2018-09-19 14:59:41 SIEBEL UCM Survivorship: Inserting Attribute Group Data
ObjMgrSqlObjLog WriteRecord 5 00000e295b9f084c:0 2018-09-19 14:59:41 Begin: WriteRecord for SqlObj 'UCM Personal Address Attribute Data' at 1989f9a8
ObjMgrBusCompLog Error 1 00000e295b9f084c:0 2018-09-19 14:59:41 (oracon.cpp (4821)) SBL-DBC-00111: An error has occurred writing to a record.
Please continue or ask your systems administrator to check your application configuration if the problem persists.
SQLParseAndExecute Execute 5 00000e295b9f084c:0 2018-09-19 14:59:41 ORA-00001: unique constraint (SIEBEL.S_ADDR_PER_UPD_U1) violated
ObjMgrBusCompLog Error 1 00000e295b9f084c:0 2018-09-19 14:59:41 (oracon.cpp (1242)) SBL-DAT-00381: A record that contains identical values to the record you have created already exists.

Specifically, the log file shows the query against the S_ADDR_PER_UPD has ADDR_ID IS NULL with no value, causing 0 rows found on the S_ADDR_PER_UPD and UCM to insert another row with the same values and thus generating the error:

 


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Invoke UCMBatchManager with UCM Search Specification : [Contact.Id] = '1-17R7-1'

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot update addresses at the TEST environment (Enterprise : UCMNATEST, Server : UCMTEST03)

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.