Latest Contributions by LanceCole

@BrandenHarding, I updated the BUG-000166278 link above to the correct public format. It is still showing as under consideration. As the bug has not yet been prioritized, I would recommend reporting your issue through ESRI support.

After working with ESRI support, this was confirmed as a Bug. BUG-000166278

‎02-28-2024

Out of curiosity, if you are experiencing the same issue, what enterprise database platform are we using? I am experiencing this on MS SQL.

‎02-27-2024

I am still working with support on this issue. We have another session scheduled for tomorrow to capture some SQL logs. They have been able to replicate the issue.

‎02-12-2024

I am still working with ESRI support to narrow down the issue. They were able to replicate the problem and are leaning towards a bug.

‎02-03-2024

I am attempting to run Delete Identical on a feature hosted on an enterprise geodatabase and keep receiving the Error 000224: Cannot insert features. This occurs when running from a standalone Python script and running the tool directly in ArcGIS Pro. I have tried both a user with appropriate permissions and the geodata owner. If I export the data to a local GDB everything runs great. Error 000224 is typically related to mismatched field definitions between incoming features and the output feature class. But this tool modifies the existing feature class, so they should be the same. This is similar to the issue reported by @MulfordnSons in arcpy.DeleteIdentical_management does not delete identicals in ESRI sqlite database. However, this was to have been resolved in ArGIS Pro 3.0. Currently running ArcGIS Pro 3.2.1, the database is hosted on an MS SQL Server as an 11.2 version enterprise database. Any ideas? I did submit a support ticket, but it will be Monday or Tuesday before they get back to me.

‎01-17-2024

@MichelleMathias When moving an individual message or comment in a topic, is there an option to retitle the moved portion? I recently had a user post an unrelated comment/question in an answered thread and wanted to move the individual message or comment, but it did not appear to have the option to rename the new thread. Perhaps this is provided after selecting Move Post, but I did not want to take the chance it would only keep the original thread title.

‎01-17-2024

@RamonWilliams, I recommend creating a new post in the appropriate category rather than replying to an existing answered thread that is not related. I was going to move your reply, but it was unclear what category you wanted based on the context of your post and that you posted in ArcGIS Field Maps Questions.

‎01-12-2024

All, After working with ESRI support the past week, we were able to confirm this is a bug in ArcGIS Pro with not only SQL but other Enterprise Databases as well - BUG-000164308. The issue was present before version 3.2 and caused "flashing" of the ArcGIS Pro Desktop when using the shape.stlength() field in the labeling - SQL Where clause. In version 3.2 Drawing Alert messages were added allowing us to be able to narrow in on the source of the problem. Thanks, @JoshuaBixby for your time and for digging in to confirm the issue.

‎12-31-2023

@JoshuaBixby, Thanks for the reply and for confirming you are experiencing the same on a clean install. I have a ticket in with ESRI, but with the holiday weekend, it will be mid-week for a reply. In the interim, we have modified the layers where we are using labeling based on the shape.STLength() field. I am not sure if it became an issue with Pro 3.2, upgrading to 11.2 on our enterprise deployment or the database update from 10.8 to 11.2. Did not see anything on initial testing and for some reason the issue does not occur on our published feature and map services to the same database just a direct SDE connection. Happy New Year!

‎12-29-2023

About three weeks ago, we updated to ArcGIS Enterprise 11.2. Last weekend, we updated our enterprise database from 10.8 to 11.2. In ArcGIS Pro 3.2, we are noting issues with all feature classes that utilize a SQL Where clause for labeling based upon the field Shape.STLength(). When labeling is on, hundreds of drawing alerts are produced for any of these features. The message states that an "Error parsing the WHERE clause. One or more fields could not be found." This has worked without issue since moving to ArcGIS Pro some time ago. I created a straightforward linear feature on our enterprise database and drew a handful of lines. Once I set a SQL Where clause to use the Shape.STLength() field drawing alerts began to appear. We typically use this field to label features differently based upon the length. Any ideas? The data is accessed directly to the database using an SDE connection string and the systems are using Microsoft ODBC Driver v18.3.1.1.

‎12-29-2023

@jschuckert, After working with ESRI support on this issue throughout the week, it has been determined this is a BUG-000164046 when working with map services. There are a few workarounds: Utilize Map Viewer Classic to configure pop-ups. Add the individual feature layers of the map service to Map Viewer <serviceURL>/MapServer/0 rather than <serviceURL>/MapServer. Publish as a hosted feature layer and manage layer properties in Map Viewer. If the pop-ups have not been enabled in the map service, they will not display in FieldMaps; however, once enabled in the map, they will always be on in FieldMaps and cannot be turned off despite the map settings. You can remove and reload the original services in the map but lose any other configurations.

‎12-26-2023

@jschuckert , Happy Holidays. So far, I have only been able to turn off pop-ups in field maps by using the Map Viewer Classic. I also do not see the option to disconnect layer properties for the problematic features as others have noted. I have a support ticket in with ESRI; however, because of the extended holiday we have yet to schedule a phone call and screen share to discuss the issue in more detail. I will post more once I have more info.

‎12-22-2023

Has anyone heard of a permanent resolution or is there an official BUG ID for this? Using Map Viewer Classic is starting to result in a loss of functionality and an inability to leverage the new Map Viewer in FieldMaps. Also, I am not seeing the referenced "disconnect layer properties" under the Layer > Properties > Info, as noted in @ajevans429' s post. We are using Map Services so may account for the missing option.

Re: Create a "Built-In" AGOL User · ‎12-21-2023

I ended up putting a ticket in with ESRI Support, and they confirmed I was not losing my marbles, at least this time. You can no longer create "Built-In" accounts on AGOL, which is still supported on the Enterprise Portal. Unfortunately, we do not publicly expose our Portal and only utilize AGOL when not connected to our network. The numerous Built-In accounts I deleted from AGOL to replace with a new batch of mobile devices cannot be recreated or restored. However, you can create multiple accounts now, all with the same email address, which is what we ended up doing. After doing so, we found that the password set by the administrator had to be reset on each device after connecting the first time. Built-in accounts were so much simpler to manage, especially since we do not provide the AGOL username and password to the volunteer or intern using the mobile devices. We only provide a pin to the device. I still have 15-20 Built-In accounts on AGOL and I am not deleting those until required by ESRI.

Online Status	Offline
Date Last Visited	2 weeks ago

My Ideas

Latest Contributions by LanceCole

Re: Error 000224 when running Delete Identical on SDE enterprise database

Re: Error 000224 when running Delete Identical on SDE enterprise database

Re: Error 000224 when running Delete Identical on SDE enterprise database

Re: Error 000224 when running Delete Identical on SDE enterprise database

Re: Error 000224 when running Delete Identical on SDE enterprise database

Error 000224 when running Delete Identical on SDE enterprise database

Re: How to move a post

Re: Pop-ups not enabled in web map but showing up in Field Maps App

Re: Error in feature class label SQL Where clause when using Shape.STLength()

Re: Error in feature class label SQL Where clause when using Shape.STLength()

Error in feature class label SQL Where clause when using Shape.STLength()

Re: Pop-ups not enabled in web map but showing up in Field Maps App

Re: Pop-ups not enabled in web map but showing up in Field Maps App

Re: Pop-ups not enabled in web map but showing up in Field Maps App

Re: Create a "Built-In" AGOL User

Re: Error 000224 when running Delete Identical on ...

Re: Error 000224 when running Delete Identical on ...

Error 000224 when running Delete Identical on SDE ...

Re: Integrate portal with IWA before or after Fede...

Re: Error 000224 when running Delete Identical on ...

Web AppBuilder Custom Widgets

Experience Builder Custom Widgets