Problem: Join tables are dropped when using file based data
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.
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.
Joins that use ODBC connections on Windows are not supported by the ArcMap server on Unix.