Module Navigation

Troubleshooting Sage 300 Integration Error: Employee Identity and Demographics

Sage 300 CRE, through its HH2 integration, requires a core set of identity fields before it will accept an employee record: Employee Id, First Name, Last Name, Social Security Number, Gender, and Ethnicity. Arcoro also needs a Social Security Number on file in Sage 300 CRE before it will bring an employee record in on a read.

When one of these fields is missing, too long, or not set in the source system, the sync either skips the whole employee record, skips just the affected piece of data, or logs a warning while continuing, depending on which field is involved. Read the outcome column below carefully. Two of these messages are named as warnings but are actually logged as errors in the sync log.

Error Messages

Message textDirectionOccurs whenOutcomeFix
Employee ID is a required field.Write (Arcoro to Sage 300 CRE, by way of HH2)The employee's Employee ID field in Arcoro is missing, empty, or blank. Checked on every sync for both new and existing employees.Whole record skipped. The employee is not written to Sage 300 CRE.Enter an Employee ID on the employee's profile in Arcoro.
First Name is a required field.Write (Arcoro to Sage 300 CRE, by way of HH2)The employee's First Name field in Arcoro is missing, empty, or blank. Checked on every sync, for both new and existing employees.Whole record skipped. The employee is not written to Sage 300 CRE.Enter a First Name on the employee's profile in Arcoro.
Last Name is a required field.Write (Arcoro to Sage 300 CRE, by way of HH2)The employee's Last Name field in Arcoro is missing, empty, or blank. Checked on every sync, for both new and existing employees.Whole record skipped. The employee is not written to Sage 300 CRE.Enter a Last Name on the employee's profile in Arcoro.
Social Security Number is a required field.Write (Arcoro to Sage 300 CRE, by way of HH2)The employee's Social Security Number field in Arcoro is missing, empty, or blank. Checked on every sync for both new and existing employees.Whole record skipped. The employee is not written to Sage 300 CRE.Enter the employee's Social Security Number in Arcoro.
Gender is a required field.Write (Arcoro to Sage 300 CRE, by way of HH2)The employee's Gender field in Arcoro is missing or set to the unspecified placeholder value. Checked on every sync, for both new and existing employees.Whole record skipped. The employee is not written to Sage 300 CRE.Set Gender on the employee's profile in Arcoro.
Ethnicity is a required field.Write (Arcoro to Sage 300 CRE, by way of HH2)The employee's Ethnicity field in Arcoro is missing or set to the unspecified placeholder value. Checked on every sync, for both new and existing employees, even when Ethnicity is not selected as a scope for reads.Whole record skipped. The employee is not written to Sage 300 CRE.Set Ethnicity on the employee's profile in Arcoro.
EmployeeIdentifier field is greater than 10 characters. Sage 300 CRE only allows a maximum length of 10.Write (Arcoro to Sage 300 CRE, by way of HH2)The employee's Employee ID field in Arcoro is not blank and is longer than 10 characters.Whole record skipped. The employee is not written to Sage 300 CRE.Shorten the Employee ID value in Arcoro to 10 characters or fewer.
Employee's Social Security Number exceeds the maximum length supported by Sage 300 CRE and will be truncated after 11 characters.Write (Arcoro to Sage 300 CRE, by way of HH2)The Social Security Number field was included in this sync, and the value read from Arcoro is longer than 11 characters.Logged as an error in the sync log, but the write continues. This message is named as a warning, but it is logged at error severity. Sage 300 CRE truncates the stored value to 11 characters; the rest of the employee record still writes normally.Correct the Social Security Number value in Arcoro so it is a standard-length value, for example, an 11-character value with dashes.
Employee's primary address not found. Ensure the address is valid in the source system.Write (Arcoro to Sage 300 CRE, by way of HH2)The employee in Arcoro has no home address marked as primary, and no home address marked as secondary either.Field skipped only. The address portion of the record is left out of the write. The rest of the employee's identity and demographic fields still sync.Add or correct a primary home address for the employee in Arcoro.
HH2 does not contain a social security number for this employee. The record will not be synced.Read (Sage 300 CRE to Arcoro, by way of HH2)The lookup for the employee's Social Security Number completes without error, but HH2 has no Social Security Number on file for that employee. Does not fire if the lookup call itself failed, since that failure is logged separately.Whole record skipped. This message is named as a warning, but it is logged at error severity, and the employee is marked as bad data and not brought into Arcoro on this sync.Add the missing Social Security Number to the employee's record in Sage 300 CRE, then re-run the sync.

Confirming the Error

  1. Open the Sync History screen and find the sync execution for the time in question.
  2. Open the step for the Sage 300 CRE connector.
  3. Find the Employees entity row. Check the Errors column. If it is greater than zero, at least one employee could not be written or read because of a message in this family.
  4. Open the entity row's error list and locate the affected employee by name or Employee ID.
  5. Match the message text against the fixed part of the sentence shown in the table above, not the values that vary by employee.
  6. Remember that two messages in this family are named as warnings, but they are logged in the Errors column, not the Warnings column. Check Errors first for both of them.

Resolving the Error

Missing Required Field: Employee ID, First Name, Last Name, Social Security Number, Gender, or Ethnicity

  1. Confirm which field the error message names.
  2. In Arcoro, open the employee's profile and go to the section that holds that field.
  3. Enter or correct the value for the field named in the message.
  4. Save the change in Arcoro.
  5. Re-run the sync for this connector and confirm the employee no longer appears in the Errors list for this message.

Employee ID Longer Than 10 Characters

  1. In Arcoro, open the employee's profile.
  2. Shorten the Employee Id value to 10 characters or fewer. Sage 300 CRE cannot store a longer value.
  3. Save the change in Arcoro.
  4. Re-run the sync and confirm the Errors count for the Employees entity has gone down.

Social Security Number Longer Than 11 Characters

  1. In Arcoro, open the employee's profile and review the Social Security Number field.
  2. Correct the value so it is a standard-length Social Security Number, for example, 11 characters with dashes.
  3. Save the change in Arcoro.
  4. Re-run the sync. The employee record writes even before this fix, but Sage 300 CRE truncates the stored value, so correct the source value to keep the two systems in agreement.

Missing Primary Address

  1. In Arcoro, open the employee's profile and review the home address.
  2. Add or correct a primary or secondary home address for the employee.
  3. Save the change in Arcoro.
  4. Re-run the sync and confirm the address now appears on the employee's record in Sage 300 CRE.

No Social Security Number on File in Sage 300 CRE (Read)

  1. In Sage 300 CRE, open the employee's record.
  2. Add the employee's Social Security Number.
  3. Save the change in Sage 300 CRE.
  4. Re-run the read sync for this connector and confirm the employee is no longer skipped.

When to Escalate

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

  • You confirm the required field named in the message, Employee Id, First Name, Last Name, Social Security Number, Gender, or Ethnicity, is already filled in on the employee's profile in Arcoro, but the same error appears after a re-run.
  • The Employee ID is already 10 characters or fewer, but the length error still appears.
  • The employee already has a primary home address in Arcoro, but the missing-address message still appears.
  • You confirm the Social Security Number is on file in Sage 300 CRE, but the missing-SSN read message keeps appearing.
  • A message from this family appears alongside an error from a different family, such as tax or compensation, on the same employee, since resolving only this family may not clear the record.
Was this article helpful?
0 out of 0 found this helpful