Latest Contributions by Waan

‎01-11-2023

It's 2023 and my organization is on Pro 3.0, but we still have no simple means of rapidly disconnecting from SDEs. I'm commenting here just to keep this topic active as this would be an extremely useful piece of ArcMap/ArcCatalog functionality to port over for those of us who administer SDEs now with ArcGIS Pro.

‎06-25-2019

I think there actually is an option 3, but it's ……. less than ideal. And it likely won't work for Zachary Hart (but possibly might work for Carrie Carsell). Is it possible to stand up a fully federated Enterprise site with Portal and all that junk, and then turn around and buy/install another ArcGIS Server in an unfederated environment for your 3rd-party users? If it is, that offers a potential workaround. ADMITTEDLY this is still a hefty extra spend, but it might actually make sense if it's less expensive than buying everyone and their brother a named-user license. Of course it kinda kills the whole point of federation, but certain Esri applications are basically forcing us to adopt federation (my organization is facing this if it upgrades GeoEvent Server to any version beyond 10.5.1).

‎06-21-2019

I ran into the same issue when generating Thiessen (Voronoi) polygons ... commenting here in case anyone is Googling a similar error message. Looks the gp creates geometry and then joins the full attributes back to the geometry as the final step. Doubtless other tools are adversely affected by the presence of a Global ID.

‎06-03-2019

Yup, this is the first thing I'm noticing as I just started using Pro today: I've got loads of folders with the same name(s). Clicking on the "More Detail" option allows me to hover over the folder and see the full UNC path, but that's more of a workaround than it is a solution. And since it's not a good use of my time to add aliases to each folder, can we modify this request a bit? Just have the folder name explicitly show the UNC path. I realize this is replicating ArcCatalog behavior, but that works really well when navigating various directories/folders.

‎10-03-2018

Seconding Marco's request--did you ever make progress on this issue?

‎07-02-2018

Hot off the press … Esri is saying "first half of 2019". This is from the 2018 UC Q&A.

‎04-25-2018

Here's a strange one ... would love to hear some feedback. I managed to fix the problem but I don't understand why this was a problem in the first place. I believe this has to do with how I was passing a directory string into the tool. We have a relatively simple arcpy script that exports jpegs to a folder. The script runs on a Windows 2008 R2 server where we have both ArcGIS Server 10.3.1 installed along with ArcGIS 10.3.1 desktop. Since the latter was the last installed, the default Python IDLE is 32-bit. When the script is run interactively in IDLE, it runs just fine with no errors. However, when run via Windows Task Scheduler, it throws the error "PageLayoutObject: Error in executing ExportToJPEG". I am 100% positive that it is running from the same user account when we run it either interactively in IDLE or via Task Scheduler, and that that user account has the correct privileges to the writeoff directory. The offending code is this: arcpy.mapping.ExportToJPEG(mxd, r"R:\GIS\Maps\Map_" + str(pageName) + ".jpg", resolution = 250) But when I make a relatively minor change, it works fine: writeoff_dir = "//somedirectory/GIS/Maps/" arcpy.mapping.ExportToJPEG(mxd, writeoff_dir + "Map_" + str(pageName) + ".jpg", resolution = 250) Again, I must emphasize that both code snippets work fine when run interactively in IDLE; it's only when the first snipped is run in Task Scheduler that it throws an error. I tried pointing Task Scheduler to a batch file that referenced either the 32-bit and 64-bit IDLE versions installed on the machine, but it didn't make a difference. So two questions for the community: 1. Why doesn't the input appear to like the 'r' prefix for the path? 2. Why would these both run fine interactively in IDLE but the first code snippet bomb via Task Scheduler? Thanks in advance. At a minimum, I hope my solution helps someone experiencing the same uninformative error.

‎05-04-2017

Hey Xander, did you ever sort this out? Thinking about an upgrade to 10.5....

‎12-07-2016

Ivan--ran across your interesting (aggravating) problem. Did you ever sort this out? Did you talk to Esri? I got to wondering about which geodatabase version you were using, which database you were using, and whether you were able to replicate this problem in a test environment. -W

‎10-17-2016

That’s what I originally thought—but then I saw this in the 10.3 documentation: “One-way, child-to-parent replication works in a similar manner, but in the opposite direction. Here the data in the child replica is editable, but the data in the parent is considered read-only.” So given our configuration, I don’t know why I’d choose one over the other.

‎10-17-2016

Hi GeoNet Pretty straightforward question here: when setting up one-way replication, what are the pros and cons of choosing Child-to-Parent versus Parent-to-Child in an all-SDE environment? The documentation doesn't provide much guidance. I can't discern if one has any advantages (or disadvantages) over the other as the differences don't seem to be relevant to SDE. (I gather that older ArcGIS versions required edits to from Parent-to-Child (is this correct?), though that no longer seems to be the case.) Our setup: Desktop 10.3.1 A single SQL Server "editing" SDE (10.1) A single SQL Server "publication" SDE (also 10.1) The SDEs will not be used for disconnected editing, hosting geometric networks (or similar), and there will only be a handful of editors. This is a very simple setup where we wish to replicate an editing SDE to a publication SDE. The publication SDE is used for publishing services, serving out layers, etc. We don't intend to replicate with file or personal geodatabases.

‎08-08-2016

Turns out it was the quotes in the selection syntax. This change occurred sometime between 10.1 and 10.3.1, though Esri says I was writing bad queries all along as double-quotes are a no-no … though it looks like double-quotes are only problematic when used on joined fields in various selection queries (including definition queries—this was also causing problems in some 10.1 .mxds once we upgraded 10.3.1). I’ve removed them from my arcpy habits altogether. This worked at 10.1 but doesn't work at 10.3.1: arcpy.SelectLayerByAttribute_management("wellboretable_layer", "NEW_SELECTION", "\"tbl_wellbores.OBJECTID\" = 1") This does: arcpy.SelectLayerByAttribute_management("wellboretable_layer", "NEW_SELECTION", "tbl_wellbores.OBJECTID = 1")

‎05-25-2016

Thanks Dan, I was actually wading through some of them when you replied. While there were some fixes to MakeTableView in 10.3 and 10.4, they seemed to deal with specific issues, e.g. when working on a .csv. I didn't see anything to indicate a broader fix. I re-opened a ticket with Esri about this issue. For the sake of completeness in this thread, here's my piece of code that bombs ... this is a table and a feature class in a file geodatabase: wellboretable = workspace + "tbl_wellbores" wellbores = workspace + "wellbores" arcpy.MakeTableView_management(wellboretable, "wellboretable_layer") arcpy.AddJoin_management("wellboretable_layer", "UniqueId", wellbores, "UniqueId", "KEEP_ALL") arcpy.SelectLayerByAttribute_management("wellboretable_layer", "NEW_SELECTION", "(\"tbl_wellbores.Deviation\" = '' OR \"tbl_wellbores.Deviation\" IS NULL) AND \"wellbores.Length_ft\" >= 3000") Lest anyone thinks the syntax in the select statement is bad, I used GetCount_management, Exists, ListFields, and CopyRows_management to verify that data existed, the join worked, and the fields were typed accurately. I also tried using single and double quotes instead but still received an error. Interestingly, I noticed GetCount_management would return 0 after a bomb, so I used a CLEAR_SELECTION throughout my testing. To make this even simpler, I tried the following after the join: arcpy.SelectLayerByAttribute_management("wellboretable_layer", "NEW_SELECTION", "\"tbl_wellbores.OBJECTID\" = 1") ... which still threw the same ERROR 000358. To be sure, I used a SearchCursor to verify that an OBJECTID of 1 exists in this table view. I emphasize that all of this code works fine in 10.1. I didn't spot anything in 10.3 (or 10.3.1) documentation that the SelectByAttribute syntax or SQL syntax had changed. I'll see what Esri has to say.

‎05-25-2016

Hi Kathleen, Have you found a workaround for this? Did Esri get back to you about a bug report? We are testing an upgrade from 10.1 to 10.3.1 and found a vital script is failing after a MakeTableView (error is actually thrown by a subsequent SelectLayerByAttribute). Thanks, -W

‎08-03-2015

I was just struggling with this topic and stumbled upon another gotcha ... thought I'd pitch in my $0.02. When publishing a map service, make sure you enable "Allow per request modification of layer order and symbology". This can be found in Service Editor -> Capabilities -> Mapping. ArcGIS Help 10.1

Online Status	Offline
Date Last Visited	Tuesday

My Ideas

Latest Contributions by Waan

Re: Provide a way to disconnect database connections from ArcGIS Pro

Re: A case against Federation? Hidden Cost?

Re: Dissolve tool error: "Invalid field type" only in GP Service

Re: Let us create an alias for connected folders in ArcGIS Pro

Re: Arc Pro connection to SQL - very slow

Re: Using python in ArcGIS Pro to upload a map service to ArcGIS for Server or Portal

Obscure ExportToJPEG problem

Re: import arceditor does not set proper license level

Re: Anyone experiencing duplicate global ids in base table?

Re: Child-to-Parent or Parent-to-Child?

Child-to-Parent or Parent-to-Child?

Re: MakeTableView in python script fails after Update to 10.3.1 on 64 bit OS

Re: MakeTableView in python script fails after Update to 10.3.1 on 64 bit OS

Re: MakeTableView in python script fails after Update to 10.3.1 on 64 bit OS

Re: ArcGIS Online viewer: 'change symbols' not available for selection

Use arcpy to manage topology rules via .rul files

Re: MakeTableView in python script fails after Upd...

Re: Using python in ArcGIS Pro to upload a map ser...

Re: A case against Federation? Hidden Cost?

Re: Let us create an alias for connected folders i...