Latest Contributions by SteveMaskol

‎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.

‎11-10-2015

As of now the only work around I see would be to go all the way back to the MXD being used to publish the service in the web map. I would have to hide the fields in the layers and then republish the services. If I don't get any feedback from this post I will eventually submit a request with Tech Support and post the response.

‎11-10-2015

I am creating a web app through the Web AppBuilder. In the web app that I am using in AppBuilder I configured the layers to display only selected fields in the popups. However, AppBuilder is not honoring the field configuration that I saved in the web app. It displays all fields for all layers. It is as if the AppBuilder ignores the web map's saved configurations for popups. Is there a setting that I can enable/disable so only the fields that I have selected to be visible in popups configured in the web map will be displayed in AppBuilder?

‎02-25-2013

Hi, I just came across your post and I wanted to see if you found a resolution. I am having a similar problem. I have the code to check out a license in my web service. It errors when it tries to check out either an advanced or basic license. I have tried both a WCF web service and asp.net service and both have the same result. This was not a problem at 9.3. It started at 10.1. I have an incident opened with ESRI but to make a long story short I am not getting anywhere so we are trying to get the incident escalated. Please let me know if you have found a resolution. Thanks for your help.

‎10-14-2010

Is 2.0 compatible with Visual Studio 2008? We have not yet moved to Visual Studio 2010. The sample I am referring to comes from the ArcGIS API for Microsoft Silverlight - Interactive Samples page. http://resources.esri.com/help/9.3/arcgisserver/apis/silverlight/samples/start.htm The sample is called Toolbar and can be found under Toolkit on the left side of the page.

Online Status	Offline
Date Last Visited	yesterday

My Ideas

Latest Contributions by SteveMaskol

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 Fields

Web AppBuilder 1.2 Incorrectly Displays All Fields

Re: How to add arcgis license checking in a web service?

Re: Toolbar icons are not visible

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