topic Re: Applying WaterDistribution_AssetPackage fails in Water Utilities Questions

Applying WaterDistribution_AssetPackage fails

DavidHoy — Wed, 20 Mar 2019 21:42:42 GMT

Attempted to apply the most current WaterDistribution_AssetPackage.gdb

to a newly staged v10.6.1 Enterprise GeoDB using UNTools 2.3.1 in ArcGIS Pro 2.3 SP1

Error after 14 minutes

Start Time: Wednesday, 20 March 2019 6:29:44 PM

Running script AssetPackageToUtilityNetwork...

ArcGIS Pro 2.3.1.15769

untools 2.3.1

Parallel processing enabled: 6

ERROR 002717: Invalid Arcade expression, SCRIPTEXPRESSION (row 2)Failed to execute (ImportAttributeRules).

Failed to execute (AssetPackageToUtilityNetwork).

Failed at Wednesday, 20 March 2019 6:44:33 PM (Elapsed Time: 14 minutes 49 seconds)

I feature classes and tables have been successfully created in the database.

Seems that just step 6 of 6 failed - the ImportAttributeRules step.

Any ideas?

Re: Applying WaterDistribution_AssetPackage fails

PaulLeBlanc1 — Wed, 20 Mar 2019 23:03:30 GMT

I believe this is BUG-000120526: The Apply Asset Package tool fails with Stormwater U..

If you choose load data, it should work.

Re: Applying WaterDistribution_AssetPackage fails

DavidHoy — Tue, 26 Mar 2019 07:05:52 GMT

sadly, tried using the "Load Data" option.

Failed again at exactly the same spot

And even using the latest Pro 2.3.1.15769 and untools 2.3.2 and the latest WaterDistribution_AssetPackage (2.0.1 Jan 26 2019).

I have altered the spatial reference to match my UN boundary polygon

also tried upgrading the package (went from 1.0 to 2.3)

probably not the same issue.

Re: Applying WaterDistribution_AssetPackage fails

PaulLeBlanc1 — Tue, 26 Mar 2019 16:39:19 GMT

Ahh it could be that the class it's failing on is empty. For your particular spatial reference, that is causing an issue.

I believe this will be resolved in the next patch of ArcGIS Pro.

Re: Applying WaterDistribution_AssetPackage fails

DavidHoy — Tue, 26 Mar 2019 22:31:31 GMT

thanks Paul, is there a bug reference? Any workaround?

How far off for this patch?

All classes in the current are empty except the boundary_polygon.

The Asset Package has no records to be loaded.

We are using Australian Projected Coordinate System GDA 1994 MGA Zone 56

Vish Apte‌ - have you struck this in other sites on Australian East Coast?

Re: Applying WaterDistribution_AssetPackage fails

PaulLeBlanc1 — Tue, 26 Mar 2019 23:14:54 GMT

Yes, I linked the bug in the original comment. BUG-000120526

If you want that class loaded, you can digitize a temporary feature, which should allow the attribute rule to load correctly.

Re: Applying WaterDistribution_AssetPackage fails

DavidHoy — Wed, 27 Mar 2019 01:00:41 GMT

do I need to load a dummy feature into every class in the Asset_Package?

and, is the patch for Pro generally or just for UNTools?

Re: Applying WaterDistribution_AssetPackage fails

PaulLeBlanc1 — Wed, 27 Mar 2019 04:15:17 GMT

You'd need to load it in any class with attribute rules that access $feature I think. Which I believe might be all of them for Naperville Water.

The fix is specific to Pro. There's nothing I can do in UNTools to fix this.

Re: Applying WaterDistribution_AssetPackage fails

VishApte — Thu, 30 May 2019 04:08:42 GMT

David Hoy‌

I have been using Web Mercator coordinate system and had worked. Now that my electric customer has signed the project, I urgently need to get the UN working in GDA94 Zone 55 coordinate system. Did you find the workaround?

Paul LeBlanc‌, is this issue specific to the coordinate system we are using or due to not having data in certain feature classes or both. I did not get this error when I tried with the same asset package but Web Mercator coordinate system. So confused what I need to fix it.

Regards,

Vish

Re: Applying WaterDistribution_AssetPackage fails

VishApte — Thu, 30 May 2019 06:25:28 GMT

Apparently, BUG-000120763 caused this issue. I just updated to ArcGIS Pro 2.3.3 and Apply Asset Package tool from untools v2.3.1 worked successfully. I now have UN Electric Transmission and Distribution domains in Australian projected coordinate system.

Cheers,

Vish

Re: Applying WaterDistribution_AssetPackage fails

PaulLeBlanc1 — Fri, 31 May 2019 16:21:26 GMT

It is specific to that coordinate system (among others) and not having data. Glad that Pro 2.3.3 resolved your issue!

Re: Applying WaterDistribution_AssetPackage fails

DamienPyne — Thu, 20 Jun 2019 00:02:02 GMT

Paul

I have been trying to build a model using GDA2020/AHD, using the naperville datamodel with ST for Australia. I had been able to build a blank database using pro2.3.1 and untools 2.3.1.

I tried to build another database under the same approach (GDA2020/AHD naperville DM) this time with Pro 2.3.3/untools 2.3.1, loading a single feature from our dataset (a single feature as we have had issues when turning on topology with >10000 features - conversation for another day).

This failed in the same location as others have had - invalid arcade expression.

2019-06-20 09:41:46 Start Time: Thursday, 20 June 2019 9:41:45 AM
Succeeded at Thursday, 20 June 2019 9:41:46 AM (Elapsed Time: 0.06 seconds)
2019-06-20 09:41:46 ImportAttributeRules (15/16)
2019-06-20 09:41:46 ...ImportAttributeRules (84/32)
2019-06-20 09:43:25 Start Time: Thursday, 20 June 2019 9:42:20 AM
Succeeded at Thursday, 20 June 2019 9:43:11 AM (Elapsed Time: 50.95 seconds)
2019-06-20 09:43:25 ...ImportAttributeRules (85/32)
2019-06-20 09:45:09 Start Time: Thursday, 20 June 2019 9:44:04 AM
Succeeded at Thursday, 20 June 2019 9:44:54 AM (Elapsed Time: 50.00 seconds)
2019-06-20 09:45:09 ...ImportAttributeRules (86/32)
2019-06-20 09:46:55 Start Time: Thursday, 20 June 2019 9:45:48 AM
Succeeded at Thursday, 20 June 2019 9:46:40 AM (Elapsed Time: 52.19 seconds)
2019-06-20 09:46:55 ...ImportAttributeRules (87/32)
2019-06-20 09:47:55 ERROR 002717: Invalid Arcade expression, SCRIPTEXPRESSION (row 2)
Failed to execute (ImportAttributeRules).
Failed to execute (AssetPackageToUtilityNetwork).

Do you have any ideas on how to get around this issue?

I am also interested in understanding more on "It is specific to that coordinate system (among others) and not having data". What coordinate systems are impacted and why is there an impact?

Thanks Damien

Edit: This failed with the same message without data on Pro2.3.3/untools 2.3.1