こんにちは、組織内でelectric utility networkを作成するのに苦労しています。ドキュメントの手順に従いました: Electric Distribution Utility Network Configurationの開始方法014;Get Started | ArcGIS for Electric<\/A> すべては正しく設定されています。PostgreSQL 9.5.7データベースを使用しています。問題は4番目のポイントから始まります。'Stage the Utility Network'は成功しましたが、毎回'Apply an asset package'を試みるとエラーが発生します。すでに異なる構成を試しましたが、通常のエラーは以下の通りです: <\/P><\/P>Running script AssetPackageToUtilityNetwork...<\/SPAN>ArcGIS Pro 2.1.1.10257<\/SPAN>untools 2.1.0.1<\/SPAN>Updating schema on ElectricDistributionAssembly<\/SPAN>Updating schema on ElectricDistributionDevice<\/SPAN>Updating schema on ElectricDistributionJunction<\/SPAN>Updating schema on ElectricDistributionLine<\/SPAN> ERROR 999999: 関数の実行中にエラーが発生しました。<\/SPAN>サブタイプはすでに存在します。 [un.andreasbv.ElectricDistributionAssembly]<\/SPAN>(AddSubtype) の実行に失敗しました。<\/SPAN>例外<\/SPAN>トレースバック (最新の呼び出しが最後):<\/SPAN> ファイル "C:\\Program Files\\ArcGIS\\Pro\\bin\\Python\\envs\\arcgispro-py3\\lib\\site-packages\\untools\\common\\wrappers.py", 行 90, in wrapper<\/SPAN> 関数を返す(*args, **kwargs)<\/SPAN> ファイル "C:\\Program Files\\ArcGIS\\Pro\\bin\\Python\\envs\\arcgispro-py3\\lib\\site-packages\\untools\\gptools\\tools.py", 行 300, in run<\/SPAN> share.schema_apply()<\/SPAN> ファイル "C:\\Program Files\\ArcGIS\\Pro\\bin\\Python\\envs\\arcgispro-py3\\lib\\site-packages\\untools\\utils\\shared_validation.py", 行 504, in schema_apply<\/SPAN> return self.apply()<\/SPAN> ファイル "C:\\Program Files\\ArcGIS\\Pro\\bin\\Python\\envs\\arcgispro-py3\\lib\\site-packages\\untools\\utils\\shared_validation.py", 行 450, in apply<\/SPAN> result = func(**kwargs)<\/SPAN> ファイル "c:\\program files\\arcgis\\pro\\Resources\\arcpy\\arcpy\\management.py", 行 16618, in AddSubtype<\/SPAN> e を発生させる <\/SPAN> ファイル "c:\\program files\\arcgis\\pro\\Resources\\arcpy\\arcpy\\management.py", 行 16615, in AddSubtype <\/SPAN> retval = convertArcObjectToPythonObject(gp.AddSubtype_management(*gp_fixargs((in_table, subtype_code, subtype_description), True))) <\/SPAN> ファイル "c:\\program files\\arcgis\\pro\\Resources\\arcpy\\arcpy\\geoprocessing\\_base.py", 行 506, in <lambda><\/SPAN> return lambda *args: val(*gp_fixargs(args, True)) <\/SPAN>arcgisscripting.ExecuteError: ERROR 999999: 関数の実行中にエラーが発生しました。 <\/SPAN>サブタイプはすでに存在します。 [un.andreasbv.ElectricDistributionAssembly] <\/SPAN>(AddSubtype) の実行に失敗しました。 <\/SPAN> (AssetPackageToUtilityNetwork) の実行に失敗しました。 <\/SPAN><\/PRE><\/P>アセットパッケージとしてデフォルトのジオデータベースElectricDistribution_AssetPackage.gdbを使用しており、StructureとElectricDistributionの両方を確認しています。また、入力として前のステップで作成したUtility Networkを使用しています。現在はデータをロードせず、スキームだけを持ちたいと考えています。 <\/P>どなたか私が何を間違っているか教えていただけますか？Utility Network Modelのロジックの背後には何か詳細があると思いますが、ドキュメントではプロセスがかなり簡潔に説明されているため、適切なアプローチがわかりません。 <\/P><\/BODY><\/HTML>
<\/P>
Running script AssetPackageToUtilityNetwork...<\/SPAN>ArcGIS Pro 2.1.1.10257<\/SPAN>untools 2.1.0.1<\/SPAN>Updating schema on ElectricDistributionAssembly<\/SPAN>Updating schema on ElectricDistributionDevice<\/SPAN>Updating schema on ElectricDistributionJunction<\/SPAN>Updating schema on ElectricDistributionLine<\/SPAN> ERROR 999999: 関数の実行中にエラーが発生しました。<\/SPAN>サブタイプはすでに存在します。 [un.andreasbv.ElectricDistributionAssembly]<\/SPAN>(AddSubtype) の実行に失敗しました。<\/SPAN>例外<\/SPAN>トレースバック (最新の呼び出しが最後):<\/SPAN> ファイル "C:\\Program Files\\ArcGIS\\Pro\\bin\\Python\\envs\\arcgispro-py3\\lib\\site-packages\\untools\\common\\wrappers.py", 行 90, in wrapper<\/SPAN> 関数を返す(*args, **kwargs)<\/SPAN> ファイル "C:\\Program Files\\ArcGIS\\Pro\\bin\\Python\\envs\\arcgispro-py3\\lib\\site-packages\\untools\\gptools\\tools.py", 行 300, in run<\/SPAN> share.schema_apply()<\/SPAN> ファイル "C:\\Program Files\\ArcGIS\\Pro\\bin\\Python\\envs\\arcgispro-py3\\lib\\site-packages\\untools\\utils\\shared_validation.py", 行 504, in schema_apply<\/SPAN> return self.apply()<\/SPAN> ファイル "C:\\Program Files\\ArcGIS\\Pro\\bin\\Python\\envs\\arcgispro-py3\\lib\\site-packages\\untools\\utils\\shared_validation.py", 行 450, in apply<\/SPAN> result = func(**kwargs)<\/SPAN> ファイル "c:\\program files\\arcgis\\pro\\Resources\\arcpy\\arcpy\\management.py", 行 16618, in AddSubtype<\/SPAN> e を発生させる <\/SPAN> ファイル "c:\\program files\\arcgis\\pro\\Resources\\arcpy\\arcpy\\management.py", 行 16615, in AddSubtype <\/SPAN> retval = convertArcObjectToPythonObject(gp.AddSubtype_management(*gp_fixargs((in_table, subtype_code, subtype_description), True))) <\/SPAN> ファイル "c:\\program files\\arcgis\\pro\\Resources\\arcpy\\arcpy\\geoprocessing\\_base.py", 行 506, in <lambda><\/SPAN> return lambda *args: val(*gp_fixargs(args, True)) <\/SPAN>arcgisscripting.ExecuteError: ERROR 999999: 関数の実行中にエラーが発生しました。 <\/SPAN>サブタイプはすでに存在します。 [un.andreasbv.ElectricDistributionAssembly] <\/SPAN>(AddSubtype) の実行に失敗しました。 <\/SPAN> (AssetPackageToUtilityNetwork) の実行に失敗しました。 <\/SPAN><\/PRE><\/P>アセットパッケージとしてデフォルトのジオデータベースElectricDistribution_AssetPackage.gdbを使用しており、StructureとElectricDistributionの両方を確認しています。また、入力として前のステップで作成したUtility Networkを使用しています。現在はデータをロードせず、スキームだけを持ちたいと考えています。 <\/P>どなたか私が何を間違っているか教えていただけますか？Utility Network Modelのロジックの背後には何か詳細があると思いますが、ドキュメントではプロセスがかなり簡潔に説明されているため、適切なアプローチがわかりません。 <\/P><\/BODY><\/HTML>
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.
UNtools Version 2.5.1. I also tried the asset package to file geodatabase, with the same error. Thanks for the quick response.
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.
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.
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.
Hi Michael,
Here is the entire message.
"MessagesStart Time: Tuesday, August 27, 2019 1:37:04 PMRunning script AssetPackageToUtilityNetwork...ArcGIS Pro 2.4.19948untools 2.4.1Executing from ArcGIS Pro, 3 map(s), activeMap = TrueParallel processing enabled: 3Asset Package schema version: 2.42019-08-27 18:31:59 Starting 3 processes for Append2019-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 ImportAssociations2019-08-27 18:53:58 Starting Associations_001...2019-08-27 18:53:58 Start Time: Tuesday, August 27, 2019 6:52:29 PMERROR 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)".
Could you share the entire message? What version of pro/untools?
Possibly, there are records in C_Associations table where from/to globalid does not exist in the specified from/to feature class.
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.
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?
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.
ParametersAsset Package \Projects\UtilityNetworkBuild\Electric_AssetPackage_GDA94.gdbDomain Networks to apply Structure;ElectricDistribution;ElectricTransmissionInput Utility Network \Projects\UtilityNetworkBuild\BasicPackage\netadmin.sde\UN.NETADMIN.Networks\UN.NETADMIN.UNElectricLoad data trueCalculate Spatial Index and Analyze trueOutput Utility Network MessagesStart Time: Thursday, 24 January 2019 5:07:58 PMRunning script AssetPackageToUtilityNetwork...ArcGIS Pro 2.2.4.12813untools 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.
I had same error and not having map open helped. Just that error message doesn't relate anyway with map being open.
Paul, thank you for help. I established new connection to newly created PostgreSQL database, staged UN again, and 'apply asset package' finally worked.
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'
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.
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?
サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
