Follow Ritesh Maddala Blogs - Join the Fan Club Today and Keep Learning
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
OIM - Recon Event is not getting generated or Create Reconciliation Profile Failed or Failed to Create Index on RA_
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
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
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