Error from Write HCM Employee To SAP Master

[Former Member]

Hi guys. I'm follow the configuration guide but getting an error when the users are extracted from HCM.

The error is following.

sap_getSysUname Par: [20110215-99991231]01000040!![20110215-20110215]|[20110215-20110215]KGOTT|[20110216-99991231]KGOTT|[20110216-99991231] Invalid SyUname: [20110215-20110215]|[20110215-20110215]KGOTT|[20110216-99991231]KGOTT|[20110216-99991231] does not exist or is not valid today

Values in VDS

p0105-syhr_a_p0105_af_sysuname [20110216-99991231]|[20110216-99991231]KGOTT

p0105-syhr_a_p0105_af_email [20110216-99991231]KGOTT@<domain>|[20110216-99991231]

As you see I'm getting a lot of time stamps. I don't know if the problem is in the query or in IC. When I'm executing the query in SQ01 every employee is displayed on multiple rows. Most of the fields are duplicated but values from IT 0105 are presented on their own row. A new row is added for every 0105 value.

How can I fix this isse? I been trying to use the debugger but it doesnt capture the scripts.

Thanks,

Vit

[Former Member · Accepted solution]

Go to this Check Username Job (above the WriteToMaster)

There in the destiation you see the attribute SYUNAME. What does it say there?

[Former Member · Accepted solution]

Hi Christian

Attribute: MX_HCM_SYSUNAME

Value: $FUNCTION.sap_cutDate(%P0105-SYHR_A_P0105_AF_SYSUNAME%)$$

[Former Member · Accepted solution]

See SAP Note 1308250

VI/ Export of HR Employee Data to Virtual Directory Server

Using the Template HCM_Staging_Area:

Symptom: When reading data from an HCM system into the Identity Center staging area, you encounter the following error message in job 'Write HCM Employee To SAP Master':

Pass: Write HCM Employee To SAP Master

...

sap_getSysUname Par: [20090210-99991231]<PERNR>!![20090210-99991231]

Invalid SyUname: [20090210-99991231] does not exist or is not valid today

Pass stopped by script

This error occurs when the exported data from the HCM system does not provide a valid SYUNAME. A workaround for this error message is:

Navigate to the 'Write HCM Employee To SAP Master' - Pass and change the following lines in the 'Destination' tab page:

Comment the following line:

# MX_HCM_SYSUNAME $FUNCTION.sap_getSysUname(%P0000-PERNR%!!%P0105-SYHR_A_P0105_AF_SYSUNAME%)$$

Use the following entry instead:

. MX_HCM_SYSUNAME $FUNCTION.sap_cutDate(%P0105-SYHR_A_P0105_AF_SYSUNAME%)$$

[Former Member · Accepted solution]

Hi Christian,

I've tried to implement the note some days ago with no result. Today I tried again and it worked! I guess something else was wrong back then.

Hat off and 10 points.

Vit