POST
|
Thanks for the reply. My enterprise license is available for ArcGIS 10.1-10.5. I haven't been able to test with a newer version. After some more digging, I am now pretty sure it's a bug. I analyzed the command output of the Geoprocessing Window while the tool is running and I discovered the SQL query is missing the division sign ("/"). Apparently, the tool chooses to ignore it, hence the error thrown by the ODBC driver. The same SQL query works perfectly with multiplication, so I think it is safe to rule out syntax issues in other parts of the query. I'll follow your advice and contact Esri Technical.
... View more
10-30-2020
01:22 AM
|
0
|
0
|
1699
|
POST
|
I have the following issue when using the Create Database View tool in ArcMap. My query runs fine in Microsoft SSMS and Visual Code (with mssql extension) against the enterprise geodatabase. But for some reason, when I'm trying to create the view using Create Database View in ArcMap, I get the following error. Traceback (most recent call last): File "D:\Beni\OT\Databases\Actualizare\Tools\Scripts\10_Creare_view.py", line 39, in <module> arcpy.CreateDatabaseView_management(in_db,numeView,defView) File "c:\program files (x86)\arcgis\desktop10.5\arcpy\arcpy\management.py", line 4318, in CreateDatabaseView raise e ExecuteError: ERROR 999999: Error executing function. [[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near '('.] DBMS table not found Failed to execute (CreateDatabaseView). ERROR 999999: Error executing function. [[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near '('.] DBMS table not found Failed to execute (CreateDatabaseView). I can successfully connect to the Enterprise Geodatabase in ArcMap and create other views using the same tool, on the same geodatabase. Also, I am able to create the view via Catalog window in ArcMap, using right-click on geodatabase connection - New - View. It works flawlessly this way and it doesn't complain about syntax. I could create the views manually, via the above-mentioned method, but I am trying to automate the operation via the Create Database View tool. This is not the only query that fails with this tool (I have about 400 of them which work and about 70 which fail). I checked the syntax a thousand times and I still can't figure it out. Maybe someone here could help me understand the issue. My only conclusion is that this could be a bug in the Create Database View tool, with certain types of queries. The SQL query looks like this: SELECT CAST (ROW_NUMBER() OVER (ORDER BY ADM.DENUMIRE) AS INT) AS OBJECTID, ADM.DENUMIRE, CAST(ADM.LOC_COMPONENTE_ALE_MUN_ORAS AS DECIMAL) / CAST(iif(AGR.ANUL_2014 = 0, -1, AGR.ANUL_2014) AS DECIMAL) AS DENSITATEA_ASEZARILOR_URBANE, ADM.LOC_COMPONENTE_ALE_MUN_ORAS, AGR.ANUL_2014 AS SUPRAFATA, ADM.SHAPE FROM (SELECT JUD.OBJECTID, JUD.DEN_JUD AS DENUMIRE, ADM.LOC_COMPONENTE_ALE_MUN_ORAS, JUD.SHAPE FROM (SELECT JUDET, SUM(LOC_COMPONENTE_ALE_MUN_ORAS) AS LOC_COMPONENTE_ALE_MUN_ORAS FROM gisdata_owner.ADM010 AS ADM GROUP BY JUDET) AS ADM RIGHT OUTER JOIN gisdata_owner.JUDETESIMP AS JUD ON JUD.DEN_JUD = ADM.JUDET) AS ADM INNER JOIN (SELECT AGR.MACROREGIUNI_REGIUNI_DE_DEZVO AS DENUMIRE, AGR.ANUL_2014 FROM gisdata_owner.AGR101A AS AGR WHERE AGR.FORME_DE_PROPRIETATE = 'Total' AND AGR.MODUL_DE_FOLOSINTA_A_FONDULUI = 'Total') AS AGR ON AGR.DENUMIRE = ADM.DENUMIRE Setup info Windows 10 Pro v. 2004 (build 19041.572) ArcGIS Desktop Advanced / ArcMap 10.5.0.6491 SQL Server 2014 Developer Edition (12.0.6118.4)
... View more
10-28-2020
01:40 AM
|
0
|
4
|
1753
|
POST
|
For those having the same issue with WAB, here is a working solution: 1. Create a custom Python script to iterate through your table and create field aliases for each field; you can use arcpy.AlterField_management for this purpose (make sure you skip required fields, such as OBJECTID, Shape, Shape_length, Shape_area etc.). 2. Publish your data as a service. 3. Create a webmap from your published service and enable popups (they will be automatically generated based on your field aliases). 4. Launch WAB Developer with the new webmap and you should have proper labels for your infographics (based on field aliases and not field names).
... View more
07-30-2018
11:04 PM
|
0
|
0
|
772
|
POST
|
Ok, so here's the thing I worked with ArcGIS for Desktop 10.3.1 to do some geomorphologic analysis, which resulted in a few raster layers (all in GeoTIFF format). I want to publish them to ArcGIS online, in order to make a Web App for presenting those maps. I uploaded the GeoTIFF rasters as a Tile Package (Create Map Tile Package function) and used Publish to convert it to a Tile Layer (online). All good so far. The problem is I can't choose which raster to display in an online map. It only shows me the one which had its check mark on, when I created the Tile Package in ArcGIS for Desktop... I can't choose another one from the list, in order to make it visible (see the picture) . Am I doing something wrong or is it a known limitation of ArcGIS Online? I am using an Esri Developer account on Microsoft Edge 38.14393.0.0, Windows 10 Home 64 bit. Thanks a lot for the help
... View more
09-02-2016
12:40 PM
|
1
|
0
|
707
|
Title | Kudos | Posted |
---|---|---|
1 | 09-02-2016 12:40 PM |
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:24 AM
|