|
POST
|
This helps a bunch! Thank you very much. Seemed odd that this would be considered a problem. Thanks for confirming it is not. Ed
... View more
07-20-2025
02:54 PM
|
1
|
0
|
1371
|
|
POST
|
All - Working with a vendor we were told that the Utility Network would consider it invalid to have a structure network junction coincident with a utility domain device or junction. This seems illogical and I'm looking for a reality check. In our GN implementation we have separate underground structure and electric networks and many cases where an electric feature (i.e., a fuse) is coincident with an underground structure junction (i.e., a conduit end point). Any clarification here would be much appreciated. Thx, Ed
... View more
07-19-2025
11:36 AM
|
1
|
2
|
1418
|
|
POST
|
Hi - We are starting discussion on out Utility Network model and are considering adding tiers for sub-transmission and substations. The sub-transmission tier would hold equipment energized at 34.5kV, 25 kV and 23kV - which are distinct from both transmission and distribution tiers. So we feel pretty safe there. But (we *think*) we also want a substation tier that encompasses equipment within the substation - with a subnetwork controller being one or more "injection points" on the high side of the sub. Of course the substation has equipment energized at transmission, distribution and sub-transmission voltage levels. So this would prevent the tiers from being in a consistent hierarchy -- for example sometimes sub-transmission will be on the "load" side of the sub and sometimes sub-transmission will be on the "feed" side of the sub. Will we run into problems with this tier definition? Has anyone configured tiers this way? Any pointers would be much appreciated. Thx, Ed
... View more
06-25-2025
07:19 PM
|
1
|
7
|
1954
|
|
POST
|
So... as far as I can tell, this is a bug. However, I did find that another way to accomplish what I want to do is insert into the _EVW. Below is SQL that worked for me. Interestingly, the procedure "sde.next_globalid" works, while "sde.next_rowid" fails. And, apparently, when inserting into the _EVW the OBJECTID is generated as part of the "insert" operation. DECLARE @GID uniqueidentifier EXEC sde.next_globalid @GID OUTPUT INSERT INTO ASSEMBLY_EVW (GLOBALID,PARENTOBJECTID,UNIT,SUBTYPECD,QUANTITY,DATECREATED) VALUES (@gid,1408321,'UTSLV',5,1,GETDATE());
... View more
06-06-2025
11:26 AM
|
0
|
0
|
599
|
|
POST
|
I looked for bugs related to this problem and Gemini told me this: SQL Server Version: Problems with sde.next_rowid have been reported when using SQL statements to import data into an SQL Server SDE database, specifically with GeoDatabase version 10.8 and SQL Server version 2019. Now, I'm using ArcGIS 10.8.1 with SQL*Server version 2022, and I have more than once had Gemini lead me on a wild goose chase, but... any chance anyone knows what "problems" might be referring to? Thx, Ed
... View more
06-05-2025
06:23 PM
|
0
|
0
|
613
|
|
POST
|
David - Thanks for the reply. I had tried using INT prior to BIGINT. Same results. Ed
... View more
06-05-2025
09:13 AM
|
1
|
0
|
645
|
|
POST
|
Hi - I'm trying to use sde.next_rowid to get an OID for a new row to be created in a table registered and versioned within a SQL*Server 10.8.1 geodatabase. Here's my syntax: DECLARE @next_oid AS BIGINT EXEC sde.next_rowid 'gisadmin', 'ASSEMBLY', @next_oid OUTPUT Here's the error I receive: Msg 8144, Level 16, State 2, Procedure gisadmin.i36_get_ids, Line 0 [Batch Start Line 13] Procedure or function i36_get_ids has too many arguments specified. I'm afraid I'm stumped. The syntax I'm using matches what has been documented here (https://community.esri.com/t5/geodatabase-questions/using-sde-next-rowid-in-t-sql/td-p/761989) and other places. Any suggestions would be greatly appreciated. Thx, Ed
... View more
06-05-2025
08:49 AM
|
0
|
4
|
665
|
|
POST
|
Hi George - I do have an 10.8.1 client -- though its not identical to the 10.6.1 client. I tested creating a version with the 10.8 client on the 10.6.1 Geodatabase with the Geodatabase Administration too. This worked without error. I can't really say whether the problem occurred recently. Creating versions with the Geodatabase Administration tool is not part of our company's normal work flow. I happened to do it last week as part of a test. The problem may have been present a long time. ArcPro and the U/N is, as I'm sure you know, a big, costly decision and above my pay grade. Since we're moving to 10.8 soon and since we rarely create versions with the Geodatabase Admin tool, I may leave this sleeping dog lie. Though I might first take a look at other differences between the 10.6.1 and 10.8.1 clients. Thanks again for your help. Ed
... View more
03-19-2025
07:55 AM
|
0
|
0
|
836
|
|
POST
|
Right. This is ArcGIS 10.6.1. We'll be upgrading to 10.8.1 in a month. The DBMS is SQL*Server 2017. The database has a geometric network, so ArcGIS Pro does not apply. Thanks for the reply. Ed
... View more
03-19-2025
06:52 AM
|
0
|
0
|
856
|
|
POST
|
I should note that my steps to create the version are: 1. Open the Geodatabase Administration tool 2. Right-click on the SDE.Default version and select "New Version" 3. Complete the New Version dialog. The dialog disappears and Arc tries to think a little while before it gets stumped and crashes.
... View more
03-19-2025
06:38 AM
|
0
|
0
|
862
|
|
POST
|
STACK_TEXT:
00000000 00000000 ArcCatalog.exe!unknown_function+0x0
00000000 00000000 unknown![.ecxr]+0x0
00bddcd8 7736d652 KERNELBASE!RaiseException+0x62
00bddd3c 7393d9a1 clr!RaiseTheExceptionInternalOnly+0x27c
00bdddd8 7393e846 clr!IL_Throw+0x146
00bddea0 12c06e14 PresentationCore_ni!System.Windows.Automation.Peers.AutomationPeer.GetChildren+0x38c468
00bddec4 12879be1 PresentationCore_ni!System.Windows.Automation.Peers.AutomationPeer.isDescendantOf+0x19
-->
... it also crashes in ArcMap. However, using the "Create New Version" tool in ArcMap works fine without error. Also, though the process of creating a new version in the "Geodatabase Administration" tool results in a rapid exit, the version is still created and seems to be no worse for wear. My hunch is that the error occurs when Arc is tying to reload the form's list of versions, *not* when trying to create the version itself. I say this because when I examine the resulting dmp file with WindDbg it looks like the error is raised from the Windows Presentation Framework (below). This could be completely off base, but any suggestions on how I might resolve this would be greatly appreciated. Thx, Ed STACK_TEXT:
00000000 00000000 ArcCatalog.exe!unknown_function+0x0
00000000 00000000 unknown![.ecxr]+0x0
00bddcd8 7736d652 KERNELBASE!RaiseException+0x62
00bddd3c 7393d9a1 clr!RaiseTheExceptionInternalOnly+0x27c
00bdddd8 7393e846 clr!IL_Throw+0x146
00bddea0 12c06e14 PresentationCore_ni!System.Windows.Automation.Peers.AutomationPeer.GetChildren+0x38c468
00bddec4 12879be1 PresentationCore_ni!System.Windows.Automation.Peers.AutomationPeer.isDescendantOf+0x19
... View more
03-19-2025
06:36 AM
|
0
|
6
|
864
|
|
POST
|
Is it possible that when we shut down the sync-enabled feature services that we also go into the system services and stop the sync geoprocessing service that this would prevent client requests from entering the queue? Ed
... View more
03-18-2025
05:29 PM
|
0
|
0
|
456
|
|
POST
|
Hi all - We have an ArcGIS runtime-based mobile solution that attempts to sync with nine (9) separate sync-enabled feature services published via portal from an archive-enabled enterprise geodatabase once or twice a day. There are approximately 600 mobile clients connecting at different times over three daily work shifts. This generally works OK. However, we recently had a need to bring the feature services down for about 5 hours for maintenance over a weekend. When we brought the feature services back up the portal servers were immediately flooded with requests in what one member of our team likened to a denial-of-service attack. We eventually got the situation under control by a set of steps we would rather not have to repeat. My question is, it seems there must be a better way to do this. Should we have (somehow) paused the client requests when the feature services were restored? Any suggestions would be much appreciated. Thx, Ed
... View more
03-16-2025
09:19 AM
|
0
|
1
|
511
|
|
POST
|
After much testing, including tests that incorporated the Esri-suggested work-around for the ArcPro bug (deleting individual fields in distinct "DeleteField" operations rather multiple fields at a time) I'm now convinced this is also a bug in ArcMap/ArcCatalog. Specifically, Oracle versioned views (evw's) can "break" (not be updated to reflect deleted fields) when fields are deleted through Python scripts. I've also found that there is a (fairly) convenient way to repair the views once broken. Simply select the affected class in ArcCatalog and select "Manage | Enable SQL Access" , as described here It would be much better if the views didn't break in the first place. But if they do, at least you don't have to modify the SQL in SQL*Developer to fix them. Ed
... View more
03-14-2025
06:06 PM
|
0
|
0
|
416
|
|
POST
|
We recently ran a Python script to remove multiple old, unused fields from several versioned feature classes. Initial testing found this to work OK. Later rounds of testing found that this script "broke" multiple versioned views -- as in, the _evw SQL was not updated to remove the deleted fields. We later found the following bug report describing this problem occurring when multiple fields are deleted in ArcGIS Pro. However, our script ran in ArcMap. Is there a chance the same bug reported for Pro also exists in ArcMap? Thx, Ed https://support.esri.com/en-us/bug/a-versioned-enterprise-geodatabase-view-does-not-update-bug-000164901
... View more
03-11-2025
09:10 AM
|
0
|
1
|
463
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 4 weeks ago | |
| 1 | 06-25-2025 07:19 PM | |
| 1 | 07-31-2025 10:50 AM | |
| 1 | 07-20-2025 02:54 PM | |
| 1 | 07-19-2025 11:36 AM |
| Online Status |
Offline
|
| Date Last Visited |
9 hours ago
|