Latest Contributions by deactivated-user-ChrisBeaudett

Update to my previous post... We were able to get our portal operational again, but not ideal:  we were able to determine the flags passed to the postgres.exe command and started it in a command prompt window, and all started working again.  The command that we used is: postgres.exe -D "E:/arcgisportal/db" -p 7654 where -D is the database directory and -p is the port number to listen on.  (You can see all flags by running 'postgres.exe --help') Once we got pgsql running we tried bouncing the Portal for ArcGIS Windows service again, hoping that whatever condition existed to prevent pgsql from starting before was now resolved, but PostGreSQL still did not start. We're running ArcGIS Enterprise v10.7.1. I don't know if that additional info is meaningful enough to point the Esri folks to a possible resolution.  Any help with troubleshooting the pgsql component would be helpful to the user community. ... View more

We're having the same issue:  After stopping/starting the Portal for ArcGIS Windows service, not all java executables were started, the postgres.exe process is not running on the machine, and the portal (including the portaladmin endpoint) became unresponsive.  The java.exe process was started (I'm guessing this is the Windows service), but no javaw.exe processes.  Eventually the indexer javaw.exe process started (after a few minutes).  The portal logs contained serveral instances of this error: The portal has been initialized and configured but is not accessible. The internal portal database does not appear to be running or accepting connections. Restart the portal machine or machines and if the problem persists, contact Esri technical support (U.S.) ... And the Windows Event Viewer had half a dozen PostgreSQL errors of two different variations... 1) The description for Event ID 0 from source PostgreSQL cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer. If the event originated on another computer, the display information had to be saved with the event. The following information was included with the event: pg_ctl: PID file "E:/arcgisportal/db/postmaster.pid" does not exist 2) The description for Event ID 0 from source PostgreSQL cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer. If the event originated on another computer, the display information had to be saved with the event. The following information was included with the event: Is server running? ... both of which we've been told to ignore in the previous post. The same conditions persisted after rebooting the machine. As the local PostgreSQL db is installed as an Esri component of the portal and is software-managed without the usual PostgreSQL client applications, perhaps Esri could provide additional feedback on how to troubleshoot this issue. ... View more

Matthew Dickinson‌ did you ever find a solution to this? We're seeing something similar when attempting to sync data from Collector to a hosted Feature layer in ArcGIS Enterprise v10.7.1.  We're getting the "A table in the database is locked" error, but intermittently and apparently every other attempt. ... View more

We saw this exact same behavior:  we're searching on a title of "MyServiceName" and it was returning the name of "MyServiceName_UAT" (we had both in AGOL), since the "_UAT"-named service was the first element in the returned array.  Found this very important bit of documentation: It's important to understand that the  search  mechanism uses many different inputs to find possible matches, ranks them and returns appropriate results. The  search  becomes ideal for human interaction, but  fuzzy  when looking for specific records programmatically. The search results are non-deterministic. Using  search  may not necessarily be the best approach for finding specific items, but more a group of items from which to further filter. Seems like the only way around this is to loop through the results and look for the exact item name/title, i.e. something like: sdItems = gis.content.search(query="title:{} AND owner: {}".format(my_name, user), item_type="Service Definition") if len(sdItems) > 0: for item in sdItems: if item.title == my_name: sditem = item break else: continue else:   # assume that the one item found is the one you want sditem = sdItems[0] Or something like that. (Code above untested) ... View more

I work with Greg and we've been troubleshooting this.  Still no resolution, but some additional data points: - we are using AGS v10.3 in our Test and Production environments and are seeing the issue in both - we upgraded our Test environment to v10.3.1 and applied the ArcGIS 10.3.1 for (Desktop, Engine, Server) Feature Service Sync Performance Patch, but are still seeing the sync errors. - we upgraded our Test environment to v10.5.1 and are still seeing the sync errors - the latest Collector for Android seems to work find against both AGS 10.3 and AGS 10.5.1 - we can't upgrade to AGS v10.7.1 due to changes there where services will fail to publish due to feature class registration issues with some of our data warehouse feature classes (being resolved on the data side but not soon) We are working with Esri tech support and will continue to use Collector Classic as a workaround until this is resolved. ... View more

Also we submitted a ticket with Esri support for this issue. ... View more

If I'm understanding the issue correctly, we are seeing the same thing:  when we have a point feature class in a web map where we do -not- change the symbology from the default symbology published with the feature service, i.e. we are not setting the symbology in the web map layer, then the point features do not show up in Collector v19.0.1.  We are using Collector on iOS devices, v11.x and 12.x. If you set the symbology in the web map then it works around the issue, but this seems like a bug with Collector. ... View more

Indeed, we found the same: if you have Portal Settings > Security > Edit Identity Provider > Your users will be able to join: Automatically set before the upgrade, then after the upgrade the Portal Settings > Member Roles > Default User Type and Default role for new members will be un-set/set to invalid values.  You have to set these values before new users will be able to log into the portal and get their accounts auto-created.  (Existing accounts work fine). ... View more

Thanks Joshua. I've let the dialog run to completion as well, but still no cloned environment after a restart. ... View more

I have Pro 2.2.3 and I'm seeing the same behavior when attempting to clone an existing environment:  the new env just disappears.  What's even more frustrating is that it's essentially impossible to get both the arcgis SDK for Python and ArcPy configured in a standalone conda environment w/ Python 3.6+ outside of Pro.  So if you want arcgis + arcpy + any custom modules, you can't do it. And, Spyder is also apparently no longer installed w/ Pro.  At least, I can't find it.  (I'd prefer to use PyCharm anyway, but I'll take any IDE that will let me code + debug in a custom Pro env). If anyone has done this (custom env with arcgis + arcpy) as of Pro 2.2.3 with Python 3.6+, please let me know your secret sauce. ... View more

From what I've found the last published date/time is not available from any of the APIs (service REST endpoint nor the admin API nor the Updated date in AGOL, for a layer item that references an on-prem AGS service). From what I can tell the only way to resolve the last-published date/time for an AGS service is to  browse the AGS server directory and get the timestamp on the \\AGS_SERVER_NAME\DRIVE$\arcgisserver\directories\arcgissystem\arcgisinput\FOLDER_NAME\SERVICE_NAME.MapServer folder, and/or on the MXD in the underlying folder at ...\extracted\v101\MXD_NAME.mxd. Not ideal. Would be great if it was logged somewhere. ... View more

That's the info I was looking for.  Thanks Robert. ... View more