topic Re: Geometric Network Issue in Geodatabase Questions

Geometric Network Issue

CynthiaMatney — Tue, 18 Aug 2015 19:32:30 GMT

Hello. I am working in 10.2.2 - ArcMap Advanced. We have a sql database that is versioned. I unregistered the dataset as versioned and the I created a Geometric Network on our Water Distribution dataset. All seemed to be okay, so I registered the feature dataset. However, I found out that those water feature classes that participated within the geometric network, no longer were showing up within people's desktop maps. I was able to re-add those layers into a map on most occasions and all appeared to work fine while in the map. However, when you got out and then went back into the map - they once again showed red exclamations next to those water layers. On a few computers I'd get the error message "Error opening feature class. The feature class participates in a geometric network that could not be opened. DBMS table not found." and I was unable to even add the feature classes back into these maps. I'd appreciate any insight into this issue! Thank you much!

Cynthia

Re: Geometric Network Issue

JoeBorgione — Tue, 18 Aug 2015 20:44:20 GMT

My guess it's a user permissions issue and or a lock but...

I avoid any and all instances of feature datasets within the SDE environment. This is one example as to why I avoid them; they just don't work real well in SDE. I would suggest you maintain your data in SDE, and replicate the features you need to a FGDB/ feature dataset that all have access to.

Re: Geometric Network Issue

CynthiaMatney — Tue, 13 Oct 2015 13:48:55 GMT

So - if I create a replica of just the water feature datasets - then do I create the geometric network within that replica? If that is allowed - how does that work when synchronizing the data back and forth between the original SDE and the replica (I'd use two-way/connected replication). I've only created a disconnected replication once before when we had a third party working on data.

Thanks!

Re: Geometric Network Issue

ChrisDonohue__GISP — Tue, 13 Oct 2015 15:01:24 GMT

Adding some of the ESRI folks knowledgeable about Enterprise Geodatabases in case they have some insight:

Asrujit SenGupta

Jake Skinner

Vince Angelo

Chris Donohue, GISP

Re: Geometric Network Issue

JoeBorgione — Tue, 13 Oct 2015 15:32:57 GMT

You would replicate to a feature dataset; I do that with a one way replication to FGDB feature dataset that holds a street centerline network.

If I understand your process, you maintain your geometric network on both ends; parent and child, correct? I think I'll will let the folks Chris mentioned reply to that; my guess is it it'll be a bit tricky. (Chris Donohue)

Re: Geometric Network Issue

AsrujitSengupta — Tue, 13 Oct 2015 17:51:22 GMT

Have you tried re-granting the Privileges on the Feature Dataset as suggested earlier? Did that help?

Re: Geometric Network Issue

AsrujitSengupta — Tue, 13 Oct 2015 17:55:48 GMT

Just create the replica after you have:

1. created your Geometric Network inside the Feature Dataset,

2. Registered the Dataset as Versioned and

3. added GlobalIDs

If the same data exists in both the Geodatabases, use the Register with Existing Data option to create the replica.

Re: Geometric Network Issue

CynthiaMatney — Tue, 13 Oct 2015 20:19:47 GMT

On the original feature dataset within the SDE? I had checked after I initially had the lock out issues after adding the Geometric Network and it wasn't showing that any of the permissions/privileges had been changed. I ended up having to delete the Geometric Network I had created w/in the Water Distribution Feature Dataset (in the SDE) in order for my crews to be able to once again view and utilize all the feature classes w/in that dataset. Once I deleted the Geometric Network - access was back to normal for all users.

Re: Geometric Network Issue

CynthiaMatney — Tue, 13 Oct 2015 20:23:19 GMT

Are you saying to create the Geometric Network w/in the original Water Distribution Feature Dataset that is in the SDE? And then when I create the replica from that dataset - I would have everyone use the replica vs the original feature dataset?

Re: Geometric Network Issue

JoeBorgione — Tue, 13 Oct 2015 20:49:18 GMT

I ended up having to delete the Geometric Network I had created w/in the Water Distribution Feature Dataset (in the SDE) in order for my crews to be able to once again view and utilize all the feature classes w/in that dataset. Once I deleted the Geometric Network - access was back to normal for all users.

You've hit the nail on the head as to why I avoid feature datasets and the data there in while in the SDE environment...

Re: Geometric Network Issue

JerryGarcia1 — Fri, 12 Feb 2016 17:07:14 GMT

This is the answer. Had the same problem, just needed to re grant permission.

Re: Geometric Network Issue

StanMcShinsky — Tue, 30 May 2017 14:19:48 GMT

re-granting permissions worked like a charm for me.

Re: Geometric Network Issue

AmritaMundal1 — Mon, 10 Sep 2018 11:23:47 GMT

Hi Asrujit SenGupta,

I am working on a case where the user is facing this error: Error opening dataset. Network Property already exists.He is working on ArcMap 10.3.1, Oracle 12C. Will re-granting the permissions help resolve the issue?

Any help will be highly appreciated!

Thanks,

Amrita Mundal.

Re: Geometric Network Issue

forestknutsen1 — Tue, 19 Feb 2019 22:18:48 GMT

Did you find a solution to this? We have an old database presting an identical error as yours, save the table name. I tried to add the network to a map while connected as the data owner and I still get the same error...