Latest Contributions by HenryLindemann

‎01-27-2020

Hi Jay, Just install SQL Server Management Studio and connect to your Database Navigate to the Database There is a table called SDE_server_config and check what is the value under Auth_key If the data has expired then your DB license has expired

‎01-24-2020

Hi Jay, So It seems to be a database error, since you also get the error when you create a new FC it might be that the license in the DB has expired. This would be a possibility if you have a term license for ArcGIS server. The tool to update the license is under Data Management Tools > Geodatabase Administration > Update Enterprise Geodatabase License Now usually you get a warning about this so it is a long shot. I know we have had problems where the version tree was never reconciled, posted back and those trees got very large and eventually broke, but I am not very well versed with the inner working of the SDE yet. How large is your current state tree? I do know that you can have different rights applied to children so that might also be a avenue to explore. Hope it helps Regards Henry

‎01-15-2020

Hi Jay, Ok are you using the same version of ArcMap as your Server or are you using ArcGIS Pro. If ArcMap Geodatabase version when you go to the properties of your Database Connection what version is the Geodatabase if the version is below 10.4.1 i would recommend upgrading it Data Store Are you publishing to a ArcGis Data Store E.G managed database ? If yes you can check if the Data Store is up and working correctly. Navigate to the server where data store is installed C:\Program Files\ArcGIS\DataStore\tools open a administrative command prompt and run describedatastore.bat It should look like this make sure Data store mode is ReadWrite if not you either ran our of disk space or some other error can can place it back in read write by running changedatastoremode.bat Kind Regards

‎01-09-2020

Hi Jay, You mentioned that you are using a join and that the database is a SQL server. Q: is the join coming form the same database? I am thinking that the layers or the users have a rights problem on the data. what some times happen is that a person connects to the data-source in database_1 and the other using database_2 but not both are registered or the ArcGIS server. Also make sure that the instance and user specified in the Database connection is the one registered with the server some time the database is registered but with the wrong user or only using the server name and not the full name "FQDN" Right click your server connection in ArcMap go to server properties, select Data Store then the MSSQL server that is used then click properties -the finger under the x- then click edit the details must be the same as the Database connection is ODBC 13 for SQLServer installed on both the server and the station that publishes? I don't think this is your problem but a common problem. Deleting the connection Strings and recreating them might also solve the problem as they corrupt every now and then I hope something helps Regards Henry

‎01-08-2020

Hi Jay, You can first try to just publish a blank feature class E.G create a new FC and just place a point in it if that publishes then you probably have an error in your data. Where is your data hosted? If it is not hosted on the server then that can also cause a problem. Are you using a SQL database of a FGDB ? Regards Henry

‎01-08-2020

Hi Brian, When you install your web adaptor you should use the DNS name that you intent to use for your system because localhost will only be available on the server that the application is installed on. If you don't have content or customisation then Like Jonathan indicate the best option is to reinstall the environment. If you get a 404 on this url http://localhost/server/webadaptorit might indicate that you have a problem with IIS or you are trying to access the service from another server can you access your server on http://localhost:6080/arcgis/manager or http://my_server_name.local_fqnd:6080/arcgis/manager? You should also use Https instead of http for any production system.

‎10-18-2019

Hi everyone, I have a 10.6.1 datastore that has almost 7000 hosted FC in the store this is +- 30GB but I am getting a problem when I try to add a failover. Problem: After adding the failover the wizard copies over the datastore and unpacks it. It then fires up one thread to read through the content now because of the volume and a slow server it fails to read through all the content and start up the datastore before the timeout it then fails. Workaround I had to copy out most of the data to get the failover to configure but this is a very time-intensive script. Question Is there a setting to extend the timeout of the wizard when adding the datastore?

‎09-18-2019

You just add the query string inside the quotes. search_result = gis.content.search(query="owner:some_user NOT Feature Service") Search reference—ArcGIS REST API: Users, groups, and content | ArcGIS for Developers inside the () you can only use = it is just an assignment parameter_1=some_value

‎09-18-2019

So Before you even go into the Arcpy or ArcGIS Modules build up a base understanding of python ArcGIS Desktop is using Python 2.7 ArcGIS Pro is using Python 3.x I came across this excellent course in Udemy it is well worth your time for learning python. https://www.udemy.com/share/1000dOAkQddFhXRnQ=/ A Great Resource for ArcGIS module is the ArcGIS API for Python | ArcGIS for Developers site t because this module is becoming more and more relevant and is definitely the future of Python GIS in my opinion. for tools in ArcGIS pro have a look at this. https://pro.arcgis.com/en/pro-app/tool-reference and for ArcMAP https://desktop.arcgis.com/en/arcmap/latest/tools And Keep in mind python 2.7 is retiring Python 2.7 Countdown

‎09-17-2019

also have a look at InsertCursor—Help | ArcGIS for Desktop

‎09-17-2019

import arcpy import os # Set Parameters inFiles = arcpy.GetParameterAsText(0) inTable = arcpy.GetParameterAsText(1) inField = arcpy.GetParameterAsText(2) # inField must be in list format ['myField'] outTable = arcpy.SetParameterAsText(3) # Iterate through files in folder, insert rows based on file names, and make table view layer with arcpy.da.InsertCursor(inTable, inField) as cursor: # inField must be a list of fields # List Files # a list can be represented as [] flist = [inFiles] for f in flist: # Get filename(s) # if a file name use split then split on the spaces file_name = f.split('/')[-1] # get the last name in the file path arcpy.AddMessage("file to add {0}".format(file_name)) # Insert values and rows in table cursor.insertRow([file_name]) del cursor # Add Message arcpy.AddMessage("This row {0} was added.".format(f))

‎09-17-2019

Hi So in pure python you just want this import arcpy cursor = arcpy.da.InsertCursor('E:/temp/test.gdb/test', ['inField']) list_of_files = ['file', 'file1', 'file2'] for file in list_of_files: cursor.insertRow(['file Path']) del cursor Hope it helps

‎09-02-2019

Tags: ArcGIS Server, Pooling, Survery123, Hosted Feature Services, ArcGIS Desktop, ArcMap. I came across an interesting bug in ArcMap 10.6.1 today and thought I should share it with the community. My client lost all connections to their survey123 surveys after setting pooling on an ArcGIS Server. This was the errors that the client received Portal UI: ArcGIS Server UI: just a blank screen Poral logs: <Msg time="2019-08-30T16:36:24,29" type="SEVERE" code="207047" source="Portal Admin" process="3952" thread="16" methodName="" machine="[my server name]" user="" elapsed="">Failed to update federated server '[my server name] (id: SmZlAFBzaRbJ0KA1)'. Failed to validate the server managed database '/enterpriseDatabases/AGSDataStore_ds_4927moek'.</Msg> ArcGIS Server Logs: <Msg time="2019-09-02T11:05:36,297" type="WARNING" code="9003" source="Rest" process="1564" thread="16" methodName="" machine="[my server name]" user="" elapsed="">Unable to process request. Service Hosted/service_6990198ab90942e28dfc646fa6834839/MapServer not found </Msg> Trouble Shooting after replicating the workflow on another server I noticed that the server JSON looked funny Actual Erroneous JSON { "serviceName": "service_0d5061e6228d4e5a85301e3666919372", "type": "FeatureServer", "description": "", "capabilities": "Query,Editing,Create,Update,Delete,Extract,Sync,Uploads", "provider": "SDS", "clusterName": "default", "minInstancesPerNode": 1, "maxInstancesPerNode": 2, "instancesPerContainer": 1, "maxWaitTime": 60, "maxStartupTime": 300, "maxIdleTime": 1800, "maxUsageTime": 600, "loadBalancing": "ROUND_ROBIN", "isolationLevel": "HIGH", "configuredState": "STARTED", "recycleInterval": 24, "recycleStartTime": "00:00", "keepAliveInterval": -1, "private": false, "isDefault": false, "maxUploadFileSize": 0, "allowedUploadFileTypes": "", "properties": {}, "portalProperties": { "isHosted": true, "portalItems": [{ "itemID": "ba880b7b91074eb68038d690ab9a7c4b", "type": "FeatureServer" }] }, "extensions": [], "frameworkProperties": {}, "datasets": [] } Expected JSON { "serviceName": "service_0d5061e6228d4e5a85301e3666919372", "type": "FeatureServer", "description": "", "capabilities": "Query,Editing,Create,Update,Delete,Extract,Sync", "provider": "SDS", "clusterName": "default", "minInstancesPerNode": 1, "maxInstancesPerNode": 2, "instancesPerContainer": 1, "maxWaitTime": 60, "maxStartupTime": 300, "maxIdleTime": 1800, "maxUsageTime": 600, "loadBalancing": "ROUND_ROBIN", "isolationLevel": "HIGH", "configuredState": "STARTED", "recycleInterval": 24, "recycleStartTime": "00:00", "keepAliveInterval": -1, "private": false, "isDefault": false, "maxUploadFileSize": 0, "allowedUploadFileTypes": "", "properties": {}, "jsonProperties": { "adminServiceInfo": { "status": "STARTED", "name": "service_0d5061e6228d4e5a85301e3666919372", "type": "FeatureServer", "database": {"datasource": {"name": "/enterpriseDatabases/AGSDataStore_ds_smdosaso"}}, "serviceViews": [{ "name": "survey123_e8b9dff7626d43ebb8ee752f03e69ad2_stakeholder", "serviceItemId": "603093eba1ce491aa1bf84b9b4a2f64b", "type": "FeatureServer", "refCount": 1 }] }, "xssPreventionInfo": { "xssPreventionEnabled": true, "xssInputRule": "rejectInvalid", "xssPreventionRule": "InputOnly" }, "supportedQueryFormats": "JSON, geoJSON", "allowGeometryUpdates": true, "maxRecordCount": 1000, "syncEnabled": true, "copyrightText": "", "enableZDefaults": false, "serviceDescription": "Python_S123_Test2", "description": "", "currentVersion": 10.61, "capabilities": "Query,Editing,Create,Update,Delete,Extract,Sync", "hasVersionedData": false, "editorTrackingInfo": { "allowOthersToDelete": true, "enableOwnershipAccessControl": false, "enableEditorTracking": true, "allowOthersToUpdate": true, "allowOthersToQuery": true }, ... Resolution As it turns out that in ArcMap you can set the pooling for hosted features service and in the case of Surver123 services the JSON gets overwritten. You don't get a warning or error it just execute even though there is no such option in ArcGIS Server Manager. We restored a backup of the JSON and restarted the server and everything came back up. I hope this helps.

‎09-02-2019

Hi Mats, navigate to C:\Program Files\ArcGIS\DataStore\tools run the tool describedatastore.bat in an administrative command prompt The database name might have changed on reinstall, so make sure that your DB ds_512zquke is reflecting on the line Information for relational data store [my database name] if the DB name changed re-install your backup if you have one. if the DB name did not change then the perhaps the DB users changed on re-install run the tool: "C:\Program Files\ArcGIS\DataStore\tools\listadminusers.bat" then verify the result against: "[My Datastore path ]arcgisdatastore\pgdata\pg_hba.conf" in this file, the user information will display if the user is present. if the user did change contact your Esri support team to help you set up the old user on the new database. Section 2 Dis the datastore validate in ArcGIS Server Manager? if not you can unregister the connection and then re-register it in ArcGIS Server Manager being that this is a month later I hope this post helps future queries. Kind Regards Henry

‎08-13-2019

I had another broken index in 10.7.1, Szu Nyiap Tang steps resolved it. A easy way to see if the index is broken is if you Reindex does the status go to 0 if not the index is probably broken.

Online Status	Offline
Date Last Visited	a week ago

My Ideas

Latest Contributions by HenryLindemann

Re: Server publishing errors 001487 and 001369

Re: Server publishing errors 001487 and 001369

Re: Server publishing errors 001487 and 001369

Re: Server publishing errors 001487 and 001369

Re: Server publishing errors 001487 and 001369

Re: change server url in enterprise

Extending the ArcGIS DataStore Failover Time Out when Configuring?

Re: Is it possible to restrict item types in gis.content.search?

Re: What is the best way to study python?

Re: How do you loop through a list of files, getting the filenames, and then adding the names to a standalone table?

Re: How do you loop through a list of files, getting the filenames, and then adding the names to a standalone table?

Re: How do you loop through a list of files, getting the filenames, and then adding the names to a standalone table?

Survey123 Error: Failed to validate the server managed database

Re: Failed to validate the server managed database

Re: The index service seems to be unavaliable. Please check the index service.

Re: CA Certificate - Web Server Machine Certificat...

Re: gis.users.search - Exception: User does not ex...

Re: Change hosted server possible?

Re: Portal login issue after upgrade to 11.3

Re: Web Adaptor IIS Error