topic Re: Error apply asset package in enterprise database in ArcGIS Utility Network Questions

Error apply asset package in enterprise database

NadiaAlami — Wed, 07 Feb 2024 15:06:43 GMT

Hi and good day everyone...
We try to migrate our utility network file geodatabase to enterprise database,
when try to apply asset package, we encounter error like below.
what should we do?

It is correct our step to migrate from file geodatabase to enterprise database for our Utility network db.
first, we create enterprise geodatabase then we create enterprise geodatabase user .
After that we run stage asset package then we apply asset package.

We manage to do the first three steps but encounter error when to apply the asset package processing.

Re: Error apply asset package in enterprise database

RobertKrisher — Wed, 07 Feb 2024 15:35:25 GMT

Your steps are correct, but there appears to be a problem with the isolation and system subnetwork fields. In those subnetwork name fields must be non-nullable, and they are in the default model. If you made any changes (or dropped and re-added these fields) then that may have set them to be nullable.

The easiest way to correct the issue in the asset package is to:

create a copy of the table
delete all the rows out of the copy
set the subnetwork name fields in the copy to be non-nullable (this can only be done on an empty table)
append the rows from the original table into the copy
delete the original table, and rename the copy table to match the original table

Re: Error apply asset package in enterprise database

JoaquinMadrid1 — Wed, 07 Feb 2024 17:13:04 GMT

Thank you, Robert, for identifying the issue and providing the detailed solution.

Also, Nadia, and as a side note, before applying an AP to an E-GDB we found very helpful to first run the Asset Package to Geodatabase GPTool (from Esri's Utility Network Package Tools). It would not resolve your problems, but it would encounter them and allow you to fix them in the AP before you invested a lot of effort working directly on an E-GDB.

Re: Error apply asset package in enterprise database

MikeMillerGIS — Thu, 08 Feb 2024 14:02:36 GMT

The quicker fix is to just delete these fields in the Asset Package. When the tools apply the Asset Package, the call to Set Subnetwork Def with create the field with the correct settings.

Re: Error apply asset package in enterprise database

NadiaAlami — Fri, 09 Feb 2024 00:57:51 GMT

thank you so much...we manage to solve it with your help

Re: Error apply asset package in enterprise database

NadiaAlami — Fri, 09 Feb 2024 01:09:59 GMT

thank you so much...we manage to solve it with your help