Latest Contributions by George_Thompson

You can call Esri Technical Support and log an issue that way. That may be the best course of action. ... View more

Did you install the correct SQL Server client, The Microsoft ODBC Driver 13? Can you check to see if there is a timeout on the network? Sometimes networks have a timeout after a certain time frame with out any communication on the port. Does this error happen after you leave the PC locked for a certain amount of time? Geodatabase‌ ... View more

What are the machine specs that ArcGIS Pro is being run on? How much free space is located on the hard drive(s)? I have seen in the past where creating these MMPK's can take a lot of machine resources to complete the process. ... View more

Are you running this Pro instance on a VM or Physical machine? Where is the data located that the MMPK is being created from? ... View more

Not sure that this helps but found this in the documentation: Before you create a geodatabase, SQL Server must be installed and the instance configured. How you configure the instance depends on the specific needs of your organization. However, note that the SQL Server instance must use a case-insensitive collation. Under "Install and Configure SQL Server": Create an enterprise geodatabase in SQL Server—Help | ArcGIS Desktop  ... View more

No worries. That works for me. ... View more

Hi Marco, I am unable to forward this to a specific analyst. You would need to create a technical support case. It sounds like there needs to be a specialist to look into this behavior. ... View more

Have you imported the certs into each of the server machines? Configuring HTTPS using an existing certificate—ArcGIS Server Administration (Windows) | ArcGIS Enterprise  ... View more

Hi Marco - I think that this would need to be reviewed by a Support analyst on the Geodata team to investigate in more detail. I unfortunately do not have a Postgres instance readily available to just sneak a peak at. If I remember correctly, ArcGIS clients treat tables in non-geodatabases as query layers. I am not sure when using query layers if the index is used or not. Maybe someone else can chime in on that one. ... View more

I do not think that FME on the same machine would cause the issue unless it was doing a resource intensive job at the time. I have seen in the past where having the SQL machine on a VM causes issues, mainly due to over allocated host machines. When the SQL machine really needs resources they may not be available on the host and that can cause issues. I think increasing the available memory up and then tuning of the SQL database server should help. Update: Here are some links to UC presentations on SQL Server that may be of use, start with the 2015 presentation UC 2015: Troubleshooting SQL Server Enterprise Geodatabase performance Issues - http://proceedings.esri.com/library/userconf/proc15/tech-workshops/tw_988-194.pdf  ans zip file: http://proceedings.esri.com/library/userconf/proc15/tech-workshops/tw_988-193.zip  UC 2017: Troubleshooting SQL Server Enterprise Geodatabase Performance Issues: http://proceedings.esri.com/library/userconf/proc17/tech-workshops/tw_460-208.pdf  Administering Your Microsoft SQL Server Geodatabase: http://proceedings.esri.com/library/userconf/proc17/tech-workshops/tw_210-184.pdf  ... View more

Have you reviewed this doc: Connections to highly available SQL Server databases—Help | ArcGIS Desktop  You could put the number of instances on the DR map services to "0" till they are needed. If the DBA's have the SQL Server configured the switch should happen normally without intervention. ... View more

As I understand it; if any instances of the map service are running, i.e. minimum instances = 1, then yes there is a "live" connection. If no one is consuming the instance then it is more or less idle but is available for use. Are there some issues with SQL Server side? ... View more

Here is another piece of help doc that supports the "_" not being a good thing: Database management systems have different definitions of acceptable characters for object names. Most names must begin with a letter and cannot contain spaces, backslashes, or reserved database management system keywords. Some databases allow special characters such as forward slashes (/), underscores (_), dollar signs ($), dashes (-), dots (.), or mixed cases. Sometimes the database allows you to use special characters or reserved keywords, or force mixed, upper-, or lowercase names if you provide the object name enclosed in delimiters, such as double quotation marks. However, ArcGIS does not delimit object names. Do not create any tables, feature classes, indexes, databases, users*, roles, or other object names that require delimiters if you will be using them with ArcGIS. The object will be created in the database, but you cannot access it from ArcGIS. Enterprise geodatabase size and name limits—ArcGIS Help | ArcGIS Desktop  ... View more

I think that may have to do with the DB name. The issue may be with the underscore "_" Here is the note from the help: Type the database name in lowercase; upper- and mixed-case object names are not supported for geodatabases in PostgreSQL. If you type a database name in upper or mixed case, ArcGIS converts it to lower case. This is step #5 under "Create a geodatabase" at the link above. Can you please try and create a default DB called "esritest"? and report the results? ... View more

Did you update the pg_hba.config file? This file allows the Postgres DB to accept connections from other machines. Create a geodatabase in PostgreSQL on Windows—Help | ArcGIS Desktop  You can install PGAdmin or other PG SQL client and try to connect to the DB as the PG Admin? ... View more