Latest Contributions by AndresCastillo

2 weeks later, the workforce project started causing issues again. The Esri analyst said: location__d9188f26f2343f78951e16ec_locationtracking_evw before crashing (could not receive data from client: An existing connection was forcibly closed by the remote host) FATAL: no pg_hba.conf entry for host "::1", user "<username>", database "<dbInstanceName>", SSL off the location tracking is inside this location service I checked and did not see Sync under capabilities in the service rest From the logs, this service may have archiving enabled on the database. This is what I would like to confirm in-house before making any suggestions on your end.  I see logs with errors requesting the location service as well as many unauthorized access to the database under the couch logs. Our reply: Modify pg_hba.conf on Relational Datastore?  Although we do not have the option to disable sync for location in the portal item page, in the admin endpoint for the location layer, we might be able to disable it by updating definition with the capabilities in json format, excluding the sync capability: Esri reply: Please find below instructions to update the service definition: While logged in as an administrator, go to this location:  https://<serverurl>/webadaptor/rest/services/mysevice/FeatureServer?f=pjson and get the “capabilities”. E.g.:  "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Sync", Remove Sync from the list Next go to this location https://<serverurl>/webadaptor/rest/admin/services/mysevice/FeatureServer/updateDefinition Run the updateDefinition with the capabilities from step 2 (minus sync)  e.g.  { "capabilities": "Query,Create,Update,Delete,Uploads,Editing"} ... View more

documentation regarding Rudy's comment: Error Connecting to database FATAL : no pg_hba.conf entry for host"x.x.x.x", user"jiradbuser", database"jiradb", SSL off…  ... View more

Thank you Janice. This portal for my client is on 10.5.1 ... View more

you can also test the extract data directly within the web map (not the app) as it uses the same portal tool. Here are the errors I encounter from setting SpatialAnalysisTools>Parameters>Properties>Message Level to info in ArcGIS Server Manager, and observing fiddler/Chrome Dev Tools Network Traffic: description=File "C:\Program Files\ArcGIS\Server\ArcToolBox\Services\scripts\extractdata.py", line 277, in <module> if not hostedgp.CheckPrivilege(PRIVILEGE_CREATE_ITEM): description=File "c:\program files\arcgis\server\arcpy\hostedgp\__init__.py", line 273, in CheckPrivilege raise GPCloudExec("CheckPrivilege",unicode(err).encode('utf-8')) description=GPCloudExec description={"messageCode": "AO_100026", "message": "ExtractData failed."} System/SpatialAnalysisTools.GPServer Portal request self failed with error Service Unavailable. (status code 503). ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ This is a federated and hosting ArcGIS Server. According to the error above, the gp service may have a permission issue that it cannot access to ArcGIS Feature Service data. The fix may be to grant the ArcGIS Server service account permissions to the data found in the Datastore and Hosting ArcGIS Server directories. https://enterprise.arcgis.com/en/server/latest/manage-data/windows/making-your-data-accessible-to-arcgis-server.htm ... View more

Thank you Margaret. Excellent notes on troubleshooting ArcMap slow performance. ... View more

related article: Problem: Using Update Georeference in ArcMap moves a raster image to a different location  ... View more

related article: Problem: Using Update Georeference in ArcMap moves a raster image to a different location  ... View more

The solution seems to be to disabling the sync option in the hosted feature layer settings: The analyst correlated the server and the postgresql logs with inserts into "location__d9188f26f2343f78951e16ec_locationtracking_evw" and the disconnection of the database. Having *_evw is an indicative that sync was enabled on some feature services. Comment from Esri Support Analyst------------------------------------------------------------------------------------------------------------------------------------------------------------ Enabling sync on a hosted feature layer may increase the feature storage size. So it is possible that there could be archived records in the table in the Data Store postgres database. Please refer to the "Allow offline editing or collaboration" section here: Manage hosted feature layers—Portal for ArcGIS | Documentation for ArcGIS Enterprise  Disabling sync on the hosted feature layer would empty the archiving information from the table in the Data Store. I suspect that this could attribute to the Data Store functioning properly today. End comment------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ I saw that AGO says Workforce Beta is available with offline support. Eventually, the same should come with ArcGIS Enterprise. Does our sync issue reveal that we need to increase the PostgreSQL datastore machine storage? I believe we had plenty of space in that machine. Is there a best practice to configure the datastore to handle sync enabled? Sync would be a requirement for future offline workflows. We are using soap ui/JMeter to load test the hosted feature services created by the workforce project using a query to the database: https://community.esri.com/groups/technical-support/blog/2012/06/14/preparing-for-the-flood-will-your-gis-server-sink-or-swim  First, get a temporary token for https://{portal.domain.com}/{webadaptor}/admin/ from the Federated and Hosting ArcGIS Server: https://{arcgisserver.domain.com}/{webadaptor}/sharing/rest/generateToken Workers: https://{portal.domain.com}/{webadaptor}/rest/services/Hosted/workers_{itemID}/FeatureServer/0/query?where=1=1&token={token}&f=json Assignments: https://{portal.domain.com}/{webadaptor}/rest/services/Hosted/assignments_{itemID}/FeatureServer/0/query?where=1=1&token={token}&f=json Location: (testing system to see if parsing long strings) https://{portal.domain.com}/{webadaptor}/rest/services/Hosted/location_{itemID}/FeatureServer/0/query?where=1%3D1&objectIds=&time=&geometry=&geometryType=esriGeometryEnvelope&inSR=&spatialRel=esriSpatialRelIntersects&distance=&units=esriSRUnit_Foot&relationParam=&outFields=&returnGeometry=true&maxAllowableOffset=&geometryPrecision=&outSR=&havingClause=&gdbVersion=&historicMoment=&returnDistinctValues=false&returnIdsOnly=false&returnCountOnly=false&returnExtentOnly=false&orderByFields=&groupByFieldsForStatistics=&outStatistics=&returnZ=false&returnM=false&multipatchOption=xyFootprint&resultOffset=&resultRecordCount=&returnTrueCurves=false&returnCentroid=false&sqlFormat=none&resultType=&datumTransformation=&token={token}&f=json ... View more

This is exactly the tool (also SoapUI) that we are using now to load test and debug some datastore crashes we are experiencing. See related article: https://community.esri.com/groups/technical-support/blog/2017/01/11/gauging-arcgis-gis-server-performance-with-integrated-windows-authentication  Also, another tool that we use in case of a request failure: https://community.esri.com/groups/technical-support/blog/2018/06/07/monitoring-web-service-requests-using-fiddler  Also, Chrome Dev Tools>Network>export Har ... View more

excellent article ... View more

excellent article ... View more

will do. We have an escalated ticket with Esri Support, so I will include that email. Thank you for your reply. ... View more

Karen, Did you find resolution to this? We experience the same Datastore hosted services on ArcGIS Enterprise goes down after a certain amount of requests are made on workforce hosted services. Kelly Gerrow‌ Craig Gillgrass‌ Jeff Shaner‌ Aaron Pulver‌ Kylie Donia‌ Rickey Fite‌ Xander Bakker‌ Joshua Clifford‌ ... View more

This is the thread Leon mentions: https://community.esri.com/thread/209433  ... View more