nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Error 000732 when importing asset pacakge to SDE in WaterDistributionDataManagementForArcGISEnterprise

VHolubec

Hello,

I am trying to load sample data of WaterDistributionDataManagementForArcGISEnterprise v 1.1 to SDE geodatabase (PostgrSQL).

The Tool Apply Asset Package has failed on error: StructureLine does not exist or is not supported (error 000732) when executing Append operation. But this particular Feature class is present in the dataset.

Is there any fix for this issue?

Thank you,

Vladimir

Find more posts tagged with

Water Distribution

Accepted answers

All comments

PaulLeBlanc1

Hi Vladimir,

What version of Pro are you using? Does your target PostgreSQL enterprise geodatabase have multiple utility networks or a feature class called StructureLine_1?

VHolubec

Hi @PaulLeBlanc1.

I am using PRO 2.8.0 with dltsolutions 2.7.1 and untools 2.8.1. Every attempt goes to the fresh empty SDE geodatabase, so there shouldn´t be any collision. But also it´s true that now I got different errors, when recording my workflow and that I´ve often seen some error in Utility Data Management Support.pyt.

See the attached video.

On Pro 2.8.1 on another machine is the situation worse. So my only question is - is PRO 2.8 supported here? Because for now I don´t see any other reason why this shouldn´t work.

If you would have any idea what to try, just let me know.

Thank you,

Vladimir

VHolubec

UPDATE:

I tried it again and still I got the same error as in initial mail. The workflow was the same as in the video above

Do I miss something?

Vladimir

PaulLeBlanc1

Well this is very interesting... I've never seen error 2824 that you show in your video. Your workflow is just fine, not sure why it isn't working.

Before you run Apply Asset Package, try setting the Parallel Processing Factor to 0.

As a sanity check, try running Asset Package to File Geodatabase (just accept all defaults). If that works, then we know to focus on PostgreSQL.

PaulLeBlanc1

One other question, are you using ST_Geometry, PG_Geometry, or PG_Geography?

VHolubec

Hi @PaulLeBlanc1,

there must be something with my PostgreSQL 11.

The problem is with SDE only, the tool - Asset Package to File Geodatabase - has run well.

The parallel processing hasn´t helped, so I created new database via Tasks in the Solution from scratch, start with new geodatabase, but even I moved forward the import hasn´t finished well (tried two times).

Now I am stuck on last step with errors - 001896 and 160281. See the messages below.

I will dig deeper on the database server.

I also checked the geometry type and there is ST_Geometry used, as expected.

PaulLeBlanc1

Ok good, so append can find the feature class now.

If you append StructureJunction in asset package to StructureJunction in target, do you get the same warnings? Hopefully so, because that will greatly simplify the debugging.

VHolubec

Hi @PaulLeBlanc1,

Summarizing the errors below. Interesting that in the log there is no Append error, but the error is on Import Associations.

WARNING 000595: C:\Users\vholubec\AppData\Local\Temp\3\ArcGISProTemp18380\WaterDevice0.fid contains the full list of records not able to be processed.WARNING 000595: C:\Users\vholubec\AppData\Local\Temp\3\ArcGISProTemp18380\WaterLine0.fid WARNING 000595: C:\Users\vholubec\AppData\Local\Temp\3\ArcGISProTemp18380\WaterJunction0.fid contains the full list of records not able to be processed.WARNING 000595: C:\Users\vholubec\AppData\Local\Temp\3\ArcGISProTemp18380\StructureBoundary0.fid contains the full list of records not able to be processed.WARNING 000595: C:\Users\vholubec\AppData\Local\Temp\3\ArcGISProTemp18380\WaterAssembly0.fid contains the full list of records not able to be processed.WARNING 000595: C:\Users\vholubec\AppData\Local\Temp\3\ArcGISProTemp18380\StructureJunction0.fid contains the full list of records not able to be processed.
ERROR 001896: Invalid association parameters (row 1). DBMS table not found [utility.creator.VodovodniSit] DBMS table not found [utility.creator.VodovodniSit] .ERROR 160281: A requested row object could not be located. (row 1)
Failed to execute (ImportAssociations).

Anyway I´ve tried to appned data from asset package to SDE and I get the schema mismatch error:

ERROR 000466: C:\Users\vholubec\Desktop\WaterDistributionDataManagementForArcGISEnterpriseV1_1\Databases\WaterDistribution_AssetPackage.gdb\UtilityNetwork\StructureJunction

does not match the schema of target

C:\Users\vholubec\Desktop\WaterDistributionDataManagementForArcGISEnterpriseV1_1\tpp.sde\utility.creator.UN\utility.creator.StructureJunction

I assume the previous step with Asset Package to File Geodatabase shouldn´t affect the Asset Pacakge.

But the schema is really different - don´t know why:

Did I miss some step?

PaulLeBlanc1

That's not good. That means all the calls to add fields failed for some reason.

Apply Asset Package and Asset Package to File Geodatabase are both read operations on the source data, so nothing there.

At this point you might need to reach out to support. We load this specific asset package frequently into PostgreSQL without issue.

VHolubec

Ok, thank you, It´s good to know that it´s not some general issue. I will discuss it with colleagues from Tech Support.

Just to be sure - ArcGIS PRO 2.8, PostgreSQL 11, dltsolutions 2.7.1, untools 2.8.1 on Asset Package 2.7 is everything which should work together with Water Management Solution?

If we find a the reason for this/solution I will let you know.

Thank you for you help!

PaulLeBlanc1

Yes, all of those versions are valid.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.