This error appears during a data import when a field name in the target table contains a special character. SelectHR databases only support alphabetical characters in field names. If a field includes a special character, the import will fail.
📌 Note: The Incorrect Syntax near 'X' aspect of the error may contain a different letter depending on the impacted field, and may not necessarily be represented by an X as in the example above.
If you have a field within your table that contains a special character, this will require the following actions:
The removal of all references to that field from all forms, processes, lookups, listings, field lists, etc.
A SQL level change to the field name to remove the special characters.
The re-implementation of the field in all reference points where it was removed.
This is considered data correction and is not something that can be carried out by the support team.
However, our consultancy team can review the impacted field and perform this work for you in order to resolve the issue. Any consultancy time would likely incur a charge, so it's worth bearing this in mind before raising a request for consultancy time.
Please reach out to your account manager or raise via the FlexPoint portal.