on 08-31-2009 1:20 PM
Hi All
We have IDM 7.1 SP2.
How we can write from the staging identity store to productive identity store? In the 7.1 sp2 guide nothing is said about it.
Does we just need to run the job u201C
Write HCM Employee To SAP Master u201C ?
Please share any the exact steps.
Also how we can check if the HCM data is actually available in the staging identity store? We executed the report RPLDAP_EXTRACT_IDM successfully and it showed the records have been moved. But how we can check if the records are moved to VDS ? Also from VDS to staging identity store?
Please advice.
Hi Sahad
>
> Also how we can check if the HCM data is actually available in the staging identity store? We executed the report RPLDAP_EXTRACT_IDM successfully and it showed the records have been moved. But how we can check if the records are moved to VDS ? Also from VDS to staging identity store?
Option 1:
You can check the data from the monitoring page ( though i have 7.0) , select your identity store (Staging HR Identity store) and run a blank search to return all data from the store.
Option 2:
You can check the statistics of the staging identity store from the Identity manager console, there it has all the statistics of the records, entries etc
About writing the data from the Staging IC to SAP Master IC, there should be a job in the jobs template (in IdM 7.0 it is "HCM Read Employees") so my guess would be that the "Write HCM employee to SAP master" should do the trick for you.
Let me know if that works out.
PS: Will be installing the 7.1 soon, so would be able to help more with 7.1 installations...
Cheers !!
Zaheer
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Zaheer
I am now able to run the job and it is trying to write to productive identity store but we are getting following error
"sap_importTimeValues Par: [20090901-99991231]Sahad ak|[20090909-99991231]Sahad ak!!DISPLAYNAME Attribute: DISPLAYNAME is NOT defined as Multivalue Attribute(Storage Type) in Schema of Identity Store: 2. The values which should be imported contain multiple values at the same point in time: {VALIDFROM=2009-09-01!!VALIDTO=9999-12-31}Sahad ak|{VALIDFROM=2009-09-09!!VALIDTO=9999-12-31}Sahad ak "
Do you know how to set DISPLAY NAME as multivalued Attribute in Schema of identity store? Please advice.
Regards
Sahad
Hi Sahad
I don't think it is a good idea to set the DISPLAYNAME as multivalue attribute. I suppose you have to take care of the cause of this multi-value occurence.
But you can can change the Attribute like this (in IDM 7.1):
1. Go to your identity store in MMC
2. <IDStore 2> -> ID store schema -> Attributes
3. Double click DISPLAYNAME attribute
4. "Storage" tab
5. Select "Mulitvalue attribute"
Hope I cuold help
Regards
Michael
Hi Shahad,
Looking at the log, seems like there are two valid from dates for the same ID, can you check the initial load in the HR Staging Area for this ID.
Also, just to verify the HR extract test run the LDAP extractor query in the back end HCM system.
>{VALIDFROM=2009-09-01!!VALIDTO=9999-12-31}Sahad ak|{VALIDFROM=2009-09-09!!VALIDTO=9999-12-31}Sahad ak "
I don't think you should change the DISPLAYNAME as multivalue attributes, rather than fixing the problem it is hiding the problem approach, which may eventually cause problems while provisioning from the SAP Master identity store.
Cheers !!
Zaheer
Hi Zaheer
I executed the query and two dates are the start date and the end date. Is there any problem.
There are couple of fields like Buildings, City, House street etc which is not pulling values. Are they causing the issues?. Do you feel if the issue is at HCM side or at Identity center side
As part of solving the error, We have enabled the multiple value storage attribute on DISPLAYNAME, LASTNAME, FIRSTNAME, MX_FS_ACADEMIC_TITLE_1_ID, MX_FS_PERSONNEL_NUMBER, MX_FS_POSITION, MX_FS_POSITION_ID,MX_FS_SALUTATION_ID, MX_ACADEMIC_TITLE_1
Do you think we should revert back all of them?
Now we are getting errors like
##
putNextEntry failed storingMX_PERSON
Exception from Add operation:com.sap.idm.ic.ToPassException: ToIDStore.addEntry failed storing entry 'MX_PERSON'. IDStore returned error message: " Value not legal for this attribute:Attribute: MX_ACADEMIC_TITLE_1" when storing attribute 'MX_ACADEMIC_TITLE_1={VALIDFROM=2009-09-01!!VALIDTO=9999-12-31}Mr'
Exception from Modify operation:com.sap.idm.ic.ToPassException: ToIDStore.modEntry failed updating entry 'MX_PERSON'. IDStore returned error message: "Entry does not exist" when fetching entry
##
Please advice.
HI Sahad,
Do you have the untouched version of the Identity store attributes with you ? Backup export. If not, then try creating a test repository and change the "HR_STAGING_AREA_IDS_ID" to point to it and try reloading the fresh data into it. Then create a test SAP Master and change "SAP_MASTER_IDS_ID" to point it to the new test IS.
This time while performing loads, put the dispatcher in DEBUG mode to capture everything.
Cheers !!
Zaheer
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.