Latest Contributions by EdwardBlair

All - Like everyone maintaining a geometric network (at least everyone I know of) we occasionally find "corrupt network features" -- that is, features which, for whatever reason, have become disassociated with their logical network representation.  When we find these we use the ArcMap "Rebuild Connectivity" to repair them. Since these occur seemingly at random in different parts of the database we created a process that runs weekly over different parts of the service territory and detects them, writing out a log which a GIS technician subsequently uses to seek out and repair.    There are usually only a handful and sometimes none at all.  But since they can cause unwanted behavior we feel its best to actively seek them rather than lie undetected. As we are starting to plan what functionality we need as we move to the U/N, the question has come up, so we still need to worry about network features becoming corrupt?    And if so, do we need to continue to proactively seek these out and fix them. Any experience or insight would be much appreciated, Ed ... View more

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

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

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

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