PROBLEM

Join tables are dropped when using file based data

Last Published: April 25, 2020

Description

When file based tables are used in joins, for example: <shapefile>.dbf, the joined table is dropped by ArcGIS Server Map Server or ArcIMS ArcMap Service on Solaris or Linux.

Cause

Paths to join tables are not updated correctly within the ArcMap document, when using the Set Data Source utility.

Solution or Workaround

Select one of the following workarounds:

  • Use ArcSDE based tables instead of a file based table. This eliminates the need to update the data path using Set Data Source.

  • When updating the data path using Set Data Source utility in ArcCatalog, repeat the steps twice. The first time the data path is updated, join table paths do not get updated. Follow the steps below:

    A. In ArcCatalog, right-click on the ArcMap document with the joined layers and select 'Set Data Source...'

    B. Update all Windows paths to Unix and save the changes.

    C. Reopen the Set Data Source dialog box again (Step A). Notice that the join tables still have Windows path set to the data.

    D. Update this Windows path to an Unix location and save the changes.
    Note:
    Joins that use ODBC connections on Windows are not supported by the ArcMap server on Unix.

Article ID:000006895

Software:
  • ArcGIS Server

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic