Latest Contributions by WoosterBe10

‎09-04-2025

Yes, that response last Friday did not make any sense. My apologies. It was late in the day and I was rushing through it. Today I did a selection location to get all of the sign points that are within one intersection polygon. I am only doing one now for testing purpose. I did a spatial join on the sign points and the streets with the target being the sign points. I did a one-to-many join. The output of the spatial join returns only one street. I need to be able to find the street and the cross street for each sign. Is there another geoprocessing task that needs to be run to include both streets?

‎09-04-2025

I am finally circling back to this after almost a week. Would creating a near table be able to return the two closest streets? I need to get the street and the cross street for each sign. After the near table is created, I'm guessing that the streets feature class could be joined with it to get the street names. For some reason I am having trouble wrapping my hear around this process.

‎08-29-2025

The problem is that in the output of the spatial join, there are multiple points for the same street sign. For example, a point is repeated four times. One time for each street segment in the intersection.

‎08-29-2025

I am using Pro 3.2.4. We have a feature class of signs (points) and a feature class of streets (lines). The streets feature class includes the name of each street. There is also a polygon feature class of intersections. For each intersection, I would like to get the names of the streets from the street feature class and add them to attribute fields in the signs feature class for all points that fall in the intersection. I can do a spatial join using the street lines and the intersection polygons but the resulting output includes multiple polygons and I am not sure what tool to use next. Maybe I am not using the spatial join correctly or not with the right feature classes. What is the best method to accomplish this task?

‎03-27-2020

The SSL certificate used in our Data Store expires soon. We renewed the certificate "in place". The expiration date for the certificate has been updated to a date next year. I can see it in the MMC after adding the certificate snap-in. Because it was renewed in place, the modified dates of the existing PFX and related files have not changed. Is that sufficient for the Data Store? The certificate won't expire until next year so I would think we are set but does the Data Store see it that way? I don't think using updatesslcertificate will make a difference because the PFX hasn't changed. A second question, is there a way to return the certificate information in the Data Store? You can see the certificate information for Server and Portal through the Admin Directory windows. The Data Store doesn't have an Admin Directory and describedatastore doesn't return the certificate information. Are there any alternatives for returning the SSL certificate details in the Data Store?

‎05-29-2019

Hi Daniel, I found a way to stop the errors. I don't know if it is the correct solution but it stopped the errors. I found this method off of a forum but I don't recall which one. I think it was a PostgreSQL related forum. On the server where our Portal site is installed there is a file called pg_hba.conf in the folder \arcgisportal\db\. I added an entry under the "IPv6 local connections:" section in the file. host all all ::1/128 md5 The "FATAL: no pg_hba.conf entry for host "::1" error stopped. I have been meaning to revisit this to make sure this was the best method but have been too involved with getting all of the SSL certificates set up for Server, Portal and Data Store before I federate. The certificates have been a royal pain. I hope this is helpful. Steve

‎04-25-2019

There are 17 PostgreSQL Server processes currently running on the Portal machine. Is it expected to be that many? In the logs in pg_logs, I am seeing this error several times. FATAL: no pg_hba.conf entry for host "::1" The error includes our ArcGIS Server administrator user name and a database. Although not classified as fatal, there are numerous instances of three log entries where a connection is received, a connection is authorized and finally disconnection. Is it normal behavior to see that many connections and disconnections?

‎04-25-2019

Hi Michael, I started my own post, "Warning Message in the Portal Logs", before finding yours. Have you found a resolution to this problem? I am encountering the same issue. I restarted the Portal service. The warning messages are not as frequent but they still show up in the log file. Prior to restarting the service, the messages were showing up in the logs dozens of times throughout the day. Now it is only a few times a day. We have the Portal site installed on one server and the Data Store installed to another server. In the Task Manager for the server where the Portal site is installed, I see PostgresSQL Server listed 15 times under the Processes tab. Do you know if this is normal behavior? No one is using our Portal site. I am in the process of federating but before I do I would like to get this warning message resolved.

‎04-24-2019

I recently installed ArcGIS Portal and Data Store, 10.6.1. They were installed on two different servers. In the Portal logs I am seeing the following warning message. "The database server was found to be stopped. Re-starting it." The warning code is 217060. The warning message was repeating numerous times throughout the day for several days. I restarted the Portal service and the Data Store service. Initially, that seemed to resolve the problem. The last warning was logged at 11:00 AM yesterday. This morning the warning message again appeared in the logs. Although, not with the same frequency as in days past. So far, I've seen the message three times. A PostgresSQL error message is also being generated in the Event Viewer at the same time. "pg_ctl:another server might be running; trying to start the server anyway" No errors are found in the Event Viewer on the server where the Data Store has been installed. The servers have not been rebooted or stopped. This is the first time I've installed Portal and the Data Store and I am not a PostgresSQL expert. Has anyone encountered this problem? Any recommendations on how to get it fixed? Thanks!

‎03-22-2017

I am using ArcGIS 10.4.1. Recently I created a table in SDE (Oracle). On several of the fields I applied field aliases. I set up a relationship class between the table and an SDE point feature class. In ArcMap, when I use the Identify tool on a feature and drill down to view the data from the related table, the field names are shown instead of the alias names. Is this a known limitation between field aliases, relationship classes and the Identify tool or have I missed something when I created the relationship class? Thanks.

‎11-08-2016

Thanks for your reply. This was very helpful. I will change my code so the Change Privileges tool is called three times, once for each role. Thanks for letting me know that this is a known issue with the GP tool.

‎11-03-2016

Through ArcObjects code in a C# executable I am creating a table in SDE and setting the user privileges. To set the user privileges I am using the geoprocessing tool ChangePrivileges. The executable runs overnight on our SDE server. It has been running successfully for years. I am in the process of upgrading the executable to 10.4.1. When I run the exe to test, it fails on the ChangePrivilges tool. I get the error "Bad login user". This is referring to the USER parameter of ChangePrivileges. I specify three names for the parameter. gpPrivileges.user = "CITY_VIEWER,CNTY_VIEWER,GISWEB"; This line is part of the exe that successfully runs on our SDE server each night. I have tried altering the parameter to include only one user and that works. Has something changed with how multiple users are defined for this parameter? Are you no longer able to define multiple users or roles for this parameter? Our SDE is 10.1. It is understandable that usage of the tool in ArcObjects could have changed but I have not been able to find any documentation in support or against this. Below, is the full code that is used to change privileges. Thanks to anyone who can provide help on setting privileges for a table with multiple users. Geoprocessor gp = new Geoprocessor(); try { X = 1; ChangePrivileges gpPrivileges = new ChangePrivileges(); gpPrivileges.in_dataset = mCitySdeDbConn + @"\" + mCogParcelAttOld; gpPrivileges.user = "CITY_VIEWER,CNTY_VIEWER,GISWEB"; gpPrivileges.View = "GRANT"; gp.Execute(gpPrivileges, null); if (gp.MessageCount > 0) { for (int x = 0; x <= gp.MessageCount - 1; x++) { WriteOutput(gp.GetMessage(x)); } } X = 0; gp.ResetEnvironments();

‎03-14-2016

Hi Katy, I work for a municipality. While I did not create the geometric network for our water system I have some experience with networks. There are eight feature classes that participate in our network. Crosses Hydrants Mains Nodes Water Tanks Tees Valves Junctions All are simple junctions except for the mains. The mains have the role of complex edge. We have a feature class of water meters. Currently the meters are not in the geometric network but will need to be added so we can take advantage of ESRI's Utility Isolation Trace App. I've been testing the Trace App with a file geodatabase of our water system where the meters are part of the geometric network. I'm not sure if it is a requirement for meters to be included in a network for all tracing tools. It is for the app. You may want to include meters in your geometric network if you plan on doing tracing. ESRI has a suite of tools that you can download for ArcGIS called the Water Utility Network Editing and Analysis solution. It includes two Add-Ins for ArcMap and a toolbox. I've only used one tool from one of the add-ins to create a feature class of water laterals but it looks like there are a lot of very useful tools with both add-ins that can be used with water water networks. They may be very helpful with your water network. I hope this has been helpful. Let me know if you have any questions. Steve Maskol

‎02-25-2016

Is there any good reason to install the ArcGIS for Desktop VBA Compatibility for 10.3.1? Any custom tools that were created in VBA were moved to .NET years ago. We also use a lot of Python scripts. I don't know of anything we are using that requires VBA. We installed the Desktop VBA Compatibility at 10.2 but I think that was more for "just in case" scenarios. I really don't think it is needed. Is it merely there to install for legacy applications or am I missing something?

‎11-13-2015

I realize it has been almost a year since you made this post but were you able to find a resolution to this issue? I am having the same issue with ArcGIS Server 10.2. I am trying to use the ArcGIS Utility Isolation Trace App. One of the things needed for the app are three empty SDE feature classes which are used to write out results. I get the invalid xml registry file error for the feature service that is using these feature classes. Did you contact ESRI or were you able to solve this on your own? Thanks.

Online Status	Offline
Date Last Visited	4 weeks ago

My Ideas

Latest Contributions by WoosterBe10

Re: Geoprocessing Tools to Add Street Names to Sign Points

Re: Geoprocessing Tools to Add Street Names to Sign Points

Re: Geoprocessing Tools to Add Street Names to Sign Points

Geoprocessing Tools to Add Street Names to Sign Points

Data Store certificate renewal

Re: Warning Message in the Portal Logs

Re: Warning Message in the Portal Logs

Re: Frequent "The database server was found to be stopped. Re-starting it."

Warning Message in the Portal Logs

Are field aliases supported with relationship classes?

Re: Change Privileges for multiple users or roles

Change Privileges for multiple users or roles

Re: Help in setting up geometric network

Is ArcGIS for Desktop VBA Compatibility necessary?

Re: Invalid xml registry file: C:\Program Files\ArcGIS\Server\bin\XmlSupport.dat

Re: Web AppBuilder 1.2 Incorrectly Displays All Fi...

Re: Help in setting up geometric network

Re: Invalid xml registry file: C:\Program Files\Ar...

Web AppBuilder 1.2 Incorrectly Displays All Fields