Reconciling a New User, Recon Event Status Stays in 'Event Received' (Doc ID 1391793.1)

Last updated on MARCH 08, 2017

Applies to:

Identity Manager - Version 9.1.0.2 and later
Information in this document applies to any platform.
**Check for Relevance on 31-Oct-2013**

Symptoms

When reconciling users from a target system, the new user data is received, but is not linked.  Re-applying the matching rule throws an error message saying "Mandatory Fields are Missing". The data appears to have all the mandatory fields.

This might start occurring after upgrade of a connector.

The Recon Event shows the following data

Recon event 164423:
Processed Data all with values.
User ID
First Name
Last Name
User Type
Employee Type
Organization Name
Status
OIMPassword



When Retry Mapping Rules is clicked, then the following Pop-up Error is displayed.
---

No value provided for mandatory fields
Insert failed.
Cannot Save: Bad SQL operation ERROR, raw value -559038737
Update failed.


Log files in DEBUG level shows:

DEBUG,[XELLERATE.SERVER],Class/Method: tcDataBase/readPartialStatement entered.
INFO,[XELLERATE.DATABASE],DB read: SELECT LKU_FIELD FROM LKU WHERE LKU_TYPE_STRING_KEY = 'Users.User ID'
DEBUG,XELLERATE.DATABASE],SELECT LKU_FIELD FROM LKU WHERE LKU_TYPE_STRING_KEY = 'Users.User ID'
INFO,[XELLERATE.PERFORMANCE],Query: DB: 16, LOAD: 0, TOTAL: 16
DEBUG,[XELLERATE.SERVER],Class/Method: tcDataBase/readPartialStatement entered.
INFO,[XELLERATE.DATABASE],DB read: SELECT LKU_FIELD FROM LKU WHERE LKU_TYPE_STRING_KEY = 'Users.First Name'
DEBUG,[XELLERATE.DATABASE],SELECT LKU_FIELD FROM LKU WHERE LKU_TYPE_STRING_KEY = 'Users.First Name'
INFO,[XELLERATE.PERFORMANCE],Query: DB: 13, LOAD: 0, TOTAL: 13
DEBUG,[XELLERATE.SERVER],Class/Method: tcDataBase/readPartialStatement entered.
INFO,[XELLERATE.DATABASE],DB read: SELECT LKU_FIELD FROM LKU WHERE LKU_TYPE_STRING_KEY = 'Users.Last Name'
DEBUG,[XELLERATE.DATABASE],SELECT LKU_FIELD FROM LKU WHERE LKU_TYPE_STRING_KEY = 'Users.Last Name'
INFO,[XELLERATE.PERFORMANCE],Query: DB: 7, LOAD: 0, TOTAL: 7
DEBUG,[XELLERATE.SERVER],Class/Method: tcDataBase/readPartialStatement entered.
INFO,[XELLERATE.DATABASE],DB read: SELECT LKU_FIELD FROM LKU WHERE LKU_TYPE_STRING_KEY = 'Organizations.Organization Name'
DEBUG,[XELLERATE.DATABASE],SELECT LKU_FIELD FROM LKU WHERE LKU_TYPE_STRING_KEY = 'Organizations.Organization Name'
INFO,[XELLERATE.PERFORMANCE],Query: DB: 8, LOAD: 0, TOTAL: 8
DEBUG,[XELLERATE.SERVER],Class/Method: tcDataBase/readPartialStatement entered.
INFO,[XELLERATE.DATABASE],DB read: SELECT LKU_FIELD FROM LKU WHERE LKU_TYPE_STRING_KEY = 'Users.Xellerate Type'
DEBUG,[XELLERATE.DATABASE],SELECT LKU_FIELD FROM LKU WHERE LKU_TYPE_STRING_KEY = 'Users.Xellerate Type'
INFO,[XELLERATE.PERFORMANCE],Query: DB: 5, LOAD: 0, TOTAL: 5
DEBUG,[XELLERATE.SERVER],Class/Method: tcDataBase/readPartialStatement entered.
INFO,[XELLERATE.DATABASE],DB read: SELECT LKU_FIELD FROM LKU WHERE LKU_TYPE_STRING_KEY = 'Users.Role'
DEBUG,[XELLERATE.DATABASE],SELECT LKU_FIELD FROM LKU WHERE LKU_TYPE_STRING_KEY = 'Users.Role'
INFO,[XELLERATE.PERFORMANCE],Query: DB: 5, LOAD: 0, TOTAL: 5
ERROR,[XELLERATE.SERVER],Class/Method: tcUSR/eventPreInsert Error :Mandatory fields are blank or null.
DEBUG,[XELLERATE.SERVER],Class/Method: tcDataBase/getError entered.
DEBUG,[XELLERATE.SERVER],Class/Method: tcDataBase/readPartialStatement entered.
INFO,[XELLERATE.DATABASE],DB read: select err_key, err_code, err_desc, err_rowver, err_remedy, err_count, err_last_occurance, err_action, err_help_url, err_severity from err where err_code='DOBJ.USR_BLANK_MANDATORY_FIELD_VALUE'
DEBUG,03 Jan 2012 10:21:23,922,[XELLERATE.DATABASE],select err_key, err_code, err_desc, err_rowver, err_remedy, err_count, err_last_occurance, err_action, err_help_url, err_severity from err where err_code='DOBJ.USR_BLANK_MANDATORY_FIELD_VALUE'

DEBUG,[XELLERATE.SERVER],Class/Method: tcDataObj:handleErr - Data: poError.isAction - Value: E
DEBUG,[XELLERATE.SERVER],Class/Method: tcDataObj:handleErr - Data: poError.isCode - Value: DOBJ.USR_BLANK_MANDATORY_FIELD_VALUE
DEBUG,[XELLERATE.SERVER],Class/Method: tcDataObj:handleErr - Data: poError.isDescription - Value: No value provided for mandatory fields
DEBUG,[XELLERATE.SERVER],Class/Method: tcDataObj:handleErr - Data: poError.isRemedy - Value:
DEBUG,[XELLERATE.SERVER],Class/Method: tcDataObj:handleErr - Data: poError.isDetail - Value:
DEBUG,[XELLERATE.SERVER],Class/Method: tcErrorList/addError entered.
DEBUG,[XELLERATE.SERVER],Class/Method: tcDataObj:handleErr - Data: poError.isAction - Value: E
DEBUG,[XELLERATE.SERVER],Class/Method: tcDataObj:handleErr - Data: poError.isCode - Value: DOBJ.USR_BLANK_MANDATORY_FIELD_VALUE
DEBUG,[XELLERATE.SERVER],Class/Method: tcDataObj:handleErr - Data: poError.isDescription - Value: No value provided for mandatory fields
DEBUG,[XELLERATE.SERVER],Class/Method: tcDataObj:handleErr - Data: poError.isRemedy - Value:
DEBUG,[XELLERATE.SERVER],Class/Method: tcDataObj:handleErr - Data: poError.isDetail - Value:

ERROR,[XELLERATE.SERVER],Class/Method: tcDataObj/save Error :Insertion of dataobject into database failed

Changes

Connector upgrade.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms