Latest Contributions by LanceCole

‎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.

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

Can you no longer create a "Built-In" like user account in AGOL? I do not see an option in AGOL as there is in Portal. We have multiple devices for which we have created an account for each on AGOL and set up the Username and Password without an email address. Interns often use these to collect data who do not have a company email address and may not always grab the same iPad daily. We just received a few more devices, and I went to create additional accounts; however, it does not appear you can create a "Built-In" account any longer in AGOL, and each account must have a unique email address. Am I missing something?

‎07-05-2023

@LeslieUK, That appears to have worked. IT reported Windows was showing the driver as current but a newer driver suite was available from the graphics card vendor. Updated and the issue appears to have been resolved. Thanks

Online Status	Offline
Date Last Visited	‎08-21-2024 01:01 AM

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

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

Create a "Built-In" AGOL User

Re: ArcGIS Pro - Constant Refresh and Screen Flicker

City of Wooster, Ohio - GIS Project Manager/Coordi...

Re: ArcGIS Pro Python - A row with this OID alread...

Re: ArcGIS Pro 3.2 - Drawing Alerts - Returning ST...

Re: Cordinate systems and transformations with col...

Re: Edit related table records in Survey123 and we...