Latest Contributions by George_Thompson

I would also mention the Geodatabase group as you are using Oracle. ... View more

Adding other groups..... Geodatabase​ Enterprise GIS​ ... View more

Hi Maria, I am assuming that your PostgreSQL instance in on a Windows machine? If so, is it the same machine as DT 10.3.1? Where did you copy the 9.3 st_geometry.dll file (C:\Program Files (x86)\ArcGIS\Desktop10.3\DatabaseSupport\PostgreSQL\9.3) to on the PostgreSQL install? Did you copy it to the "PostgreSQL home\lib" directory? Set up a geodatabase in PostgreSQL on Windows—Help | ArcGIS for Desktop Hope this helps...... -George Geodatabase​ Managing Data​ ... View more

Hi DEV APP, I think that we will need a little more context to the issue. -What version of Oracle? -What version is the geodatabase at? -Can you provide some sample SQL that you are using to create your view? -What type of feature class is the view being created on? It the table registered with the geodatabase? -What ArcGIS Client is being used to view the DB view? The error message looks like there may an issue reading the OID's in the table..... -George ... View more

Hi Chris, If I understand you post correctly you want to do the following: 1. Export data from an enterprise geodatabase into a file geodatabase. 2. You do NOT want the file geodatabase folder that holds the data to contain the ".gdb" extension, correct? 3. You only are willing to use ArcGIS 10.0 for this process. Some follow up questions: A. Why do not want to the exported geodatabase data to have the extention? B. What is your ultimate goal with the exported data? Please let me know if I misunderstood your post. I am adding a few other groups to gain a little more visibility. -George Geodatabase​ Managing Data​ Enterprise GIS​ ... View more

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