Before an employee is written to Viewpoint Spectrum, the sync checks a handful of core identity fields on the Arcoro employee record: the employee code, first name, last name, and Social Security Number. If any of these fail the check, that employee is not sent to Spectrum for this run. The record is not partially written and no other field on the same employee is written either.
These checks always run for every employee in the write step. They are not tied to any optional scope, so there is no setting that can turn them off. The checks also do not stop after the first problem. One employee can fail more than one of these checks in the same run, so the sync log for that employee may show two, three, or more of these messages together.
Error Messages
| Message text | Direction | Occurs when | Outcome | Fix |
|---|---|---|---|---|
| Employee Code is required. The Employee will not be Synced. Correct the data in the source system and execute the Sync again. | Write (Arcoro to Spectrum) | The employee code field on the Arcoro employee record is blank or only whitespace. | Record skipped | Enter an employee code on the employee record in Arcoro. |
| Employee Code includes invalid special characters like / * ? " ' > < # , & ~ \. Please verify that the input data is correct. | Write (Arcoro to Spectrum) | The employee code contains at least one of these characters: / * ? " ' > < # , & ~ \ | Record skipped | Remove the special character from the employee code in Arcoro. |
| First Name is required. The Employee will not be Synced. Correct the data in the source system and execute the Sync again. | Write (Arcoro to Spectrum) | The first name field on the Arcoro employee record is blank or only whitespace. | Record skipped | Enter a first name on the employee record in Arcoro. |
| Last Name is required. The Employee will not be Synced. Correct the data in the source system and execute the Sync again. | Write (Arcoro to Spectrum) | The last name field on the Arcoro employee record is blank or only whitespace. | Record skipped | Enter a last name on the employee record in Arcoro. |
| Social Security Number is required. | Write (Arcoro to Spectrum) | After stripping all non-digit characters from the SSN field, nothing is left (the field was blank, or every character in it was a formatting character such as a dash). | Record skipped | Enter the employee's Social Security Number in Arcoro. |
| Employee Social Security Number must be 9 digits. | Write (Arcoro to Spectrum) | After stripping all non-digit characters from the SSN field, at least one digit remains but the digit count is not exactly 9. | Record skipped | Correct the SSN in Arcoro so it has exactly 9 digits. |
The two SSN messages cannot both appear for the same employee in the same run. The check strips dashes and other non-digit characters first and then looks at what is left. If nothing is left, only Social Security Number is required fires. If something is left but the digit count is wrong, only Employee Social Security Number must be 9 digits fires. Formatting characters like dashes are never the cause of either message on their own, since they are removed before the length check happens.
Confirming the Error
- Open the sync history for the connector and find the sync execution for the run in question.
- Open the step for the Viewpoint Spectrum connector.
- Find the affected employee row. A non-zero count in the Errors column for that employee row means one or more of these checks failed. The Added, Updated, and Unchanged columns will show no change for that employee, since the record was skipped.
- Open the employee row and review the errors list. Match on the fixed part of each sentence (for example, Employee Code is required or must be 9 digits), not on any quoted or substituted value, since the message text itself does not include the employee's actual data.
- Check the full errors list for that employee before fixing anything. It is common to see two or more of these messages on the same employee in the same run, for example, a missing last name together with an invalid SSN length.
Resolving the Error
Missing Employee Code, First Name, or Last Name
- Open the employee's record in Arcoro.
- Enter a value in the missing field (Employee Code, First Name, or Last Name).
- Save the record.
Employee Code Contains an Invalid Character
- Open the employee's record in Arcoro and locate the employee code field.
- Remove any of the following characters from the code: / * ? " ' > < # , & ~ \
- Save the record. Note that employee code length by itself is not the problem here; Spectrum only supports up to 11 characters and the sync shortens longer codes automatically without stopping the sync, but that shortening is unrelated to this error, which is only about the character content.
Missing or Invalid Social Security Number
- Open the employee's record in Arcoro and locate the Social Security Number field.
- If the field is blank, have them enter the employee's SSN.
- If the field has a value but the digit count is wrong, have them correct it so that removing any dashes or spaces leaves exactly 9 digits.
After the correction is saved in Arcoro, run the sync again. Confirm the fix by reopening the sync history for the new run and checking that the employee row now shows the record processed (an entry in Added or Updated) with no entry in Errors for that employee.
When to Escalate
If any of the following occur, you may need to reach out to Arcoro support for additional assistance.
- The employee record in Arcoro shows a correct employee code, first name, last name, and 9-digit SSN, but the same message still appears after a fresh sync run.
- The errors list shows a message with the same wording but references a field not covered in this article.
- The employee code or SSN field will not save in Arcoro.