Latest Contributions by LouieRowley

I am disappointed in the migration for Enterprise solution but admit I may be missing something after many google searches and numerous experiments.  I can find no end to end solution and thus had to come up with my own workarounds to fix URLS for maps and apps.  Here my take away on the Migration of Enterprise, moving from Dev environment to Test/Prod Environment.  As with anything do not do any of this code development on anything that you can not afford to loose. Some Resources: https://enterprise.arcgis.com/en/portal/latest/administer/windows/migration-strategies.htm https://www.esri.com/arcgis-blog/products/arcgis-enterprise/administration/moving-content-across-tiered-arcgis-enterprise-environments/ https://developers.arcgis.com/python/api-reference/arcgis.gis.toc.html#item https://ago-assistant.esri.com/ Solution: Manually export the maps/apps from Dev and import to Test/Prod, this will retain the item ids and configuration, which is a must.  See the resource on moving content across tiered arcgis enterprise environments above.    Run code to fix Map URLs and item ID's. Run code to fix App URLS, bonus change color of text in title to indicate different environment. Issues: Why not use python to automate the export and import of maps/apps?  I was unable to get the api to connect; see https://community.esri.com/t5/arcgis-api-for-python-questions/arcgis-api-for-python-group-manager-create-403/m-p/1076152#M6330 Why do you just export maps/apps?  The export of feature layers is problematic.  It just fails with no error. The export/import is not supported for "Hosted Views", that is a large portion of our layers. so export/import of data ends up making little sense for us.  We can just host it from ArcGIS Pro to different environments, knowing the data will have different ids, this is unavoidable on the Hosted Views. Why do care about item ids for feature layers in maps?  If you do not match the item ids in the portal where you are migrating your maps to, when a user finds the "description" and clicks on it they will end up on the Rest Endpoint of ArcGIS, this is not something I really like.  Note, the ArcGIS Assistant does not fix the item id's when you use it to change the URLS, this is something I found out just recently and is problematic. See attached code for example of how I am making updates to urls in maps and apps. ... View more

I would like to use the migration abilities of the API however after the migration.create is called, I receive a 403 error.  I have not idea why the error, I can do other things, such as search and get the item id for the group.    <code> gisconn = GIS(user etc) gp = gisconn.groups.get('someid') result = gp.migration.create(items=self.get_map_ids(),future=False) #produces 403 </code> <error> File "c:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\lib\site-packages\arcgis\gis\__init__.py", line 1319, in create res = self._gis._con.post(url, params) File "c:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\lib\site-packages\arcgis\gis\_impl\_con\_connection.py", line 720, in post force_bytes=kwargs.pop('force_bytes', False)) File "c:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\lib\site-packages\arcgis\gis\_impl\_con\_connection.py", line 514, in _handle_response self._handle_json_error(data['error'], errorcode) File "c:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\lib\site-packages\arcgis\gis\_impl\_con\_connection.py", line 536, in _handle_json_error raise Exception(errormessage) Exception: You do not have permissions to access this resource or perform this operation. (Error Code: 403) </error> ... View more

We found some code and modified it to go through our SDE data and remove certain information such as server names from our metadata using the arcpy.XSLTransform_conversion and arcpy.MetadataImporter_conversion . The tools to do this process work from the application with each upgrade/new install however the scripting will fail because arcpy is looking for a couple of libraries in the GAC that are not registered.   Current environments do not have the gacutility and it can be difficult to find, so I found the instructions for using Powershell.  I pass this on to all those who have a similar issue, you would think that ESRI would fix such a thing but metadata is obviously a low priority, look at how ArcGIS Pro is coming along in this area, disappointing. -------  What you  need to know The dlls are at YOURDDRIVE:\Program Files (x86)\ArcGIS\Desktop10.6\bin  {10.6 would be whatever version} MetadataTranslator.dll, GpMetadataFunctions.dll Run Powershell in Admin mode and run commands, see below.   Comment:  Startup system reflection [System.Reflection.Assembly]::Load("System.EnterpriseServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a") $publish = New-Object System.EnterpriseServices.Internal.Publish Comment: use reflection to install dll into GAC.  I moved the dll to temp location but that is not neccessary, it just makes the path a little less of a problem with all the spaces in the name etc. $publish.GacInstall("c:\temp\MetadataTranslator.dll")  Comment: Note $publish.GacRemove should remove a library from GAC. Verify install: Comment: use reflection to confirm it has been added to GAC ([system.reflection.assembly]::loadfile("c:\temp\MetadataTranslator.dll")).FullName ... View more

Is there a way to elevate from license level to Advanced ArcGIS Pro scripting?  According to Desktop arcpy documentation, you should be able to import the module for the level you would like to run, for instance, import arcview or import arcinfo.  This does not work for ArcGIS Pro scripting, it does nothing to the license level.  I really can not sacrifice an ArcInfo License to automation for 2 or 3 little things that take seconds to complete. ... View more

I have installed ArcGIS 10.5.1 on four different Windows 2016 servers.  The 64Bit Python and 64 bit Background processing have also been installed on these machines.  After noting what appeared to be python slowness, I have narrowed down the issue to Python that is connecting to SDE (SQL Server).  A simple job that deletes 65k rows and then appends 65k rows from one SDE layer to another can take up-to 12min to complete.  The same job on my Windows 7 machine with the 64 bit libraries and ArcGIS 10.5.1 takes about 2.5 min, every time I run it.  The same job on a windows 2012 R2 server with the 64bit libraries and ArcGIS 10.5.1 takes about 2.5 min every time.  The Windows 2016 Servers run the code sometimes in 2.5 min but most of the time it takes greater than 8 min up-to 12 min. I have created a support request with ESR, I hope they come back with something soon.  Meanwhile, has anyone noticed an issue with Windows 2016, Python and insert/delete of SDE layers? Thank you. Louie Rowley ... View more