Latest Contributions by HenryLindemann

Hi @HeatherScroggins, ok it is what it is :). so I created to Microsoft SQL 2016 instances and did the following tests test service is working    Here you see the old connection change data source in ArcGIS server shut down the old SQL, tested and the records pulled thru. Here is the new connection         The records are pulling thru     But here is the crux the metadata does not update and you have broken mxd in mapx files in your arcgisinput folder (which if your server crashes is often used to rebuild the services or say you left and the new person needs to work with the data) for example if you work for a large company with a 100 SQL databases and say your datastore connection gets deleted and this is two years down the line with a new GIS Practitioner how will this person fix the problem?     I hope this gives you better insights and welcome further discussion on this: Kind regards  Henry   ... View more

Hi@HeatherScroggins , so try and convince the IT to maintain the name please because it will be a major headache to fix. on desktop you are sorted and I think on server manager you are sorted just edit the connection and import the new connection   the problem is the services the "mxd and mapx (ArcGIS Pro)" that little database next to your service idicatd the data source so the change will break all you services. You can run the script below on the server it will write the required metadata into a csv you look for onServerConnectionString if it points to your db then you will need to reconfigure and republish this mxd or mapx service. the mxd ... will be located here for arcgis pro here e.g. where you installed ArcGIS Server "D OR C OR where you installed it :\arcgisserver\directories\arcgissystem\arcgisinput\province_lds.MapServer\extracted\p20\Updated_province_lds.mapx" ArcGIS Desktop "D:\arcgisserver\directories\arcgissystem\arcgisinput\province_lds.MapServer\extracted\v101\Updated_province_lds.mxd" you pull out these services fix the data source and override the service. let me know if you have a million services I have another script that can rewrite mxd data sources. Hope it Helps  Henry   ... View more

Hi @ArranGIS, the datastore is probably still reverencing the old url all you do is re-register it. Go to https://your_url.co.za/webadaptor_name/manager/site.html then datastore and click on the x for relational and tile cache if present.   Then go to the server that datastore is installed on and reregister the datastores This is the admin password for ArcGIS server   go to the describe tool when you are done and run it in a administrative command prompt the new URL's should reflect  "C:\Program Files\ArcGIS\DataStore\tools\describedatastore.bat" or where you installed the datastore app.   Kind Regards Henry       ... View more

Hi @ArranGIS, you should not unfederate your ArcGIS  Server because when you federate to the same ArcGIS server again all the items in ArcGIS Server will be re-added with new itemid's and this causes havoc to permissions links etc. what you should do if you changed the webadaptor name is to reconfigure your federation to use the new name and update all the url's in the system with something like ago-assistant. so if you don't have a backup of the server to repair the damage you will need to go to the answer below: if you have backups and you would like to repair the federation let me know and I will help.   Answer:  https://your_name.co.za/portal/sharing/rest  login  https://your_name.co.za/portal/sharing/rest/portals/0123456789ABCDEF/servers click on the server id and UnRegister Server   Hope It Helps  Henry     ... View more

Hi @MohammedElsayed, let me get some history is everything installed on one server or multiple servers ? on the server you can try https://localhost:7443/arcgis/portaladmin/federation/servers if this is the server that portal is installed on. or perhaps https://onesourcemei.fugro.com:7443/arcgis/portaladmin/federation/servers or https://onesourcemei.fugro.com/arcgis/portaladmin/federation/servers or https://onesourcemei.fugro.com/portal/portaladmin/federation/servers have a look at your programs and features the web adaptors will be listed there If you go to add remove programs is ArcGIS Data Store installed ?   ... View more

Hi @MohammedElsayed  can you log onto the server ? if yes go to the equivalent url https://yourdns.com/webadaptorname/portaladmin/federation/servers click on the name  and then validate and have a look at the error there   ArcGIS datastore needs to be registered with https://yourdns.com:2443/arcgis/datastore on your server.   you can also in a administrative command prompt check if datastore has a problem by running this command  "C:\Program Files\ArcGIS\DataStore\tools\describedatastore.bat" Hope it helps Henry ... View more

Hi @VMASK It is not available out of the box, but easy to achieve in a script using python https://developers.arcgis.com/python/api-reference/arcgis.gis.toc.html#user   ‘’’ import arcgis import datetime con = arcgis.gos.GIS("https://service.url", "admin_user", "admin_psw", verify_cert=True) users = ["username_a", "username_b", "username_c"] while True:     hr = datetime.datetime.now().hour     if hr > 6 and hr < 18:         for user in users:             pass             selected_user = arcgis.gis.User(con, user)             selected_user.disable()     else:         for user in users:             pass             selected_user = arcgis.gis.User(con, user)             selected_user.enable()     time.sleep(60) #seconds   ‘’’ ... View more

Hi @NickShannon2, I have added a script to delete data, I usually break it up into packs of 2000, queries are very dependent on network performance. Just unzip the scripts into a python project an install ArcGIS for python pip install arcgis the script you want to fill in is trunk_data.py then on line 42 fill in your server details  and point to the service  in agol you can get the service url details if you navigate to overview then url, you add /0 if there is only one service /1, /2 for the next etc.                ... View more

Hi there might be a corrupt folder in your hosted folder D:\arcgisserver\config-store\services\Hosted this sometimes happens when a user tries to publish and it crashes, look for empty folders or that large service and remove it. Just make a backup before you start. Regards Henry ... View more

HI Dean Are you using Windows Authentication Perhaps ? What is the error in the logs ? ... View more

Hi Dean, You can navigate to the collaboration workspace in the rest . https://server.co.za/portal/sharing/rest/portals/0123456789ABCDEF/collaborations/04ddb40f20734a878cc05c8dce425f"COLLABORATION ID"/workspaces/070ff68f5e334b838c5a082f8c525f"Workspace ID" At this location you will find sync status there is detailed logs as to which item failed, look for the itemID. Typical failures are schema changes and large datasets 10 000 records + for schema changes you will have drop the item in the destination. Regards Henry ... View more

Hi @IngridMans, Do you ever add the services with the url for example https://henrycerttrain.esri-southafrica.com/hosting/rest/services/folder/name/FeatureServer/0 ?  I have seen before that only the item with the itmeId controls the sharing. Can you verify that the itemId in ArcGIS Server matches the ItemId in portal it is located under admin https://henrycerttrain.esri-southafrica.com/hosting/admin/services/SampleWorldCities.MapServer Have you ever unfederated the Portal ? Regards Henry   ... View more

Hi @IngridMans, Your portal is probably in some intense logging mode like fine or verbose, you can set it to warning and reduce the retention period to 30 days. Also check if you have severe errors this is a indication of a problem and they tend to log every time the problem occurs. https://henrycerttrain.esri-southafrica.com/portal/portaladmin/logs/settings/edit [cid:[email protected]] On WebGISDR it cleans out the portal .wal files -NB never delete the .wal manually- not the regular log files Kind Regards Henry ... View more