I have a feature class named AGS.MUNICIPIOS_AM and a table datasource named AGS.POPULACAO_MUN_AM. My goal is to use the shapes from MUNICIPIOS_AM and the attributes from POPULACAO_MUN_AM, which contains the population by year for each city.
I have defined a Dynamic Layer using a Join Data Source:
{ "id": 102, "source": { "dataSource": { "leftTableSource": { "mapLayerId": 0, "type": "mapLayer" }, "rightTableSource": { "dataSource": { "dataSourceName": "AGS.POPULACAO_MUN_AM", "workspaceId": "DatabaseWorkspace", "type": "table" }, "type": "dataLayer" }, "leftTableKey": "NOME_MUNICIPIO", "rightTableKey": "MUNICIPIO", "joinType": "esriLeftOuterJoin", "type": "joinTable" }, "type": "dataLayer" } }My service URL is http://services-gis.prodam.am.gov.br/arcgis/rest/services/SUSAM/TesteValoresMunicipais/MapServer.
My test to query it was successful using this request: http://services-gis.prodam.am.gov.br/arcgis/rest/services/SUSAM/TesteValoresMunicipais/MapServer/dyn...
# records: 62
AGS.Municipios_AM.OBJECTID: 1
AGS.Municipios_AM.ID: 92
AGS.Municipios_AM.SHAPE_LENG: 4.12620879
AGS.Municipios_AM.REGIAO: NORTE
AGS.Municipios_AM.GEOCODIGO: 1301100
AGS.Municipios_AM.NOME_MUNICIPIO: CAREIRO
AGS.Municipios_AM.UF: AM
AGS.Municipios_AM.COD_UF: 13
AGS.Municipios_AM.LONG_: -60.36374167
AGS.Municipios_AM.LAT: -3.82246776
AGS.Municipios_AM.ARRUAMENTO: 0
AGS.Municipios_AM.CREATED_USER: null
AGS.Municipios_AM.CREATED_DATE: null
AGS.Municipios_AM.LAST_EDITED_USER: null
AGS.Municipios_AM.LAST_EDITED_DATE: null
AGS.Municipios_AM.OID_SISP: 40
AGS.Municipios_AM.GLOBALID: {3E3D6361-4B84-47A2-8E0A-5FAD0D63FDF2}
SHAPE.AREA: 0
SHAPE.LEN: 0
AGS.POPULACAO_MUN_AM.IBGE: 1301100
AGS.POPULACAO_MUN_AM.MESORREGIAO: Centro Amazonense
AGS.POPULACAO_MUN_AM.MICRO: 13007 Manaus
AGS.POPULACAO_MUN_AM.REGIONAL_SAUDE: Entorno de Manaus
AGS.POPULACAO_MUN_AM.MUNICIPIO: CAREIRO
AGS.POPULACAO_MUN_AM.VALOR_2009: 32637
AGS.POPULACAO_MUN_AM.VALOR_2010: 32734
AGS.POPULACAO_MUN_AM.VALOR_2011: 33132
AGS.POPULACAO_MUN_AM.VALOR_2012: 33517
AGS.POPULACAO_MUN_AM.VALOR_2013: 35431
AGS.POPULACAO_MUN_AM.VALOR_2014: 35938
AGS.POPULACAO_MUN_AM.VALOR_2015: 36435
AGS.POPULACAO_MUN_AM.VALOR_2016: null
Polygon:
[-60.018250953999996, -3.3700131009999836] , [-60.00077279599998, -3.3578726640000127] , [-59.936067863999995, -3.298994760000028] more..
However, when it needs to render an image, the server returns nothing. The test was done using this request: http://services-gis.prodam.am.gov.br/arcgis/rest/services/SUSAM/TesteValoresMunicipais/MapServer/exp...
I got this problem after changing the Dynamic Data Layer with Table Join sample to use our own service.
I've checked the logs at ArcGIS Server Manager and there is no entry.
Is it a bug in Dynamic Layer for ArcGIS Server 10.4? Maybe some misconfiguration at our service? Any ideas?
