PROBLEM
Joining a shapefile to a DBF table fails in Unix: jointables reference is case-sensitve. The SPATIALQUERY statement must be correctly constructed to perform the join, for example:
Code:
<WORKSPACES>
<SHAPEWORKSPACE name="shp_ws-0" directory="/server/dir1/data" />
</WORKSPACES>
<LAYER type="featureclass" name="Cities layer with join" visible="true" id="3">
<DATASET name="cities" type="point" workspace="shp_ws-0" />
<SPATIALQUERY jointables="lookup" joinexpression="To=[cities.city_code],From=[lookup.city_code],Type=[exact]" />
... etc.
The name of external table needs to be in upper-case.
Suspicion that this is the cause is verified when ArcExplorer Java is used to display a Feature map service. As noted above, the features of the joined layer do not display in the map. Furthermore, when an attempt to select points from the joined layer, by using the selction tool within an extent where the features should otherwise exist, the following error message is generated in the ArcExplorer Java Message Console:
Code:
com.esri.mo.client.aims.InvalidStreamDataException:
A general exception has occurred:
(SpatialServer has detected the following error: Cannot validate file /server/dir1/data/LOOKUP.dbf.)
Code:
<SPATIALQUERY jointables="LOOKUP" joinexpression="To=[cities.city_code],From=[lookup.city_code],Type=[exact]" />
Article ID:000005888
Get help from ArcGIS experts
Download the Esri Support App