Latest Contributions by ReinholdSchnizer

Hi, I have already looked at the latest version of the Electric Utility Network Foundation. This is based on the ESRI UN electric model for Naperville and has a few adoptions to the UNC model. But the concept ist still based on partitioned network and a very complex set of terminal devices with mixed definitions of directional / bidirectional. The subnetworks in this model are extremly difficult to handle. I think for electric networks a far more simple concept based on hierarchical network and only bidirectional terminal devices is the better path to a UN with fully working subnetworks. Therefore I would like to take a closer look at the terminal and subnetwork definitions in the original UNC model. ... View more

Hello, I had a similar problem with Arc* Clients (Versions 10.6.1 and 10.2.1) and Geodatabase 10.2.1 in Oracle 12.2. We too have 1000+ feature classes and 350 registered views, created mostly with the old sdetools. A few of them make problems with "schema out of date...", opening the view as owner + OK or recreating the view and new registration didn't help. At least for one view I found the reason: There was a difference in string lengths between Oracle data dictionary and SDE Repository. The reason was a column with a string concatenation which included an implicit date to string conversion. The result differed between languages (we use german clients and english servers), therefore the stored column details in SDE were different to the column as seen in the client. For the analysis I needed days, but the solution was simple: I added an explicit format in the expression, so Oracle data dictionary and SDE repository are always consistent. In my case I had to drop/recreate the view and register it with 10.6.1, since registering views in 10.2.1 with arcpy isn't possible. see https://community.esri.com/thread/210919-unregistering-a-spatial-view Until now I only tried it in my testing environment, I am also waiting for an answer from ESRI/Partner about using a newer ArcCatalog for administration of an older Geodatabase. Here is my SQL to select registered tables/views with different character string lengths: select * from ( select c.owner,c.table_name,c.column_name,c.sde_type,c.column_size,d.data_type,d.data_length from dba_tab_columns d, sde.column_registry c where c.owner=d.owner and c.table_name=d.table_name and c.column_name=d.column_name ) where column_size <> data_length and   data_type in ('VARCHAR2','NVARCHAR2') and   owner <> 'SDE' ; ... View more