00137: Query table has a non-integer unique identifier field

The unique identifier field chosen for this query table is a non-integer, and you are attempting to publish to a spatial data server (SDS).

Solution

• Choose an integer field for the query table unique identifier field.
  1. In the table of contents, right-click the query table whose query you would like to modify.
  2. Click Properties to open the Properties dialog box.
  3. Click the Source tab.
  4. Click Change query.
  5. Check the Show Advanced Options check box on the Edit Query Layer dialog box.
  6. Click Next.
  7. Choose only a single integer field from the Unique Identifier Field(s) field list.
  8. Click Finish.

More information

Although you can use non-integer fields as unique identifiers for a query table, publishing query tables to SDS requires that the identifier field be an integer.

Learn more about query layers

Learn more about authoring feature services for a spatial data server (SDS)