This content has been marked as final. Show 12 replies
what happens when you try to reevaluate the recon event?
it is showing only the following options
1. Close and 2. Refresh
There is no button for Reevaluate events for generated events
Did you create Reconciliation Profile?
For which resource you are trying to execute this trusted recon? Is it a custom resource?
I think no need to create Recon profile while creating new GTC, hope it will create automatically, anyhow I have created recon profile manually, did purge and restarted the server too but getting the same exception again.
I'm trying to fetch new/updated records from DB(trusted) to OIM using OOTB Application table connector.
could you please check the field mapping once again in GTC?
For e.g :
Employee Type -> Role
User Type -> User Type
Try providing value for Display Name as well in reconciliation data.
Let me know how it goes.
Check your key field for reconciliation field mapping.
Same thing happen to me when i am doing trusted recon using DBUM Connector. Do you added any fields for mapping?
Displayname (custom field) --> Displayname
is my current mappings.
@Gyanprakash : I have one key field in my mappings and that field is there in recon rule too
@User7609 : I have created new fileds in recon staging table and mapped to respective fields in oim.
How did you fixed that issue?
1. provide the userlogin constant and lets see how it work.
go to process definition-> field mapping-> map the key field wih literal value(hope userlogin is the key field)
if above works can try below
2. update the rule as case Insensitive : (normally oim store userlogin in Caps and the incomming data may be in small one)
even mark key field mapping as case insensitive
whenever make anay changes on mapping make sure you click on "Create Reconciliation profile"
As per my requirement,I kept other field as Key field and it holds only numbers, also I have checked userlogin as case insensitive. Eventhough I have made Userlogin field as literal and hardcode the userlogin in caps and created reconciliation profile. But getting the same exception.
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
ORA-06512: at "TST_OIM.OIM_SP_RECONBLKUSERCRUD", line 3925
ORA-06512: at "TST_OIM.OIM_SP_RECONBLKUSRMLSWRAPPER", line 71
ORA-06512: at line 1
Edited by: S.K.N on Jul 18, 2012 12:26 PM
No even i am also not able to resolve this still i am also looking for answer. Do you have any updates?