Module Navigation

Troubleshooting Sage 100 Integration Error: Employee Identity and Demographics

These messages all come from the basic identity checks Arcoro runs on an employee record before it is sent to Sage 100, or from a missing value found while pulling an employee record out of Sage 100. On the write side, Arcoro validates required fields such as Employee Id, First Name, Last Name, Gender, Ethnicity, Work State, and Social Security Number before it will send the employee to Sage 100 (HH2). On the read side, Arcoro checks whether Sage 100 (HH2) actually has a Social Security Number on file for the employee. Most of these issues trace back to a field that is blank, malformed, or missing in the source system, and the fix is almost always a data correction rather than a connector setting.

Error Messages

Message textDirectionOccurs whenOutcomeFix
Employee Id is required.Write (Arcoro to Sage 100)The employee's Employee Id field is blank in Arcoro.Whole employee record skipped.Enter an Employee Id on the employee record in Arcoro.
Employee Id must be a number.Write (Arcoro to Sage 100)The employee's Employee Id value does not parse as a whole number. This check always runs, so a blank Employee Id triggers this message together with "Employee Id is required" in the same pass.Whole employee record skipped.Change the Employee Id in Arcoro to a numeric value that matches the Sage 100 employee code.
EmployeeIdentifier field is greater than 10 characters. This employee will not be updated in HH2.Write (Arcoro to Sage 100)The employee's Employee Id is longer than 10 characters.Whole employee record skipped.Shorten the Employee Id in Arcoro to 10 characters or fewer.
First Name is required.Write (Arcoro to Sage 100)The employee's First Name field is blank in Arcoro.Whole employee record skipped.Enter a First Name on the employee record in Arcoro.
Last Name is required.Write (Arcoro to Sage 100)The employee's Last Name field is blank in Arcoro.Whole employee record skipped.Enter a Last Name on the employee record in Arcoro.
Gender is required.Write (Arcoro to Sage 100)The employee's Gender field is blank or not set to a mapped value in Arcoro.Whole employee record skipped.Set the Gender field on the employee record in Arcoro to a supported value.
Ethnicity is required.Write (Arcoro to Sage 100)The employee's Ethnicity field is blank or not set to a mapped value in Arcoro.Whole employee record skipped.Set the Ethnicity field on the employee record in Arcoro to a supported value.
Work State is required.Write (Arcoro to Sage 100)The employee's Work State field is blank in Arcoro.Whole employee record skipped.Set the Work State field on the employee record in Arcoro.
Social Security Number is a required field.Write (Arcoro to Sage 100)The employee's Social Security Number field is blank in Arcoro.Whole employee record skipped.Enter the employee's Social Security Number in Arcoro.
Employee's Social Security Number must be in the format ###-##-#### or #########. Correct the data in the Source System and execute the Sync again.Write (Arcoro to Sage 100)The employee has a Social Security Number value, but it is not 9 digits in the format ###-##-#### or #########.Whole employee record skipped.Correct the Social Security Number format on the employee record in Arcoro, then run the sync again.
HH2 does not contain a social security number for this employee. The record will not be synced.Read (Sage 100 to Arcoro)Arcoro successfully reads the employee from Sage 100 (HH2), but Sage 100 (HH2) has no Social Security Number value stored for that employee.Whole employee record skipped. The employee is not brought into Arcoro at all for this sync pass.Enter the employee's Social Security Number in Sage 100, then run the sync again.
Employee's primary address not found. Ensure the address is valid in the source system.Write (Arcoro to Sage 100)The employee has no address in Arcoro marked as a Home Primary or Home Secondary address type.Field skipped only. The employee's other demographic fields and any already-valid scopes are still created or updated in Sage 100; only the address is not sent.Add a Home Primary (or Home Secondary) address on the employee record in Arcoro.
Employee Home Address State is required. This employee will not be updated in HH2.Write (Arcoro to Sage 100)Either the employee has no addresses at all in Arcoro, or at least one Home Primary or Home Secondary address on the employee is missing a State value.Whole employee record skipped.Set the State field on the employee's Home Primary or Home Secondary address in Arcoro.
The matching employee in HH2 has IsArchived = true and the Sync process cannot update it. To Sync this employee contact Arcoro support to have HH2 set IsArchived = false for the employee and run the Sync again.Write (Arcoro to Sage 100)The employee's Employee Id matches a Sage 100 (HH2) employee record that is flagged IsArchived = true.Whole employee record skipped.Escalate to Arcoro support to have the matching employee in Sage 100 (HH2) unarchived, then run the sync again.

Confirming the Error

  1. Open the sync execution for your Sage 100 connector in the Sync History screen.
  2. Open the step for the Employees entity within that execution.
  3. Check the Errors column for the Employees row. All of the messages in this article are logged as errors, even the one whose internal name ends in "Warning". A non-zero Failures count on this row points to a different problem, such as a preload or connection failure, and is not part of this family.
  4. Open the entity row to see the per-employee errors list.
  5. Find the affected employee and match on the fixed part of the sentence, ignoring any employee-specific values in quotes.
  6. Note whether more than one of these messages appears for the same employee in the same pass. Several of the write-side checks run independently in one validation pass, so more than one can appear together for a single employee.

Resolving the Error

Employee ID Is Required / Employee ID Must Be a Number / EmployeeIdentifier Field Is Greater Than 10 Characters

  1. In Arcoro, open the employee record and check the Employee Id field.
  2. Enter a numeric Employee Id of 10 characters or fewer that matches the corresponding Sage 100 employee code.
  3. Save the change and run the sync again.
  4. Confirm the employee no longer appears in the Errors list for the Employees entity.

First Name Is Required / Last Name Is Required / Gender Is Required / Ethnicity Is Required / Work State Is Required / Social Security Number Is a Required Field

  1. In Arcoro, open the employee record.
  2. Fill in the missing field named in the message.
  3. Save the change and run the sync again.
  4. Confirm the employee no longer appears in the Errors list for the Employees entity.

Employee’s Social Security Number Must Be In the Format ###-##-#### Or #########

  1. In Arcoro, open the employee record and locate the Social Security Number field.
  2. Correct the value so it contains exactly 9 digits, either as plain digits or in the ###-##-#### format.
  3. Save the change and run the sync again.
  4. Confirm the employee no longer appears in the Errors list for the Employees entity.

HH2 Does Not Contain a Social Security Number for This Employee

  1. In Sage 100, open the employee record and check the Social Security Number field.
  2. Enter the employee's Social Security Number in Sage 100.
  3. Run the sync again.
  4. Confirm the employee is now brought into Arcoro and no longer appears in the Errors list for the Employees entity.

Employee’s Primary Address Not Found

  1. In Arcoro, open the employee record and check the Addresses section.
  2. Add or correct a Home Primary address, or a Home Secondary address if no Home Primary address exists.
  3. Save the change and run the sync again.
  4. Confirm the address now appears on the matching employee in Sage 100 and the employee no longer appears in the Errors list for the Employees entity.

Employee Home Address State is Required

  1. In Arcoro, open the employee record and check the Home Primary and Home Secondary addresses.
  2. Set the State field on each Home address that is missing one.
  3. Save the change and run the sync again.
  4. Confirm the employee no longer appears in the Errors list for the Employees entity.

The Matching Employee in HH2 has IsArchived = True

  1. Confirm that this is the employee they intend to sync, and that the Employee Id in Arcoro matches the employee code in Sage 100.
  2. Escalate to Arcoro support and ask that the matching employee record in Sage 100 (HH2) be set to IsArchived = false.
  3. Once support confirms the change, run the sync again.
  4. Confirm the employee no longer appears in the Errors list for the Employees entity.

When to Escalate

If any of the following occur, you may need to reach out to Arcoro support for additional assistance.

  • The message says "The matching employee in HH2 has IsArchived = true" and you need the record unarchived.
  • You confirm the field named in the message is already filled in on their side (Arcoro or Sage 100, depending on the message's direction) but the same error keeps appearing after a sync re-run.
  • The same employee shows a mix of identity errors and errors from unrelated families (for example tax or compensation) at the same time, which can indicate a broader preload or data quality issue worth a deeper look.
  • The Failures column for the Employees entity is non-zero; that is outside this family and points to a connection, authentication, or preload problem.
Was this article helpful?
0 out of 0 found this helpful