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!
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.
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.
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)
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?
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.
