|
POST
|
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
10-29-2019
08:19 AM
|
2
|
0
|
2786
|
|
POST
|
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
10-01-2019
02:51 PM
|
0
|
0
|
689
|
|
POST
|
Thank you for reaching out, there are some differences with an Azure SQL database and a typical SQL Server database. One of those functional differences is the ability to drop users from the Geodatabase Administration window. Functionality differences for geodatabases in Azure SQL Database https://enterprise.arcgis.com/en/server/latest/cloud/azure/functionality-geodatabase-azure-sql-database.htm
... View more
09-27-2019
10:57 AM
|
1
|
0
|
1687
|
|
POST
|
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
09-26-2019
03:09 PM
|
0
|
0
|
1171
|
|
POST
|
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
09-26-2019
10:31 AM
|
0
|
2
|
1171
|
|
POST
|
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
09-24-2019
06:46 PM
|
0
|
1
|
1067
|
|
POST
|
This looks to be a bug from one of the beta builds BUG-000121076: Explorer for ArcGIS (Android) beta incorrectly reque..
... View more
09-24-2019
04:23 PM
|
0
|
1
|
958
|
|
POST
|
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
09-24-2019
04:18 PM
|
1
|
0
|
15674
|
|
POST
|
That sounds great...here is a quick reference on using the SDE Command Line tools with a version above 10.2.x: FAQ: Can ArcSDE command line tools be used against 10.3 and newer geodatabases? Here is the command line reference if needed: ArcSDE Administration Command Reference
... View more
09-24-2019
03:04 PM
|
1
|
2
|
15674
|
|
POST
|
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
09-24-2019
12:18 PM
|
0
|
4
|
15674
|
|
POST
|
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
09-24-2019
11:28 AM
|
0
|
1
|
15674
|
|
POST
|
I think you are heading down the right path regarding the necessity of a unique identifier. I've seen similar behavior when there are duplicate values in the field that was selected as the unique identifier. Here are the rules for a unique identifier field in views, both single and composite fields can be used: Unique identifier fields in database tables—Help | ArcGIS Desktop There are a few ways to address the unique identifier issue: Call the newID() function in the view and ensure the data type matches ArcGIS requirements This may require a CAST() function Create a new field in the table (not the view) that is unique using Add Incrementing ID Field—Help | ArcGIS Desktop These can be challenging to track down and Technical Support may be the best to assist. Please let me know if you would like me to have a support analyst reach out to you.
... View more
09-24-2019
10:57 AM
|
1
|
1
|
2322
|
|
POST
|
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
09-24-2019
10:46 AM
|
0
|
3
|
15674
|
|
POST
|
I'm glad to hear this resolved the issue, Chris. Have a good day!
... View more
09-24-2019
08:10 AM
|
0
|
0
|
2660
|
|
POST
|
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
09-23-2019
12:55 PM
|
0
|
2
|
2660
|
| Title | Kudos | Posted |
|---|---|---|
| 3 | 10-09-2025 08:31 AM | |
| 12 | 09-27-2022 06:23 AM | |
| 3 | 03-28-2024 05:12 AM | |
| 3 | 12-20-2023 06:42 AM | |
| 6 | 08-31-2023 05:42 PM |
| Online Status |
Offline
|
| Date Last Visited |
yesterday
|