Module Navigation

Troubleshooting CMiC Integration Error: Org Structure (Department, Location, Facility)

Before CMiC will accept an employee, it needs three pieces of work assignment information filled in and valid: a Department code, a Company (this is the field Arcoro calls WorkLocation1), and a work state or location code (this is the field Arcoro calls WorkState/Location). Arcoro checks all of these, and several other fields, before it sends the employee to CMiC. If any required value is missing, does not match an existing CMiC record, or is too long for the field CMiC allows, the whole employee is held back, and nothing is sent for that employee on that sync.

Arcoro checks every field on the employee before deciding whether to send it; it does not stop at the first problem it finds. This means a single employee can show more than one of the messages in this article at the same time, plus messages from other troubleshooting articles, if that employee has more than one field problem. Fixing only the first message you see and re-running the sync will not resolve the ticket if other messages are still present for that same employee.

Error Messages

Message textDirectionOccurs whenOutcomeFix
Employee Department is required. Employee will not be sent to CMiC.Arcoro to CMiC (write)The employee's Department value is blank.Record skippedEnter a Department value for the employee in Arcoro and re-run the sync.
The Department '[department code]' was not found in CMiC. The employee will not be processed. Correct the data and run the sync again.Arcoro to CMiC (write)The employee's Department value is not blank, but its code does not exactly match any department already loaded from CMiC for the companies configured on this connector. The comparison is case-sensitive.Record skippedCorrect the department code in Arcoro to match an existing CMiC department code exactly, or have the CMiC administrator create that department code in CMiC.
Employee's department exceeds the maximum length of 6 characters supported by the provider and will not be synced.Arcoro to CMiC (write)The employee's Department value is not blank, it matches an existing CMiC department code, and that code is longer than 6 characters.Record skippedShorten the department code to 6 characters or fewer, either on the employee in Arcoro or on the department record in CMiC.
Employee WorkLocation1 is required. This maps to CMiC Company, which is a required field. Employee will not be sent to CMiC.Arcoro to CMiC (write)The employee's WorkLocation1 value is blank.Record skippedEnter a WorkLocation1 value for the employee in Arcoro and re-run the sync.
Employee's facility exceeds the maximum length of 8 characters supported by the provider and will not be synced.Arcoro to CMiC (write)The employee's WorkLocation1 value is not blank and is longer than 8 characters.Record skippedShorten the WorkLocation1 value to 8 characters or fewer in Arcoro.
Employee WorkState/Location is required. This maps to CMiC WrlCode, which is a required field. Employee will not be sent to CMiC.Arcoro to CMiC (write)The employee's WorkState/Location value is blank.Record skippedEnter a WorkState/Location value for the employee in Arcoro and re-run the sync.

What WorkLocation1 and WorkState/Location actually mean in CMiC

WorkLocation1 is the Arcoro field name for the value that becomes the employee's Company in CMiC. In CMiC, every employee belongs to a company, and Company is a required field on the employee record, so Arcoro will not send an employee to CMiC without a WorkLocation1 value. This value is sent to CMiC as-is; it is not checked against a list of CMiC departments. It is, however, checked elsewhere against the list of company codes configured on the connector itself, and a mismatch there produces a different message covered in CMiC: Connector configuration missing or invalid (see Related, below).

WorkState/Location is the Arcoro field name for the value that becomes the employee's work location code in CMiC, which CMiC calls WrlCode. This field only needs to be present for the write to proceed. If a WorkState/Location value is entered but does not match any work location CMiC has on file, no error message is raised for that mismatch; the record still writes, just without a matching work location code. Keep this in mind if the Work State information is missing in CMiC on an employee that shows no error in the sync log for this family.

Confirming the Error

  1. Open the sync execution in Sync History for the CMiC connector.
  2. Find the step for the CMiC connector within that execution.
  3. On that step, locate the Employees entity row and check its Errors column for a non-zero count.
  4. Open the errors list for that entity row.
  5. Match each entry on the fixed part of the sentence, for example "was not found in CMiC", rather than on the department code shown in quotes, since that value is specific to each employee.
  6. Read the whole errors list for the employee identifier in question before making any change. Because Arcoro checks every field before deciding whether to send the employee, the same employee can appear against several messages in this article, and against messages from other articles, in the same run.

Resolving the Error

Department Value Is Blank

  1. In Arcoro, open the employee record and go to the Department field.
  2. Enter a Department value for the employee.
  3. Save the change and re-run the sync.
  4. Confirm the employee no longer appears in the Employees entity errors list for this message.

Department code not found in CMiC

  1. Note the department code shown in quotes in the message text.
  2. Check whether that code is a typo of an existing CMiC department, a casing mismatch (the match is case-sensitive), or a department that genuinely does not exist yet in CMiC.
  3. If it is a typo or casing issue, correct the Department value on the employee in Arcoro to match the CMiC department code exactly.
  4. If the department genuinely does not exist in CMiC, have the CMiC administrator create it there.
  5. Re-run the sync and confirm the employee no longer appears in the errors list for this message.

Department Code Too Long

  1. Note that this only occurs when the department code already matches an existing CMiC department, so the code is present in CMiC but longer than CMiC's 6-character limit.
  2. Have your CMiC administrator confirm the correct, shorter department code for that department.
  3. Update the Department value on the employee in Arcoro to the corrected code.
  4. Re-run the sync and confirm the employee no longer appears in the errors list for this message.

WorkLocation1 (Company) Value is Blank

  1. In Arcoro, open the employee record and go to the WorkLocation1 field.
  2. Enter a WorkLocation1 value for the employee.
  3. Save the change and re-run the sync.
  4. Confirm the employee no longer appears in the errors list for this message. If a message about the WorkLocation1 value not matching the connector's configured companies also appears for the same employee, see CMiC: Connector configuration missing or invalid in Related, below.

WorkLocation1 (Facility) Value Too Long

  1. In Arcoro, open the employee record and go to the WorkLocation1 field.
  2. Shorten the value to 8 characters or fewer.
  3. Save the change and re-run the sync.
  4. Confirm the employee no longer appears in the errors list for this message.

WorkState/Location Value is Blank

  1. In Arcoro, open the employee record and go to the WorkState/Location field.
  2. Enter a WorkState/Location value for the employee.
  3. Save the change and re-run the sync.
  4. Confirm the employee no longer appears in the errors list for this message.

When to Escalate

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

  • The message persists for an employee after the Arcoro source value has been corrected and confirmed saved.
  • You are seeing a missing or incorrect Work State/Location value in CMiC, but no message from this article appears in the errors list for that employee. This can happen because a WorkState/Location value that does not match any CMiC work location does not raise an error; escalate so a developer can confirm the value on the CMiC side.
  • The department or company code you expect to exist in CMiC cannot be confirmed as present, and the CMiC administrator is not available to verify or create it.
  • The log text does not match any message text in this article, or it looks like it is passthrough text from CMiC rather than an Arcoro message.
Was this article helpful?
0 out of 0 found this helpful