topic Re: Apply an asset package error message in Gas and Pipeline Questions

Apply an asset package error message

deleted-user-GKyg-xriCvci — Sun, 12 Dec 2021 16:53:27 GMT

Hello, I am struggling with creating en electric utility network inside my organization. I followed steps from documentation: Get started with the Electric Distribution Utility Network Configuration—Get Started | ArcGIS for Electric and everything is configured as it should be. I am using PostgreSQL 9.5.7 database. My problem starts in the point 4.. I managed to 'Stage the Utility Network' but every time I am trying to 'Apply an asset package' I am getting errors. I have tried different configurations already but usually the error is:

Running script AssetPackageToUtilityNetwork...
ArcGIS Pro 2.1.1.10257
untools 2.1.0.1
Updating schema on ElectricDistributionAssembly
Updating schema on ElectricDistributionDevice
Updating schema on ElectricDistributionJunction
Updating schema on ElectricDistributionLine
 ERROR 999999: Error executing function.
The subtype already exists. [un.andreasbv.ElectricDistributionAssembly]
Failed to execute (AddSubtype).
EXCEPTION
Traceback (most recent call last):
 File "C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\lib\site-packages\untools\common\wrappers.py", line 90, in wrapper
 return func(*args, **kwargs)
 File "C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\lib\site-packages\untools\gptools\tools.py", line 300, in run
 share.schema_apply()
 File "C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\lib\site-packages\untools\utils\shared_validation.py", line 504, in schema_apply
 return self.apply()
 File "C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\lib\site-packages\untools\utils\shared_validation.py", line 450, in apply
 result = func(**kwargs)
 File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\management.py", line 16618, in AddSubtype
 raise e
 File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\management.py", line 16615, in AddSubtype
 retval = convertArcObjectToPythonObject(gp.AddSubtype_management(*gp_fixargs((in_table, subtype_code, subtype_description), True)))
 File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\geoprocessing\_base.py", line 506, in <lambda>
 return lambda *args: val(*gp_fixargs(args, True))
arcgisscripting.ExecuteError: ERROR 999999: Error executing function.
The subtype already exists. [un.andreasbv.ElectricDistributionAssembly]
Failed to execute (AddSubtype).
 Failed to execute (AssetPackageToUtilityNetwork).

As an Asset Package I am using default geodatabase ElectricDistribution_AssetPackage.gdb, I am checking both Structure and ElectricDistribution and as Input I am using Utility Network created in previous step. I am not loading data as for a now I would like to have just a scheme.

Could anyone tell me what am I doing wrong? I believe there is some detail which stands behind the logic of Utility Network Model but as documentation describe the process quite briefly I can't figure out appropriate approach.

Re: Apply an asset package error message

PaulLeBlanc1 — Tue, 20 Feb 2018 22:49:51 GMT

Did you have any maps open when running `Apply Asset Package`?

If you look are the subtype view on ElectricDistributionAssembly, does it match the properties page of the UN?

Re: Apply an asset package error message

deleted-user-GKyg-xriCvci — Wed, 21 Feb 2018 12:57:17 GMT

Thank you for quick reply! I had always background map open but I closed it today and run again and I got the same error. Answering your second question I am not sure if my previous step 'Stage the Utility Network' works correctly. After running it I am getting only layers from Structure Domain network:

Is it correct? When I start running 'Apply Asset Package', Electric Distribution Domain Network five classes are being created and then the process fails. So I am not sure where can I find subtype view on ElectricDistributionAssembly.

Re: Apply an asset package error message

PaulLeBlanc1 — Wed, 21 Feb 2018 16:40:26 GMT

You might want to try with a new UN if you are still getting the same error. When there is a map open, the layers are locked and unlocked hundreds of times.

'Stage the Utility Network' only ever creates the structure classes -- the domain network classes (in your case Electric Distribution), are added by 'Add Domain Network'

Re: Apply an asset package error message

deleted-user-GKyg-xriCvci — Fri, 23 Feb 2018 12:03:10 GMT

Paul, thank you for help. I established new connection to newly created PostgreSQL database, staged UN again, and 'apply asset package' finally worked.

Re: Apply an asset package error message

AbhijeetKulkarni — Tue, 13 Mar 2018 12:08:03 GMT

I had same error and not having map open helped. Just that error message doesn't relate anyway with map being open.

Re: Apply an asset package error message

VishApte — Thu, 24 Jan 2019 06:46:51 GMT

Hi UN Team,

I am trying to build Electric Utility Network for a client here using Electric Asset Package with no changes. I get an error in Apply Asset Package that I cannot figure out how to fix.

Parameters
Asset Package D:\Projects\UtilityNetworkBuild\Electric_AssetPackage_GDA94.gdb
Domain Networks to apply Structure;ElectricDistribution;ElectricTransmission
Input Utility Network D:\Projects\UtilityNetworkBuild\BasicPackage\netadmin.sde\UN.NETADMIN.Networks\UN.NETADMIN.UNElectric
Load data true
Calculate Spatial Index and Analyze true
Output Utility Network

Messages
Start Time: Thursday, 24 January 2019 5:07:58 PM
Running script AssetPackageToUtilityNetwork...
ArcGIS Pro 2.2.4.12813
untools 2.2.2
ERROR 999999: Something unexpected caused the tool to fail. Please refer to the error help for potential solutions, or contact Esri Technical Support http://esriurl.com/support.
Table is already locked [Table is already locked[UN.NETADMIN.ElectricDistributionDevice.SUBNETWORKNAME]]
Failed to execute (AddTier).
Failed to execute (AssetPackageToUtilityNetwork).
Failed at Thursday, 24 January 2019 5:20:30 PM (Elapsed Time: 12 minutes 31 seconds)

There is no other app open, no map open, no SDE connection open. So not sure why "Table is already locked" unless there is some race condition in the tool.

Any help is much appreciated.

Re: Apply an asset package error message

PaulLeBlanc1 — Thu, 24 Jan 2019 18:15:17 GMT

Is there a map in your project with the UN layers added to it? Sometimes, that will happen even if the map is closed.

Otherwise, I'm not sure. If you run Apply again, does it fail in the same place?

Re: Apply an asset package error message

ChatruNenavath — Wed, 28 Aug 2019 06:15:56 GMT

Hi Paul,
I am trying to create Electric Utility Network using Electric Asset Package tool. I got an error in Apply Asset Package that I cannot figure out how to fix.

I am using ArcGis pro 2.4.0 and asset package 3.1 version.

ERROR 001896: Invalid association parameters (row 2). A requested row object could not be located. .
Failed to execute (ImportAssociations).

Any help is much appreciated.

Re: Apply an asset package error message

VishApte — Wed, 28 Aug 2019 07:55:25 GMT

Possibly, there are records in C_Associations table where from/to globalid does not exist in the specified from/to feature class.

Re: Apply an asset package error message

MikeMillerGIS — Wed, 28 Aug 2019 09:28:14 GMT

Could you share the entire message? What version of pro/untools?

Re: Apply an asset package error message

ChatruNenavath — Wed, 28 Aug 2019 09:41:24 GMT

Hi Michael,

Here is the entire message.

"Messages
Start Time: Tuesday, August 27, 2019 1:37:04 PM
Running script AssetPackageToUtilityNetwork...
ArcGIS Pro 2.4.19948
untools 2.4.1
Executing from ArcGIS Pro, 3 map(s), activeMap = True
Parallel processing enabled: 3
Asset Package schema version: 2.4
2019-08-27 18:31:59 Starting 3 processes for Append
2019-08-27 18:36:22 Starting StructureJunction...
2019-08-27 18:36:22 Finished StructureJunction (0:03:59)...
2019-08-27 18:37:37 Starting ElectricDevice...
2019-08-27 18:37:37 Finished ElectricDevice (0:05:15)...
2019-08-27 18:39:13 Starting ElectricJunction...
2019-08-27 18:39:13 Finished ElectricJunction (0:02:35)...
2019-08-27 18:39:40 Starting ElectricAssembly...
2019-08-27 18:39:40 Finished ElectricAssembly (0:01:47)...
2019-08-27 18:40:07 Starting ElectricDeviceUnit...
2019-08-27 18:40:07 Finished ElectricDeviceUnit (0:00:15)...
2019-08-27 18:40:40 Starting ElectricJunctionA...
2019-08-27 18:40:40 Finished ElectricJunctionA (0:00:20)...
2019-08-27 18:40:52 Starting StructureBoundary...
2019-08-27 18:40:52 Finished StructureBoundary (0:01:27)...
2019-08-27 18:41:19 Starting ElectricLineA...
2019-08-27 18:41:19 Finished ElectricLineA (0:00:25)...
2019-08-27 18:41:28 Starting ElectricWireData...
2019-08-27 18:41:28 Finished ElectricWireData (0:00:20)...
2019-08-27 18:41:37 Starting ElectricLine...
2019-08-27 18:41:37 Finished ElectricLine (0:09:15)...
2019-08-27 18:51:37 Starting 3 processes for ImportAssociations
2019-08-27 18:53:58 Starting Associations_001...
2019-08-27 18:53:58 Start Time: Tuesday, August 27, 2019 6:52:29 PM
ERROR 001896: Invalid association parameters (row 2). A requested row object could not be located. .
Failed to execute (ImportAssociations).
Failed at Tuesday, August 27, 2019 6:52:41 PM (Elapsed Time: 11.77 seconds)
2019-08-27 18:53:58 Starting Associations_003...
2019-08-27 18:53:58 Start Time: Tuesday, August 27, 2019 6:52:29 PM
ERROR 001896: Invalid association parameters (row 2). A requested row object could not be located. .
Failed to execute (ImportAssociations).
Failed at Tuesday, August 27, 2019 6:52:41 PM (Elapsed Time: 11.73 seconds)
2019-08-27 18:53:58 Starting Associations_002...
2019-08-27 18:53:58 Start Time: Tuesday, August 27, 2019 6:52:29 PM
ERROR 001896: Invalid association parameters (row 2). A requested row object could not be located. .
Failed to execute (ImportAssociations).
Failed at Tuesday, August 27, 2019 6:52:41 PM (Elapsed Time: 11.75 seconds)
Failed to execute (AssetPackageToUtilityNetwork).
Failed at Tuesday, August 27, 2019 6:54:01 PM (Elapsed Time: 5 hours 16 minutes 56 seconds)".

Re: Apply an asset package error message

MikeMillerGIS — Wed, 28 Aug 2019 10:01:50 GMT

If you look at the feature classes, can you verify the features where appended?

You can try the import association again, you will need to modify the AP_workspace folder that was created. In there, open the main.py and remove calls prior to the import associations call. Using the python command prompt, run that by file.

Re: Apply an asset package error message

HeatherWillever — Fri, 08 May 2020 19:29:11 GMT

Hello, I am trying to just view the Sewer Utility Network. I want to check out the functionality of trace and learn how to find problems with the network and see if it would be useful to my clients. I followed the steps to create a utility network, and got a similar error as above. I don't want to add any of my data, just view what came with the package but it hangs up on the apply asset package. Is there a more detailed step by step instructions to just create a network and see how it works? I am using Pro 2.5.1. I have no maps open, I downloaded the lates UNTools. This is the error I keep getting.

ERROR 999999: Something unexpected caused the tool to fail. Contact Esri Technical Support (http://esriurl.com/support) to Report a Bug, and refer to the error help for potential solutions or workarounds.
Failed to execute (ImportXMLWorkspaceDocument).
Failed to execute (AssetPackageToUtilityNetwork).

Am I missing something? Does this only work in an Enterprise environment? The documentation said it could work with a File Geodatabase.

Any help would be greatly appreciated.

Re: Apply an asset package error message

PaulLeBlanc1 — Fri, 08 May 2020 19:58:46 GMT

Hi Heather,

Can you confirm which version of untools you have (it should be printed at the top of the GP messages)?

The Utility Network works on file geodatabase. You can use Asset Package to File Geodatabase—Tool Reference | ArcGIS Solutions to quickly get started.

Re: Apply an asset package error message

HeatherWillever — Mon, 11 May 2020 15:06:30 GMT

UNtools Version 2.5.1. I also tried the asset package to file geodatabase, with the same error. Thanks for the quick response.

Re: Apply an asset package error message

PaulLeBlanc1 — Mon, 11 May 2020 15:20:27 GMT

Hmm that is odd. What version of sewer are you using? You can open the _Version table in the asset package and paste the contents here.

Re: Apply an asset package error message

HeatherWillever — Mon, 11 May 2020 15:30:38 GMT

Schema Version 2.4

Pro Version 2.5

untools Version 2.5.1

Date Exported 3/24/2020

Model Version 3.1

Model Date 3/24/2020

Re: Apply an asset package error message

PaulLeBlanc1 — Mon, 11 May 2020 17:17:36 GMT

I was successful in loading Sewer 3.1 with Pro 2.5.1 and untools 2.5.1

If you can, upgrade your Pro and try that. If it's still failing, then you should probably reach out to support. I'm not sure what might be causing this error...

Re: Apply an asset package error message

HeatherWillever — Sun, 12 Dec 2021 08:21:21 GMT

I made sure everything was upgraded and it still seems to get hung up on the ImportXMLWorkspaceDocument, any clue why that may be happening?

Running script AssetPackageToFileGeodatabase...

ArcGIS Pro 2.5.1.22081

untools 2.5.1

Executing from ArcGIS Pro, 3 map(s), activeMap = False

Parallel processing enabled: 6

Asset Package schema version: 2.4

ERROR 999999: Something unexpected caused the tool to fail. 
Contact Esri Technical Support (http://esriurl.com/support) to Report a Bug, 
and refer to the error help for potential solutions or workarounds. Failed to execute (ImportXMLWorkspaceDocument).

Failed to execute (AssetPackageToFileGeodatabase)