Dynamic Layer Join Data Source not rendering in a map

BrunoMendes — Wed, 11 Jan 2017 14:05:04 GMT

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/dynamicLayer/query?laye…

# 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/export?bbox=-8298520.16…

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?

Re: Dynamic Layer Join Data Source not rendering in a map

KristianEkenes — Wed, 11 Jan 2017 20:03:25 GMT

This is a bug that will be fixed in 4.3. In the meantime you can use the patch in your 4.2 apps referenced here: https://community.esri.com/thread/188434-definitionexpression-with-mapimagelayer-sublayer#comment-658350

That should help temporarily fix the issue. The patch code will need to be removed once the app is upgraded o 4.3.

Re: Dynamic Layer Join Data Source not rendering in a map

BrunoMendes — Thu, 12 Jan 2017 17:51:03 GMT

Thanks for the quick response Kristian, but the patch didn't solve my problem.

I can reproduce the problem without using the JSAPI and calling the service directly with the following parameters:

The test was done using this request: http://services-gis.prodam.am.gov.br/arcgis/rest/services/SUSAM/TesteValoresMunicipais/MapServer/export?bbox=-8298520.16…

I'll try to upgrade our server from 10.4 to 10.4.1 this week and test again.

topic Dynamic Layer Join Data Source not rendering in a map in ArcGIS JavaScript Maps SDK Questions

Dynamic Layer Join Data Source not rendering in a map

Re: Dynamic Layer Join Data Source not rendering in a map

Re: Dynamic Layer Join Data Source not rendering in a map