POST
|
I created a new DB and connection file but get: DBMS table not found [42S02:[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Invalid object name '<dbname>.dbo.GDB_Release'.] [<dbname>.dbo.GDB_Release] Existing DBs work fine. It's just the newly created DB that throws this error. Using SQL Server Mgt Studio I can see that there is no GDB_Release table in the database, but there is no GDB_Release table in any of the databases. Any ideas? ----------------------------------------------------------- Microsoft Windows Server 2012 R2 Standard 6.3.9600 N/A Build 9600 Microsoft SQL Server 2014 Standard (64-bit) SP3 version 12.0.6024.0 ArcGIS Server 10.8 ArcGIS Desktop 10.8
... View more
08-21-2021
06:41 AM
|
0
|
1
|
1706
|
POST
|
Thanks Jonathan. That was it. As soon as I opened another browser tab and went to ..\portaladmin the Upgrade Complete window disappeared.
... View more
04-21-2020
03:07 PM
|
0
|
0
|
903
|
POST
|
Upgrading Enterprise from 10.6.1 to 10.8, the Upgrade Complete window has been spinning for 20 hours. Task Manager shows no CPU usage. Anyone else experience this? ESRI support says to let it continue running. Developer Tools shows net::ERR_CERT_COMMON_NAME_INVALID being thrown every couple minutes.
... View more
04-21-2020
07:17 AM
|
0
|
2
|
955
|
POST
|
import arcpy import os, sys from arcgis.gis import GIS def update(planningLayer, serviceItemID): # Set the path to the project prjPath = r"\\server\ServiceProjects\Planning\\" + planningLayer + ".aprx" # Feature service/SD name in arcgis.com, user/password of the owner account sd_fs_name = planningLayer portal = "http://www.arcgis.com" # Can also reference a local portal user = "" password = "" # Set sharing options shrOrg = True shrEveryone = True shrGroups = "" # Local paths to create temporary content relPath = sys.path[0] sddraft = os.path.join(relPath, planningLayer + ".sddraft") sd = os.path.join(relPath, planningLayer + ".sd") # Create a new SDDraft and stage to SD print("Creating SD file") arcpy.env.overwriteOutput = True prj = arcpy.mp.ArcGISProject(prjPath) mp = prj.listMaps()[0] arcpy.mp.CreateWebLayerSDDraft(mp, sddraft, sd_fs_name, 'MY_HOSTED_SERVICES', 'FEATURE_ACCESS','', True, True) arcpy.StageService_server(sddraft, sd) print("Connecting to {}".format(portal)) gis = GIS(portal, user, password) # Find the SD, update it, publish /w overwrite and set sharing and metadata print("Search for original SD on portal...") sdItem = gis.content.search('id:' + serviceItemID)[0] print("Found SD: {}, ID: {} \n Uploading and overwriting...".format(sdItem.title, sdItem.id)) #print("Found SD: {}, ID: {} \n Uploading and overwriting...".format(sdItem.id)) sdItem.update(data=sd) print("Overwriting existing feature service...") fs = sdItem.publish(overwrite=True) if shrOrg or shrEveryone or shrGroups: print("Setting sharing options...") fs.share(org=shrOrg, everyone=shrEveryone, groups=shrGroups) print("Finished updating: {} - ID: {}".format(fs.title, fs.id))
... View more
01-28-2019
02:11 PM
|
0
|
0
|
2720
|
POST
|
Hi Morten, Did you ever figure this out? When ArcGIS Server Manager on the target server is used the REST endpoint is a URL on the target server, as it should be, but the service is empty. Thanks, Mike
... View more
08-17-2018
02:19 PM
|
0
|
1
|
594
|
POST
|
That was it! The ID that was being passed in was for the feature layer, not the service definition. Thanks Aaron!
... View more
01-08-2018
10:17 AM
|
0
|
0
|
2720
|
POST
|
Thanks Aaron, There's still the problem that the line gis.content.search won't run if type is specified, but if type is not specified then the sdItem.publish errors out. Here is the error for including both type and id, as formatted in your response, with the one difference of passing in the id as a variable: --------------------------------------------------- pydev debugger: starting (pid: 11304) Creating SD file Connecting to http://www.arcgis.com Search for original SD on portal... File "C:\GIS\PROJECTS\PLANNING\UpdateZoning&GPToMatchNewParcels\updateAGOL_Pro.py", line 109, in <module> update("Zoning", "f78c18c992e74846806fc7dc98fb66f8") File "C:\GIS\PROJECTS\PLANNING\UpdateZoning&GPToMatchNewParcels\updateAGOL_Pro.py", line 76, in update sdItem = gis.content.search('type:"Service Definition" id:' + serviceItemID)[0] IndexError: list index out of range Here is the error when fileType is not specified: ------------------------------------------------------------------------ pydev debugger: starting (pid: 7432) Creating SD file Connecting to http://www.arcgis.com Search for original SD on portal... Found SD: Zoning, ID: f78c18c992e74846806fc7dc98fb66f8 Uploading and overwriting... Overwriting existing feature service... File "C:\GIS\PROJECTS\PLANNING\UpdateZoning&GPToMatchNewParcels\updateAGOL_Pro.py", line 110, in <module> update("Zoning", "f78c18c992e74846806fc7dc98fb66f8") File "C:\GIS\PROJECTS\PLANNING\UpdateZoning&GPToMatchNewParcels\updateAGOL_Pro.py", line 101, in update fs = sdItem.publish(overwrite=True) File "C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\lib\site-packages\arcgis\gis.py", line 3125, in publish if fileType == 'shapefile': UnboundLocalError: local variable 'fileType' referenced before assignment
... View more
01-08-2018
09:19 AM
|
0
|
2
|
2720
|
POST
|
Using the script at this blog: https://blogs.esri.com/esri/arcgis/2017/03/14/updating-your-hosted-feature-services-with-arcgis-pro-and-the-arcgis-api-for-python/ Line 41: sdItem = gis.content.search("{} AND owner:{}".format(sd_fs_name, user), item_type="Service Definition")[0] returns the wrong Service Definition (SD). The title query is not strict enough, so it returns any SD with a "Z" in the title. The SD I'm looking for is Zoning. Title or owner can be replaced with id: sdItem = gis.content.search(query="title:"+ sd_fs_name + " AND id:" + serviceItemID, item_type= "Service Definition")[0] which throws: IndexError: list index out of range Many permutations have been tried for using ID. If item_type= "Service Definition" is removed, line 41 will run: sdItem = gis.content.search(query="title:"+ sd_fs_name + " AND id:" + serviceItemID)[0] However, then on line 45: fs = sdItem.publish(overwrite=True) it throws: File “C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\lib\site-packages\arcgis\gis.py”, line 3125, in publish if fileType == ‘shapefile’: UnboundLocalError: local variable ‘fileType’ referenced before assignment So, the question is - how do I specify the ID, and also specify the item type?
... View more
01-05-2018
01:59 PM
|
0
|
6
|
4121
|
POST
|
I'm trying to debug the script described at: https://blogs.esri.com/esri/arcgis/2017/03/14/updating-your-hosted-feature-services-with-arcgis-pro-and-the-arcgis-api-for-python/ on line 41, if I use: sdItem = gis.content.search("{} AND owner:{}".format(sd_fs_name, user), item_type="Service Definition")[0] Then the wrong service definition is returned, because the name query is not strict enough. The only way to get the correct service definition is to use the id instead of owner or title, e.g. sdItem = gis.content.search(query="title:"+ sd_fs_name + " AND id:" + serviceItemID, item_type= "Service Definition")[0] but this throws the error: IndexError: list index out of range The correct service definition can be returned without an IndexError if item_type is not included; sdItem = gis.content.search(query="title:"+ sd_fs_name + " AND id:" + serviceItemID)[0] but then line 45 fs = sdItem.publish(overwrite=True) throws: File "C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\lib\site-packages\arcgis\gis.py", line 3125, in publish if fileType == 'shapefile': UnboundLocalError: local variable 'fileType' referenced before assignment Does anyone have any ideas on how to both get the correct service definition, and also specify item type? I've tried many different permutations of the different arguments.
... View more
01-04-2018
01:10 PM
|
0
|
0
|
518
|
POST
|
According to this page: http://support.esri.com/en/technical-article/000012659 To write an AddIn in Visual Studio 2015 requires Visual Studio 2013 Shell, which cannot be installed on Windows 10. Currently I'm using ArcObjects/ArcGIS 10.5 and VS2015 on Windows 10, so AddIns will not work. Is there a way to get AddIns to work with this system, or am I stuck using a MapControl in ArcEngine?
... View more
09-21-2017
04:49 PM
|
0
|
0
|
414
|
POST
|
For example, click a polygon to bring up the popup window, click the link to related tables, open the related table, then click a row in the related table to open a PDF or JPG. Currently the related tables have paths to the files, but I can't figure out how to get them hyperlinked. I've tried URL, UNC and local paths. None of them have worked. Thanks!
... View more
06-11-2015
02:50 PM
|
0
|
0
|
4811
|
POST
|
Does anyone know if this has been/can be done? There are decibel meter apps available for IPhones. I have not used them and know nothing about them, but was curious if a meter reading could be attached to a feature in Collector, just like an image file can be attached. Thanks, Mike
... View more
02-10-2015
02:36 PM
|
0
|
0
|
3748
|
Online Status |
Offline
|
Date Last Visited |
07-03-2024
12:46 AM
|