VERIFIED SOLUTION i
X

Resolving the Anysite error: "Invalid identifier. Unresolved identifier "_TmpLink_Linked.Zip". (Err=1011) (table=_TmpLink)" when trying to display linked layer

Issue

User has an .xls file of zipcodes and data.  User creates a database for this .xls and then links to zipcodes boundary table.
When added to a map preference, an error is thrown:
User-added image
---------------------------
Invalid identifier. Unresolved identifier "_TmpLink_Linked.Zip".  (Err=1011) (table=_TmpLink)

Cause

The error is occurring because the user's xls spreadsheet had a field with a space in the name: "Zip Code"
According to the AnySite  manual, tables and column names cannot have spaces or special characters::

User-added image

Resolution

UPDATED: September 8, 2017


To resolve this issue, user must change the field name to remove the space, i.e. "ZIPCODE" instead of "ZIP CODE"

Environment Details

Product affected: AnySite™
 

Downloads

  • No Downloads