Erro
| Número de ID do Erro | BUG-000137860 |
|---|---|
| Enviado | March 2, 2021 |
| Última Modificação | June 25, 2025 |
| Aplica-se à | ArcGIS Pro |
| Versão encontrada | 2.4.2 |
| Sistema Operacional | Windows OS |
| Versão do Sistema Operacional | 10.0 64 Bit |
| Status | Will Not Be Addressed |
Use SQL to determine which associations are orphaned, and then clean them up via the feature service using ArcGIS Pro:
1) Identify all unique networksourceid values present in the association table. For example:
select distinct fromnetworksourceid from <OWNER>.un<_DSID_>associations where GDB_BRANCH_ID = 0
select distinct TONETWORKSOURCEID from <OWNER>.un<_DSID_>associations where GDB_BRANCH_ID = 0
2) Use the <UN name>_<UN_ID>_FeatureSourceID coded value domain to determine which feature classes/internal UN tables to which these networksourceid values correspond.
3) Use nested SQL statements to search for any globalids existing in the association table, but not existing in the corresponding networksourceid table. For example:
--default only from network source id
select objectid from <OWNER>.un<_DSID_>associations where gdb_branch_id = 0 and fromnetworksourceid = 6 and fromglobalid not in (select globalid from <OWNER>.<DOMAINNAME>DEVICE where GDB_BRANCH_ID = 0)
select objectid from <OWNER>.un<_DSID_>associations where gdb_branch_id = 0 and fromnetworksourceid = 8 and fromglobalid not in (select globalid from <OWNER>.<DOMAINNAME>ASSEMBLY where gdb_branch_id = 0)
select objectid from <OWNER>.un<_DSID_>associations where gdb_branch_id = 0 and fromnetworksourceid = 9 and fromglobalid not in (select globalid from <OWNER>.<DOMAINNAME>JUNCTION where gdb_branch_id = 0)
--default only to network source id
select objectid from <OWNER>.un<_DSID_>associations where gdb_branch_id = 0 and TONETWORKSOURCEID = 6 and TOGLOBALID not in (select globalid from <OWNER>.<DOMAINNAME>DEVICE where GDB_BRANCH_ID = 0)
select objectid from <OWNER>.un<_DSID_>associations where gdb_branch_id = 0 and TONETWORKSOURCEID = 7 and TOGLOBALID not in (select globalid from <OWNER>.<DOMAINNAME>LINE where GDB_BRANCH_ID = 0)
select objectid from <OWNER>.un<_DSID_>associations where gdb_branch_id = 0 and TONETWORKSOURCEID = 9 and TOGLOBALID not in (select globalid from <OWNER>.<DOMAINNAME>JUNCTION where GDB_BRANCH_ID = 0)
4) Users have a list of objectids of associations. Delete them by adding the UN feature service to ArcGIS Pro. Open the association table, select by attributes, and then delete the rows.
ID do Erro: BUG-000137860
Software:
Obtenha ajuda de especialistas do ArcGIS
Baixe o Aplicativo de Suporte da Esri