Latest Contributions by ChristianWells

One workaround we have seen to work is to re-generate the MXD's via Python. You could try the following script here: developer-support/refresh-mxd-layers.py at gh-pages · Esri/developer-support · GitHub  This will take a folder of MXDs, move them to a blank MXD and then save to a new folder.  It could be worth a test on a handful of MXDs ... View more

Hello All,  This issue sounds like the following defect: BUG-000098582 If possible, please contact Esri Technical Support to have your organization attached to this defect.  Best,  Christian ... View more

What state does the geodatabase get compressed to? If the state is other than 0, are there a lot of records in the Adds/Deletes tables following the compress? ... View more

Normally for user-schema GDBs the 'Instance' property should be used. The formatting would look like this:  sde.oracle11g:server/sid:schema ... View more

Can you provide a sample of the TNS file that caused the issue? I would be interested to see if this can be reproduced on any Oracle geodatabase. ... View more

What version of software are you running? Are you using background GP? Are you running this inside ArcMap or in IDLE or some other IDE? ... View more

In addition to George's help, this new question should be attached to a different thread so others using GeoNet for help can see this new topic. ... View more

Muqit Zoarder​ if this sample is helpful, please mark the post as answered. ... View more

If you know the path, you can use the value function to gather the values: SELECT GDB_ITEMS.NAME                                                   AS "FC_Name",   DEFINITION.value('(/DEFeatureClassInfo/Versioned)[1]', 'varchar(20)') AS "Versioned",   GDB_ITEMTYPES.NAME                                                    AS "GDB_Type" FROM SDE.GDB_ITEMS INNER JOIN SDE.GDB_ITEMTYPES ON SDE.GDB_ITEMS.TYPE         = SDE.GDB_ITEMTYPES.UUID WHERE SDE.GDB_ITEMTYPES.NAME IN ('Feature Class','Table') However, as George Thompson​ stated, please don't make any changes to the GDB repository XML tables. ... View more

I found the case you had previously. I will be reviewing it with some colleagues here and will reach back out to gather more information from you. ... View more

Hi Xiaoyue, have you raised this ArcMap hanging to Esri Technical Support? If not, I would recommend creating a case for investigation into the hanging issue. ... View more

Xiaoyue Chen​ currently this does not exist within the GUI or arcpy module. Instead of looking at the need to close states, can you please elaborate on how open states are being created? When edited via the ArcGIS client, states should be closed following the transaction. ... View more

Chloe Thomas​ when running the query without "_evw" you wouldn't be looking at the default tables. You would be looking at only a single table, referred to as the "base" table. This table contains only the rows that have been fully reconciled with the DEFAULT version and compressed. Because you are only looking at one table it is much faster than the versioned view, which queries over 5 different tables (Base, Adds, Deletes, States, State_Lineage). In addition, I would avoid using the versioned_view in any ArcGIS application, because it will only ever point to the DEFAULT version of the data. Instead, it is better to just use a copy of the feature class and specify the version that you want to use. This is because the queries that ArcGIS sends to a versioned feature class are much different than the versioned view, including the execution plan. Two options I would explore are: 1. Use the query in SSMS to create a stand-alone table with a spatial index; regenerating as needed 2. Perform the analysis of aggregation and spatial analysis in ArcGIS instead of SQL ... View more

Panagiotis Papadopoulos​ and Nicola Braccini​, each version of the Enterprise Geodatabase (SDE) is explicitly tied to its st_geometry.dll (Windows) or libst_shapelib.so (Linux/UNIX) file. To upgrade, both the geodatabase and file need to be upgraded. Although, it may "work" by changing the dll, this is not recommended or certified. There are a number of bugs similar to this in versions 10.1, 10.2.x, and 10.3.x which were fixed at 10.4.x. ... View more

Hi Alexander, From the Geodatabase Administration Locks window, you can right click on the lock and choose > View User. This takes you to the Connections window and highlights the user holding the lock. ... View more