Skip to main content

Geometric Network Cannot Be Created on SDE Connection

Updated

Problem

The geometric network is supposed to be created on an SDE default connection using the update script (NETDEF.XML). 

At the end, the following error messages may appear:

  • OLE error $80040411 (FDO_E_FEATURECLASS_NO_SHAPE_COLUMN)
  • OLE error $80040302 (FDO_E_DATASET_INVALID_NAME)
  • Some conflict with a table named "N_1..." or "N_2..."

Solution

The OLE errors could be resolved using the following Geotools:

image2021-7-26_19-14-7.png

  • Check and repair the connectivity of the geometric network
  • Check version metadata
  • Repair version metadata
  • Check version tables
  • Repair version tables

In French:

image2021-7-26_19-15-36.png

 

The conflict with the "N_" tables could be resolved by

  1. Ensuring that the geometric network is not present in ArcCatalog.
  2. Closing ArcCatalog, GEONIS, and all database connections to the SQL Server.
  3. Logging into Microsoft SQL Server Management Studio as an admin.
  4. Manually deleting all "N_" tables in the database.
    image2021-7-26_19-21-56.png
  5. Manually deleting all N_ entries in the SDE-table_registry.
    image2021-7-26_19-22-22.png
  6. Attempting again to create the geometric network using the GEONIS update script (NETDEF.XML).
Create Geometric Network with SDE Connection

In order to create the geometric network using the update script (NETDEF.XML), the following prerequisites must be met.

  1. There must be a deversioned and compressed default SDE connection available.
  2. No one should be connected to the database.
  3. An owner connection must be used.

Related articles

Comments

0 comments

Article is closed for comments.