Skip to Content
0
Former Member
Aug 01, 2009 at 09:17 AM

Help on Initial load of ume users to Identity store on IDM 7.1

25 Views

Hi all

In the job Initial load of UME users to identity store, the pass ReadLocalJavaUsers is working fine as per logs.

But the pass WriteLocalUsers is giving us following errors.

####

Error Error inserting entry in delta. DN:

java.sql.SQLException: ORA-01400: cannot insert NULL into ("MXMC_OPER"."LOGENTRIES"."DN")

Error Error selecting record in delta. SQL:SELECT operation, entid, changejob FROM logentries WHERE dn=? AND ownerid=? DN:

java.sql.SQLException: Exhausted Resultset

Error Error inserting entry in delta. DN:

java.sql.SQLException: ORA-01400: cannot insert NULL into ("MXMC_OPER"."LOGENTRIES"."DN")

Error putNextEntry failed storing

Exception from Add operation:com.sap.idm.ic.ToPassException: ToIDStore.addEntry failed storing entry 'MX_PERSON'.

####

In the source tab, we have put values as follows

for SQL statement :

SELECT DISTINCT mskey FROM MXIV_SENTRIES WHERE is_id=2 AND

((mskey IN (SELECT mskey FROM MXIV_SENTRIES WHERE attrname='MX_ENTRYTYPE' AND searchvalue = 'MX_PERSON')))

What should be the values we need to put in source and destination tabs for pulling the users from UME for pass WriteLocalUsers ?

Thank you in advance.

Regards

sahad