Latest Contributions by George_Thompson

‎02-18-2016

Thomas, I just checked and the case that you logged back in Sept of 2015 had an enhancement logged. It has been closed as a Known Limit: ST_Raster uses external Win32 APIs for the Esri projection engine and spatial reference system. SAFE permissions cannot access external resources. Hope this help clear up some of the confusion. -George

‎02-18-2016

Hi Michael, Here is a great blog that talks about editing query layers in ArcGIS for Server: The Evolution of Query Layers | Support Services Blog Geodatabase

‎02-18-2016

Hi Jayanta, I would start here: Oracle data types supported in ArcGIS—Help | ArcGIS for Desktop ST_Geometry in Oracle—Help | ArcGIS for Desktop SDO_GEOMETRY and ArcGIS—Help | ArcGIS for Desktop Deciding which one is best for you would be based on your workflows. Also how comfortable you are at using SQL: SQL and enterprise geodatabases—Help | ArcGIS for Desktop *Updated: I would also add this, what other products are going to be consuming the data? If all ArcGIS products they can read the ST_Geometry, if they are 3rd party products then they may only read SDO_Geometry. Just something to keep in mind. Hope this help! -George Managing Data Enterprise GIS

‎02-17-2016

Electric and Gas User Group

‎02-17-2016

The ArcGIS 10.2.1 for (Desktop, Engine, Server) Utilities and Telecom Update 5 Patch is now available for download! ArcGIS 10.2.1 for (Desktop, Engine, Server) Utilities and Telecom Update 5 Patch | Samples and Utilities Issues Addressed (including all previous Utility and Telecom Updates): BUG-000091718 - Improve selectivity and performance of DB_table_list_tables queries. BUG-000091460 - Add code to Sql Server to support insert + delete + sync case. BUG-000091247 - 'Underlying DBMS error ORA-01008: Not all variables bound' error observed while using Select By Attribute on a Non-Versioned Archiving enabled feature class. BUG-000091883 - Syncing in some cases where inserts are applied as updates causes incorrect / duplicate globalids to be set. BUG-000091688 - Need to add brackets to the whereclause in sqlFilter for reduction rules to have the correct filter and avoid processing filters when no features of the feature class are selected. BUG-000091464 - Syncing a 1 way replica fails when the child has a GN and inconsistent connectivity. BUG-000090884 - Errors related to the GDB_TEMP_USER_IDS table, created as an optimization to the Geometric Network Rebuild/Repair operations need to be suppressed. BUG-000089740 - The error, "Network I/O error [SDE.DEFAULT]", is returned when opening a MXD file after applying the Utility Update Patch 2 (UTUP2) with default connection set up via an add-in extension. BUG-000089580 - Slow performance for the Synchronize Changes gp tool (via Python as well) comparing to the Synchronize Changes Wizard from GUI. BUG-000089100 - Synchronizing one particular replica fails with the following error, "synchronize replica failed". BUG-000088300 - Enabling schema cache on a SQL server SDE workspace crashes ArcMap. BUG-000087750 - Squares appear in the annotation in an exported PDF if Unicode symbols are used with Arial font. BUG-000087594 - Service start up time increases the more feature classes exist in an Oracle database and the service is serving data from the Oracle database in ArcGIS 10.3 for Server. BUG-000087277 - An annotation feature class fails to update correctly if the feature class is joined to a table or another feature class. BUG-000084769 - The initial and full extent information of the feature service endpoint differs from the map service endpoint in a multi-machine site. BUG-000083703 - When exporting data changes for a replica from a disconnected editing session, all the changes from the related tables are not exported to the delta geodatabase. NIM103075 - Inefficient spatial query encountered when using the Annotate Selected. Features command on versioned SDO_GEOMETRY, ST_Geometry and Sql Server Geometry feature classes. NIM101171 - ArcCatalog crashes, when the Identity tool is used on a Web Map Service (WMS) in ArcCatalog preview. NIM100525 - Identifying a specific Web Map Service (WMS) causes ArcMap to crash. NIM097058 - The 'Simplification Tolerance' option disappears from the Simplify Line and Simplify Polygon geoprocessing tools after installing Internet Explorer (IE) 11. NIM084109 - Deleting a feature class from a large SDE/Oracle database (contains more than 3000 feature classes) causes one SQL query being executed and fetched thousands of times which leads to a slow performance issue. Geodatabase Enterprise GIS Managing Data Esri Technical Support

‎02-16-2016

Hi Curt, Is the data versioned? What RDBMS are you using? What is the version of your geodatabase? -George

‎02-16-2016

Hi Thomas, I would recommend filling out this form: Report a Security Concern | ArcGIS Also feel free to visit Trust | ArcGIS with any security related concerns. Did you ever open a support case? -George

‎02-09-2016

Here is blog that covers that information: Simplify Your Life: Working with Schema Changes in Replicas | Support Services Blog

‎02-09-2016

Here is a blog that gives detailed information GDB replication and schema changes: Simplify Your Life: Working with Schema Changes in Replicas | Support Services Blog Geodatabase

‎02-08-2016

Martin, I am not sure about using the sdelayer to "toggle" between load_only and normal_io and any potential issues. That could cause an issue in itself. You also mention that you have a specific hotfix installed and may need to get a case with support created to investigate the issue in more detail. This would probably include a full backup of the database in question (SDE and other data schemas).

‎02-08-2016

Hi Martin, The patch that you reference is ONLY for Oracle geodatabases that were upgraded to/created at version 10.0, at some point. There was no known issue with 9.3.x or 10.1 or newer geodatabases that never went to version 10.0. As I understand it the patch should drop/recreate the spatial index on the GDB_Items table (update to the correct SRID) and prevent any other spatial inconsistency referenced in this KB: 42461 - Unable to insert or update Oracle st_geometry feature classes, encountering ORA-20085 errors I would say that as long as you have applied the patch to the clients and upgraded the Oracle geodatabase with the patched client that you will be good to move forward. Hope this helps with some of the confusion. -George Managing Data Enterprise GIS

Re: Overview of Users, Owners in SDE · ‎02-04-2016

Hi Leo, When you create a new feature class in Oracle it is listed by "OwnerName.Table Name" (i.e. George.FeatureClass) The GIS user is not the "admin" account for Oracle. By default the SDE user is the geodatabase administrator (who owns the geodatabase (SDE/GDB) repository tables). As for loading the data as the GIS user, that is up to you. I would say that it make administration of the data easier to have a separate data owner. Here is some documentation on Oracle and owning data: User Accounts in Oracle GDB Admin in Oracle What are user privileges User privileges for Oracle If you need more detail or help, I would recommend opening a Esri Support ticket and talking to the Geodata team. -George Geodatabase Enterprise GIS

‎02-01-2016

Using our favourite GDBT toolset with Desktop 10.1 or later release

‎02-01-2016

Adding the Geodatabase group....

‎01-28-2016

I am adding some more groups for more visibility.... Python Developers Geodatabase If this is a show stopper, I would recommend login a case with Technical Support also to possible get to a resolution more quickly. -George

Online Status	Offline
Date Last Visited	yesterday

My Ideas

Latest Contributions by George_Thompson

Re: ST_Raster is a security Risk? Why?

Re: SDE Query Layer and ArcGIS Server (AGS) Locks

Re: ST_Geometry vs SDO_Geometry?

Re: ArcGIS 10.2.1 for (Desktop, Engine, Server) Utilities and Telecom Update 5 Patch - Now Available!!!!!

ArcGIS 10.2.1 for (Desktop, Engine, Server) Utilities and Telecom Update 5 Patch - Now Available!!!!!

Re: Spatial View Not Updating

Re: ST_Raster is a security Risk? Why?

Re: Multiple GDBs vs Single GDB

Re: Workflow for gdb replication

Re: Spatial Reference Consistency question (0 or 4326)?

Re: Spatial Reference Consistency question (0 or 4326)?

Re: Overview of Users, Owners in SDE

Re: Tool for visualizing the state tree

Re: SDE is causing Oracle to lock out the schema

Re: arcpy.mapping scripting environment NOT suppressing dialog box - possible bug

Re: Error Connecting to Enterprise Geodatabase (SQ...

Re: Question about AD Groups in SQL & permissions

Re: Copying from SHP to Existing GDB FC

Re: ArcGIS Pro Python Toolbox updates enterprise g...

Re: ArcGIS Sites Redirecting to Other Org's Pages

Esri Certified Individuals

Cloud Computing