Latest Contributions by HenryLindemann

Hi @RomanValoria1, if you maintenance is up to date up to 10.5.1 you will have the license available under my.esri.com. I know you can authorize a 10.4.1 with a 10.5.1 so it might be possible with the 10.3.1 as well. Hope it helps Henry ... View more

Hi @BanchanaPandey, I am going to take a stab at this and guess that you have more than 250 services on that system. So if my guess is right there are a few possible solutions, I have seen the arcgisserver.exe crash when the server has a lot of services 500 and the server has low clock speed around 2.4 GHz, in this case the solutions was the reduce all the pooling minimum instances to 0 -You can up the pooling for critical services- and that stabilized the system. The Second case that I had was a ArcGIS Server that had over 1000 services it generated the low memory error that you mentioned even though it had more than enough swap memory, the solution is shared instances , but this only works for services published out of pro so you will have to convert any ArcMap Services. to implement case 2  Go to ArcGIS Server Manager Site Settings and apply the settings as below  HenryLindemann_0-1617253750419.png   Then go to all ArcGIS Pro Services and apply these settings  HenryLindemann_1-1617253820292.png   Hope it helps  Henry       ... View more

Hi @HaroldKrivell, Here is a little script that I wrote to do that just run it on the server just point line 137 to your config store connection file, it will spit out a csv file. # Get config store path # C:\Program Files\ArcGIS\Server\framework\etc\config-store-connection.xml # for entry in file get # <entry key="connectionString">\\dns\Arcgis\arcgisserver\hostname\config</entry> # get registered data connections # \\dns\Arcgis\arcgisserver\hostname\config\data # get federation if exists # \\dns\Arcgis\arcgisserver\hostname\config\security # get list of services # for folder in services does it have a json file if yes what type eg mapserver # if the manifest exists get datasource details # compile service details import json import wmi # Dependency for pyinstaller import win32 import win32.com import win32.com.client import zmq import pywintypes import pythoncom import pkgutil computer = wmi.WMI() # modules used in Win32 computer_info = computer.Win32_ComputerSystem()[0] def get_service_types(path): print_list = [] path = path.split('/') path = '\\'.join(path) import os service_types = set() # {'GPServer', 'WorkspaceServer', 'GeoDataServer', 'IndexGenerator', 'IndexingLauncher', 'SearchServer', # 'MapServer', 'ImageServer', 'FeatureServer', 'GeometryServer', 'SceneServer'} for root, dirs, files in os.walk(path + '\\services', topdown=False): for name in dirs: if name.__contains__('.'): service_type = name.split('.')[-1] service_types.add(service_type) service_path = os.path.join(root, name) if service_path.__contains__('\\System\\'): continue if service_path.__contains__('\\Utilities\\'): continue manifest = f'{service_path}\esriinfo\manifest' manifest_path = f"{manifest}\manifest.json" service = service_path.split('\\') name = str(service[-1]).split('.') if os.path.isfile(manifest_path): try: if service[-2] == 'services': print_list.append(f"root;{name[0]};{name[1]};True") else: print_list.append(f"{service[-2]};{name[0]};{name[1]};True") with open(manifest_path, 'r') as manifest_file: manifest = json.load(manifest_file) manifest = manifest['databases'] for dataset in range(0, len(manifest)): #Dataset if dataset > 0: print_list.append(f"\n;;;;;{dataset + 1}") else: print_list.append(f";{dataset + 1}") for record in manifest[dataset]: data_string_list = [] if record in ['onServerWorkspaceFactoryProgID', 'onServerName', 'onPremisePath', 'datasets']: continue if record in ['onServerConnectionString', 'onPremiseConnectionString']: data_string = manifest[0][record] if data_string.__contains__(';'): data = data_string.split(';') else: data = None if data is not None: for record_1 in data: data_string_list.append(record_1.split('=')) else: data_string = manifest[0][record] if data_string_list.__contains__('DATABASE'): continue if len(data_string_list) > 1: data_string = '' for value in data_string_list: if len(value) != 2: continue if value[0] in ['ENCRYPTED_PASSWORD', 'INSTANCE', 'VERSION']: continue data_string += f"{value[0]}={value[1]};" if record == 'onPremiseConnectionString': print_list.append(f"\n;;;;;;;;{record};{data_string}") else: print_list.append(f"{record};{data_string}") print_list.append('Line_Break') except Exception as e: print(e) print_list.append(e) else: if service[-2] == 'services': # Folder Name Type Manifest print_list.append(f"root;{name[0]};{name[1]};False") print_list.append('Line_Break') else: # Folder Name Type Manifest print_list.append(f"{service[-2]};{name[0]};{name[1]};False") print_list.append('Line_Break') with open(f'arcgis_server_services_sql_{computer_info.DNSHostName}.csv', 'w') as ass_write_file: write_out = '' ass_write_file.write('Folder;Service;Type;Manifest;;Dataset_Count;Referenced\n') for record in print_list: if record == 'Line_Break': write_out += '\n' write_out = write_out.replace(',', '_') ass_write_file.write(write_out) write_out = '' else: write_out += f"{record};" if __name__ == "__main__": import os import re default_path = r'C:\Program Files\ArcGIS\Server\framework\etc\config-store-connection.xml' if os.path.isfile(default_path): with open(default_path, 'r') as config_store_connection_file: file = config_store_connection_file.readlines() for line in file: if line.__contains__('key="connectionString"'): path = re.sub('<entry key="connectionString">', '', line) path = re.sub('</entry>\n', '', path) path = path.split('\\') path = '/'.join(path) print(path) get_service_types(path)   ... View more

Hi @Kathleen_Crombez, It might be a device problem yes, I think the best solution would just be to log a support call  with the device and android version and support will be able to tell you if the android version is supported. Regards Henry ... View more

Hi @ThorstenHohenstrater, I had a look but could not find any articles related to your error, I think the next step would be to log a support call at your distributer. Kind Regards Henry   ... View more

Hi @SpencerLarson, I think a 4 Core Sql Deployment will be a good starter system especially because you said you can go up to 100 WebMaps, I do work with  SQL a lot but mostly standard deployment , so what I can see regarding MS SQL Enterprise is that it seems to be more geared for Advanced work so for High Availability and Data Science work in SQL and since I don't see that you are using High Availability yet I am leaning to standard.  [SOLVED] Microsoft SQL Standard vs Enterprise Licencing Question - SQL Server Forum - Spiceworks   I am also thinking that if you already have a SQL deployment then you can just create a DB on that MS SQL if the recourses are adequate. Hope it helps  Henry  ... View more

Hi @Kathleen_Crombez, is your system public facing? if yes test it with SSL Certificate Checker (sslchecker.com) if the checker resolves correctly then you probably have to copy the certificate to the device and install it here is a link that might help. How to Install SSL Certificate on Android (comodosslstore.com) Regards Henry   ... View more

Hi @CliveSwan, You can also use the TOP clause  import arcpy fc = 'c:/data/base.mdb/well' fields = ['WELL_ID', 'WELL_TYPE'] # Use SQL TOP to sort field values for row in arcpy.da.SearchCursor(fc, fields, sql_clause=('TOP 3', None)): print('{0}, {1}'.format(row[0], row[1]))   Ref SearchCursor—Help | ArcGIS for Desktop ... View more

Hi @CliveSwan,  So each layer in a Hosted Feature Service will be a Table in the Datastore SQL with a few exceptions; The best solution is to just manage it out of portal because editing the data in datastore can corrupt items in portal. HenryLindemann_0-1614948545893.png     ... View more

Hi @SpencerLarson, So the ArcGIS datastore is a highly optimized SQL server, the services you publish to it is called Hosted Feature services, using it instead of a MS SQL server has a benefit in ram consumption and it is included in your purchase. Then you can also have a look at PostgresSQL which is a free SQL server.   Then on MS Sql, Express is free but it has a 10GIG Database limit 1410MB Ram limit and 4 cores and you will not be able to do a seamless upgrade should you decide to up the specs because of the way you access the express SQL is dns/sqlexpress versus just dns so if you change this you will have to re-publish the services. Here in South Africa I mostly see a 4 core SQL deployment so that seems to be the standard.   On Portal, A WebMap consists of services e.g Hosted Feature "Datastore", FeatureServer and MapServer "SQL" or "GDB", the WebMap itself is stored in ArcGIS portal but the services that is feeding it is coming from a data source, in order words you can have 100 WebMaps that have 1000 connections to a data source if they have 10 layers each. I would start with a Standard SQL as this will give you room to upgrade if needed with minimum hassle. and this is base on at least a Standard ArcGIS Enterprise purchase.   Hope it helps  Henry   ... View more

Hi @ThorstenHohenstrater, so what I think is there is some script that is querying your ArcGIS Online portal with more than the 10 000 queries/calls per minute and then you trigger the restriction since you are in essence flooding the API with calls. Your IT might be able to give you a report on traffic usage. Hope it helps Henry    ... View more

Hi @LR2, there is a attribute in the clone_items method called copy_data=False try setting it to True.   Regards Henry  ... View more

Hi @Anonymous User, so all you users are setup in AGOL, and you don't want to replicate that onto the on premises system because of licensing and administrative burden correct? So my question is if your Hosted Feature layer is already in AGOL is there a specific reason why you bring the service down to Enterprise since you don't get billed for hosting WebMaps and Apps in AGOL but you do get billed for the Hosted Feature service? Kind Regards Henry ... View more