Pageviews

Saturday, October 29, 2016

OIM - Recon Event is not getting generated or Create Reconciliation Profile Failed or Failed to Create Index on RA_ in OIM Diagnostic Logs

Issue :

OIM - Recon Event is not getting generated or Create Reconciliation Profile Failed or Failed to Create Index on RA_ in OIM Diagnostic Logs

Solution : 

The issue was due to Child form must have atleast 1 key field

To resolve set Required=true as properties in key attribute for child process form.


Data AccessException: com.thortech.xl.orb.dataaccess.tcDataAccessException: DB_READ_FAILEDDetail: Description: ORA-00936: missing expression SQL State: 42000Vendor Code: 936Additional Debug Info:com.thortech.xl.orb.dataaccess.tcDataAccessException

Issue - 

Data AccessException:SQL State: 42000Vendor Code: 936Additional Debug Info:com.thortech.xl.orb.dataaccess.tcDataAccessException

com.thortech.xl.orb.dataaccess.tcDataAccessException: DB_READ_FAILEDDetail: SQL: = Description: ORA-00936: missing expression

Solution - 

Correct the Mapping of adapter variables in Process Task.

This issue is typically due to incorrect mapping of Columns in Process Task Adapter.

Mostly this issue occurs when Process task's Adapter Variable is mapped with wrong Column_Name/Table_Name required in Adapter. Check the Process Task Adapter Mapping and its literal value for Process Form - Column_Name/Table_Name. The column name and table name must be exactly same as provided in Process Form.

For example :

Child Table name = UD_SIEBEL_C
Child Table Column Name = UD_SIEBEL_C_USER_LOGIN

So your adapter mapping must contain same/exact value as provided in Process Form.

In my case I configured the wrong Child Process form column_name in my Process Task's Adapter mapping , which is required to update the Child Process Form's column value.

Let's say Instead of "UD_SIEBEL_C_USER_LOGIN", I configured it to UD_SIEBEL_C_U_LOGIN