I've run into a bit of a stumbling block when trying to use a join within the context of a dynamic layer. I've included some details about my test environment; I've also included a working dynamic layers rendering request without a join and a broken request with a join. I am hoping someone is able to spot my error.
Environment:
ArcServer 10.1 Beta 1
ArcSDE 9.1
Oracle 10gR2
The connection within the MapService is registered as the schema owner (VRIMSD_ADMIN); this user is not a DBA.
The VRIMSD_ADMIN.FOREST_COVER_OBJECT table is a spatially enabled SDO table; VRIMSD_ADMIN.FOREST_COVER_OBJECT.FOREST_COVER_OBJECT_ID is registered as the obid column.
The VRIMSD_ADMIN.VEGETATION_COVER_POLYGON_EST table does not have any spatial components and is registered with SDE. There is a 1-1 relationship from the FOREST_COVER_OBJECT table to the VEGETATION_COVER_POLYGON_EST table.
*** WORKS ***
[
{
"id": "VRIMSD_ADMIN.FOREST_COVER_OBJECT",
"source": {
"type": "dataLayer",
"dataSource":
{
"type": "table",
"workspaceId": "VegWrk",
"dataSourceName": "VRIMSD_ADMIN.FOREST_COVER_OBJECT"
}
},
"drawingInfo":
{
"renderer":
{
"type": "simple",
"symbol":
{
"type" : "esriSFS",
"style" : "esriSFSSolid",
"color" : [166,36,0,255],
"outline" :
{
"type" : "esriSLS",
"style" : "esriSLSSolid",
"color" : [0,255,0,255],
"width" : 2
}
},
"description": ""
},
"transparency": 60
}
}
]
*** RETURNS A WHITE IMAGE ***
[
{
"id": "VRIMSD_ADMIN.FOREST_COVER_OBJECT",
"source": {
"type": "joinTable",
"leftTableSource":
{
"type": "dataLayer",
"dataSource":
{
"type": "table",
"workspaceId": "VegWrk",
"dataSourceName": "VRIMSD_ADMIN.FOREST_COVER_OBJECT"
}
},
"rightTableSource":
{
"type": "dataLayer",
"dataSource":
{
"type": "table",
"workspaceId": "VegWrk",
"dataSourceName": "VRIMSD_ADMIN.VEGETATION_COVER_POLYGON_EST"
}
},
"leftTableKey": "VRIMSD_ADMIN.FOREST_COVER_OBJECT.FOREST_COVER_OBJECT_ID",
"rightTableKey": "VRIMSD_ADMIN.VEGETATION_COVER_POLYGON_EST.FOREST_COVER_OBJECT_ID",
"joinType": "esriLeftOuterJoin"
},
"drawingInfo":
{
"renderer":
{
"type": "simple",
"symbol":
{
"type" : "esriSFS",
"style" : "esriSFSSolid",
"color" : [166,36,0,255],
"outline" :
{
"type" : "esriSLS",
"style" : "esriSLSSolid",
"color" : [0,255,0,255],
"width" : 2
}
},
"description": ""
}
}
}
]