Latest Contributions by RichRuh

SQL Server, Oracle, Postgres, etc. are all sql databases. Which one are you using? ... View more

I would start by fixing the syntax error, as pointed out by @KenBuja. I suspect the problem here is a bad error message. What kind of database is this? --Rich ... View more

Hi Mody, I'm not an expert on editing events, so I cannot really comment on your code. Just wanted to ask if you'd had a chance to look into attribute rules?  These are rules written in Arcade script that fire during the editing process.  You can write constraint rules, which allow checks to take place before an edit is accepted, and calculation rules, which fill in data values.   It sounds like a perfect match for your requirements, although there many be other circumstances which prevent them from working for you. --Rich ... View more

Hi, If you are taking this sequence value and writing it into a database field, you might think about using attribute rules. Attribute Rules are short scripts that run during editing can be used to fill in a value.  They are written using Arcade, which provides a built-in cross-platform sequence function. That said, if this doesn't work or you want to continue with your current technique here's how. First, use DatabaseClient.Execute statement to generate the next sequence value and write it into a temporary table. SELECT NEXT VALUE FOR sequencename as VALUE INTO ##temptbl; Second, use Geodatabase.Evaluate to read the value from the temporary table and return it back to your application SELECT value from ##temptbl Please let me know if this works. Thanks, --Rich   ... View more

Hi Rejean, You cannot use the Pro SDK to add new coded values to a domain- Python is the answer for now. The good news is that we'll be adding this capability in Pro 3.1, targeted for Q1 2023. --Rich ... View more

You'll probably get more responses if you move this to the ArcGIS Python forums. This is for C# ... View more

Hi Anete, When you publish a web map with a utility network layer in it, the utility network information is stored in the web map, but it does not show up as a separate layer. It's possible to view dirty areas, but it takes a little bit of extra work.  You have to add the dirty area layer as a separate layer to your web map.  Here's how to do this in ArcGIS Pro: 1. Right-click on the utility network layer in your Pro map, and bring up layer properties. Go to the source tab: Copy the Location information, as well as the dataset id (23 in the example above). 2. Exit out of that dialog and go to the Add Data tool and choose Data From Path   3. Fill in the path with the web service that you found in step 1.  Add a "/" to the end, and the layer id of the dirty area layer- this should be 1 more than the Dataset ID of the utility network itself. My example above had 23, so in this case the number would be 24: 4. In the table of contents, you'll see both the utility network layer, plus the Dirty Area layer you just added: 5. If you publish this from ArcGIS Pro, you should be able to see the dirty areas in Field Maps.   This isn't an acceptable user interface for what should be a common workflow. We are discussing better options to make this automatic when publishing from ArcGIS Pro, and make it an option in the Enterprise Map Viewer. Hopefully this will get you working in the meantime.  Let me know if you encounter any more issues. --Rich   ... View more

Hi Anete, The Map Viewer in Portal doesn't yet work with utility network layers or subtype group layers.  This is why you have to use ArcGIS Pro to create and publish your webmap.  After it's been published to the Portal you can open and use it with Field Maps. I hope this helps, --Rich ... View more

The schema locks error is expected. When you edit a version by calling the REST endpoint, it creates a write lock, since only one connection can be editing at a time.  What I am trying to understand is why it takes so long to call update all subnetworks from the SDK. If we can fix that problem then you'll be able to use the SDK instead of the REST endpoint, and the schema locks problem will be solved. --Ric ... View more

Both the REST call and ArcPro SDK is doing the same work, like updating multiple subnetworks. REST call is super fast taking about 1 minute. while ArcPro SDK taking about 8 to 10 minutes to update the subnetwork on first time. Second time the processing time is decreasing to 3 to 4 minutes. That's why I'm focusing to the REST call.  When you call the Pro SDK to update a subnetwork, how long does the REST call take? Also I noticed that if we are updating subnetwork for branch version from SDE.Default I'm not sure what you mean here. Are you updating the subnetwork on the branch version or the default version? ... View more

To run the subsequent trace, you would want to set a new starting point at the result of the first trace. Does this help? ... View more

Try keeping the traversability section of the trace configuration the way you normally would for an upstream trace, and enter a Filter to stop at overhead fuses. ... View more

The time difference here is alarming and unexpected.  Do you have fiddler installed? I'm wondering if you could examine the call to update subnetwork that is generated by the Pro SDK and see if it matches what happens when you manually call it?  Is the Pro SDK updating multiple subnetworks? --Rich ... View more