Latest Contributions by JakeSkinner

‎07-15-2022

@GregCarlino2 did you stop the ArcGIS Server service before executing the script?

‎07-14-2022

Hi @MarioBruschi I've seen this error when an components were reinstalled individually in the past. Unfortunately, you have to upgrade each application individually.

‎07-13-2022

Hi @GISLearner, Take a look at the example here.

‎07-13-2022

If your GeoEvent Definition has Groups within it, you will not be able to use that definition to create your feature service. You would have two options, create the geoevent definition manually, and then create your feature service in GeoEvent, or create a feature class in ArcGIS Pro and publish the feature service.

‎07-12-2022

@LuisEduardoPerezGraterol yes you can, but there are additional steps you need to take. See the following help document: https://desktop.arcgis.com/en/arcmap/latest/manage-data/editing-fundamentals/about-editing-data-from-feature-services.htm

‎07-12-2022

@JonSwoveland you should be able to install Notebook Server with an existing ArcGIS Server instance, though it is usually not recommended. Instead, though, you could schedule the script to run from a machine that has ArcGIS Pro or ArcGIS Server installed. Take a look at the following document for more details.

‎07-12-2022

Hi @ElviraForslund, As a test, are you able to write event to a feature service?

‎07-12-2022

@RonBolesky you can enable editor tracking on the hosted feature service: https://doc.arcgis.com/en/arcgis-online/manage-data/data-access-and-editing.htm#ESRI_SECTION1_706C909AECFB45B38E690DA1B16F8EFF

‎06-16-2022

Hi @Bud, Here is an example of creating a table, inserting points, inserting into the user_sdo_geom_metadata table, creating the index, and then registering with your geodatabase: create table SDO_Points (OID number(38) not null unique, TestID number, shape SDO_GEOMETRY); Insert into SDO_Points values (1, 1, SDO_GEOMETRY(4001, 8260, null, SDO_ELEM_INFO_ARRAY(1, 1, 1), SDO_ORDINATE_ARRAY(10.0, 10.0, 10, 1100))); Insert into SDO_Points values (2, 2, SDO_GEOMETRY(4001, 8260, null, SDO_ELEM_INFO_ARRAY(1, 1, 1), SDO_ORDINATE_ARRAY(10.0, 20.0, 20, 1200))); Insert into SDO_Points values (3, 3, SDO_GEOMETRY(4001, 8260, null, SDO_ELEM_INFO_ARRAY(1, 1, 1), SDO_ORDINATE_ARRAY(10.0, 30.0, 30, 1300))); Insert into SDO_Points values (4, 4, SDO_GEOMETRY(4001, 8260, null, SDO_ELEM_INFO_ARRAY(1, 1, 1), SDO_ORDINATE_ARRAY(10.0, 40.0, 40, 1400))); insert into user_sdo_geom_metadata values ('SDO_Points', 'SHAPE', SDO_DIM_ARRAY(SDO_DIM_ELEMENT('Lat', -90, 90, 0.05), SDO_DIM_ELEMENT('Long', -180, 180, 0.05), SDO_DIM_ELEMENT('Elevation', 0, 5000, 0.05), SDO_DIM_ELEMENT('M', 0, 5000, 0.05)), 8260); create index SDO_8260_4D_Point_indx on SDO_Points(shape) indextype is mdsys.spatial_index; Last step is to execute the Register with Geodatabase tool in ArcGIS Pro/ArcMap.

‎06-13-2022

@Brian_Wilson good call on the re.sub expression. I've updated the script to only update whole words.

‎06-12-2022

@Brian_Wilson you are right, updating the Data Store connection file updated the data source of the services. Originally, I tried this with a customer and we both thought the connections were not updated due to Service Workspaces in Server Manager showing the original instance information (i.e. screen shot in the Results section of the document). The workflow above will update that information. The replace option on line 127 will only update the manifest.json for a service that contained the previousDSID value. It will not crawl through every file in the config-store directory/sub-directory updating occurrences of the previous SQL instance.

‎06-11-2022

@Brian_Wilson let me know how the script works out for you.

‎06-09-2022

After moving your SQL Server instance to a new server, this guide will show you how to update your ArcGIS Server services. Additionally, it will demonstrate how to update file-based services that use data from a file geodatabase, such as map and image services, after the network share has changed. Scenario It might be necessary for you to move your SQL Server geodatabase to a different server. The 2022 instance, for instance, might be on a different server when you upgrade from SQL Server 2019 to SQL Server 2022. With a database backup and restore, moving the geodatabase is simple. However, what about updating your ArcGIS Server services? The services will use the SQL instance name if they are referencing information from your enterprise geodatabase. This can be fixed by re-mapping the data sources in your Pro Projects/MXDs, and then re-publishing your services. But what if you have dozens, or hundreds, of services? This can be extremely time consuming. The below video will show how you can update all of your services with a couple of python scripts. Note: Before executing the scripts, be sure you have made a copy of the \arcgisserver\config-store\services and \arcgisserver\directories\arcgissystem\arcgisinput directories.

‎05-24-2022

@JosephHilliard94 you could use AGOL Notebook Server. Take a look at the following document. It has similar functionality to what you're trying to do, and could be revamped to run in Notebook Server.

‎05-24-2022

@JonathanWhite1 no, you would have to execute the script separately for each table.

Online Status	Offline
Date Last Visited	Friday

My Ideas

Latest Contributions by JakeSkinner

Re: Update ArcGIS Server Services after SQL Server Instance Change

Re: The following must be resolved to run this setup program: ArcGIS Data Store 10.8.1 needs to be removed

Re: Where in the ArcPy OD Cost Matrix line do I specify that I want distance in MILES

Re: Error Sending Features to a Stream Service GeoEvent

Re: Can I edit my ArcGis Online data with Arcmap 10.8?

Re: Can a single instance of ArcGIS Server perform multiple roles?

Re: Error Sending Features to a Stream Service GeoEvent

Re: Auto populate the date when a new point is added to a map.

Re: Convert a database table to a feature class?

Re: Update ArcGIS Server Services after SQL Server Instance Change

Re: Update ArcGIS Server Services after SQL Server Instance Change

Re: Update ArcGIS Server Services after SQL Server Instance Change

Update ArcGIS Server Services after SQL Server Instance and/or Network File Share Change

Re: Append data from one hosted feature layer to another

Re: Overwrite ArcGIS Online Feature Service using Truncate and Append

Re: Remove empty tilecache 11.3 before upgrade to ...

Display Latest Feature In a Feature Service

Re: Licenses for the parallel prod

Re: Change Portal Admin URL in Portal Administrato...

Re: Update the organization URL in ArcGIS Enterpri...

Web AppBuilder Custom Widgets