AnsweredAssumed Answered

Table DIRTYAREAS in Network Dataset on SQL SERVER

Question asked by valraa on Jul 27, 2016
Latest reply on Nov 23, 2016 by valraa

Hello, I'm working on a server with ArcGIS Desktop 10.3.1 and 10.3.1 Server with Network Analyst Extension (one for testing and one for production): my problem is in the copy from test server to production server of the Network Dataset , and connected Feature Class (sde on SQL Server): the copy requires several minutes (too many for the content, about 1,000 arches) and often the operation remains in the state 'Not Responding'.

it seems that are also copied many Dirty Areas (see table ND_ <ITEMID> _DIRTYAREAS in http://desktop.arcgis.com/en/arcmap/10.3/manage-data/gdbs-in-sql-server/network-dataset-storage-sqlserver.htm).

About 4000 records, that really does not seem to be useful, because on dataset is already done the build. Also as a result of a Compress the DB, the records in the table ND_ <ITEMID> _DIRTYAREAS remain.

Is there a way to ease these tables? I can manually delete dirty Areas that have the field 'isretired' = 1?

 

Thanks in advance..

Outcomes