Latest Contributions by ChristianWells

Dina - I'm glad this script is still helpful for someone a couple of years later. In my script I didn't originally consider seeing the Layout view, however, this should be a simple item to address. What we'll need to do is set the mxd.activeView to "PAGE_LAYOUT" so the MXD shifts to the layout tab instead. Can you try this code instead? import arcpy mxd = arcpy.mapping.MapDocument("CURRENT") mxd.activeView = 'PAGE_LAYOUT' for bkmk in arcpy.mapping.ListBookmarks(mxd): ext = bkmk.extent df = arcpy.mapping.ListDataFrames(mxd)[0] df.extent = ext arcpy.mapping.ExportToPDF(mxd, r"C:\Temp\{0}".format(bkmk.name)) ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Edit: Here is the documentation I am referencing for the MapDocument Properties in ArcPy Mapping module. MapDocument—Help | ArcGIS Desktop  ... View more

Great question, Jose. I don't have a specific tool to recommend, but I'd like to help narrow it down. What are you hoping to monitor? Is it to find who is locking the database? Or just to be notified when is becomes locked? ... View more

Here is my testing: Create db1 as an Enterprise Geodatabase (same instance) Create db2 as a standalone database (same instance) Create a spatial table in db2 with 100 records using Create Random Points Fields (OID, Shape) Create an empty feature class in db1 with the same schema Fields (OID, Shape) Run the following code: -- Get the number of rows in the looping table DECLARE @RowCount INT SET @RowCount = (SELECT COUNT(*) FROM [db1].[dbo].[ORIGINFC]) -- Declare an iterator DECLARE @iterator INT -- Initialize the iterator SELECT @iterator = MIN(OID) FROM db1.dbo.ORIGINFC -- Loop through the rows of a table WHILE @iterator is NOT NULL BEGIN DECLARE @id as integer -- Get OBJECTID value EXEC sde.next_rowid 'sde', 'destinationfc', @id OUTPUT; -- Insert the data while casting the points geometry INSERT INTO SDE.destinationfc (oid, shape) SELECT @id,Shape FROM db1.dbo.ORIGINFC where OID = @iterator; -- Update the iterator value SELECT @iterator= MIN(OID) FROM db1.dbo.ORIGINFC WHERE @iterator < OID END‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Query the destination table count which should equal 100 I ran this with a 10.7.1 EGDB and SQL Server 2014 (12.0.6108.1) but I don't see duplicate records in the destination feature class.  Could you repeat my steps with a generic feature class and share the results you receive? I know this is a really simplified example but maybe it will point us towards the cause.  ... View more

Thanks for sharing your findings. Let me take a look at 10.7 and get back to you. What version of SQL Server are you using? ... View more

Yes, you can see the updates from each field worker but querying the version name will depend on their sync status and method. We have some great documentation here: Offline maps and traditional versioned data—Documentation | ArcGIS Enterprise  ... View more

This looks to be a bug from one of the beta builds BUG-000121076: Explorer for ArcGIS (Android) beta incorrectly reque..  ... View more

Great to hear Alice, thank you for the follow-up. I had a few thoughts for this solution long-term I wanted to share with you. If you aren't editing versioned Feature Classes with SQL this won't play as crucial a role, but I recommend doing this clean-up effort at some point in your DBMS maintenance. Although the views you created solve the issue, they don't contain the same definition as the versioned view would have. This is low-risk if you are only editing with ArcMap or ArcGIS Pro, but it would ensure quality repositories in the geodatabase Steps Delete the multi-versioned views using the SDE Command Line tools (sdetable -o delete_mv_view) This will remove the metadata reference and the substitute views you created above Create the versioned views using the Enable SQL Access tool This will update the naming convention to have "_evw" but it will ensure the view has the correct definition ... View more

In the past, they would have been set up using the SDE command-line tools (deprecated at 10.2.x). Do you mind if I get you connected with Technical Support to help identify the cause and suggest a resolution? ... View more

Ok, it sounds like this might be an orphaned repository record. Does that table (port.mv_ELEC_VAULT) exist in the database? If not, do you mind if we get you connected with Technical Support? ... View more

The "mv_" prefix looks like this was a multi-versioned view created some time at or prior to a 10.x version of the geodatabase. As such this may be an orphaned metadata entry in the Geodatabase.  In ArcCatalog, can you have the dataowner schema Enable SQL Access on the feature class? It may be as simple as having the object created for the reference metadata. Here are instructions on creating the versioned view: What is a versioned view?—Help | ArcGIS Desktop  ... View more

I'm glad to hear this resolved the issue, Chris. Have a good day! ... View more

Can you check the "PARAMETERS" and "DOMIDX_OPSTATUS" of the index in Oracle? select * from all_indexes Where index_name like 'A784_IX1'‍;‍ If PARAMETERS is blank or DOMIDX_OPSTATUS is marked as "FAILED", we will need to update the index properties in the Geodatabase through ArcCatalog. ... View more