Latest Contributions by Clint_Glover

‎12-17-2019

I am currently running three environments (development, acceptance, production) of ArcGIS Enterprise 10.6.1 on Windows 2012 servers (Portal and Server are federated) and I am experiencing an issue (only on the acceptance environment) where all of our web services within ArcGIS Server are shown with a status of "Stopping". In the ArcGIS Server logs, two big error codes appear after each attempt to restart the ArcGIS Server windows service. The error codes are 6550 (failed to start the server machine) and 7365 (error while starting AppServer). I began my troubleshooting by restarting the ArcGIS Server windows service. After that didn't fix the issue, I rebooted the entire server (didn't fix the issue). After that, I went through and checked multiple things including verifying that the windows account running ArcGIS Server has the correct folder permissions set, verifying that I have a valid licenses to run ArcGIS Server, verifying that the acceptance environment is configured the same as the development and production environments, and verifying that the acceptance environment has the same ArcGIS Enterprise patches installed as the other environments. I will note that this behavior occurred after some recent windows patches were installed on that server. When comparing the timestamp of the errors appearing in the ArcGIS Server logs to the timestamp of the installation of the windows patches on the acceptance server, they are very similar (same day). This leads me to believe that the recent windows patches had some affect on ArcGIS Server. The odd thing is that the same windows patches were installed on the development and production environments with no issues arising after installation. I contacted ESRI support and all they can tell me to do is to attempt to uninstall the windows patches to see if it corrects the issues or uninstall/reinstall ArcGIS Server in that environment. I would rather not have to uninstall/reinstall ArcGIS Server due to possible issues that might arise from our federation with Portal. This is the first time I have ever experienced this behavior in any version of ArcGIS Enterprise. Does anyone have any other suggestions for things I can try?

‎12-17-2019

Yes I totally agree. Nothing ever seems straightforward with ESRI. I'm not sure how we are going to handle it yet (not really using ArcGIS Pro just yet for publishing our web services), but we will come up with something in the near future.

‎12-17-2019

The join issue I noted above has been resolved when updating to ArcGIS Pro 2.4. I'm not sure exactly what the difference was but something in the update fixed it when running the script within Pro 2.4.

‎07-23-2019

I am currently responsible for updating layer data sources within mxds after an Oracle password change takes place. To do this I have put together a Python script that goes through a folder (designated by the user), finds all of the .mxd files, and one by one reads in the layers of each mxd (arcpy.mapping.ListLayers), checks the workspacePath of each layer to determine which Oracle account is used for the layer, and then uses the replaceDataSource method to set it to the updated sde connection file. After it finishes, it saves the mxd and then goes on to the next mxd file. I've recently discovered that when running the Python script, the data source information of some of the layers will occasionally be assigned to a temporary sde connection file that is being generated by some part of the ESRI software. This assignment is being done BEFORE my Python checks the workspacePath and attempts to use the replaceDataSource method. The temporary sde files are being generated in the following location on my local machine: C:\Users\John Doe\AppData\Local\Temp. Within the Temp folder, a folder titled "arc66D2" was generated, which contained the temporary sde file that was named 131dcb16a392ebc818a09874d51fce89.sde. When I looked at the connection properties of this temp sde file (from ArcCatalog), it contained the old connection information from one of the layers within a mxd I ran my Python script on. This behavior has happened on multiple occasions, each of which involves a different temporary sde file that were generated. I have also discovered that this behavior occurs some times when I open ArcCatalog, right click on a mxd file, and select the "Set Data Source(s)..." option, which allows you to manually update the data source information for an mxd. The tricky part is that there doesn't appear to be any pattern with this occurrence. Has anyone ever had this same issue and/or know why this is occurring and how to prevent it? From my tests, this has occurred when working with mxds on my local machine as well as mxds located on various servers. After a password change, I have to run this Python script on thousands of mxds that have been created over the past 5 to 10 years by our end users to fix the data source information of all the layers, and when this temporary sde file is thrown in there "randomly", I can't trust my script to work 100% of the time and it causes additional work for me. For reference, I am using ArcMap/ArcCatalog 10.6.1 and Oracle 12c. In the past, our Oracle account passwords have never changed, thus this wasn't a problem. Recently, my organization started forcing us to update our Oracle passwords every 90 days, so this is becoming a huge ordeal for our GIS group to support and manage.

‎07-11-2019

I have not attempted to switch a layer's data source from a file geodatabase to an enterprise geodatabase so unfortunately I'm of no help to you in this particular situation. If I get some spare time, I'll attempt it and will let you know what I find out.

‎07-11-2019

I actually called ESRI tech support on this particular issue and below is the Python code ESRI gave me as the solution to this issue. Instead of resetting the connection properties to another sde connection file, this Python simply just updates the password for each layer. After running some quick initial tests, it seems to work for me, with the exception of a layer that contains a join. Python code ESRI provided import arcpy, pprint p = arcpy.mp.ArcGISProject('current') m = p.listMaps()[0] for l in m.listLayers(): conProp = l.connectionProperties conProp['connection_info']['password'] = '<new password>' l.updateConnectionProperties(l.connectionProperties, conProp) p.save() ## This may work as wlel if they are sure that only their database layers are broken in the project. ##for l in m.listLayers(): ## if l.isBroken == 'True': ## conProp = l.connectionProperties ## conProp['connection_info']['password'] = 'sa' ## l.updateConnectionProperties(l.connectionProperties, conProp) ##p.save()‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ When there is a layer with a join, conProp can not find the 'connection_info', and this is due to it being split into two different sections, one for the layer's connection info and one for the connection info for the join. From what I found, it looks like you access the connection info for the layer and the join with the following code: conProp['source']['connection_info']['password'] conProp['destination']['connection_info']['password']‍‍ When I put it all together, it should look like this: import arcpy, pprint p = arcpy.mp.ArcGISProject('current') m = p.listMaps()[0] for l in m.listLayers(): conProp = l.connectionProperties conProp['source']['connection_info']['password'] = '<new password>' conProp['destination']['connection_info']['password'] = '<new password>' l.updateConnectionProperties(l.connectionProperties, conProp) p.save() ## This may work as wlel if they are sure that only their database layers are broken in the project. ##for l in m.listLayers(): ## if l.isBroken == 'True': ## conProp = l.connectionProperties ## conProp['connection_info']['password'] = 'sa' ## l.updateConnectionProperties(l.connectionProperties, conProp) ##p.save()‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ After making that change, the Python still did not work to fix those layers and/or save the Pro project in Pro 2.3.3. It appears to run through the first layer of the map in the Pro project and then it stops with no errors or anything. EDIT: All of the issues with the Python listed above not updating layers with joins and saving the Pro projects were fixed after I updated from Pro 2.3.3 to 2.4.1. Something in the Pro update fixed the issues.

‎06-06-2019

My organization is currently running ArcGIS Enterprise (10.6.1) and as the site administrator I am looking to improve efficiency for some tasks. Is there currently a solution using ArcPy that will allow Portal administrators to remove a level 2 from a Portal account and replace it with a level 1? We currently have a finite number of level 2 Portal licenses, and we would like to come up with a Python script that we could run that would complete this task for us when a user hasn't logged in recently (within the past 90 days or so). In some cases, our users are granted a level 2 licenses and they end up using it a couple of times and never using it again. We currently have around 4500 users (mostly level 1), and it would be beneficial if we could automate that process to prevent level 2 licenses from becoming stagnant.

‎06-04-2019

Currently within my organization, password rules have been put in place that requires us to update our Oracle passwords every 90 days. Due to these rules, I am in the process of creating a python script for both ArcMap mxds and ArcGIS Pro projects. We currently have our SDE connection files in a shared directory to make this process easier. When a password change is required, we update the Oracle password and then update the password for the associated SDE connection file in the shared directory. Our intentions are to reuse the SDE connection files after a password changes, so our python scripts essentially should just reset each layer's connection info back to itself, which would then contain the updated password for the associated SDE file. The ArcMap python script has been created and works correctly using the .replaceDataSource function. When I began working on the ArcGIS Pro python script, I ran into issues using the updateConnectionProperties function for layers within a map in a ArcGIS Pro project that used SDE connection files in our shared directory. I attempted to set the new SDE connection file for each layer back to itself (which works with the replaceDataSource function for ArcMap), due to the SDE connection file staying the same, with only the password being updated. I have also attempted to reset each layer's connection properties to a completely new SDE file, but that doesn't appear to work either. None of ESRI's examples show using updateConnectionProperties to go from one SDE connection to another SDE connection file. Does anyone know if this is possible or if there is an alternate route I can take to complete this task? For reference, I am using the latest version of ArcGIS Pro (2.3.3) and our SDE connection files are pointed to an Oracle database (12c).

‎03-28-2019

Thank you for the information. Any idea about how to handle GeoEvent Server?

‎03-28-2019

I have been tasked to update our ArcGIS Server and Portal for ArcGIS accounts that run on our Windows 2012 servers. We use the same Windows account to run ArcGIS Server, GeoEvent Server, ArcGIS Data Store, and Portal for ArcGIS. I have read through the ESRI instructions for using the ArcGIS Server Account utility for ArcGIS Server and the configureserviceaccount utility for Portal for ArcGIS, but I'm not sure how/if those utilities affect the account used to run GeoEvent Server and ArcGIS Data Store. Is there a separate utility for updating those accounts or does the ArcGIS Server Account utility also update those? If the answer is no to both of those questions, how do you go about updating the account (other than changing it with the operating system settings)? I've never had to update these accounts before so this is all new to me. Any assistance on this situation would be greatly appreciated. Just for reference we are running ArcGIS Enterprise 10.6.1.

‎01-14-2019

I am currently using the Smart Editor widget inside of Web AppBuilder Developer Edition (version 2.10) and I have a date field that needs to use 24 hour time (HH:mm:ss). I have set that field in the Portal web map to use 24 hour time, but it seems that the Smart Editor widget is either ignoring or overriding it. The Smart Editor widget appears to only want to use h:mm:ss am/pm time format no matter what the date/time format is set to in the Portal map. I'm not sure if this is intentional behavior by the Smart Editor widget, but whether it is or is not, does anyone know of a solution to fix my issue? For reference, I am using ArcGIS Enterprise (10.5.1).

‎08-06-2018

Thanks for the help and the resources. I think we will try incorporating this script into our workflow for the future.

‎08-02-2018

Yes that is exactly what we had been doing in the past. Our accounts used for making our map services have never been changed since I started working in our GIS group. We recently upgraded to Oracle 12c on our lower environments, and since then we were told by our management that we have to change our passwords (now required to be 18 characters) every 60 days. We are in the process of trying to get an exemption to this rule, but I was tasked with finding a solution to this issue if we were not granted an exemption. I agree this makes it a nightmare for us to support and administer, especially with numerous accounts for development, acceptance, and production environments.

‎08-02-2018

So if I am reading that right, the ExternalizeConnectionStrings.bat command utility only needs to be run if you are upgrading from 10.3 to 10.5 or 10.6? We recently upgraded from 10.4.1 to 10.5.1, so we should be able to just log in to Server Manager and update the Data Store connection files. I think that should work for us to get our services updated. Another question I have is what is the quickest/easiest way to update the data sources' connection information for layers inside of MXDs. We currently have used ArcCatalog, right clicked on each MXD and updated the data sources. We are also aware of the Arcpy script utlizing the findAndReplaceWorkspacePaths method that does basically the same thing. Are these two the only real options for updating data souces after password updates? We have a significant number of MXDs that will need to be updated and our Oracle passwords are set to be updated every 60 days so we would like to find the most efficient method possible.

‎08-01-2018

I currently have several database connections that are used in various MXDs that are used to publish my map and feature services. I recently had to change the passwords for all of those database connections, and thus there is a need to update all of the layers in the MXDs with the updated data source information. In this situation, once the layers in the MXDs are updated, will the web services need to be republished or simply just restarted? I feel like the services would need to be republished for the changes to be reflected, but I've never done this before so I just wanted to make sure I was doing it correctly. For reference, I am currently using ArcGIS Server 10.5.1 and my database connections are Oracle.

Online Status	Offline
Date Last Visited	a week ago

My Ideas

Latest Contributions by Clint_Glover

All Web Services Shown as "Stopping" in ArcGIS Server 10.6.1

Re: Update SDE Connection Properties in ArcGIS Pro Project Via ArcPy

Re: Update SDE Connection Properties in ArcGIS Pro Project Via ArcPy

MXD Layers Assigned To Temp SDE Files When Using ArcPy & ArcCatalog

Re: Update SDE Connection Properties in ArcGIS Pro Project Via ArcPy

Re: Update SDE Connection Properties in ArcGIS Pro Project Via ArcPy

Reassign Portal Account Levels via ArcPy

Update SDE Connection Properties in ArcGIS Pro Project Via ArcPy

Re: ArcGIS Enterprise: Changing ArcGIS Server/Portal accounts

ArcGIS Enterprise: Changing ArcGIS Server/Portal accounts

Using 24 hour time in Smart Editor widget

Re: Republishing/Restarting services after database connection password change

Re: Republishing/Restarting services after database connection password change

Re: Republishing/Restarting services after database connection password change

Republishing/Restarting services after database connection password change

Republishing/Restarting services after database co...

ArcGIS Pro: Sort & Search Portal Group Items in Ca...

Overwriting Web Layers in ArcGIS Pro as Portal Adm...

Re: MXD Layers Assigned To Temp SDE Files When Usi...

MXD Layers Assigned To Temp SDE Files When Using A...