Latest Contributions by George_Thompson

Hi Maria, You cannot register a table with a PostgreSQL database without the geodatabase repository tables. Have you run the Create Enterprise Geodatabase or Enable Enterprise Geodatabase GP tools on this specific PostgreSQL database yet? If not, following this documentation: Set up a geodatabase in PostgreSQL on Windows—Help | ArcGIS for Desktop Hope this gets you in the correct direction... -George Geodatabase​ ... View more

Tobias, Who owns the domain? Only the owner of the domain (or i think the Geodatabase Administrator) can make changes to existing domains. Browsing the attribute domains of a geodatabase from a feature class or table—Help | ArcGIS for Desktop -George ... View more

Hi Tobias, I would say that there is not a "safe" way to modify the domains in the geodatabase outside of the ArcGIS client (this would include the ways that Asrujit SenGupta​ mentioned) Editing the geodatabase outside the ArcGIS client is also unsupported. Here is some more documentation on the domains: Domains in a geodatabase stored in Oracle—Help | ArcGIS for Desktop​ System tables of a geodatabase stored in Oracle—Help | ArcGIS for Desktop SQL access to enterprise geodatabase data—Help | ArcGIS for Desktop Hope this helps. -George Managing Data​ ... View more

Hi Hani, That is just a warning saying that you do not have the ST_Geometry libraries configured for this specific geodatabase. You need to configure the EXTPROC on the Oracle server: Configure the Oracle extproc to access the geodatabase with SQL—Help | ArcGIS for Desktop 39119 - Check if the Oracle extproc is set up correctly for direct ST_GEOMETRY SQL queries 38043 - Configure ST_GEOMETRY for use in Oracle 11G Release 2 on Windows This should get that corrected. -George ... View more

Are you receiving any errors when trying to delete them? Are there any feature classes that are using those domains currently? Who was the original owner of those domains? Are they still a user in the geodatabase? Can you try with the geodatabase administrator to delete them? Here some documentation on removing domains: Delete Domain—Help | ArcGIS for Desktop Hope this helps...... -George Managing Data​ Enterprise GIS​ ... View more

That is an error when connecting to the Oracle database. Are you using TNSNAMES for connecting or EZConnect? Try something like this: ServerName/SID (Server name that Oracle is installed on/Oracle SID Name) That should get you past that error. -George ... View more

Hi John, I have not seen anyone use OS Authentication for PostgreSQL yet........ As for the Create Database User GP tool, it only supports creation of an OS user on SQL Server and Oracle. Use this only if an operating system login exists for which you want to create a database user. Only enabled for SQL Server and Oracle databases. DATABASE_USER —Create a database-authenticated user. This is the default. If your database management system is not configured to allow database authentication, do not use this option. OPERATING_SYSTEM_USER —Create an operating system-authenticated user. The corresponding login must already exist. If your database management system is not configured to allow operating system authentication, do not use this option. Create Database User—Help | ArcGIS for Desktop I was able to find some documentation from the PostgreSQL site on Client Authentication. PostgreSQL: Documentation: 9.3: Client Authentication I also looked at the KB article you mentioned and it says: Trust authentication should not be used in a production environment. Where you attempting this for a production machine or in a development environment? Here some more documentation from the ArcGIS 10.2.x Help: It is not recommended to use OS authentication with geodatabases in PostgreSQL, because you would have to change to an unsecured authentication type in the database. ArcGIS Help (10.2, 10.2.1, and 10.2.2) I would try to get it working outside of the Esri Client (ArcMap/ArcCatalog) and attempt to connect via PGAdmin client using O/S authentication first. Everything that I have seen is related to how you have the pg_hba.config set up and there may be a mix-match of authentications for the IP that you are specifying. i.e. using 1.1.1.1 md5 and 1.1.1.1 trust at the same time. It is usually not within the scope of Esri support to help with some specific RDBMS configurations (i.e. OS Authentication on Oracle, performance tuning, system recommendations, etc...). There are also other items that are outside of Esri scope, especially related to other products that we have a dependency on, like Linux OS issues that impact PostgreSQL/Oracle RDBMS installed on them and then directly impact our product. We have no control over when or if those items get corrected by the appropriate people. Hope this helps clear up some possible confusion..... -George Managing Data​ ... View more

Hi Sarah, The ArcSDE Commandline tools are only designed to work with Enterprise geodatabases, created with an ArcGIS For Server Enterprise license (an level), and NOT with ArcGIS Server for Workgroup. The Workgroup level geodatabases are based on SQL Server Express and not a "full" SQL Server version. Hope this help.... -George Geodatabase​ ... View more

Hi Dean, It looks like you do not have the correct Desktop extension enabled for that layer. I have seen a similar error when copying over Network Datasets and not having the Network Analyst extension enabled in ArcMap/ArcCatalog. I am going to take a guess and think you may need to check-out a Schematics license in Desktop. ArcGIS Help (10.2, 10.2.1, and 10.2.2) Let me know how this goes? -George ... View more

No worries, I am glad that we were able to help clear up any confusion. -George ... View more

Hi Nicola, You can use SQL Server Express for Workgroup geodatabases, this is what Workgroup geodatabases (multiuser) are designed for an supported on. These are the same as Enterprise Geodatabases on SQL Server, Oracle, etc.... The differences are related to the limitations on the number of connections allowed (an Esri limit of 10 for Workgroup licensing and 3 for Desktop licensing) and then the limits that Microsoft puts on the SQL Server Express installation: Microsoft limits the use of SQL Server Express to one CPU (or core within a socket) and 1GB of RAM. The maximum database size for SQL Server 2005 or 2008 Express is limited to 4GB. The maximum database size for SQL Server 2008 Express R2 is 10GB. (Consult your Esri license agreement for specific information on the instance size limitations for your implementation.) Types of geodatabases—ArcGIS Help | ArcGIS for Desktop Using Workgroup authorization/licensing on SQL Server Standard/Enterpise is not supported for creation of Enterprise Geodatabases. Here are some other similar post on GeoNet with more information: Can you install ArcGIS for Server Advanced Enterprise on SQL Server Express How to configure existing SQL Server Express database for use with ArcGIS for Server Enterprise ArcSDE for SQL server express Hope this help with the confusion..... -George ... View more

Hani, What is the full name of the ".exe" that you are installing? If it did not ask for a licence file, as it would in a ArcGIS for Server Workgroup, then you must be using the Database Server for Desktop. Here is the documentation for this specific install: Beginning at ArcGIS 9.2, ArcGIS for Desktop Standard and Advanced includes an installation of Microsoft SQL Server Express. These software products also include ArcSDE capabilities to support enterprise geodatabases in SQL Server Express for up to three simultaneous desktop users. Types of geodatabases—ArcGIS Help | ArcGIS for Desktop Hope this clears up some of the confusion.......... If you want "True" workgroup level licencing you need to re-install with the correct Database Server install media. -George Enterprise GIS​ ... View more

Adding the Geodatabase​ group. ... View more