SAP Knowledge Base Article - Public

3758520 - Integration Center Upsert fails due to xxxxx field length

Symptom

The Integration Center job runs but ends with an error and the upsert fails. 

Error message: "User: UPSERT failed for the row with key: User/userld=XXXXXX. Reason: Maximum length limit exceeded for field xxxxx" 

Environment

  • SAP SuccessFactors HCM Suite
  • Integration Center

Reproducing the Issue

  1. Add an onboardee to initiate the Employee Recruitment intelligent services event.
  2. Observe that the Integration Center job "Set New Hire Login Methid PWD to SSO" starts.
  3. The job ends in error and the login method does not update.
  4. Review the job/event details and see the upsert error and that the assignment UUID source field is blank.

Cause

Data issue: Most of the Upsert failures are data-issue related. So you need to fix the data that you are sending in the Upsert to make sure it's according what is expected in the API. In this example, let's use the Gender field;

the Gender field value sent in the upsert exceeds the configured maximum length (maximum is 5; payload uses 10), causing the job to fail.

Resolution

Following the example above using the 'gender' field:

  1. Check the Integration Center Upsert payload and confirm the length of the Gender field value being sent.
  2. Option A: In Manage Business Configuration, increase the maximum length of the Gender field to match the value length required by your process.
  3. Option B: Adjust the Integration Center Upsert data so the Gender field value is no longer than 5 characters.
  4. Save the configuration or mapping changes.
  5. Run the Integration Center job again from the intelligent services event and confirm it completes successfully.

See Also

Keywords

intelligent services, integration center, employee recruitment event, onboarding, new hire, login method, sso, upsert failed, required property user id is missing, gender field length, manage business configuration, payload validation, IAS, user mapping , KBA , LOD-SF-INT-INC-ODATA , ODATA API In Integration Center , Problem

Product

SAP SuccessFactors HCM Suite all versions