This content has been marked as final. Show 6 replies
I can see the users got created in oim when I ran the sql query on oim DB.
Surprisingly I am not able to search those user via UI when I try to get list of all the users. But I was able to get the user listed via advanced search.
But now I am facing another issue. My incremental recon is not working. When I am running incremental recon it is generating reconciliation event for all the records.
I tried adding the Timestamp Attribute in the design parameters of connector as the Trusted database table timestamp column name but it started throwing the exception as Caused By: com.thortech.xl.gc.exception.DBException: Attribute: does not exist in the specified parent table/view: User1.Comp_users
Please let me know if I am doing something wrong.
I am afraid it might be due to some limitation of GTC...
It seems that the GTC does not use ignoreEvent() method for Incremental ones...
boolean bool = localGenericAdapter.getReconType().equals("Full");
if ((!bool) || (!localtcReconciliationOperationsIntf.ignoreEvent(str4, localMap)))
l2 = localtcReconciliationOperationsIntf.createReconciliationEvent(str4, localMap, false);
As the above snippet implies, if it is Incremental, i.e. bool is false, it simply goes ahead and creates event without ignoreEvent()...
Use Full Recon instead of Incremental...
Actually, in the Incremental recon, it assumes that ONLY Changed records are provided to it... So, it does not bother to call ignoreEvent() method...
If you rather use Full recon, it will itself figure out which records are changed, which are not by calling ignoreEvent() method...
And since it is Database recon, if you have provided any flag, say UPDATE_DATE flag or something in the database side, use this one to narrow down your search criteria at the filter level itself... rather than having to go through each record in 10k records to figure out that these 5 records were changed... I worked only on Flat File GTC connector... So, I am not sure whether there is any such facility to provide query for narrowing down the search result... However, if there is any such facility, use it fully... It will be 1000 times better than making GTC incremental...