Select to view content in your preferred language

Issues Reconciling and Posting Versions When Multiple Utility Networks Exist in the Same Enterprise Geodatabase (Insufficient Permissions Error)

253
6
Jump to solution
Monday
MatheusSparapani
Regular Contributor

Hi,

This is my system configuration:

  • Utility Network version 7
  • ArcGIS Enterprise 11.3
  • ArcGIS Pro 3.3 or ArcGIS Pro 3.5

I have an ArcGIS Enterprise geodatabase where I created two separate schemas, each with its own database user:

  • un_agua → contains a Water Utility Network

  • un_esgoto → contains a Sewer Utility Network

Both schemas and Utility Networks were created using the Create Database User tool in ArcGIS Pro, and each UN was published as a separate feature service through ArcGIS Enterprise.
To create and publish the Utility Networks, I was connected to Portal with an administrator account.

Everything works correctly until I try to reconcile and post a version created from one of the services (for example, the sewer service).
During the reconcile/post operation, I receive:

  • WARNING 003576: Error posting version

  • Server logs show “Insufficient permissions” errors for layers that belong to the other Utility Network.

Example:
When reconciling a sewer version, the server reports insufficient permissions for water classes (WaterLine, WaterSubnetLine, DirtyAreas, SystemJunctions, etc.).
When reconciling a water version, the opposite happens—errors reference sewer classes.

This is confusing because:

  • Each service references only its own schema’s data

  • Each schema has its own separate UN and data owner

  • The feature services are independent and published separately

  • Users have permissions only within their own schema (as expected)

It seems that during reconcile/post, the server is attempting to access Utility Network system tables from both schemas, even though only one network is involved in the edit operation.

My questions:

  1. Is this expected behavior when two Utility Networks exist in the same Enterprise geodatabase?

  2. Are there known limitations or unsupported configurations related to hosting multiple UNs in a single geodatabase (even when using separate schemas)?

  3. Is the reconcile/post operation designed to access all UN system tables in the database, regardless of which UN is being edited?

  4. What is the recommended deployment pattern in this scenario?

    • Separate geodatabases for each UN?

    • Cross-schema permissions between both UN owners?

    • Other best practices?

Any clarification or official guidance from Esri regarding this behavior would be very helpful.

Thank you!

0 Kudos
1 Solution

Accepted Solutions
RobertKrisher
Esri Regular Contributor

Please log an issue with support, this sounds like it could be BUG-000173229.

View solution in original post

0 Kudos
6 Replies
George_Thompson
Esri Notable Contributor

Are both the water & sewer services in the same map during the reconcile / post?

If you just have water in the Pro map, does the reconcile / post work?

--- George T.
0 Kudos
MatheusSparapani
Regular Contributor

Only the water or sewer service. I also tried running the process directly using the Reconcile Versions tool in ArcGIS Pro, without adding the features to the map—just by entering the service URL directly in the tool and executing it.

0 Kudos
RobertKrisher
Esri Regular Contributor

Please log an issue with support, this sounds like it could be BUG-000173229.

0 Kudos
MatheusSparapani
Regular Contributor

Yes, this error is probably the same as the one described in that bug. I tested it in an 11.5 environment and I was able to reconcile and post without any problems.

MatheusSparapani_1-1765309357788.png

 

 

 

JakeJacobsAVA
Regular Contributor

Will this be patched in 11.3?

0 Kudos
RobertKrisher
Esri Regular Contributor

This is on the list of issues to be patched in 11.3.

0 Kudos